public ActionResult Create(MainApplication mainapp) { //DatabaseName = "RetailManagement1"; //CompanyName = "RetailManagement1"; //FinancialYear = "RetailManagement1"; DatabaseName = "A2ZRetail"; CompanyName = "A2ZRetail"; FinancialYear = "A2ZRetail"; Int32 sid = Convert.ToInt32(mainapp.companydetails.State); var state = _stateservice.GetStateNamebyId(sid); Int32 cid = Convert.ToInt32(mainapp.companydetails.City); var city = _cityservice.GetCityNamebyId(cid); mainapp.companydetails.State = state; mainapp.companydetails.City = city; mainapp.companydetails.Replicated = "No"; mainapp.companydetails.isEnabled = "Active"; mainapp.companydetails.ModifiedOn = DateTime.Now; if (mainapp.compbankdetails.BankName != null) { mainapp.compbankdetails.CompanyCode = mainapp.companydetails.CompanyCode; mainapp.compbankdetails.Status = "Active"; mainapp.compbankdetails.ModifiedOn = DateTime.Now; _compbankservice.CreateCompanyBankDetails(mainapp.compbankdetails); } var CompaniesCounter = _companyService.GetCompanyCounter("ValidationCompany"); int compcount = 0; foreach (var company in CompaniesCounter) { if (company.CompanyName == mainapp.companydetails.companyName) { compcount++; } } if (compcount != 0 || CompaniesCounter.Count() < 4) { _companyService.CreateCompany(mainapp.companydetails); string BackUpDbQuery = "BackUpDatabase"; _companyService.BackUpDatabase(BackUpDbQuery); string dbname = string.Empty; string datafilepath = string.Empty; string logfilepath = string.Empty; string FromFinancialYear = Convert.ToDateTime(mainapp.companydetails.FinancialYearFrom).ToString("dd-MM-yyyy"); string ToFinancialYear = Convert.ToDateTime(mainapp.companydetails.FinancialYearTo).ToString("dd-MM-yyyy"); string FinancialYearDate = FromFinancialYear + " To " + ToFinancialYear; dbname = mainapp.companydetails.companyName + " " + FinancialYearDate; datafilepath = ConfigurationManager.AppSettings["CreateDatabase.mdfFile"].ToString() + dbname + ".mdf"; logfilepath = ConfigurationManager.AppSettings["CreateDatabase.ldfFile"].ToString() + dbname + "_log.ldf"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@dbname", dbname), new SqlParameter("@datafilepath", datafilepath), new SqlParameter("@logfilepath", logfilepath), }; string query = "CreateDynamicDb" + " " + "@dbname" + "," + "@datafilepath" + "," + "@logfilepath"; var list = _companyService.CreateDynamicDatabase(query, para); var usercompanies = _userService.GetUserByName((string)HttpContext.Session["UserName"]); EmployeesCompany EmpComp = new EmployeesCompany(); EmpComp.UserCode = usercompanies.UserCode; EmpComp.CompanyCode = mainapp.companydetails.CompanyCode; _EmployeesCompanyService.Create(EmpComp); var details = _companyService.getLastInsertedCompany(); string compid = Encode(details.companyId.ToString()); return(RedirectToAction("Details/" + compid, "Company")); } else { TempData["CompanyExceed"] = "CompanyExceeded"; return(RedirectToAction("ReloadCompany")); } }