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"));
}
