public ActionResult UpdateLeads(LeadsModel objLeadmodel)
{
objResponse Response = new objResponse();
Project.Entity.Leads objLead = new Entity.Leads();
session = new SessionHelper();
List <TextValue> source = new List <TextValue>();
source = UtilityManager.GetSourceForDropDown(Convert.ToInt64(session.UserSession.PIN), "Client", "Source");
List <SelectListItem> list = new List <SelectListItem>();
list.Add(new SelectListItem {
Value = "0", Text = "Choose a Source"
});
foreach (var cat in source)
{
list.Add(new SelectListItem {
Value = cat.Value, Text = cat.Text
});
}
string route = "/Leads/ViewLead?sessionid=" + Guid.NewGuid().ToString() + "&Leadid=" + objLeadmodel.Lead_ID;
try
{
//objLead.Date = BAL.Helper.Helper.ConvertToDateNullable(objLeadmodel.Date, "dd/MM/yyyy");
// objLead.FollowUpDate = BAL.Helper.Helper.ConvertToDateNullable(objLeadmodel.FollowUpDate, "dd/MM/yyyy");
objLead.Name = objLeadmodel.Name;
objLead.CompanyName = objLeadmodel.CompanyName;
objLead.Email = objLeadmodel.Email;
objLead.ContactNo = objLeadmodel.ContactNo;
objLead.SkypeNo = objLeadmodel.SkypeNo;
objLead.ZipCode = objLeadmodel.ZipCode;
objLead.AddressLine1 = objLeadmodel.AddressLine1;
objLead.AddressLine2 = objLeadmodel.AddressLine2;
objLead.City = objLeadmodel.City;
objLead.State = objLeadmodel.State;
objLead.Country = objLeadmodel.Country;
objLead.Alternate_Email = objLeadmodel.Alternate_Email;
objLead.Source = objLeadmodel.Source;
objLead.JobDescription = objLeadmodel.JobDescription;
objLead.Lead_ID_Auto_PK = objLeadmodel.Lead_ID;
session = new SessionHelper();
Response = objLeadsManager.UpdateLead(objLead, session.UserSession.UserId);
if (Response.ErrorCode == 0)
{
ViewBag.Source_List = list;
// return RedirectToRoute("LeadHome");
//return RedirectToRoute("ViewLead");
//return View(objLeadmodel);
return(Redirect(route));
}
else
{
ViewBag.Error_Msg = Response.ErrorMessage;
ViewBag.Source_List = list;
// return RedirectToRoute("LeadHome");
//return RedirectToRoute("ViewLead");
return(View(objLeadmodel));
}
}
catch (Exception ex)
{
ViewBag.Error_Msg = Response.ErrorMessage;
ViewBag.Source_List = list;
BAL.Common.LogManager.LogError("UpdateLead Post Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
// return RedirectToRoute("LeadHome");
//return RedirectToRoute("ViewLead");
return(View(objLeadmodel));
}
}
public ActionResult ImportExcelFileToLeadDataTable()
{
objResponse Response = new objResponse();
session = new SessionHelper();
List <Project.Entity.Leads> leads = new List <Entity.Leads>();
BAL.Leads.LeadsManager objLeadsManager = new LeadsManager();
DataTable dt = new DataTable();
// string Result="";
try
{
string fname;
if (Request.Files.Count > 0)
{
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
// Checking for Internet Explorer
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = file.FileName;
}
if ((file != null) && (file.ContentLength != 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
string fileContentType = file.ContentType;
byte[] fileBytes = new byte[file.ContentLength];
var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));
}
var excel = new ExcelPackage(file.InputStream);
dt = ExcelPackageExtensions.ToDataTable(excel);
int count = 0;
foreach (DataRow dr in dt.Rows)
{
Project.Entity.Leads objLead = new Entity.Leads();
objLead.Name = dr[0].ToString();
objLead.CompanyName = dr[1].ToString();
objLead.Email = dr[2].ToString();
objLead.Alternate_Email = dr[3].ToString();
objLead.ContactNo = dr[4].ToString();
objLead.SkypeNo = dr[5].ToString();
objLead.AddressLine1 = dr[6].ToString();
objLead.AddressLine2 = dr[7].ToString();
objLead.City = dr[8].ToString();
objLead.State = dr[9].ToString();
objLead.Country = dr[10].ToString();
objLead.ZipCode = dr[11].ToString();
objLead.Source = dr[12].ToString();
Response = objLeadsManager.ImportLead(objLead, session.UserSession.Username, Convert.ToInt64(session.UserSession.PIN));
if (Response.ErrorCode == 0)
{
if (Response.ErrorMessage != "Lead with same Email Already Exists")
{
count++;
}
}
else
{
return(Json("Fail", JsonRequestBehavior.AllowGet));
}
}
return(Json("Success," + count.ToString(), JsonRequestBehavior.AllowGet));
}
return(Json("fail", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("fail", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("ImportExcelFileToLeadDataTable", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("fail", JsonRequestBehavior.AllowGet));
}
}
public ActionResult ManageLead(LeadsModel objLeadmodel)
{
objResponse Response = new objResponse();
Project.Entity.Leads objLead = new Entity.Leads();
session = new SessionHelper();
List <TextValue> source = new List <TextValue>();
source = objSetingManager.GetDropDownListing("Lead", "Source", Convert.ToInt64(session.UserSession.PIN));
List <SelectListItem> list = new List <SelectListItem>();
list.Add(new SelectListItem {
Value = "0", Text = "Choose a Source"
});
foreach (var cat in source)
{
list.Add(new SelectListItem {
Value = cat.Value, Text = cat.Text
});
}
try
{
objLead.Date = DateTime.Now;
objLead.Name = objLeadmodel.Name;
objLead.CompanyName = objLeadmodel.CompanyName;
objLead.Email = objLeadmodel.Email;
objLead.ContactNo = objLeadmodel.ContactNo;
objLead.SkypeNo = objLeadmodel.SkypeNo;
objLead.Category_ID = objLeadmodel.Category.ToString();
objLead.ZipCode = objLeadmodel.ZipCode;
objLead.AddressLine1 = objLeadmodel.AddressLine1;
objLead.AddressLine2 = objLeadmodel.AddressLine2;
objLead.City = objLeadmodel.City;
objLead.State = objLeadmodel.State;
objLead.Country = objLeadmodel.Country;
objLead.Alternate_Email = objLeadmodel.Alternate_Email;
objLead.Source = objLeadmodel.Source;
objLead.JobDescription = objLeadmodel.JobDescription;
session = new SessionHelper();
Response = objLeadsManager.AddLead(objLead, Convert.ToInt64(session.UserSession.UserId), Convert.ToInt64(session.UserSession.PIN));
if (Response.ErrorCode == 0)
{
if (Response.ErrorMessage != "Lead with same Email Already Exists")
{
return(RedirectToRoute("LeadHome"));
}
else
{
ViewBag.Error_Msg = Response.ErrorMessage;
ViewBag.Source_List = list;
return(View());
}
}
else
{
ViewBag.Error_Msg = Response.ErrorMessage;
ViewBag.Source_List = list;
return(View());
}
}
catch (Exception ex)
{
ViewBag.Error_Msg = Response.ErrorMessage;
ViewBag.Source_List = list;
BAL.Common.LogManager.LogError("ManageLead Post Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(View());
}
}
public ActionResult ImportCsvFileToLeadDataTable()
{
objResponse Response = new objResponse();
session = new SessionHelper();
List <Project.Entity.Leads> leads = new List <Entity.Leads>();
BAL.Leads.LeadsManager objLeadsManager = new LeadsManager();
DataTable dt = new DataTable();
// string Result="";
try
{
string fname;
if (Request.Files.Count > 0)
{
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
// Checking for Internet Explorer
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = file.FileName;
}
string filePath = Server.MapPath(file.FileName);
string newFileName = "IMP_Csv_" + session.UserSession.UserId + "_" + fname;
string newFilePath = Server.MapPath(ConfigurationManager.AppSettings["Import_Csv_Dir"]) + newFileName;
file.SaveAs(newFilePath);
dt = FileImporter.CsvPackageExtension.GetDataTableFromCSVFile(newFilePath);
int count = 0;
foreach (DataRow dr in dt.Rows)
{
Project.Entity.Leads objLead = new Entity.Leads();
objLead.Name = dr[0].ToString();
objLead.CompanyName = dr[1].ToString();
objLead.Email = dr[2].ToString();
objLead.Alternate_Email = dr[3].ToString();
objLead.ContactNo = dr[4].ToString();
objLead.SkypeNo = dr[5].ToString();
objLead.AddressLine1 = dr[6].ToString();
objLead.AddressLine2 = dr[7].ToString();
objLead.City = dr[8].ToString();
objLead.State = dr[9].ToString();
objLead.Country = dr[10].ToString();
objLead.ZipCode = dr[11].ToString();
objLead.Source = dr[12].ToString();
Response = objLeadsManager.ImportLead(objLead, session.UserSession.Username, Convert.ToInt64(session.UserSession.PIN));
if (Response.ErrorCode == 0)
{
if (Response.ErrorMessage != "Lead with same Email Already Exists")
{
count++;
}
}
else
{
return(Json("fail", JsonRequestBehavior.AllowGet));
}
}
if (System.IO.File.Exists(newFilePath))
{
System.IO.File.Delete(newFilePath);
}
return(Json("Success," + count.ToString(), JsonRequestBehavior.AllowGet));
}
return(Json("fail", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("fail", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("ImportCsvFileToLeadDataTable", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("fail", JsonRequestBehavior.AllowGet));
}
}
