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")); } }
public void Create(EmployeesCompany CompanyCode) { _EmployeesCompanyRepository.Add(CompanyCode); _unitOfWork.Commit(); }
public ActionResult CreateUser(User User) { string pass = CreateRandomPassword(); string encryptPass = _iutilityservice.Encryptdata(pass); string password = _iutilityservice.Decryptdata(encryptPass); SmtpClient client = new SmtpClient("180.149.243.22"); client.Port = 587; client.EnableSsl = false; client.UseDefaultCredentials = false; client.Credentials = new NetworkCredential("*****@*****.**", "70L0u?9"); string body = string.Empty; MailMessage message = new MailMessage(); message.IsBodyHtml = true; MailAddress messageFrom = new MailAddress("*****@*****.**"); message.From = messageFrom; message.Subject = "Login Credentials"; body += "Dear " + User.UserName + ",<br /><br />"; body += "Your Login Credentials for RetailManagement Software are given below<br /><br />"; body += "User Name: " + User.UserName + " <br/>"; body += "Password: "******" <br/>"; message.Body = body; MailAddress messageTo = new MailAddress(User.Email); message.To.Add(messageTo); client.Send(message); message.Dispose(); SmtpClient NewClient = new SmtpClient("180.149.243.22"); NewClient.Port = 587; NewClient.EnableSsl = false; NewClient.UseDefaultCredentials = false; NewClient.Credentials = new NetworkCredential("*****@*****.**", "70L0u?9"); string NewBody = string.Empty; MailMessage NewMessage = new MailMessage(); message.IsBodyHtml = true; MailAddress NewMessageFrom = new MailAddress("*****@*****.**"); NewMessage.From = messageFrom; NewMessage.Subject = "Login Credentials"; NewBody += "Dear " + User.UserName + ",<br /><br />"; NewBody += "Your Login Credentials for RetailManagement Software are given below<br /><br />"; NewBody += "User Name: " + User.UserName + " <br/>"; NewBody += "Password: "******" <br/>"; NewMessage.Body = body; MailAddress NewMessageTo = new MailAddress("*****@*****.**"); NewMessage.To.Add(NewMessageTo); NewClient.Send(NewMessage); NewMessage.Dispose(); User.Password = encryptPass; User.ModifiedBy = DateTime.Now; User.Status = "Active"; _iuserservice.CreateUser(User); EmployeesCompany Empcomp = new EmployeesCompany(); Empcomp.CompanyCode = User.CompanyCode; Empcomp.UserCode = User.UserCode; _iEmployeesCompanyService.Create(Empcomp); return(RedirectToAction("UserCreated")); }