public ActionResult EditPartnerCompanyAtDashboard(PartnerCompany partnerCompany) { //check user is super admin or admin if ((userData.RoleId == 1) || (userData.RoleId == 2)) { //check object is not null if (partnerCompany != null) { //assign logged user id to created by property partnerCompany.CreatedBy = userData.UserId; //assign logged user's company id to registered company id property partnerCompany.RegCompanyId = userData.Company_Id; //set zip code partnerCompany.Zip = partnerCompany.ZipPre; if (partnerCompany.Extension != null) partnerCompany.Zip += "-" + partnerCompany.Extension; //check result of update partner company is 1 if ( (new CompanyAccess()).UpdatePartnerCompany(partnerCompany) == 1) { TempData["partnerEditReslt"] = 1; } else { TempData["partnerEditReslt"] = 0; } //return to edit partner company page return RedirectToAction("EditPartnerCompanyAtDashboard"); } else { //if object is null return to login page return new HttpStatusCodeResult(404); } } else { //if user is not super admin or admin return to login page return new HttpStatusCodeResult(404); } }
/// <summary> /// Frontend page: Edit Partner Company /// Title: create view of Edit Partner Company /// Designed : Piyumi Perera /// User story: /// Developed: Piyumi Perera /// Date created: 5/4/2016 /// </summary> /// <returns></returns> public ActionResult EditPartnerCompanyAtDashboard() { //check user is super admin or admin if ((userData.RoleId == 1) || (userData.RoleId == 2)) { CompanyAccess ca = new CompanyAccess(); //get all states List<State> stateList = ca.GetAllStates(); ViewBag.StateId = new SelectList(stateList, "StateId", "StateName"); PartnerCompany pc = new PartnerCompany(); //get all non registered companies by registered company id pc.PartnerCompanyList = ca.GetNonRegCompanyDetailsByRegCompanyId2(userData.Company_Id); //check partner company list is null if (pc.PartnerCompanyList == null) { //create empty partner company list pc.PartnerCompanyList = new List<PartnerCompany>(); } //get company type by user id int comType = (new BranchAccess()).getCompanyTypeByUserId(userData.UserId); //company type 1(lender) - partner company type 2(dealer) //company type 2(dealer) - partner company type 1(lender) ViewBag.ThisCompanyType = (comType == 1) ? "Dealer" : "Lender"; //check result of update partner company is null and value is 1 if (TempData["partnerEditReslt"] != null && int.Parse(TempData["partnerEditReslt"].ToString()) == 1) { //result 1 - success ViewBag.SuccessMsg = "Partner Company Updated Successfully"; } //check result of update partner company is null and value is 0 else if (TempData["partnerEditReslt"] != null && int.Parse(TempData["partnerEditReslt"].ToString()) == 0) { //result 0 - failure ViewBag.ErrorMsg = "Failed to update partner company"; } //return object to view return View(pc); } else { //if user is not super admin or admin return to login page return new HttpStatusCodeResult(404); } }
/// <summary> /// CreatedBy : Piyumi /// CreatedDate: 05/04/2016 /// /// Insert company in setup process /// </summary> /// <param name="company"></param> /// <returns></returns> public int InsertNonRegisteredCompanyAtDashboard(PartnerCompany company) { DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@company_name", company.CompanyName.Trim() }); if (!string.IsNullOrEmpty(company.CompanyCode)) { paramertList.Add(new object[] { "@company_code", company.CompanyCode.Trim() }); } else { paramertList.Add(new object[] { "@company_code", company.CompanyCode}); } paramertList.Add(new object[] { "@company_address_1", company.CompanyAddress1.Trim() }); if (!string.IsNullOrEmpty(company.CompanyAddress2)) { company.CompanyAddress2.Trim(); paramertList.Add(new object[] { "@company_address_2", company.CompanyAddress2.Trim() }); } paramertList.Add(new object[] { "@stateId", company.StateId }); paramertList.Add(new object[] { "@city", company.City.Trim() }); paramertList.Add(new object[] { "@zip", company.Zip.Trim() }); if (!string.IsNullOrEmpty(company.Email)) { company.Email.Trim(); } if (!string.IsNullOrEmpty(company.PhoneNum2)) { company.PhoneNum2.Trim(); } if (!string.IsNullOrEmpty(company.PhoneNum3)) { company.PhoneNum3.Trim(); } paramertList.Add(new object[] { "@email", company.Email }); paramertList.Add(new object[] { "@phone_num_1", company.PhoneNum1 }); paramertList.Add(new object[] { "@phone_num_2", company.PhoneNum2 }); paramertList.Add(new object[] { "@phone_num_3", company.PhoneNum3 }); paramertList.Add(new object[] { "@fax", company.Fax }); paramertList.Add(new object[] { "@website_url", company.WebsiteUrl }); paramertList.Add(new object[] { "@created_by", company.CreatedBy }); paramertList.Add(new object[] { "@created_date", DateTime.Now }); paramertList.Add(new object[] { "@company_type", company.TypeId }); paramertList.Add(new object[] { "@reg_company_id", company.RegCompanyId }); try { return dataHandler.ExecuteSQLReturn("spInsertNonRegisteredCompanyAtDashboard", paramertList); } catch (Exception ex) { throw ex; } }
public ActionResult CreatePartnerCompanyAtDashboard(PartnerCompany partnerCompany) { //check user is super admin or admin if ((userData.RoleId == 1) || (userData.RoleId == 2)) { //check object is not null if (partnerCompany != null) { //set company zip code partnerCompany.Zip = partnerCompany.ZipPre; if (partnerCompany.Extension != null) partnerCompany.Zip += "-" + partnerCompany.Extension; //assign created by property value as logged user id partnerCompany.CreatedBy = userData.UserId; //assign created company type - (1-Lender, 2-Dealer) partnerCompany.TypeId = (userData.CompanyType == 1) ? 2 : 1; ; CompanyAccess ca = new CompanyAccess(); partnerCompany.RegCompanyId = userData.Company_Id; //regCompany.CompanyId; asanka //check result of create partner company if (ca.InsertNonRegisteredCompanyAtDashboard(partnerCompany) == 1) { //assign result to TempData object TempData["partnerReslt"] = 1; } else { TempData["partnerReslt"] = 0; } //return to create partner company page return RedirectToAction("CreatePartnerCompanyAtDashboard"); } else { //if partner company object is null return to login page return new HttpStatusCodeResult(404); } } else { //if user is not a super admin or admin return to login page return new HttpStatusCodeResult(404); } }
public List<PartnerCompany> GetNonRegCompanyDetailsByRegCompanyId2(int company_Id) { List<PartnerCompany> companyList = new List<PartnerCompany>(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@reg_company_id", company_Id }); try { DataSet dsCompany = dataHandler.GetDataSet("spGetNonRegCompanyDetailsByRegCompanyId", paramertList); if (dsCompany != null && dsCompany.Tables.Count != 0) { foreach (DataRow dataRow in dsCompany.Tables[0].Rows) { PartnerCompany company = new PartnerCompany(); company.CompanyId = int.Parse(dataRow["company_Id"].ToString()); company.CompanyName = dataRow["company_name"].ToString(); company.CompanyCode = dataRow["company_code"].ToString(); company.CompanyAddress1 = dataRow["company_address_1"].ToString(); company.CompanyAddress2 = dataRow["company_address_2"].ToString(); company.StateId = int.Parse(dataRow["stateId"].ToString()); company.City = dataRow["city"].ToString(); company.Zip = dataRow["zip"].ToString(); string[] zipWithExtention = company.Zip.Split('-'); if (zipWithExtention[0] != null) company.ZipPre = zipWithExtention[0]; if (zipWithExtention.Count() >= 2 && zipWithExtention[1] != null) company.Extension = zipWithExtention[1]; company.Email = dataRow["email"].ToString(); company.PhoneNum1 = dataRow["phone_num_1"].ToString(); if (!string.IsNullOrEmpty(dataRow["phone_num_2"].ToString())) { company.PhoneNum2 = dataRow["phone_num_2"].ToString().Trim(); } if (!string.IsNullOrEmpty(dataRow["phone_num_3"].ToString())) { company.PhoneNum3 = dataRow["phone_num_3"].ToString().Trim(); } if (!string.IsNullOrEmpty(dataRow["fax"].ToString())) { company.Fax = dataRow["fax"].ToString(); } if (!string.IsNullOrEmpty(dsCompany.Tables[0].Rows[0]["website_url"].ToString())) { company.WebsiteUrl = dataRow["website_url"].ToString().Trim(); } company.TypeId = int.Parse(dataRow["company_type"].ToString()); company.CompanyType = (company.TypeId == 1) ? "Lender" : "Dealer"; companyList.Add(company); } return companyList; } else { return null; } } catch (Exception ex) { throw ex; } }