public ActionResult Step2(CompanyBranchModel userCompany2)
{
int userId = (int)Session["userId"];
//int userId = 68;
BranchAccess ba = new BranchAccess();
userCompany2.MainBranch.StateId = userCompany2.StateId;
userCompany2.MainBranch.BranchCode = ba.createBranchCode(userCompany.Company.CompanyCode);
userCompany.MainBranch = userCompany2.MainBranch;
int reslt = ba.insertFirstBranchDetails(userCompany, userId);
if (reslt>0)
{
StepAccess sa = new StepAccess();
if (sa.updateStepNumberByUserId(userId, 3))
{
bool reslt2 = ba.updateUserBranchId(userCompany2, userId);
if (reslt2)
{
return RedirectToAction("Step3");
}
}
}
else
{
ViewBag.ErrorMsg = "Failed to create first branch";
}
return View();
}
public ActionResult Step1(Company company, int? edit)
{
if (Session["userId"] == null || Session["userId"].ToString() == "")
return RedirectToAction("UserLogin", "Login");
string type;
if (edit != 1)
{
GeneratesCode gc = new GeneratesCode();
_comCode = company.CompanyCode = gc.GenerateCompanyCode(company.CompanyName);
type = "INSERT";
}
else
{
company.CompanyCode = _comCode;
type = "UPDATE";
}
//
company.Zip = company.ZipPre;
if (company.Extension != null)
company.Zip += "-" + company.Extension;
company.CreatedBy = company.FirstSuperAdminId = Convert.ToInt32(Session["userId"]);
company.CompanyStatus = true;
CompanyAccess ca = new CompanyAccess();
//check this record is new one or exitsting one
//string type = (edit == 1) ? "UPDATE" : "INSERT";
int companyId = ca.InsertCompany(company, type);
if (companyId > 0)
{
ViewBag.SuccessMsg = "Company Successfully setup.";
CompanyType = (company.TypeId == 1) ? "Lender" : "Dealer";
//If succeed update step table to step2
StepAccess sa = new StepAccess();
sa.updateStepNumberByUserId(company.FirstSuperAdminId, 2);
//Send company detail to step 2
CompanyBranchModel comBranch = new CompanyBranchModel();
comBranch.Company = company;
TempData["Company"] = comBranch;
return RedirectToAction("Step2");
}
ViewBag.ErrorMsg = "Failed to Setup company.";
// Get company types to list
List<CompanyType> ctList = ca.GetAllCompanyType();
ViewBag.TypeId = new SelectList(ctList, "TypeId", "TypeName");
//Get states to list
List<State> stateList = ca.GetAllStates();
ViewBag.StateId = new SelectList(stateList, "StateId", "StateName");
return View();
}
public ActionResult EditDashboardBranch(CompanyBranchModel userCompany2, string branchCode)
{
CompanyAccess userCompany = new CompanyAccess();
int userId = userData.UserId;
userCompany2.Company = userCompany.GetCompanyDetailsCompanyId(userData.Company_Id);
userCompany2.MainBranch.StateId = userCompany2.StateId;
userCompany2.MainBranch.BranchCode = branchCode;
BranchAccess ba = new BranchAccess();
if (string.IsNullOrEmpty(branchCode))
{
userCompany2.MainBranch.BranchCode = ba.createBranchCode(userCompany2.Company.CompanyCode);
}
int reslt = ba.insertFirstBranchDetails(userCompany2, userId);
if (reslt == 0)
{
TempData["editBranchResult"] = 1;
if (Session["loanDashboard"] != null)
{
if (((Loan)Session["loanDashboard"]).BranchId == userCompany2.MainBranch.BranchId)
{
((Loan)Session["loanDashboard"]).BranchName = userCompany2.MainBranch.BranchName;
}
}
}
else
{
TempData["editBranchResult"] = 0;
}
return RedirectToAction("EditDashboardBranch");
}
public ActionResult Step2()
{
Session["userId"] = 229;
//Session["userId"] = 4;
//int userId = 68;
if ((Session["userId"] != null) && (Session["userId"].ToString() != ""))
//if(userId>0)
{
int userId = (int)Session["userId"];
StepAccess cs = new StepAccess();
int reslt = Convert.ToInt32(Session["companyStep"]);
if (reslt == 2)
{
if ((TempData["Company"] != null) && (TempData["Company"].ToString() != ""))
{
userCompany = new CompanyBranchModel();
userCompany = (CompanyBranchModel)TempData["Company"];
CompanyType = (userCompany.Company.TypeId == 1) ? "Lender" : "Dealer";
userCompany.MainBranch = new Branch();
if (userCompany.Company.Extension == null)
userCompany.Company.Extension = "";
}
//Get states to list
CompanyAccess ca = new CompanyAccess();
List<State> stateList = ca.GetAllStates();
ViewBag.StateId = new SelectList(stateList, "StateId", "StateName");
return View(userCompany);
}
else
{
return RedirectToAction("UserLogin", "Login");
}
}
else
{
return RedirectToAction("UserLogin", "Login");
}
}
public ActionResult CreateDashboardBranch(CompanyBranchModel userCompany2, string branchCode)
{
CompanyAccess userCompany = new CompanyAccess();
int userId = userData.UserId;
userCompany2.Company = userCompany.GetCompanyDetailsCompanyId(userData.Company_Id);
userCompany2.MainBranch.StateId = userCompany2.StateId;
userCompany2.MainBranch.BranchCode = branchCode;
BranchAccess ba = new BranchAccess();
//Insert record for Branch Table
int reslt = ba.insertFirstBranchDetails(userCompany2, userId);
//Create new record for company Step Table
StepAccess sa = new StepAccess();
sa.UpdateCompanySetupStep(userData.Company_Id, reslt, 3);
if (reslt > 0)
{
TempData["createBranchResult"] = 1;
}
else
{
TempData["createBranchResult"] = 0;
}
return RedirectToAction("CreateDashboardBranch");
}
public ActionResult EditDashboardBranch()
{
CompanyBranchModel userCompany;
//edit = 3;
int userId = userData.UserId;
int roleId = userData.RoleId;
// check he is a super admin or admin
if (roleId != 1)
{
return RedirectToAction("UserLogin", "Login");
}
if (TempData["editBranchResult"] != null)
{
if (int.Parse(TempData["editBranchResult"].ToString()) == 1)
{
ViewBag.SuccessMsg = "Branch is successfully updated";
}
else if (int.Parse(TempData["editBranchResult"].ToString()) == 0)
{
ViewBag.ErrorMsg = "Failed To Update Branch";
}
}
userCompany = new CompanyBranchModel();
ViewBag.BranchIndex = 0;
//Get company details by company id
CompanyAccess ca = new CompanyAccess();
Company preCompany = ca.GetCompanyDetailsCompanyId(userData.Company_Id);
BranchAccess ba = new BranchAccess();
IList<Branch> branches = ba.getBranchesByCompanyCode(preCompany.CompanyCode);
userCompany.SubBranches = branches;
//Get states to list
List<State> stateList = ca.GetAllStates();
ViewBag.StateId = new SelectList(stateList, "StateId", "StateName");
if (HttpContext.Request.IsAjaxRequest())
{
ViewBag.AjaxRequest = 1;
return PartialView(userCompany);
}
else
{
return View(userCompany);
}
}
public ActionResult Step2(string edit1,int? edit)
{
int userId = userData.UserId;
int roleId = userData.RoleId;
// check he is a super admin or admin
if (roleId != 1)
{
//if not a super admin return to login page
return RedirectToAction("UserLogin", "Login");
}
//check insert or update result of branch setup is >0
if (TempData["Step2Reslt"] != null && int.Parse(TempData["Step2Reslt"].ToString())>0)
{
ViewBag.SuccessMsg = "Branch Successfully Created";
}
//check insert or update result of branch setup is 0
else if (TempData["Step2Reslt"] != null && int.Parse(TempData["Step2Reslt"].ToString()) == 0)
{
ViewBag.SuccessMsg = "Branch Successfully Updated";
}
else
{
ViewBag.ErrorMsg = "Failed to Create Branch";
}
//convert Session["companyStep"] to integer
int reslt = Convert.ToInt32(Session["companyStep"]);
//check step is greater than or equal to 2
if (reslt >= 2)
{
CompanyBranchModel userCompany = new CompanyBranchModel();
//check TempData["Company"] is not null and not empty
if ((TempData["Company"] != null) && (TempData["Company"].ToString() != ""))
{
//convert TempData["Company"] to object
userCompany = (CompanyBranchModel)TempData["Company"];
//check zip extension is null
if (userCompany.Company.Extension == null)
//assign empty string to extension
userCompany.Company.Extension = "";
}
userCompany.MainBranch = new Branch();
ViewBag.BranchIndex = 0;
//Get company details by company id
CompanyAccess ca = new CompanyAccess();
Company preCompany = ca.GetCompanyDetailsCompanyId(userData.Company_Id);
userCompany.Company = preCompany;
BranchAccess ba = new BranchAccess();
IList<Branch> branches = ba.getBranchesByCompanyCode(preCompany.CompanyCode);
userCompany.SubBranches = branches;
//Get states to list
List<State> stateList = ca.GetAllStates();
ViewBag.StateId = new SelectList(stateList, "StateId", "StateName");
//check ajax request
if (HttpContext.Request.IsAjaxRequest())
{
ViewBag.AjaxRequest = 1;
return PartialView(userCompany);
}
else
{
return View(userCompany);
}
}
else
{
//if company step is less than 2 return to login page with error message
return RedirectToAction("UserLogin", "Login", new { lbl = "Due to inactivity your session has timed out, please log in again." });
}
}
public ActionResult Step2(CompanyBranchModel userCompany2, string branchCode)
{
//assign logged user's user id to variable
int userId = userData.UserId;
//check Session["companyStep"] is null
if (Session["companyStep"] == null)
{
//check ajax request
if (HttpContext.Request.IsAjaxRequest())
{
//return to login page with error message
return new HttpStatusCodeResult(404, "Due to inactivity your session has timed out, please log in again.");
}
else
{
//return to login page with error message
return RedirectToAction("UserLogin", "Login");
}
}
//assign selected state id to branch object property
userCompany2.MainBranch.StateId = userCompany2.StateId;
//assign branch code to branch object property
userCompany2.MainBranch.BranchCode = branchCode;
BranchAccess ba = new BranchAccess();
userCompany2.Company = new Company();
//check company code of userdata object is not null
if (!string.IsNullOrEmpty(userData.CompanyCode))
{
//assign company code of userdata to company object company code
userCompany2.Company.CompanyCode = userData.CompanyCode;
}
else
{
//get company details
Company cmp = new Company();
cmp = (new CompanyAccess()).GetCompanyDetailsCompanyId(userData.Company_Id);
//assign retrieved company code to company object company code
userCompany2.Company.CompanyCode = cmp.CompanyCode ;
}
//insert branch details
int reslt = ba.insertFirstBranchDetails(userCompany2, userId);
//check inserted or updated result is not 0
if (reslt >= 0)
{
//assign result to a TempData object
TempData["Step2Reslt"] = reslt;
//check current value of company setup is less than 3
if(Convert.ToInt32(Session["companyStep"].ToString()) < 3){
//assign 3 for Session["companyStep"]
Session["companyStep"] = 3;
}
//user object pass to session
if (userData.BranchId == 0)
{
userData.BranchId = reslt;
}
Session["AuthenticatedUser"] = userData;
StepAccess sa = new StepAccess();
//update company setup step table check result
if (sa.UpdateCompanySetupStep(userData.Company_Id, reslt, 3))
{
//return to branch setup page
return RedirectToAction("Step2");
}
}
else
{
//if update or insert result is less than to 0 assign 0 to TempData object
TempData["Step2Reslt"] = 0;
return RedirectToAction("UserLogin", "Login", new { lbl = "Failed to set up branch" });
}
ViewBag.BranchIndex = 0;
//Get company details by user id
userId = userData.UserId;
// need common method for that - asanka
CompanyAccess ca = new CompanyAccess();
Company preCompany = ca.GetCompanyDetailsCompanyId(userData.Company_Id);
IList<Branch> branches = ba.getBranchesByCompanyCode(preCompany.CompanyCode);
//Get states to list
List<State> stateList = ca.GetAllStates();
ViewBag.StateId = new SelectList(stateList, "StateId", "StateName");
if (HttpContext.Request.IsAjaxRequest())
{
ViewBag.AjaxRequest = 1;
return PartialView();
}
else
{
return View();
}
}
/// <summary>
/// CreatedBy : Irfan MAM
/// CreatedDate: 2016/01/27
/// Calling the default view for all step number pages
/// Redirect to Appropriate controller using step number
///
///
///
/// </summary>
/// <returns>Return the view</returns>
public ActionResult Index()
{
//convert Session["companyStep"] to int value
int stepNo = Convert.ToInt32(Session["companyStep"]);
//assign logged user id to variable
int userId = userData.UserId;
//add step no and loan step(loan setup step 1 is considerd as step 6)
stepNo = stepNo + loanstep;
ViewBag.Step = stepNo;
//assign step number to session variable
Session["stepNo"] = stepNo;
//Get company details if branch same as company
//check step number
//stepNo 2 - Branch setup
if (stepNo == 2)
{
CompanyAccess ca = new CompanyAccess();
Company company = ca.GetCompanyDetailsCompanyId(userData.Company_Id);
//return View();
return RedirectToAction("Step2");
}
//stepNo 5 - Partner Branch setup
else if (stepNo == 5)
{
CompanyAccess ca = new CompanyAccess();
//get partner company details
Company nonRegCompany = ca.GetNonRegCompanyDetailsByRegCompanyId(userData.Company_Id);
//if no partcompanies return to step 4 (Partner Company Setup)
if (string.IsNullOrEmpty(nonRegCompany.CompanyName)) return RedirectToAction("Step4", "SetupProcess");
CompanyBranchModel comBranch = new CompanyBranchModel();
comBranch.Company = nonRegCompany;
//assign returned partner company object to TempData object
TempData["NonRegCompany"] = comBranch;
//return View();
return RedirectToAction("Step5");
}
//check stepNo is 0 and return to login page
else if (stepNo == 0)
{
return RedirectToAction("UserLogin", "Login", new { lbl = "Company Setup is on going Please Contact Admin" });
}
//return to appropriate step
else
{
return RedirectToAction("Step" + stepNo);
}
}
public ActionResult Step1(Company company)
{
string type;
//check session company step is null
if (Session["companyStep"] == null)
{
//check ajax request
if (HttpContext.Request.IsAjaxRequest())
{
//return to login page with error message
return new HttpStatusCodeResult(404, "Due to inactivity your session has timed out, please log in again.");
}
else
{
//return to login page with error message
return RedirectToAction("UserLogin", "Login");
}
}
type = "UPDATE";
//check company code is null
if (string.IsNullOrEmpty(company.CompanyCode))
{
//assign type as insert
type = "INSERT";
}
//set zip code
company.Zip = company.ZipPre;
if (company.Extension != null)
company.Zip += "-" + company.Extension;
//assign looged user id to created by property
company.CreatedBy = company.FirstSuperAdminId = userData.UserId;
//assign true for company status
company.CompanyStatus = true;
CompanyAccess ca = new CompanyAccess();
//insert company details and return inserted company id
int companyId = ca.InsertCompany(company, type);
//check company id is not 0
if (companyId > 0)
{
//assign success message
ViewBag.SuccessMsg = "Company Successfully setup.";
//assign company code and company type to user data object company code and company type
userData.CompanyCode = company.CompanyCode;
userData.CompanyType = company.TypeId;
//If succeed update step table to step2
StepAccess sa = new StepAccess();
if (type == "INSERT")
{
bool res = sa.UpdateCompanySetupStep(companyId, userData.BranchId, 2);
//insert to log
Log log = new Log(userData.UserId, companyId, 0, 0, "Company Step", "Inserted company : " + company.CompanyCode, DateTime.Now);
(new LogAccess()).InsertLog(log);
}
else if (type == "UPDATE")
{
//insert to log
Log log = new Log(userData.UserId, companyId, 0, 0, "Company Step", "Updated company : " + company.CompanyCode, DateTime.Now);
(new LogAccess()).InsertLog(log);
}
//check company step is 1
if (Convert.ToInt32(Session["companyStep"].ToString()) < 2)
{
//update company step to 2
Session["companyStep"] = 2;
}
//user object pass to session
userData.Company_Id = companyId;
userData.CompanyName = company.CompanyName;
Session["AuthenticatedUser"] = userData;
//Send company detail to step 2
CompanyBranchModel comBranch = new CompanyBranchModel();
comBranch.Company = company;
TempData["Company"] = comBranch;
return RedirectToAction("Step2");
}
//return RedirectToAction("UserLogin", "Login", new { lbl = "Failed to Setup company." });
return new HttpStatusCodeResult(404, "Failed to Setup company.");
}
public ActionResult Step5(string lbls)
{
int userId = userData.UserId;
BranchAccess ba = new BranchAccess();
//get company type
int compType = ba.getCompanyTypeByUserId(userId);
//if lender company
if (compType == 1)
{
ViewBag.ThisCompanyType = "Dealer";
}
//if dealer company
else if (compType == 2)
{
ViewBag.ThisCompanyType = "Lender";
}
else
{
ViewBag.compType = "";
}
StepAccess cs = new StepAccess();
//convert session to integer
int stepNo = Convert.ToInt32(Session["companyStep"]);
//check step is less than 0
if (stepNo < 0)
{
stepNo = Convert.ToInt32(Session["companyStep"]);
}
//check step is less than 5 and return to login page
if (stepNo < 5) return RedirectToAction("UserLogin", "Login", new { lbl = "Due to inactivity your session has timed out, please log in again." });
//check result of insert or update
if (lbls != null && (lbls.Equals("Dealer branch is successfully created") || lbls.Equals("Lender branch is successfully created")))
{
ViewBag.SuccessMsg = lbls;
//check ajax request
if (HttpContext.Request.IsAjaxRequest())
{
ViewBag.AjaxRequest = 1;
return PartialView();
}
else
{
return View();
}
}
CompanyBranchModel userNonRegCompany = new CompanyBranchModel();
//check TempData["NonRegCompany"] (partner company ) is not null and empty
if ((TempData["NonRegCompany"] != null) && (TempData["NonRegCompany"].ToString() != ""))
{
//convert to model object
userNonRegCompany = (CompanyBranchModel)TempData["NonRegCompany"];
userNonRegCompany.MainBranch = new Branch();
//check extension is null
if (userNonRegCompany.Company.Extension == null)
userNonRegCompany.Company.Extension = "";
}
ViewBag.CurrUserRoleType = userData.RoleId;
//Get states to list
CompanyAccess ca = new CompanyAccess();
List<State> stateList = ca.GetAllStates();
ViewBag.StateId = new SelectList(stateList, "StateId", "StateName");
// get all branches
List<Branch> branchesLists = (new BranchAccess()).getBranches(userData.Company_Id);
ViewBag.RegBranchId = new SelectList(branchesLists, "BranchId", "BranchName");
//Get all non reg companies
List<Company> nonRegCompanyList = ca.GetCompanyByCreayedCompany(userData.Company_Id);
ViewBag.NonRegCompanyId = new SelectList(nonRegCompanyList, "CompanyId", "CompanyName", 1);
NonRegCompanyBranchModel nonRegCompanyBranch = new NonRegCompanyBranchModel();
nonRegCompanyBranch.CompanyBranch = new CompanyBranchModel();
nonRegCompanyBranch.CompanyBranch.Company = new Company();
nonRegCompanyBranch.NonRegCompany= new Company();
//Get all non registered branches by company id
List<NonRegBranch> nonRegBranches = ba.getNonRegBranches(userData.Company_Id);
nonRegCompanyBranch.NonRegBranches = nonRegBranches;
if ((TempData["NonRegCompany"] != null) && (TempData["NonRegCompany"].ToString() != ""))
{
nonRegCompanyBranch.CompanyBranch.Company = userNonRegCompany.Company;
}
else {
nonRegCompanyBranch.CompanyBranch.Company = nonRegCompanyList[0];
}
//check partner company list is not null
if (nonRegCompanyList != null)
{
//check if one partner company and assign that company id
if (nonRegCompanyList.Count() == 1)
{
nonRegCompanyBranch.NonRegCompany.CompanyId = nonRegCompanyList[0].CompanyId;
}
}
//check user is not admin
if (userData.RoleId != 2)
{
//check ajax request
if (HttpContext.Request.IsAjaxRequest())
{
ViewBag.AjaxRequest = 1;
return PartialView(nonRegCompanyBranch);
}
else
{
return View(nonRegCompanyBranch);
}
}
//Select non registered branch for admin's branch
if (nonRegBranches != null) {
var adminBonRegBranches = new List<NonRegBranch>();
adminBonRegBranches.AddRange(nonRegBranches.Where(t => userData.BranchId == t.BranchId));
nonRegCompanyBranch.NonRegBranches = adminBonRegBranches;
}
//check ajax request
if (HttpContext.Request.IsAjaxRequest())
{
ViewBag.AjaxRequest = 1;
return PartialView(nonRegCompanyBranch);
}
else
{
return View(nonRegCompanyBranch);
}
}
public ActionResult Step4(CompanyViewModel nonRegComModel, string companyCode)
{
//assign company code to object
nonRegComModel.Company.CompanyCode = companyCode;
//check company step is null
if (Session["companyStep"] == null)
{
//check ajax request
if (HttpContext.Request.IsAjaxRequest())
{
//return to login with error code 404
return new HttpStatusCodeResult(404, "Due to inactivity your session has timed out, please log in again.");
}
else
{
//return to login page
return RedirectToAction("UserLogin", "Login");
}
}
//assign companay zip with extension
nonRegComModel.Company.Zip = nonRegComModel.Company.ZipPre;
if (nonRegComModel.Company.Extension != null)
nonRegComModel.Company.Zip += "-" + nonRegComModel.Company.Extension;
//assign created by,company type and state id
int userId = userData.UserId;
nonRegComModel.Company.CreatedBy = userId;
nonRegComModel.Company.TypeId = (userData.CompanyType == 1) ? 2:1;
nonRegComModel.Company.StateId = nonRegComModel.StateId;
CompanyAccess ca = new CompanyAccess();
nonRegComModel.Company.CreatedByCompany = userData.Company_Id; //regCompany.CompanyId; asanka
Company nonRegCom = nonRegComModel.Company;
//check result of insert or update partner company
if (ca.InsertNonRegisteredCompany(nonRegCom))
{
//assign success msg according to company type
ViewBag.SuccessMsg = ((userData.CompanyType == 1) ? "Dealer" : "Lender") + " Successfully created.";
//If succeed update step table to step2
StepAccess sa = new StepAccess();
//sa.updateStepNumberByUserId(userId, 5);
sa.UpdateCompanySetupStep(userData.Company_Id, userData.BranchId, 5);
if (Convert.ToInt32(Session["companyStep"].ToString()) < 5)
{
Session["companyStep"] = 5;
}
//Send company detail to step 2
CompanyBranchModel comBranch = new CompanyBranchModel();
comBranch.Company = nonRegCom;
TempData["NonRegCompany"] = comBranch;
return RedirectToAction("Step5");
}
ViewBag.ErrorMsg = "Failed to create " + ((userData.CompanyType == 1) ? "Dealer" : "Lender") + " company.";
//return new HttpStatusCodeResult(404, ViewBag.ErrorMsg);
return RedirectToAction("UserLogin", "Login", new { lbl = ViewBag.ErrorMsg });
}
public int insertNonRegBranchDetails(CompanyBranchModel nonRegBranch, int userId)
{
nonRegBranch.MainBranch.BranchCreatedDate = DateTime.Now;
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]>();
paramertList.Add(new object[] { "@user_id", userId });
//paramertList.Add(new object[] { "@company_code", companyCode });
paramertList.Add(new object[] { "@branch_code", nonRegBranch.MainBranch.BranchCode.Trim() });
if (!string.IsNullOrEmpty(nonRegBranch.MainBranch.BranchName))
{
paramertList.Add(new object[] { "@branch_name", nonRegBranch.MainBranch.BranchName.Trim() });
}
paramertList.Add(new object[] { "@branch_address_1", nonRegBranch.MainBranch.BranchAddress1.Trim() });
paramertList.Add(new object[] { "@branch_address_2", nonRegBranch.MainBranch.BranchAddress2 ?? "" });
paramertList.Add(new object[] { "@state_id", nonRegBranch.MainBranch.StateId });
paramertList.Add(new object[] { "@city", nonRegBranch.MainBranch.BranchCity ?? "" });
if ((nonRegBranch.MainBranch.Extention != null) && (nonRegBranch.MainBranch.Extention.ToString() != ""))
{
nonRegBranch.MainBranch.BranchZip = nonRegBranch.MainBranch.ZipPre + "-" + nonRegBranch.MainBranch.Extention;
}
else
{
nonRegBranch.MainBranch.BranchZip = nonRegBranch.MainBranch.ZipPre;
}
paramertList.Add(new object[] { "@zip", nonRegBranch.MainBranch.BranchZip.Trim() });
paramertList.Add(new object[] { "@email", nonRegBranch.MainBranch.BranchEmail ?? "" });
paramertList.Add(new object[] { "@phone_num_1", nonRegBranch.MainBranch.BranchPhoneNum1.Trim() });
paramertList.Add(new object[] { "@phone_num_2", nonRegBranch.MainBranch.BranchPhoneNum2 ?? "" });
paramertList.Add(new object[] { "@phone_num_3", nonRegBranch.MainBranch.BranchPhoneNum3 ?? "" });
paramertList.Add(new object[] { "@fax", nonRegBranch.MainBranch.BranchFax ?? "" });
paramertList.Add(new object[] { "@created_date", DateTime.Now });
paramertList.Add(new object[] { "@company_id", nonRegBranch.MainBranch.BranchCompany });
paramertList.Add(new object[] { "@branch_id", nonRegBranch.MainBranch.BranchCreatedBy });
try
{
return dataHandler.ExecuteSQLReturn("spInsertNonRegisteredBranch", paramertList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// CreatedBy: Piyumi
/// CreatedDate: 2016/1/17
/// Insert branch details
/// </summary>
/// <param name="branch object"></param>
/// <param name="id"></param>
/// <returns>true/false</returns>
//public int insertBranchDetails(Branch branch, int id)
//{
// branch.BranchCode = createBranchCode(getCompanyCodeByUserId(id));
// branch.BranchCompany = getCompanyIdByUserId(id);
// branch.BranchCreatedDate = DateTime.Now;
// return this.insertBranch(branch, id);
//}
/// <summary>
/// CreatedBy: Piyumi
/// CreatedDate: 2016/1/26
/// Insert branch details
/// </summary>
/// <param name="branch object"></param>
/// <param name="userCompany3"></param>
/// <param name="id"></param>
/// <returns>true/false</returns>
public int insertFirstBranchDetails(CompanyBranchModel userCompany3, int id)
{
string companyCode = userCompany3.Company.CompanyCode;
//userCompany3.MainBranch.BranchCode = createBranchCode(companyCode);
userCompany3.MainBranch.BranchCompany = getCompanyIdByCompanyCode(companyCode);
userCompany3.MainBranch.BranchCreatedDate = DateTime.Now;
return this.insertBranch(userCompany3.MainBranch, id, companyCode);
}
/// <summary>
/// CreatedBy:piyumi
/// CreatedDate:2016/1/27
/// update branch id when first branch is created
///
///
/// UpdatedBy : nadeeka
/// UpdatedDate: 2016/03/03
/// removed existing connection open method and set parameter's to object list and pass stored procedure name to
/// call DataHandler class to update given branch details
///
/// </summary>
/// <param name=""></param>
/// <returns></returns>
public bool updateUserBranchId(CompanyBranchModel nonRegBranch, int userId)
{
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]>();
paramertList.Add(new object[] { "@user_id", userId });
paramertList.Add(new object[] { "@branch_code", nonRegBranch.MainBranch.BranchCode });
try
{
return dataHandler.ExecuteSQL("spUpdateBranchId", paramertList) ? true : false;
}
catch (Exception ex)
{
throw ex;
}
}
