public int CompanyAddForMain(MainCompanyInfo companyinfo)
{
int ina = 0;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@S_companyName", companyinfo.CompanyName));
paramCollection.Add(new DBParameter("@S_isDefault", companyinfo.IsDefault?1:0, System.Data.DbType.Boolean));
int companyId = Convert.ToInt32(_dbHelper.ExecuteScalar("CompanyAdd", paramCollection, System.Data.CommandType.StoredProcedure));
return(companyId);
}
catch (Exception ex)
{
}
finally
{
}
return(ina);
}
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();
}
}
}
}
