private void btnsave_Click(object sender, EventArgs e) { SessionVariables.DBName = "ipcadb_0"; if (tbxname.Text.Equals(String.Empty)) { MessageBox.Show(" Name Cannot be Blank !"); return; } eSunSpeedDomain.CompanyModel objcommods = new eSunSpeedDomain.CompanyModel(); objcommods.Name = tbxname.Text.Trim(); objcommods.PrintName = tbxPrintName.Text.Trim(); objcommods.ShortName = tbxshortname.Text; objcommods.Country = tbxcountry.Text; objcommods.State = tbxstate.Text; objcommods.FYBegining = Convert.ToDateTime(tbxfybeginningfrom.Text); objcommods.BooksCommencing = Convert.ToDateTime(tbxbookscommencingfrom.SelectedText.ToString()); objcommods.Address = tbxaddress.Text; objcommods.CIN = tbxCIN.Text; objcommods.PAN = tbxITPan.Text; objcommods.Ward = tbxWard.Text; objcommods.Telephone = tbxTelNo.Text; objcommods.Fax = tbxFax.Text; objcommods.Email = tbxEmail.Text; objcommods.CurrencySymbol = tbxcurrencysymbol.Text; objcommods.CurrencyString = tbxcurrencystring.Text; objcommods.CurrencySubString = tbxcurrencysubstring.Text; objcommods.CurrencyFont = tbxcurrencyfont.Text; objcommods.CurrencyCharacter = tbxcurrencycharacter.Text; objcommods.VAT = tbxEnableVAT.Text; objcommods.Type = tbxtype.Text; objcommods.EnableTaxSchg = Convert.ToBoolean(tbxEnableAddTax.Text.ToString() == "Y"?true:false); objcommods.TIN = tbxTin.Text; objcommods.CSTNo = tbxCSTNO.Text; objcommods.CreatedBy = "Admin"; string message = string.Empty; //Check for company existence in Main db if (objcombl.CheckIsCompanyExists(tbxname.Text.Trim(), 0)) { MessageBox.Show("Company already exists! \n Please try with a different Name."); return; } else { Thread oThread = new Thread(new ThreadStart(threadStart)); oThread.Start(); MainCompanyInfo mainInfo = new MainCompanyInfo(); mainInfo.CompanyName = tbxname.Text.Trim(); mainInfo.IsDefault = true; // Currently hardcoded need to retrieve it from ui design int companyId = objcombl.CompanyAddForMain(mainInfo); SessionVariables.DBName = "DBIPCA_" + companyId.ToString(); if (objcombl.CreateMySqlDatabase(ConfigurationManager.AppSettings["MySqlServer"].ToString(), ConfigurationManager.AppSettings["MySqlUserId"].ToString(), ConfigurationManager.AppSettings["MySqlPassword"].ToString(), SessionVariables.DBName)) { if (objcombl.DataBaseRestore(ConfigurationManager.AppSettings["MySqlServer"].ToString(), ConfigurationManager.AppSettings["MySqlUserId"].ToString(), ConfigurationManager.AppSettings["MySqlPassword"].ToString(), SessionVariables.DBName, global::IPCAUI.Properties.Resources.AllSql)) { objcombl.SaveCompany(objcommods); oThread.Abort(); CreateUser frmUser = new CreateUser(); frmUser.ShowDialog(); _frmMenu.Close(); } } } }