public ActionResult Setup(Company company)
{
if (Session["type"] == null)
return RedirectToAction("UserLogin", "Login");
//if (type == "CompanyEmployee")
//{
//}
GeneratesCode gc = new GeneratesCode();
company.CompanyCode = gc.GenerateCompanyCode(company.CompanyName);
UserCompanyModel userCom = new UserCompanyModel();
userCom.User = _user;
company.Zip = company.ZipPre;
if (company.Extension != null)
company.Zip += "-" + company.Extension;
userCom.Company = company;
TempData["UserCompany"] = userCom;
return RedirectToAction("CreateBranchFirstBranch", "CreateBranch", new { id = 0, type = "CompanyEmployee" });
}
/// <summary>
/// CreatedBy: Kanishka
/// CreatedDate:2016/1/18
/// insert first branch details
/// </summary>
/// <returns></returns>
public ActionResult CreateBranchFirstBranch()
{
var type = (string)Session["type"];
if (type == "CompanyEmployee")
{
ViewBag.Type = "CompanyEmployee";
_type = "CompanyEmployee";
if (TempData["UserCompany"] == null) return RedirectToAction("EmployeeLogin", "Login");
CompanyAccess ca = new CompanyAccess();
//Get states to list
List<State> stateList = ca.GetAllStates();
ViewBag.StateId = new SelectList(stateList, "StateId", "StateName");
_userCompany = (UserCompanyModel) TempData["UserCompany"];
_userCompany.Branch = new Branch();
return View(_userCompany);
}
else
{
ViewBag.Type = "";
return RedirectToAction("EmployeeLogin", "Login");
}
}
public ActionResult CreateBranchFirstBranch(UserCompanyModel userCompany)
{
if (_type == "CompanyEmployee")
{
ViewBag.Type = "CompanyEmployee";
BranchAccess ba = new BranchAccess();
userCompany.Branch.BranchCode = ba.createBranchCode(_userCompany.Company.CompanyCode);
_userCompany.Branch = userCompany.Branch;
_userCompany.Branch.StateId = userCompany.StateId;
CompanyAccess ca = new CompanyAccess();
//if (ca.SetupCompany(_userCompany))
if (ca.SetupCompanyRollback(_userCompany))
{
ViewBag.SuccessMsg = "Company is successfully setup";
return View();
}
else
{
ViewBag.ErrorMsg = "Failed to setup company";
return RedirectToAction("CreateFirstSuperUser", "CreateUser");
}
}
return View();
}
public bool SetupCompanyRollbackXxx(UserCompanyModel userCompany)
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["AutoDealersConnection"].ToString()))
{
int superAdminId = 0, companyId = 0, branchId = 0;
con.Open();
SqlTransaction tran = con.BeginTransaction();
try
{
//Insert company
var com1 = new SqlCommand("spInsertCompany", con)
{
CommandType = CommandType.StoredProcedure,
Connection = con,
Transaction = tran
};
com1.Parameters.Add("@company_name", SqlDbType.NVarChar).Value = userCompany.Company.CompanyName;
com1.Parameters.Add("@company_code", SqlDbType.NVarChar).Value = userCompany.Company.CompanyCode;
com1.Parameters.Add("@company_address", SqlDbType.NVarChar).Value =
userCompany.Company.CompanyAddress1;
com1.Parameters.Add("@state", SqlDbType.NVarChar).Value = userCompany.Company.StateId;
com1.Parameters.Add("@city", SqlDbType.NVarChar).Value = userCompany.Company.City;
com1.Parameters.Add("@zip", SqlDbType.NVarChar).Value = userCompany.Company.Zip;
com1.Parameters.Add("@email", SqlDbType.NVarChar).Value = userCompany.Company.Email;
com1.Parameters.Add("@phone_num", SqlDbType.NVarChar).Value = userCompany.Company.PhoneNum1;
com1.Parameters.Add("@fax", SqlDbType.NVarChar).Value = userCompany.Company.Fax;
com1.Parameters.Add("@website_url", SqlDbType.NVarChar).Value =
userCompany.Company.WebsiteUrl;
com1.Parameters.Add("@created_by", SqlDbType.Int).Value = 0;
com1.Parameters.Add("@created_date", SqlDbType.DateTime).Value = DateTime.Now;
com1.Parameters.Add("@company_type", SqlDbType.Int).Value = userCompany.Company.TypeId;
com1.Parameters.Add("@first_super_admin_id", SqlDbType.Int).Value = 0;
com1.ExecuteNonQuery();
//Insert branch
var com2 = new SqlCommand("spInsertBranch", con)
{
CommandType = CommandType.StoredProcedure,
Connection = con,
Transaction = tran
};
com2.Parameters.Add("@user_id", SqlDbType.Int).Value = 0;
com2.Parameters.Add("@branch_code", SqlDbType.NVarChar).Value =
userCompany.Branch.BranchCode;
com2.Parameters.Add("@branch_name", SqlDbType.NVarChar).Value =
userCompany.Branch.BranchName;
com2.Parameters.Add("@branch_address", SqlDbType.NVarChar).Value =
userCompany.Branch.BranchAddress1;
com2.Parameters.Add("@state", SqlDbType.NVarChar).Value = userCompany.Branch.StateId;
com2.Parameters.Add("@city", SqlDbType.NVarChar).Value = userCompany.Branch.BranchCity;
com2.Parameters.Add("@zip", SqlDbType.NVarChar).Value = userCompany.Branch.BranchZip;
com2.Parameters.Add("@email", SqlDbType.NVarChar).Value = userCompany.Branch.BranchEmail;
com2.Parameters.Add("@phone_num", SqlDbType.NVarChar).Value = userCompany.Branch.BranchPhoneNum1;
com2.Parameters.Add("@fax", SqlDbType.NVarChar).Value = userCompany.Branch.BranchFax;
com2.Parameters.Add("@company_id", SqlDbType.Int).Value = companyId;
com2.Parameters.Add("@created_date", SqlDbType.DateTime).Value = DateTime.Now;
com2.ExecuteNonQuery();
//Insert user
var com3 = new SqlCommand("spInsertUser", con)
{
CommandType = CommandType.StoredProcedure,
Connection = con,
Transaction = tran
};
com3.Parameters.Add("@user_name", SqlDbType.NVarChar).Value = userCompany.User.UserName;
com3.Parameters.Add("@password", SqlDbType.NVarChar).Value = userCompany.User.Password;
com3.Parameters.Add("@first_name", SqlDbType.NVarChar).Value = userCompany.User.FirstName;
com3.Parameters.Add("@last_name", SqlDbType.NVarChar).Value = userCompany.User.LastName;
com3.Parameters.Add("@email", SqlDbType.NVarChar).Value = userCompany.User.Email;
com3.Parameters.Add("@phone_no", SqlDbType.NVarChar).Value = userCompany.User.PhoneNumber;
com3.Parameters.Add("@status", SqlDbType.Bit).Value = userCompany.User.Status;
com3.Parameters.Add("@is_delete", SqlDbType.Bit).Value = 0;
com3.Parameters.Add("@created_by", SqlDbType.Int).Value = 0;
com3.Parameters.Add("@create_Date", SqlDbType.DateTime).Value = DateTime.Now;
com3.Parameters.Add("@branch_id", SqlDbType.Int).Value = branchId;
com3.Parameters.Add("@role_id", SqlDbType.Int).Value = 1;
com3.ExecuteNonQuery();
//get company id
var command = new SqlCommand("spGetCompanyIdByCompanyName", con) { CommandType = CommandType.StoredProcedure };
con.Open();
command.Parameters.Add("@company_name", SqlDbType.NVarChar).Value = userCompany.Company.CompanyName;
using (var reader = command.ExecuteReader())
{
if (reader.Read())
companyId = Convert.ToInt32(reader["company_id"]);
}
con.Close();
//get branch id by branch code
command = new SqlCommand("spGetBranchIdByBranchCode", con) { CommandType = CommandType.StoredProcedure };
con.Open();
command.Parameters.Add("@branch_code", SqlDbType.NVarChar).Value = userCompany.Branch.BranchCode;
using (var reader = command.ExecuteReader())
{
if (reader.Read())
branchId = Convert.ToInt32(reader["branch_id"]);
}
con.Close();
//Get first super admin id
command = new SqlCommand("spGetUserIdByUserName", con) { CommandType = CommandType.StoredProcedure };
con.Open();
command.Parameters.Add("@user_name", SqlDbType.NVarChar).Value = userCompany.User.UserName;
using (var reader = command.ExecuteReader())
{
if (reader.Read())
superAdminId = Convert.ToInt32(reader["user_id"]);
}
con.Close();
//update company super admin
if (superAdminId != 0)
{
command = new SqlCommand("spUpdateCompanySuperAdmin", con) { CommandType = CommandType.StoredProcedure };
command.Parameters.Add("@user_id", SqlDbType.Int).Value = superAdminId;
command.Parameters.Add("@company_name", SqlDbType.NVarChar).Value = userCompany.Company.CompanyName;
con.Open();
command.ExecuteNonQuery();
con.Close();
}
//update branch , company id and created by id
if (companyId != 0)
{
command = new SqlCommand("spUpdateBranchCompanyId", con) { CommandType = CommandType.StoredProcedure };
command.Parameters.Add("@company_id", SqlDbType.Int).Value = companyId;
command.Parameters.Add("@created_by", SqlDbType.Int).Value = superAdminId;
command.Parameters.Add("@branch_code", SqlDbType.NVarChar).Value = userCompany.Branch.BranchCode;
con.Open();
command.ExecuteNonQuery();
con.Close();
}
//update user branch id
if (branchId != 0)
{
command = new SqlCommand("spUpdateUserCreatedById", con) { CommandType = CommandType.StoredProcedure };
command.Parameters.Add("@created_by", SqlDbType.Int).Value = superAdminId;
command.Parameters.Add("@user_id", SqlDbType.Int).Value = superAdminId;
con.Open();
command.ExecuteNonQuery();
con.Close();
}
tran.Commit();
return true;
}
catch (SqlException ex)
{
tran.Rollback();
throw ex;
}
}
}
/// <summary>
/// CreatedBy : Kanishka SHM
/// CreatedDate: 2016/01/18
/// EditedDate: 2016/01/19
///
/// company, insert main branch, insert first super admin
/// with sql transaction(Roolback)
///
/// argument : companyName (string)
///
/// </summary>
/// <returns></returns>
public bool SetupCompanyRollback(UserCompanyModel userCompany)
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["AutoDealersConnection"].ToString()))
{
int companyId = 0, branchId = 0, superAdminId = 0;
try
{
var com1 = new SqlCommand("spSetupCompany", con)
{
CommandType = CommandType.StoredProcedure,
};
com1.Parameters.Add("@c_company_name", SqlDbType.NVarChar).Value =
userCompany.Company.CompanyName ?? "";
com1.Parameters.Add("@c_company_code", SqlDbType.NVarChar).Value = userCompany.Company.CompanyCode ?? "";
com1.Parameters.Add("@c_company_address_1", SqlDbType.NVarChar).Value =
userCompany.Company.CompanyAddress1 ?? "";
com1.Parameters.Add("@c_company_address_2", SqlDbType.NVarChar).Value =
userCompany.Company.CompanyAddress2 ?? "";
com1.Parameters.Add("@c_stateId", SqlDbType.Int).Value = userCompany.Company.StateId;
com1.Parameters.Add("@c_city", SqlDbType.NVarChar).Value = userCompany.Company.City ?? "";
com1.Parameters.Add("@c_zip", SqlDbType.NVarChar).Value = userCompany.Company.Zip ?? "";
com1.Parameters.Add("@c_email", SqlDbType.NVarChar).Value = userCompany.Company.Email ?? "";
com1.Parameters.Add("@c_phone_num_1", SqlDbType.NVarChar).Value = userCompany.Company.PhoneNum1 ?? "";
com1.Parameters.Add("@c_phone_num_2", SqlDbType.NVarChar).Value = userCompany.Company.PhoneNum2 ?? "";
com1.Parameters.Add("@c_phone_num_3", SqlDbType.NVarChar).Value = userCompany.Company.PhoneNum3 ?? "";
com1.Parameters.Add("@c_fax", SqlDbType.NVarChar).Value = userCompany.Company.Fax ?? "";
com1.Parameters.Add("@c_website_url", SqlDbType.NVarChar).Value =
userCompany.Company.WebsiteUrl ?? "";
com1.Parameters.Add("@c_created_by", SqlDbType.Int).Value = 0;
com1.Parameters.Add("@c_created_date", SqlDbType.DateTime).Value = DateTime.Now;
com1.Parameters.Add("@c_company_type", SqlDbType.Int).Value = userCompany.Company.TypeId;
com1.Parameters.Add("@c_first_super_admin_id", SqlDbType.Int).Value = 0;
com1.Parameters.AddWithValue("@c_company_status", true);
com1.Parameters.Add("@b_user_id", SqlDbType.Int).Value = 0;
com1.Parameters.Add("@b_branch_code", SqlDbType.NVarChar).Value =
userCompany.Branch.BranchCode ?? "";
com1.Parameters.Add("@b_branch_name", SqlDbType.NVarChar).Value =
userCompany.Branch.BranchName ?? "";
com1.Parameters.Add("@b_branch_address_1", SqlDbType.NVarChar).Value =
userCompany.Branch.BranchAddress1 ?? "";
com1.Parameters.Add("@b_branch_address_2", SqlDbType.NVarChar).Value =
userCompany.Branch.BranchAddress2 ?? "";
com1.Parameters.Add("@b_state_id", SqlDbType.Int).Value = userCompany.Branch.StateId;
com1.Parameters.Add("@b_city", SqlDbType.NVarChar).Value = userCompany.Branch.BranchCity ?? "";
com1.Parameters.Add("@b_zip", SqlDbType.NVarChar).Value = userCompany.Branch.BranchZip ?? "";
com1.Parameters.Add("@b_email", SqlDbType.NVarChar).Value = userCompany.Branch.BranchEmail ?? "";
com1.Parameters.Add("@b_phone_num_1", SqlDbType.NVarChar).Value = userCompany.Branch.BranchPhoneNum1 ?? "";
com1.Parameters.Add("@b_phone_num_2", SqlDbType.NVarChar).Value = userCompany.Branch.BranchPhoneNum2 ?? "";
com1.Parameters.Add("@b_phone_num_3", SqlDbType.NVarChar).Value = userCompany.Branch.BranchPhoneNum3 ?? "";
com1.Parameters.Add("@b_fax", SqlDbType.NVarChar).Value = userCompany.Branch.BranchFax ?? "";
com1.Parameters.Add("@b_company_id", SqlDbType.Int).Value = 0;
com1.Parameters.Add("@b_created_date", SqlDbType.DateTime).Value = DateTime.Now;
com1.Parameters.Add("@u_user_name", SqlDbType.NVarChar).Value = userCompany.User.UserName ?? "";
com1.Parameters.Add("@u_password", SqlDbType.NVarChar).Value = userCompany.User.Password ?? "";
com1.Parameters.Add("@u_first_name", SqlDbType.NVarChar).Value = userCompany.User.FirstName ?? "";
com1.Parameters.Add("@u_last_name", SqlDbType.NVarChar).Value = userCompany.User.LastName ?? "";
com1.Parameters.Add("@u_email", SqlDbType.NVarChar).Value = userCompany.User.Email ?? "";
com1.Parameters.Add("@u_phone_no", SqlDbType.NVarChar).Value = userCompany.User.PhoneNumber ?? "";
com1.Parameters.Add("@u_status", SqlDbType.Bit).Value = userCompany.User.Status;
com1.Parameters.Add("@u_is_delete", SqlDbType.Bit).Value = 0;
com1.Parameters.Add("@u_created_by", SqlDbType.Int).Value = 0;
com1.Parameters.Add("@u_create_Date", SqlDbType.DateTime).Value = DateTime.Now;
com1.Parameters.Add("@u_branch_id", SqlDbType.Int).Value = 0;
com1.Parameters.Add("@u_role_id", SqlDbType.Int).Value = 1;
con.Open();
SqlParameter returnParameter = com1.Parameters.Add("@return", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
com1.ExecuteNonQuery();
int returnVal = (int)returnParameter.Value;
con.Close();
if (returnVal == 1)
{
//get company id
var command = new SqlCommand("spGetCompanyIdByCompanyName", con) { CommandType = CommandType.StoredProcedure };
con.Open();
command.Parameters.Add("@company_name", SqlDbType.NVarChar).Value = userCompany.Company.CompanyName;
using (var reader = command.ExecuteReader())
{
if (reader.Read())
companyId = Convert.ToInt32(reader["company_id"]);
}
con.Close();
//get branch id by branch code
command = new SqlCommand("spGetBranchIdByBranchCode", con) { CommandType = CommandType.StoredProcedure };
con.Open();
command.Parameters.Add("@branch_code", SqlDbType.NVarChar).Value = userCompany.Branch.BranchCode;
using (var reader = command.ExecuteReader())
{
if (reader.Read())
branchId = Convert.ToInt32(reader["branch_id"]);
}
con.Close();
//Get first super admin id
command = new SqlCommand("spGetUserIdByUserName", con) { CommandType = CommandType.StoredProcedure };
con.Open();
command.Parameters.Add("@user_name", SqlDbType.NVarChar).Value = userCompany.User.UserName;
using (var reader = command.ExecuteReader())
{
if (reader.Read())
superAdminId = Convert.ToInt32(reader["user_id"]);
}
con.Close();
//update company super admin
if (superAdminId != 0)
{
command = new SqlCommand("spUpdateCompanySuperAdmin", con) { CommandType = CommandType.StoredProcedure };
command.Parameters.Add("@user_id", SqlDbType.Int).Value = superAdminId;
command.Parameters.Add("@company_name", SqlDbType.NVarChar).Value = userCompany.Company.CompanyName;
con.Open();
command.ExecuteNonQuery();
con.Close();
}
//update branch , company id and created by id
if (companyId != 0)
{
command = new SqlCommand("spUpdateBranchCompanyId", con) { CommandType = CommandType.StoredProcedure };
command.Parameters.Add("@company_id", SqlDbType.Int).Value = companyId;
command.Parameters.Add("@created_by", SqlDbType.Int).Value = superAdminId;
command.Parameters.Add("@branch_code", SqlDbType.NVarChar).Value = userCompany.Branch.BranchCode;
con.Open();
command.ExecuteNonQuery();
con.Close();
}
//update user branch id
if (branchId != 0)
{
command = new SqlCommand("spUpdateUserCreatedById", con) { CommandType = CommandType.StoredProcedure };
command.Parameters.Add("@created_by", SqlDbType.Int).Value = superAdminId;
command.Parameters.Add("@user_id", SqlDbType.Int).Value = superAdminId;
con.Open();
command.ExecuteNonQuery();
con.Close();
}
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw ex;
}
}
}
