private void cboAuthenticationType_SelectionChangeCommitted(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
if (cboAuthenticationType.SelectedIndex == 0)
{
clsDMCommon.ObjCon.ConnectionString = "Server=" + clsDMCommon.strServerName + ";Database=" + ClientDBName + ";uid=" + clsDMCommon.strUserID
+ ";pwd= " + clsDMCommon.strUserPassword + ";" + "Max Pool Size = 5004;Pooling=True";
clsConnection_DAL ObjDAL = new clsConnection_DAL();
ObjDAL.SetConnectionString(clsDMCommon.ObjCon.ConnectionString);
if (ObjDAL.IsDatabaseExist(ClientDBName))
{
if (!System.IO.Directory.Exists("AppConfig"))
{
System.IO.Directory.CreateDirectory("AppConfig");
File.WriteAllText("AppConfig\\ServerConfig.sc", ObjUtil.Encrypt(clsDMCommon.ObjCon.ConnectionString, true));
}
clsUtility.ShowInfoMessage("Database is already exist.\n please select client", clsUtility.strProjectTitle);
IsConnect = false;
}
else
{
grpDBRestore.Enabled = true;
txtDabasePath.Focus();
}
}
else if (cboAuthenticationType.SelectedIndex == 1)
{
grpDBRestore.Enabled = false;
ConnectToDB(clsDMCommon.strServerName, clsDMCommon.strUserID, clsDMCommon.strUserPassword, ClientDBName);
String conn = "Server=" + clsDMCommon.strServerName + ";Database=" + ClientDBName + ";uid=" + clsDMCommon.strUserID
+ ";pwd= " + clsDMCommon.strUserPassword + ";" + "Max Pool Size = 5004;Pooling=True";
String EncrConn = ObjUtil.Encrypt(conn, true);
if (!System.IO.Directory.Exists("AppConfig"))
{
System.IO.Directory.CreateDirectory("AppConfig");
File.WriteAllText("AppConfig\\ServerConfig.sc", EncrConn);
}
ObjDAL = new clsConnection_DAL(true);
//DataTable dt = ObjDAL.GetDataCol(ClientDBName + ".dbo.RegistrationDetails", "RegistrationID", "PcName = '"+ Environment.MachineName+"'", null);
int a = ObjDAL.CountRecords(ClientDBName + ".dbo.RegistrationDetails", "PcName = '" + Environment.MachineName + "'");
//if (dt == null || dt.Rows.Count == 0)
if (a == 0)
{
InsertClientRegistration();
}
else
{
clsUtility.ShowInfoMessage("Client is already Registered.", clsUtility.strProjectTitle);
Application.Exit();
}
}
this.Cursor = Cursors.Default;
}
private void RestoreDataBase()
{
try
{
clsDMCommon.ObjCon.ConnectionString = "Server=" + clsDMCommon.strServerName + ";Database=master;uid="
+ clsDMCommon.strUserID + ";pwd= " + clsDMCommon.strUserPassword + ";" + "Max Pool Size = 5004;Pooling=True";
if (clsDMCommon.ObjCon.State == ConnectionState.Closed)
{
clsDMCommon.ObjCon.Open();
}
string sqlcmd = "RESTORE DATABASE " + strRDatabseName + " FROM DISK='" + strRestorePath + "' with replace";
SqlCommand cmd = new SqlCommand(sqlcmd, clsDMCommon.ObjCon);
cmd.ExecuteNonQuery();
clsDMCommon.ObjCon.Close();
CloseLoading();
String conn = "Server=" + clsDMCommon.strServerName + ";Database=" + strRDatabseName + ";uid=" + clsDMCommon.strUserID
+ ";pwd= " + clsDMCommon.strUserPassword + ";" + "Max Pool Size = 5004;Pooling=True";
String EncrConn = ObjUtil.Encrypt(conn, true);
if (!Directory.Exists("AppConfig"))
{
System.IO.Directory.CreateDirectory("AppConfig");
File.WriteAllText("AppConfig\\ServerConfig.sc", EncrConn);
}
clsDMCommon.ObjCon.ConnectionString = conn; //for loading connection string for frmCustomerRegister
clsConnection_DAL ObjDAL = new clsConnection_DAL(true);
ObjDAL.SetColumnData("PcName", SqlDbType.NVarChar, Environment.MachineName);
ObjDAL.SetColumnData("StatusDate", SqlDbType.VarChar, ObjUtil.Encrypt(DateTime.Now.ToString("yyyy/MM/dd"), true));
ObjDAL.SetColumnData("IsTrail", SqlDbType.Bit, 1);
ObjDAL.SetColumnData("RegDate", SqlDbType.Date, DateTime.Now);
ObjDAL.SetColumnData("ExpiryDate", SqlDbType.VarChar, ObjUtil.Encrypt(DateTime.Now.AddDays(7).ToString("yyyy/MM/dd"), true));
ObjDAL.SetColumnData("IsKeyEnter", SqlDbType.Bit, 0);
ObjDAL.SetColumnData("IsServer", SqlDbType.Bit, 1);
if (ObjDAL.InsertData(strRDatabseName + ".dbo.RegistrationDetails", true) > 0)
{
clsUtility.ShowInfoMessage("RESTORE DATABASE successfully.", clsUtility.strProjectTitle);
}
}
catch (Exception ex)
{
clsDMCommon.ObjCon.Close();
CloseLoading();
clsUtility.ShowErrorMessage(ex.ToString(), clsUtility.strProjectTitle);
}
//RESTORE DATABASE database_name FROM backup_device WITH RECOVERY
}
byte i = 0; //for closing Registrationprocess if system datetime is changes
private void SplashWindow_Load(object sender, EventArgs e)
{
lblversion.Text = lblversion.Text + " " + Application.ProductVersion;
clsUtility.strProjectTitle = "Inventory Management System";
if (System.IO.Directory.Exists("AppConfig") && System.IO.File.Exists("AppConfig\\ServerConfig.sc"))
{
ObjDAL = new clsConnection_DAL(true);
clsUtility.DBName = ObjDAL.GetCurrentDBName(true);
AddStatusDate();// for adding current datetime if current datetime is greater than previous statusdate's datetime
IsPath = true;
}
else
{
lblStatus.Text = lblStatus.Text + " UnRegistered Version";
}
timer1.Enabled = true;
timer1.Start();
}
public static string GetPrinterName(PrinterType printerType)
{
CoreApp.clsConnection_DAL ObjCon = new clsConnection_DAL(true);
string printerName = "";
if (printerType == PrinterType.BarCodePrinter)
{
DataTable dtPrinter = ObjCon.ExecuteSelectStatement("SELECT * FROM [tblPrinterSetting] WITH(NOLOCK) WHERE machineName='" + Environment.MachineName + "' ");
if (dtPrinter.Rows.Count > 0)
{
printerName = dtPrinter.Rows[0]["BarCodePrinter"].ToString();
}
}
else if (printerType == PrinterType.InvoicePrinter)
{
DataTable dtPrinter = ObjCon.ExecuteSelectStatement("SELECT * FROM [tblPrinterSetting] WITH(NOLOCK) WHERE machineName='" + Environment.MachineName + "' ");
if (dtPrinter.Rows.Count > 0)
{
printerName = dtPrinter.Rows[0]["InvoicePrinter"].ToString();
}
}
return(printerName);
}
