public void DeleteLeads(Lead lead) { try { context.Leads.Attach(lead); context.Entry(lead).State = EntityState.Deleted; SaveChanges(); } catch (Exception ex) { throw ex; } }
public long InsertLeads(Lead lead) { try { lead.CreatedTime = DateTime.Now; lead.ModifiedTime = DateTime.Now; context.Entry(lead).State = EntityState.Added; context.SaveChanges(); return lead.LeadID; } catch (Exception ex) { throw ex; } }
public long UpdateLeads(Lead lead) { try { // var Leads = (context.Leads.Where(lead1 => lead1.LeadID == lead.LeadID)).FirstOrDefault(); var currentLead = context.Leads.Find(lead.LeadID); // currentLead.ModifiedTime = DateTime.Now; //context.Entry(Leads).State = EntityState.Modified; context.Entry(currentLead).CurrentValues.SetValues(lead); context.SaveChanges(); return lead.LeadID; } catch (Exception ex) { throw ex; } }
public void DeleteLeads(Lead lead) { leadrepository.DeleteLeads(lead); }
private void ValidateLead(Lead lead) { if (lead.ContactID != null) { int companyid = Convert.ToInt32(HttpContext.Current.Session["CompanyID"]); var duplicateLead = leadrepository.GetLeadByContactID(lead.ContactID, companyid).FirstOrDefault(); if (duplicateLead != null && duplicateLead.LeadID != lead.LeadID) { if (duplicateLead.ContactID == lead.ContactID) { throw new DuplicateLeadException(String.Format( "Contact Name {0} is already exist", duplicateLead.Contact.FirstName + " " + duplicateLead.Contact.LastName )); } } } }
public long UpdateLeads(Lead lead) { ValidateLead(lead); try { return leadrepository.UpdateLeads(lead); } catch (Exception ce) { throw ce; } }
public long InsertLeads(Lead lead) { ValidateLead(lead); try { return leadrepository.InsertLeads(lead); } catch (Exception ex) { throw ex; } }
protected void ImportButton_Click(object sender, EventArgs e) { long count = 0; string firstName=null; string lastname=null; StreamReader Sr =new StreamReader(@"C:\Users\rizwanul.islam\My Projects\Default Collections\C3\C3App\C3App\LeadImport.csv"); System.Text.StringBuilder sb = new System.Text.StringBuilder(); // System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); string s; bool passedFirstline = false; while (!Sr.EndOfStream) { s = Sr.ReadLine(); string[] value = s.Split(','); if (passedFirstline) { DAL.Contact contact=new DAL.Contact(); if (value[0]!=null) { firstName = value[0]; contact.FirstName = firstName; } else { contact.FirstName = "None"; } if (value[1] != null) { lastname = value[1]; contact.LastName = lastname; } else { contact.LastName = "None"; } if (value[2] != null) { contact.PrimaryEmail = value[2]; } else { contact.PrimaryEmail = "None"; } contact.CompanyID = Convert.ToInt32(Session["CompanyID"]); contact.CreatedBy = Convert.ToInt64(Session["UserID"]); contact.CreatedTime = DateTime.Now; contact.ModifiedTime = DateTime.Now; Int64 contactID = contactBL.InsertContact(contact); if (contactID!=null) { Lead lead=new Lead(); lead.ContactID = contactID; lead.FirstName = firstName; lead.LastName = lastname; lead.CompanyID = Convert.ToInt32(Session["CompanyID"]); lead.CreatedBy = Convert.ToInt64(Session["UserID"]); lead.CreatedTime = DateTime.Now; lead.ModifiedTime = DateTime.Now; Int64 leadID = leadBL.InsertLeads(lead); if (leadID!=0) { count++; } } } else { passedFirstline = true; } } Literal1.Text = "Successfully Imported"; Label1.Text = count +" "+"Data has been successfully imported to lead"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "script", "ShowAlertModal();", true); }