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