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