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