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 ActionResult ReplicateTheValues() { string procname = "TruncateTable"; _CompanyService.TruncateTable(procname); //Replicate The Bank Master Values var BankMasters = TempData["BankMasters"] as IEnumerable <BankMaster>; foreach (var Bank in BankMasters) { Bank.modifiedon = DateTime.Now; _BankService.CreateBank(Bank); } //Replicate The Client Master Values var ClientMasters = TempData["ClientMasters"] as IEnumerable <ClientMaster>; foreach (var Client in ClientMasters) { Client.ModifiedOn = DateTime.Now; _ClientMasterService.CreateClient(Client); } //Replicate The Client Bank Values var ClientBanks = TempData["ClientBanks"] as IEnumerable <ClientBankDetail>; foreach (var Bank in ClientBanks) { Bank.ModifiedOn = DateTime.Now; _ClientBankDetailService.CreateBankDetails(Bank); } //Replicate The Designation Master Values var DesignationMasters = TempData["DesignationMasters"] as IEnumerable <DesignationMaster>; foreach (var Designation in DesignationMasters) { Designation.ModifiedOn = DateTime.Now; _DesignationMasterService.Create(Designation); } //Replicate The Design Master Values var DesignMasters = TempData["DesignMasters"] as IEnumerable <DesignMaster>; foreach (var Design in DesignMasters) { Design.ModifiedOn = DateTime.Now; _DesignService.CreateDesign(Design); } //Replicate The Brand Master Values var BrandMasters = TempData["BrandMasters"] as IEnumerable <BrandMaster>; foreach (var Brand in BrandMasters) { Brand.ModifiedOn = DateTime.Now; _BrandMasterService.Create(Brand); } //Replicate The Employee Master Values var EmployeeMasters = TempData["EmployeeMasters"] as IEnumerable <EmployeeMaster>; foreach (var Employee in EmployeeMasters) { Employee.ModifiedOn = DateTime.Now; _EmployeeMasterService.CreateEmployee(Employee); } //Replicate The Godown Master Values var GodownMasters = TempData["GodownMasters"] as IEnumerable <GodownMaster>; foreach (var Godown in GodownMasters) { Godown.ModifiedOn = DateTime.Now; _GodownService.CreateGodown(Godown); } //Replicate The Godown Address Values var GodownAddresses = TempData["GodownAddresses"] as IEnumerable <GodownAddress>; foreach (var Address in GodownAddresses) { _GodownAddressService.CreateGoDown(Address); } //Replicate The Item Category Values var ItemCategory = TempData["ItemCategory"] as IEnumerable <ItemCategory>; foreach (var Category in ItemCategory) { Category.ModifiedOn = DateTime.Now; _ItemCategoryService.CreateItemCatgory(Category); } //Replicate The Item SubCategory Values var ItemSubCategory = TempData["ItemSubCategory"] as IEnumerable <ItemSubCategory>; foreach (var SubCategory in ItemSubCategory) { SubCategory.ModifiedOn = DateTime.Now; _ItemSubCategoryService.CreateItemCatgory(SubCategory); } //Replicate The Item Master Values var ItemMasters = TempData["ItemMasters"] as IEnumerable <Item>; foreach (var Item in ItemMasters) { Item.modifedOn = DateTime.Now; _ItemService.createItem(Item); } //Replicate The Non Inventory Item Values var NonInventoryItems = TempData["NonInventoryItems"] as IEnumerable <NonInventoryItem>; foreach (var NonInventoryItem in NonInventoryItems) { NonInventoryItem.modifedOn = DateTime.Now; _NonInventoryItemService.createNonInventoryItem(NonInventoryItem); } //Replicate The Barcode Numbers Values var Barcodes = TempData["BarcodeNumbers"] as IEnumerable <BarcodeNumber>; foreach (var Barcode in Barcodes) { _BarcodeNumberService.CreateBarcode(Barcode); } //Replicate The Job Worker Values var JobWorkers = TempData["JobWorkers"] as IEnumerable <JobWorker>; foreach (var JobWorker in JobWorkers) { JobWorker.ModifiedOn = DateTime.Now; _JobWorkerService.Create(JobWorker); } //Replicate The Job Worker Type Values var JobWorkerTypes = TempData["JobWorkerTypes"] as IEnumerable <JobWorkType>; foreach (var JobWorkerType in JobWorkerTypes) { JobWorkerType.ModifiedOn = DateTime.Now; _JobWorkTypeService.Create(JobWorkerType); } ////Replicate The Sales Incentives Values //var SalesIncentives = TempData["SalesIncentives"] as IEnumerable<SalesIncentiveMaster>; //foreach (var SalesIncentive in SalesIncentives) //{ // SalesIncentive.ModifiedOn = DateTime.Now; // _SalesIncentiveService.CreateSI(SalesIncentive); //} //Replicate The Shop Master Values var ShopMasters = TempData["ShopMasters"] as IEnumerable <ShopMaster>; foreach (var Shop in ShopMasters) { Shop.ModifiedOn = DateTime.Now; _ShopService.Create(Shop); } //Replicate The Type Of Material Values var TypeOfMaterials = TempData["TypeOfMaterials"] as IEnumerable <TypeOfMaterial>; foreach (var Material in TypeOfMaterials) { Material.ModifiedOn = DateTime.Now; _TypeOfMaterialService.AddTypeOfMaterial(Material); } //Replicate The Unit Master Values var UnitMasters = TempData["UnitMasters"] as IEnumerable <UnitMaster>; foreach (var Unit in UnitMasters) { Unit.modifiedOn = DateTime.Now; _UnitService.createunit(Unit); } //Replicate The Supplier Master Values var SupplierMasters = TempData["SupplierMasters"] as IEnumerable <SupplierMaster>; foreach (var Supplier in SupplierMasters) { Supplier.ModifiedOn = DateTime.Now; _SuppliersMasterService.CreateSupplier(Supplier); } //Replicate The Supplier Bank Values var SupplierBanks = TempData["SupplierBanks"] as IEnumerable <SupplierBankDetail>; foreach (var Bank in SupplierBanks) { Bank.ModifiedOn = DateTime.Now; _SupplierBankDetailService.CreateBankDetails(Bank); } //Replicate The Transport Master Values var TransportMasters = TempData["TransportMasters"] as IEnumerable <TransportMaster>; foreach (var Transport in TransportMasters) { Transport.ModifiedOn = DateTime.Now; _TransportService.CreateTransport(Transport); } //Replicate The Tranport Bank Values var TransportBanks = TempData["TransportBanks"] as IEnumerable <TransportBankDetail>; foreach (var Bank in TransportBanks) { Bank.ModifiedOn = DateTime.Now; _TransportBankDetailService.CreateBankDetails(Bank); } //Replicate The User Values var Users = TempData["Users"] as IEnumerable <User>; foreach (var User in Users) { User.ModifiedBy = DateTime.Now; _UserService.CreateUser(User); } //Replicate The Commission Master Values var CommissionMasters = TempData["CommissionMasters"] as IEnumerable <CommissionMaster>; foreach (var Commission in CommissionMasters) { Commission.ModifiedOn = DateTime.Now; _CommissionService.Create(Commission); } //Replicate The Module Values var Modules = TempData["Modules"] as IEnumerable <Module>; foreach (var module in Modules) { _ModuleService.CreateModule(module); } //Replicate The UserCredential Values var UserCredentials = TempData["UserCredentials"] as IEnumerable <UserCredential>; foreach (var usercredential in UserCredentials) { _UserCredentialService.CreateUserCredential(usercredential); } //Replicate The Employee Company Values var EmployeeCompanies = TempData["EmployeeCompanies"] as IEnumerable <EmployeesCompany>; foreach (var EmpComp in EmployeeCompanies) { _EmployeesCompanyService.Create(EmpComp); } //CompanyCode = "RetailManagement"; //CompanyName = "RetailManagement"; //DatabaseName = "RetailManagement"; CompanyCode = "A2ZRetail"; CompanyName = "A2ZRetail"; DatabaseName = "A2ZRetail"; return(RedirectToAction("ReplicationDone")); }
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")); }