Parichay v1.0.4

Rating: No reviews yet
Downloads: 446
Change Set: 8681
Released: Feb 22, 2012
Updated: Feb 23, 2012 by okdone
Dev status: Stable Help Icon

Recommended Download

Source Code Parichay v1.0.4
source code, 3731K, uploaded Feb 23, 2012 - 446 downloads

Release Notes

  • Please note that auto installer has not been created for this app. Kindly create the MySql Database first. e.g.- with name "parichaytest" and install the two SQL scripts provided.
  • The 1ParichaySecurity.sql contains the schema for Security.
  • 2ParichayMessaging.sql contains the schema for Messaging tables.
  • Change the name of NHibernate "connection string" in the web.config of the application to point to your database.
    • e.g., Enable & Update following settings for MySql Database in Web.Config file. (Update the DB name, Username, Password etc):-
       <property name="show_sql">true</property>
      <property name="use_outer_join">true</property>
      <property name="use_proxy_validator">false</property>
      <property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
      <property name="connection.isolation">ReadCommitted</property>
      <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
      <property name="dialect">NHibernate.Dialect.MySQLDialect</property>
      <property name="connection.driver_class">NHibernate.Driver.MySqlDataDriver</property>
      <property name="connection.connection_string">Server=localhost;Database=parichaytest;User ID=**Your DB UserId**;Password=**yourdbpasswrd**;Convert Zero Datetime=true</property>
  • Enable & Update following settings for SQL Server in Web.Config file:-
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
      <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
      <property name="connection.connection_string">Data Source=.\sqlexpress;Initial Catalog=parichaytest;User ID=**Your DB UserId**;Password=**yourdbpasswrd**</property>
      <property name="dialect">NHibernate.Dialect.MsSql2005Dialect</property>
      <property name="show_sql">true</property>

  • Build and run the application.
  • Remember to sign up with "sysadmin" username. The system will assign you the "Admin" role. Once the sysadmin is already created for you. You can comment out the following code block in the "Account>>Register" Controller action:-
if ((string.Equals(model.UserName,"sysadmin",StringComparison.InvariantCultureIgnoreCase))&&(Roles.GetAllRoles().Length == 0))
                        Roles.AddUserToRole(model.UserName, "Admin");

  • The current system has been tested with MySql database. For other databases you can either generate the schema from mapping files. To do this, you will need following code in NHibernateHelper classes of "Parichay.Security" and "Parichay.Data" projects:-
cfg.AddAssembly(typeof (aClassFromYourProject).Assembly);
new SchemaExport(cfg).Execute(false, true, false, false); 

Information can be found here and here

*After setting up the database, remember to update the NHibernate connection string in Web.Config file of the application.

The support for MS-SQLServer is added now. SQL Server script will be added to the project soon as the table relationships are created and tested.

Reviews for this release

No reviews yet for this release.