public ActionResult AddLead(string leadId) { LeadViewModel objviewmodel = new LeadViewModel(); SALES_tblLeads objData = new SALES_tblLeads(); if (!string.IsNullOrEmpty(leadId)) { objviewmodel.lstBillingPartner = CR.GetBillingPartner(); objviewmodel.lstcategory = CR.GetRetailCategory(); objviewmodel.lstStates = CR.GetStates(); objviewmodel.lstCity = CR.GetCity(); objData = SLR.GetsalesLeadByLeadId(Convert.ToInt32(leadId)); objData.FollowupDate = objData.FollowupDate.Value.Date; objData.Comments = ""; objviewmodel.sALES_TblLeads = objData; } else { objviewmodel.lstBillingPartner = CR.GetBillingPartner(); objviewmodel.lstcategory = CR.GetRetailCategory(); objviewmodel.lstStates = CR.GetStates(); objviewmodel.lstCity = CR.GetCity(); objviewmodel.sALES_TblLeads = objData; } return View(objviewmodel); }
public SALES_tblLeads GetsalesLeadByLeadId(int LeadId) { SALES_tblLeads objsaleslead = new SALES_tblLeads(); using (var context = new CommonDBContext()) { objsaleslead = context.SALES_tblLeads.Where(x => x.LeadId == LeadId).FirstOrDefault(); } return(objsaleslead); }
public BOTS_TblGroupMaster MeargeLeadData(SALES_tblLeads leadDetails) { BOTS_TblGroupMaster objGroupDetails = new BOTS_TblGroupMaster(); objGroupDetails.GroupName = leadDetails.BusinessName; objGroupDetails.OwnerName = leadDetails.AuthorizedPerson; objGroupDetails.OwnerMobileNo = leadDetails.MobileNo; objGroupDetails.City = leadDetails.City; objGroupDetails.OwnerEmailId = leadDetails.EmailId; return(objGroupDetails); }
public bool UpdateStatus(int LeadId, string GroupId) { bool status = false; SALES_tblLeads objlead = new SALES_tblLeads(); SALES_tblLeadTracking objsalestracking = new SALES_tblLeadTracking(); using (var context = new CommonDBContext()) { objlead = context.SALES_tblLeads.Where(x => x.LeadId == LeadId).FirstOrDefault(); objlead.UpdatedDate = DateTime.Now; objlead.MeetingType = "salesdone"; objlead.GroupId = GroupId; context.SALES_tblLeads.AddOrUpdate(objlead); context.SaveChanges(); objsalestracking.LeadId = objlead.LeadId; objsalestracking.ContactType = objlead.ContactType; objsalestracking.SpokeWith = objlead.SpokeWith; objsalestracking.LeadStatus = objlead.LeadStatus; objsalestracking.MeetingType = "salesdone"; objsalestracking.FollowupDate = objlead.FollowupDate; objsalestracking.BillingPartner = objlead.BillingPartner; objsalestracking.NoOfOutlet = objlead.NoOfOutlet; objsalestracking.EcomIntegration = objlead.EcomIntegration; objsalestracking.Address = objlead.Address; objsalestracking.State = objlead.State; objsalestracking.AlternateNo = objlead.AlternateNo; objsalestracking.EmailId = objlead.EmailId; objsalestracking.AuthorizedPerson = objlead.AuthorizedPerson; objsalestracking.APMobileNo = objlead.APMobileNo; objsalestracking.PriceQuoted = objlead.PriceQuoted; objsalestracking.LeadSource = objlead.LeadSource; objsalestracking.LeadSourceName = objlead.LeadSourceName; objsalestracking.Comments = objlead.Comments; objsalestracking.AddedBy = objlead.AddedBy; objsalestracking.AddedDate = DateTime.Now; context.SALES_tblLeadTracking.AddOrUpdate(objsalestracking); context.SaveChanges(); status = true; } return(status); }
public bool LeadTransfer(int[] LeadId, string SaleManagerId, string addedby) { bool result = false; try { SALES_tblLeads objsaleslead = new SALES_tblLeads(); SALES_tblLeadTracking objsalesleadtracking = new SALES_tblLeadTracking(); // string connStr = objCustRepo.GetCustomerConnString(GroupId); using (var contextNew = new CommonDBContext()) { foreach (int leadid in LeadId) { if (leadid != 0) { objsaleslead = contextNew.SALES_tblLeads.Where(x => x.LeadId == leadid).FirstOrDefault(); objsaleslead.AssignedLead = SaleManagerId; objsaleslead.UpdatedDate = DateTime.Now; contextNew.SALES_tblLeads.AddOrUpdate(objsaleslead); contextNew.SaveChanges(); objsalesleadtracking = contextNew.SALES_tblLeadTracking.Where(x => x.LeadId == leadid).FirstOrDefault(); if (objsalesleadtracking != null) { objsalesleadtracking.AssignedLead = SaleManagerId; objsalesleadtracking.AddedBy = addedby; objsalesleadtracking.AddedDate = DateTime.Now; contextNew.SALES_tblLeadTracking.AddOrUpdate(objsalesleadtracking); contextNew.SaveChanges(); } result = true; } } //} } } catch (Exception ex) { newexception.AddException(ex, "LeadTransfer"); } return(result); }
public ActionResult AddCustomer(OnBoardingSalesViewModel objData) { bool status = false; int GroupdId = 0; try { var userDetails = (CustomerLoginDetail)Session["UserSession"]; List <BOTS_TblRetailMaster> objLstRetail = new List <BOTS_TblRetailMaster>(); List <BOTS_TblInstallmentDetails> objLstInstallment = new List <BOTS_TblInstallmentDetails>(); List <BOTS_TblOutletMaster> objLstOutlet = new List <BOTS_TblOutletMaster>(); SALES_tblLeads leadDetails = new SALES_tblLeads(); List <SelectListItem> refferedname = new List <SelectListItem>(); SelectListItem item1 = new SelectListItem(); item1.Value = "0"; item1.Text = "Please Select"; refferedname.Add(item1); objData.lstAllGroups = refferedname; objData.lstCity = CR.GetCity(); objData.lstRetailCategory = CR.GetRetailCategory(); objData.lstBillingPartner = CR.GetBillingPartner(); objData.lstSourcedBy = CR.GetSourcedBy(); objData.lstRMAssigned = CR.GetRMAssigned(); objData.lstRefferedCategory = CR.GetAllRefferedCategory(); objData.lstStates = CR.GetStates(); JavaScriptSerializer json_serializer = new JavaScriptSerializer(); json_serializer.MaxJsonLength = int.MaxValue; object[] objCategoryData = (object[])json_serializer.DeserializeObject(objData.bots_TblGroupMaster.CategoryData); object[] objPaymentScheduleData = (object[])json_serializer.DeserializeObject(objData.bots_TblGroupMaster.PaymentScheduleData); foreach (Dictionary <string, object> item in objCategoryData) { BOTS_TblRetailMaster objItem = new BOTS_TblRetailMaster(); objItem.GroupId = Convert.ToString(item["GroupId"]); objItem.CategoryId = Convert.ToString(item["CategoryId"]); objItem.CategoryName = Convert.ToString(item["CategoryName"]); objItem.BrandName = Convert.ToString(item["BrandName"]); objItem.BrandId = Convert.ToString(item["BrandId"]); objItem.NoOfOutlets = Convert.ToInt64(item["NoOfOutlets"]); objItem.NoOfEnrolled = Convert.ToInt64(item["NoOfEnrolled"]); objItem.BOProduct = Convert.ToString(item["BOProduct"]); objItem.BillingPartner = Convert.ToString(item["BillingPartner"]); objItem.BillingProduct = Convert.ToString(item["BillingProduct"]); objLstRetail.Add(objItem); } foreach (Dictionary <string, object> item in objPaymentScheduleData) { BOTS_TblInstallmentDetails objItem = new BOTS_TblInstallmentDetails(); objItem.GroupId = Convert.ToString(item["GroupId"]); objItem.Installment = Convert.ToInt32(item["Installment"]); objItem.PaymentDate = Convert.ToDateTime(item["PaymentDate"]); objItem.PaymentAmount = Convert.ToDecimal(item["PaymentAmount"]); objLstInstallment.Add(objItem); } objData.bots_TblGroupMaster.CreatedBy = userDetails.LoginId; objData.bots_TblGroupMaster.CreatedDate = DateTime.Now; if (objData.bots_TblGroupMaster.CustomerStatus == "CSUpdate") { object[] objOutletData = (object[])json_serializer.DeserializeObject(objData.bots_TblGroupMaster.OutletData); foreach (Dictionary <string, object> item in objOutletData) { BOTS_TblOutletMaster objItem = new BOTS_TblOutletMaster(); objItem.Id = Convert.ToInt32(item["Id"]); objItem.GroupId = Convert.ToString(item["GroupId"]); objItem.BrandId = Convert.ToString(item["BrandId"]); objItem.OutletId = Convert.ToString(item["OutletId"]); objItem.OutletName = Convert.ToString(item["OutletName"]); objItem.AreaName = Convert.ToString(item["AreaName"]); objItem.AuthorisedPerson = Convert.ToString(item["AuthorisedPerson"]); objItem.RegisterMobileNo = Convert.ToString(item["RegisterMobileNo"]); objItem.RegisterEmail = Convert.ToString(item["RegisterEmail"]); objItem.Address = Convert.ToString(item["Address"]); objItem.Latitude = Convert.ToString(item["Latitude"]); objItem.Longitude = Convert.ToString(item["Longitude"]); objItem.City = Convert.ToString(item["City"]); objItem.PinCode = Convert.ToString(item["PinCode"]); objItem.State = Convert.ToString(item["State"]); objLstOutlet.Add(objItem); } GroupdId = OBR.AddOnboardingCustomer(objData.bots_TblGroupMaster, objLstRetail, objData.bots_TblDealDetails, objData.bots_TblPaymentDetails, objLstInstallment, objLstOutlet); if (objData.LeadId != null) { status = SLR.UpdateStatus(Convert.ToInt32(objData.LeadId), Convert.ToString(GroupdId)); } } else { GroupdId = OBR.AddOnboardingCustomer(objData.bots_TblGroupMaster, objLstRetail, objData.bots_TblDealDetails, objData.bots_TblPaymentDetails, objLstInstallment, objLstOutlet); if (objData.LeadId != null) { status = SLR.UpdateStatus(Convert.ToInt32(objData.LeadId), Convert.ToString(GroupdId)); } } objData.objRetailList = OBR.GetRetailDetails(Convert.ToString(GroupdId)); objData.lstOutlets = OBR.GetOutletDetails(Convert.ToString(GroupdId)); if (objData.lstOutlets.Count > 0) { var brandId = 1; var outletId = 1; foreach (var item2 in objData.objRetailList) { for (int i = 1; i <= item2.NoOfEnrolled; i++) { BOTS_TblOutletMaster outlet = new BOTS_TblOutletMaster(); outlet.Id = 0; outlet.BrandId = Convert.ToString(brandId); outlet.OutletId = Convert.ToString(outletId); outlet.BrandName = item2.BrandName; objData.lstOutlets.Add(outlet); outletId++; } brandId++; } } if (GroupdId > 0 && objData.bots_TblGroupMaster.CustomerStatus == "CS") { SendEmail(GroupdId); } TempData["status"] = true; } catch (Exception ex) { newexception.AddException(ex, ""); TempData["error"] = "Error Occured"; return(View("Index")); } CommonFunctions common = new CommonFunctions(); var groupId = common.EncryptString(Convert.ToString(GroupdId)); //return View("Index", objData); //return RedirectToAction("Index", "CustomerOnBoarding", groupId); return(RedirectToAction("Index", "CustomerOnBoarding", new { @groupId = groupId })); }
public int AddSalesLead(SALES_tblLeads objtbllead) { SALES_tblLeads objlead = new SALES_tblLeads(); SALES_tblLeadTracking objsalestracking = new SALES_tblLeadTracking(); int leadId = 0; using (var context = new CommonDBContext()) { if (objtbllead.LeadId == 0) { context.SALES_tblLeads.Add(objtbllead); context.SaveChanges(); leadId = objtbllead.LeadId; objsalestracking.LeadId = objtbllead.LeadId; objsalestracking.ContactType = objtbllead.ContactType; objsalestracking.SpokeWith = objtbllead.SpokeWith; objsalestracking.LeadStatus = objtbllead.LeadStatus; objsalestracking.MeetingType = objtbllead.MeetingType; objsalestracking.FollowupDate = objtbllead.FollowupDate; objsalestracking.BillingPartner = objtbllead.BillingPartner; objsalestracking.NoOfOutlet = objtbllead.NoOfOutlet; objsalestracking.EcomIntegration = objtbllead.EcomIntegration; objsalestracking.Address = objtbllead.Address; objsalestracking.State = objtbllead.State; objsalestracking.AlternateNo = objtbllead.AlternateNo; objsalestracking.EmailId = objtbllead.EmailId; objsalestracking.AuthorizedPerson = objtbllead.AuthorizedPerson; objsalestracking.APMobileNo = objtbllead.APMobileNo; objsalestracking.PriceQuoted = objtbllead.PriceQuoted; objsalestracking.LeadSource = objtbllead.LeadSource; objsalestracking.LeadSourceName = objtbllead.LeadSourceName; objsalestracking.Comments = objtbllead.Comments; objsalestracking.AddedBy = objtbllead.AddedBy; objsalestracking.AddedDate = objtbllead.AddedDate; objsalestracking.AssignedLead = objtbllead.AddedBy; context.SALES_tblLeadTracking.AddOrUpdate(objsalestracking); context.SaveChanges(); } else { objlead = context.SALES_tblLeads.Where(x => x.LeadId == objtbllead.LeadId).FirstOrDefault(); objtbllead.UpdatedDate = DateTime.Now; objtbllead.Category = objlead.Category; objtbllead.Product = objlead.Product; objtbllead.City = objlead.City; if (objtbllead.MeetingType == "salesdone") { objtbllead.MeetingType = objlead.MeetingType; } context.SALES_tblLeads.AddOrUpdate(objtbllead); context.SaveChanges(); //leadId = objtbllead.LeadId; objsalestracking.LeadId = objlead.LeadId; objsalestracking.ContactType = objtbllead.ContactType; objsalestracking.SpokeWith = objtbllead.SpokeWith; objsalestracking.LeadStatus = objtbllead.LeadStatus; if (objtbllead.MeetingType == "salesdone") { objsalestracking.MeetingType = objlead.MeetingType; } else { objsalestracking.MeetingType = objtbllead.MeetingType; } objsalestracking.FollowupDate = objtbllead.FollowupDate; objsalestracking.BillingPartner = objtbllead.BillingPartner; objsalestracking.NoOfOutlet = objtbllead.NoOfOutlet; objsalestracking.EcomIntegration = objtbllead.EcomIntegration; objsalestracking.Address = objtbllead.Address; objsalestracking.State = objtbllead.State; objsalestracking.AlternateNo = objtbllead.AlternateNo; objsalestracking.EmailId = objtbllead.EmailId; objsalestracking.AuthorizedPerson = objtbllead.AuthorizedPerson; objsalestracking.APMobileNo = objtbllead.APMobileNo; objsalestracking.PriceQuoted = objtbllead.PriceQuoted; objsalestracking.LeadSource = objtbllead.LeadSource; objsalestracking.LeadSourceName = objtbllead.LeadSourceName; objsalestracking.Comments = objtbllead.Comments; objsalestracking.AddedBy = objtbllead.AddedBy; objsalestracking.AddedDate = objtbllead.AddedDate; objsalestracking.AssignedLead = objtbllead.AddedBy; context.SALES_tblLeadTracking.AddOrUpdate(objsalestracking); context.SaveChanges(); leadId = objtbllead.LeadId; } } return(leadId); }