protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { IUserServiceContext userServiceContext = new UserServiceContext(_accessToken, _apiKey); IListService listServiceContext = new ListService(userServiceContext); if (Request.QueryString["LeadID"] != null) { int leadID = Convert.ToInt32(Request.QueryString["LeadID"]); DailyLeadEntity dailyLead = dailyLeadHelper.GetLeadRecordsByLeadID(leadID); txtDoT.Text = dailyLead.DOTNumber; txtBusinessName.Text = dailyLead.LegalName; txtComplianceAgent.Text = Request.Cookies["Name"].Value; txtBestPhone.Text = dailyLead.PhoneNo; } ContactList[] contactlist = listServiceContext.GetLists(DateTime.Now.Subtract(new TimeSpan(2000, 2000, 2000))).ToArray(); List <ContactList> contactData = new List <ContactList>(); foreach (ContactList item in contactlist) { ContactList contactitem = item; contactData.Add(contactitem); } drpEmailList.DataSource = contactData; drpEmailList.DataTextField = "Name"; drpEmailList.DataValueField = "Id"; drpEmailList.DataBind(); } }
protected void btnSearchByDOTNo_Click(object sender, EventArgs e) { DailyLeadEntity LeadsData = leadHelper.GetLeadRecordsByDOTNo(txtDOTNo.Text); List <DailyLeadEntity> lstLeadsData = new List <DailyLeadEntity>(); lstLeadsData.Add(LeadsData); lstOfLeads.DataSource = lstLeadsData; lstOfLeads.DataBind(); UpdateLeadStats(lstLeadsData); }
public static string GetUSDOTDetails(string usdotno) { MCSaleHelper mcSaleHelper = new MCSaleHelper(); MCSaleEntity mcSale = mcSaleHelper.GetMCSaleUSDotNo(usdotno); if (mcSale == null) { DailyLeadsHelper leadHelper = new DailyLeadsHelper(); DailyLeadEntity LeadsData = leadHelper.GetLeadRecordsByDOTNo(usdotno); var json = new JavaScriptSerializer().Serialize(LeadsData); return(json); } var jsonSale = new JavaScriptSerializer().Serialize(mcSale); return(jsonSale); }
public DailyLeadEntity GetLeadRecordsByDOTNo(string DOTNo) { DailyLeadEntity dailyLeadRecord = new DailyLeadEntity(); using (uow = new UnitOfWork.UnitOfWork()) { try { dailyLeadRecord = uow.DailyLeadRepository.Get().Where(x => x.DOTNumber.Equals(DOTNo)).Select(po => new DailyLeadEntity { AuthForHire = po.AuthForHire, DailyLeadID = po.DailyLeadID, DateFiled = po.DateFiled, DOTNumber = po.DOTNumber, Drivers = po.Drivers, Interstate = po.Interstate, LeadDocID = po.LeadDocID, LegalName = po.LegalName, MailingAddress = po.MailingAddress, OperatingStatus = po.OperatingStatus, PhoneNo = po.PhoneNo, PhysicalAddress = po.PhysicalAddress, PowerUnits = po.PowerUnits, Status = po.Status, TimeZone = po.TimeZone, ZipCode = po.ZipCode, SavedOn = po.SavedOn //}).OrderByDescending(x => Convert.ToDateTime(x.SavedOn)).ToList(); }).FirstOrDefault(); } catch { } } return(dailyLeadRecord); }
protected void btnAddLead_Click(object sender, EventArgs e) { LeadData lead = new LeadData(); lead.BusinessName = txtBusinessName.Text; lead.ComplianceAgent = txtComplianceAgent.Text; lead.ContactName = txtContactName.Text; lead.DOTNo = txtDoT.Text; lead.Email = txtEmail.Text; lead.Notes = txtNotes.Text; lead.PhoneNoForContact = txtBestPhone.Text; lead.SalesPersonID = Convert.ToInt32(Request.Cookies["UserID"].Value); lead.ServiceDiscussed = txtServiceDiscussed.Text; lead.TimeLine = txtTimeLine.Text; bool isLeadAdded = leadHelper.AddLead(lead); IUserServiceContext userServiceContext = new UserServiceContext(_accessToken, _apiKey); ConstantContactFactory serviceFactory = new ConstantContactFactory(userServiceContext); //List<string> lists = new List<string>() { "1236366064" }; List <string> lists = new List <string>(); string[] emailid = hdnEmailID.Value.Split(','); foreach (string item in emailid) { if (!String.IsNullOrEmpty(item)) { lists.Add(item); } } List <ContactList> contactLists = new List <ContactList>(); foreach (string list in lists) { ContactList contactList = new ContactList() { Id = list }; contactLists.Add(contactList); } if (isLeadAdded) { int leadID = Convert.ToInt32(Request.QueryString["LeadID"]); DailyLeadEntity dailyLead = dailyLeadHelper.GetLeadRecordsByLeadID(leadID); var contactService = serviceFactory.CreateContactService(); string physicalCity = ""; try { physicalCity = dailyLead.PhysicalAddress.Split(',')[1].Split(null)[1]; } catch { } Address address = new Address(); try { address = new Address() { AddressType = "BUSINESS", City = toString(physicalCity), CountryCode = "US", Line1 = toString(dailyLead.MailingAddress.Substring(0, 40)), Line2 = toString(dailyLead.MailingAddress.Substring(0, 40)), PostalCode = toString(dailyLead.ZipCode), StateCode = toString("ID"), }; } catch { address = new Address() { AddressType = "BUSINESS" }; } try { if (dailyLead != null) { Contact contact = new Contact() { Addresses = new List <Address> { address }, Lists = contactLists, CellPhone = dailyLead.PhoneNo, CompanyName = toString(dailyLead.LegalName), Confirmed = true, EmailAddresses = new List <EmailAddress> { new EmailAddress(toString(txtEmail.Text)) }, Fax = dailyLead.PhoneNo, FirstName = txtContactName.Text, HomePhone = txtBestPhone.Text, JobTitle = "Purcell Compliance Lead", LastName = toString(""), PrefixName = "Mr.", WorkPhone = dailyLead.PhoneNo }; contactService.AddContact(contact, false); } else { Contact contact = new Contact() { Addresses = new List <Address> { address }, Lists = contactLists, CellPhone = txtBestPhone.Text, CompanyName = toString(txtBusinessName.Text), Confirmed = true, EmailAddresses = new List <EmailAddress> { new EmailAddress(toString(txtEmail.Text)) }, Fax = txtBestPhone.Text, FirstName = txtContactName.Text, HomePhone = txtBestPhone.Text, JobTitle = "Purcell Compliance Lead", LastName = toString(""), PrefixName = "Mr.", WorkPhone = txtBestPhone.Text }; contactService.AddContact(contact, false); } Response.Write("<script>alert('Lead added Successfully.');</script>"); resetControls(); } catch { //Response.Write("<script>alert('" + ex.Message + "');</script>"); } } else { Response.Write("<script>alert('Some error occured.');</script>"); } }
protected void lstUsers_ItemCommand(object sender, ListViewCommandEventArgs e) { if (e.CommandName == "Upl") { FileUpload fileUpl = e.Item.FindControl("flUpload") as FileUpload; LeadDocEntity leadEntity = new LeadDocEntity(); string fileName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + fileUpl.FileName; leadEntity.DocumentName = fileUpl.FileName; leadEntity.DocumentPath = "Uploads/" + fileName; leadEntity.UploadedFor = Convert.ToInt32(e.CommandArgument); leadEntity.UploadDate = GetCurrentTime().ToShortDateString(); leadEntity.UploadedBy = Request.Cookies["Name"].Value; //int leadDocID = leadDocHelper.CheckDoc(leadEntity); int leadDocID = 0; if (leadDocID == 0) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; fileUpl.SaveAs(Server.MapPath("~/Uploads/" + fileName)); int isuploaded = leadDocHelper.AddLeadDoc(leadEntity); if (isuploaded > 0) { var excelName = Server.MapPath("~/Uploads/" + fileName); var connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelName + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";"; var adapter = new OleDbDataAdapter("SELECT * FROM [Leads$]", connectionString); var ds = new DataSet(); try { adapter.Fill(ds, "ExcelFileData"); } catch (Exception ex) { Response.Write("<script>alert('" + ex.Message + "');</script>"); } DataTable data = ds.Tables["ExcelFileData"]; List <DataRow> list = data.AsEnumerable().ToList(); List <DailyLeadEntity> listLeadsData = new List <DailyLeadEntity>(); foreach (DataRow item in list) { DailyLeadEntity saleData = new DailyLeadEntity(); saleData.AuthForHire = item["AuthForHire"].ToString(); saleData.DateFiled = item["DateFiled"].ToString(); saleData.DOTNumber = item["DOTNumber"].ToString(); saleData.Drivers = item["Drivers"].ToString(); saleData.Interstate = item["Interstate"].ToString(); saleData.LeadDocID = isuploaded; saleData.LegalName = item["LegalName"].ToString(); saleData.MailingAddress = item["MailingAddress"].ToString(); saleData.OperatingStatus = item["OperatingStatus"].ToString(); saleData.PhoneNo = item["PhoneNo"].ToString(); saleData.PhysicalAddress = item["PhysicalAddress"].ToString(); saleData.PowerUnits = item["PowerUnits"].ToString(); saleData.Status = "New Leads"; saleData.TimeZone = item["TimeZone"].ToString(); saleData.ZipCode = item["ZipCode"].ToString(); listLeadsData.Add(saleData); } dailyLeadsHelper.AddBulkLeads(listLeadsData); // = list.Select(new DailyLeadEntity() { AuthForHire = list["AuthForHire"] }).ToList(); Response.Write("<script>alert('Lead uploaded Successfully.');</script>"); } else { Response.Write("<script>alert('Some error occured.');</script>"); } } else { leadEntity.LeadDocID = leadDocID; fileUpl.SaveAs(Server.MapPath("~/Uploads/" + fileName)); leadDocHelper.UpdateLeadDoc(leadEntity); Response.Write("<script>alert('Lead updated Successfully.');</script>"); } } }