public void UpdateValidationResource(ValidationResource update) { using (var dc = new EngageCCTDataClassesDataContext()) { T_ValidationResource tvr = dc.T_ValidationResources.SingleOrDefault(vr => vr.vrName == update.Name); if (tvr == null) { throw new ApplicationException("Invalid validation resource name"); } tvr.vrDownloadDate = update.DownloadDate; tvr.vrContent = update.Content; dc.SubmitChanges(); } }
public void SaveTask(ScheduledTaskInfo taskInfo) { using (var dc = new EngageCCTDataClassesDataContext()) { T_ScheduledTask tTask; tTask = dc.T_ScheduledTasks.SingleOrDefault(t => t.SheduledTaskID == taskInfo.ID); if (tTask == null) { throw new ApplicationException("Invalid sheduled task ID"); } tTask.stTitle = taskInfo.Title; tTask.stInterval = taskInfo.Interval; tTask.stLastRan = taskInfo.LastRan; dc.SubmitChanges(); } }
private void IncrementLastNumber() { using (var dc = new EngageCCTDataClassesDataContext()) { var config = dc.T_Configurations.First(); config.cfgLastNumber++; dc.SubmitChanges(); } }
public int SaveValidationAddress(ValidationAddress address) { using (var dc = new EngageCCTDataClassesDataContext()) { T_ValidationAddressError tError = new T_ValidationAddressError(); if (address.Error != null) { tError.erDesc = address.Error.Description; tError.erLocation = address.Error.Location; tError.erNumber = address.Error.Number; dc.T_ValidationAddressErrors.InsertOnSubmit(tError); dc.SubmitChanges(); } T_ValidationAddress tAddress = new T_ValidationAddress(); if (!string.IsNullOrEmpty(address.Address)) { tAddress.vadAddress = address.Address; } if (!string.IsNullOrEmpty(address.City)) { tAddress.vadCity = address.City; } if (!string.IsNullOrEmpty(address.Country)) { tAddress.vadCountry = address.Country; } if (!string.IsNullOrEmpty(address.State)) { tAddress.vadState = address.State; } if (!string.IsNullOrEmpty(address.ZipCode)) { tAddress.vadZipCode = address.ZipCode; } if (address.Error != null) { tAddress.ErrorID = tError.ErrorID; } dc.T_ValidationAddresses.InsertOnSubmit(tAddress); dc.SubmitChanges(); return tAddress.AddressID; } }
public void SaveExcludedCompanies(IEnumerable<Company> companies) { using (var dc = new EngageCCTDataClassesDataContext()) { foreach (var company in companies) { T_ExcListCompany tCompany = new T_ExcListCompany(); tCompany.elcAddressLine1 = company.AddressLine1; tCompany.elcAddressLine2 = company.AddressLine2; tCompany.elcAddressLine3 = company.AddressLine3; tCompany.elcAkaDba = company.Aka; tCompany.elcCity = company.City; tCompany.elcComments = company.Comments; tCompany.elcCompanyName = company.CompanyName; tCompany.elcIssuingState = company.IssuingState; tCompany.elcLicenseNumber = company.LicenseNumber; tCompany.elcState = company.State; tCompany.elcZip = company.Zip; dc.T_ExcListCompanies.InsertOnSubmit(tCompany); } dc.SubmitChanges(); } }
public int SaveExcList(int validationID, Lead lead, string status) { using (var dc = new EngageCCTDataClassesDataContext()) { //int statusPassed = dc.T_ValidationStatus // .Where(s => s.vsDescription == ValidationConstants.StatusPassed) // .Select(st => st.StatusID) // .First(); //int statusFailed = dc.T_ValidationStatus // .Where(s => s.vsDescription == ValidationConstants.StatusFailed) // .Select(st => st.StatusID) // .First(); //int statusNoInfo = dc.T_ValidationStatus // .Where(s => s.vsDescription == ValidationConstants.StatusNoInformation) // .Select(st => st.StatusID) // .First(); int exRes = 0; T_ValidationResult tResult = new T_ValidationResult(); T_ValidationFail tExcListValidation = new T_ValidationFail(); LeadValidationManager tLeadVM = new LeadValidationManager(); tResult.ValidationID = validationID; tResult.TypeID = dc.T_ValidationTypes .Where(t => t.vtDescription == ValidationConstants.FreddieList) .Select(tp => tp.TypeID) .First(); if (status != ValidationConstants.StatusNoInformation) { var validResult = LeadValidationManager.SearchInExclusionaryList(lead); if (validResult != null) { exRes = (int)StatusValidation.Failed; tExcListValidation.vfExcList = tLeadVM.GetXmlExcListEntry(validResult); dc.T_ValidationFails.InsertOnSubmit(tExcListValidation); dc.SubmitChanges(); tResult.StatusID = (int)StatusValidation.Failed; tResult.FailID = tExcListValidation.FailID; //--------------- } else { exRes = (int)StatusValidation.Passed; tResult.StatusID = (int)StatusValidation.Passed; tResult.FailID = null; } } else { exRes = (int)StatusValidation.NoInformation; tResult.StatusID = (int)StatusValidation.NoInformation; tResult.FailID = null; } dc.T_ValidationResults.InsertOnSubmit(tResult); dc.SubmitChanges(); return exRes; } }
public int SaveValidationLead(ValidationLead validation) { using (var dc = new EngageCCTDataClassesDataContext()) { T_Validation tValidation = new T_Validation(); tValidation.LeadID = (int)validation.Lead.LeadID; tValidation.Login = validation.User.Login; tValidation.vldDate = DateTime.Now; dc.T_Validations.InsertOnSubmit(tValidation); dc.SubmitChanges(); List<ValidationResult> results = validation.Results; int ofac = 0; int exList = 0; int addVal = 0; int noInfoStatus = dc.T_ValidationStatus .Where(s => s.vsDescription == ValidationConstants.StatusNoInformation) .Select(f => f.StatusID).First(); foreach (var result in results) { switch (result.Type.Type) { case ValidationConstants.OFAC: ofac = SaveOFAC(tValidation.ValidationID, validation.Lead, result.Status.Status); break; case ValidationConstants.FreddieList: exList = SaveExcList(tValidation.ValidationID, validation.Lead, result.Status.Status); break; case ValidationConstants.Address: addVal = SaveAddrValidation(tValidation.ValidationID, validation.Lead, result.Status.Status); break; default: break; } } var tLead = dc.T_Leads.Where(l => l.LeadID == (int)validation.Lead.LeadID).First(); tLead.ldOFAC = ofac; tLead.ldAddrVal = addVal; tLead.ldExlList = exList; dc.SubmitChanges(); return tValidation.ValidationID; } }
public void DeleteActivityNote(int noteID) { using (var dc = new EngageCCTDataClassesDataContext()) { var tNote = dc.T_Notes.AsQueryable().SingleOrDefault(n => n.NoteID == noteID); var tNoteActivity = dc.T_ActivityNotes.AsQueryable().SingleOrDefault(n => n.NoteID == noteID); if (tNote == null || tNoteActivity == null) { throw new ApplicationException("Invalid note ID"); } dc.T_Notes.DeleteOnSubmit(tNote); dc.T_ActivityNotes.DeleteOnSubmit(tNoteActivity); dc.SubmitChanges(); } }
private T_AllowedContact SaveContactPreferences(ContactPreferences contact, int id) { using (var dc = new EngageCCTDataClassesDataContext()) { T_AllowedContact tContact = dc.T_AllowedContacts.SingleOrDefault(c => c.LeadID == id); if (tContact == null) { tContact = new T_AllowedContact(); tContact.LeadID = id; dc.T_AllowedContacts.InsertOnSubmit(tContact); } tContact.acBusinessPhone = contact.IsAllowBusinessPhone; tContact.acCellPhone = contact.IsAllowMobilePhone; tContact.acEmail = contact.IsAllowEmail; tContact.acFax = contact.IsAllowFax; tContact.acHomePhone = contact.IsAllowHomePhone; tContact.acSkypeName = contact.IsAllowSkype; tContact.acPreferredContact = contact.PreferredContact; dc.SubmitChanges(); return tContact; } }
public void LeadModified(int leadId) { using (var dc = new EngageCCTDataClassesDataContext()) { var lead = dc.T_Leads.Where(l => l.LeadID == leadId).FirstOrDefault(); if (lead == null) { throw new Exception("Lead Not Found"); } else { lead.ldCreatedOn = DateTime.Now; dc.SubmitChanges(); } } }
public void DeleteImportantDate(int id) { using (var dc = new EngageCCTDataClassesDataContext()) { var tLeadDate = dc.T_LeadImportantDates.Where(d => d.DateID == id).FirstOrDefault(); var tDate = dc.T_ImportantDates.Where(d => d.DateID == id).FirstOrDefault(); if (tLeadDate == null || tDate == null) { throw new ApplicationException("Important Date not found"); } dc.T_LeadImportantDates.DeleteOnSubmit(tLeadDate); dc.T_ImportantDates.DeleteOnSubmit(tDate); dc.SubmitChanges(); } }
public int SaveLead(Lead entity) { using (var dc = new EngageCCTDataClassesDataContext()) { T_Lead tLead; if (!entity.LeadID.HasValue) { tLead = new T_Lead(); dc.T_Leads.InsertOnSubmit(tLead); } else { tLead = dc.T_Leads.SingleOrDefault(l => l.LeadID == entity.LeadID); if (tLead == null) { throw new ApplicationException("Lead not found"); } } tLead.ldBusinessPhone = entity.BusinessPhone; tLead.ldCompanyName = entity.CompanyName; tLead.ldEmail = entity.Email; tLead.ldFirstName = entity.FirstName; tLead.ldHomePhone = entity.HomePhone; tLead.ldJobTitle = entity.JobTitle; tLead.ldLastName = entity.LastName; tLead.ldMobilePhone = entity.MobilePhone; tLead.ldSkype = entity.Skype; //if (entity.OFAC > 0 && entity.OFAC < 5) //{ tLead.ldOFAC = entity.OFAC; //} //if (tLead.ldExlList > 0 && tLead.ldExlList < 5) //{ tLead.ldExlList = entity.ExlList; //} //if (entity.AddrVal > 0 && entity.AddrVal < 5) //{ tLead.ldAddrVal = entity.AddrVal; //} tLead.ldSSN = entity.SSN; tLead.ldFax = entity.Fax; //SaveContactPreferences(entity.Contact, tLead.LeadID); if (!entity.LeadID.HasValue) { var lastNumber = GetLastNumber(); tLead.ldNumber = (lastNumber + 1).ToString(); entity.Number = lastNumber + 1; IncrementLastNumber(); } if (entity.Honorific != null) { tLead.SalutationID = GetSalutationIdByName(entity.Honorific); } else { tLead.SalutationID = null; } tLead.OwnerID = entity.Owner; tLead.ldTopic = entity.Topic; tLead.ldCreatedOn = entity.CreatedOn; tLead.LeadStatusID = (int)entity.LeadStatus.LeadStatusID; if (entity.LeadSource != null) { tLead.LeadSourceID = entity.LeadSource.LeadSourceID; } if (entity.CompanyAddress != null) { tLead.CompanyAddressID = SaveAddress(entity.CompanyAddress); } if (entity.HomeAddress != null) { tLead.HomeAddressID = SaveAddress(entity.HomeAddress); } if (entity.WorkAddress != null) { tLead.WorkAddressID = SaveAddress(entity.WorkAddress); } if (entity.SubjectPropertyAddress != null) { tLead.SubjectPropertyAddressID = SaveAddress(entity.SubjectPropertyAddress); } dc.SubmitChanges(); //remove this code from line 58 SaveContactPreferences(entity.Contact, tLead.LeadID); if (entity.Notes != null) { foreach (Note item in entity.Notes) { if (!item.NoteID.HasValue) { item.NoteID = SaveNote(item, tLead.LeadID); } else { T_Note tNote = dc.T_Notes.Single(n => n.NoteID == item.NoteID); if (tNote.ntEdited < item.Edited) { SaveNote(item, tLead.LeadID); } } } } //add logic to save important dates if (entity.Dates != null) { foreach (ImportantDate date in entity.Dates) { if (!date.DateID.HasValue) date.DateID = SaveImportantDate(date, tLead.LeadID); else { //T_ImportantDate tDate = dc.T_ImportantDates.SingleOrDefault(d => d.DateID == date.DateID); } } } return tLead.LeadID; } }
public void UpdateImportantDates(int id, string date, string reason, string note) { using (var dc = new EngageCCTDataClassesDataContext()) { Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture("en-US"); //CultureInfo provider = CultureInfo.InvariantCulture; DateTime dt = DateTime.Parse(date); var tDate = dc.T_ImportantDates.Where(d => d.DateID == id).First(); tDate.idtNote = note; tDate.idtReason = reason; tDate.idtDate = dt; dc.SubmitChanges(); } }
public int SaveImportantDate(ImportantDate entity, int leadID) { using (var dc = new EngageCCTDataClassesDataContext()) { T_ImportantDate tDate; T_LeadImportantDate tLeadDate; if (!entity.DateID.HasValue) { tDate = new T_ImportantDate(); tLeadDate = new T_LeadImportantDate(); } else { tDate = dc.T_ImportantDates.SingleOrDefault(d => d.DateID == entity.DateID); tLeadDate = dc.T_LeadImportantDates.SingleOrDefault(d => d.DateID == entity.DateID); if (tDate == null || tLeadDate == null) { throw new ApplicationException("Date not found"); } } tDate.idtNote = entity.Note; tDate.idtReason = entity.Reason; tDate.idtDate = entity.Date; dc.T_ImportantDates.InsertOnSubmit(tDate); if (!entity.DateID.HasValue) dc.SubmitChanges(); tLeadDate.LeadID = leadID; tLeadDate.DateID = tDate.DateID; dc.T_LeadImportantDates.InsertOnSubmit(tLeadDate); dc.SubmitChanges(); return tDate.DateID; } }
private int SaveNote(Note entity, int activityID) { using (var dc = new EngageCCTDataClassesDataContext()) { T_Note tNote; T_ActivityNote tActivityNote; if (!entity.NoteID.HasValue) { tNote = new T_Note(); tActivityNote = new T_ActivityNote(); } else { tNote = dc.T_Notes.SingleOrDefault(n => n.NoteID == entity.NoteID); tActivityNote = dc.T_ActivityNotes.SingleOrDefault(n => n.NoteID == entity.NoteID); if (tNote == null || tActivityNote == null) { throw new ApplicationException("Note not found"); } } tNote.ntCreated = entity.Created; tNote.ntEdited = entity.Edited; tNote.ntText = entity.Text; tNote.ntTitle = entity.Title; dc.T_Notes.InsertOnSubmit(tNote); if (!entity.NoteID.HasValue) { dc.SubmitChanges(); } tActivityNote.NoteID = tNote.NoteID; tActivityNote.ActivityID = activityID; dc.T_ActivityNotes.InsertOnSubmit(tActivityNote); dc.SubmitChanges(); return tNote.NoteID; } }
public void SaveRecipients(List<Recipient> usersRecipients, List<Recipient> leadsRecipients, int activityID) { _dataLeadProvider = new CCTLeadProvider(); using (var dc = new EngageCCTDataClassesDataContext()) { //T_ActivityUserInformation tActivityUserInformation; //T_ActivityLead tActivityLead; //tActivityUserInformation = dc.T_ActivityUserInformations.SingleOrDefault(a => a.ActivityID == activityID); //tActivityLead = dc.T_ActivityLeads.SingleOrDefault(l => l.ActivityID == activityID); //if (tActivityUserInformation == null) //{ // tActivityUserInformation = new T_ActivityUserInformation(); //} //if (tActivityLead == null) //{ // tActivityLead = new T_ActivityLead(); //} if (usersRecipients.Count > 0) { foreach (var user in usersRecipients) { string login = GetUserLoginByFullName(user); T_ActivityUserInformation tActivityUserInformation = new T_ActivityUserInformation(); tActivityUserInformation.ActivityID = activityID; tActivityUserInformation.Login = login; tActivityUserInformation.IsBcc = user.IsBcc; dc.T_ActivityUserInformations.InsertOnSubmit(tActivityUserInformation); dc.SubmitChanges(); } } if (leadsRecipients.Count > 0) { foreach (var lead in leadsRecipients) { int id = _dataLeadProvider.GetLeadIDByFullName(lead); T_ActivityLead tActivityLead = new T_ActivityLead(); tActivityLead.ActivityID = activityID; tActivityLead.LeadID = id; tActivityLead.IsBcc = lead.IsBcc; dc.T_ActivityLeads.InsertOnSubmit(tActivityLead); dc.SubmitChanges(); } } } }
public int SaveAddress(Address entity) { using (var dc = new EngageCCTDataClassesDataContext()) { T_Address tAddress; if (!entity.AddressID.HasValue) { tAddress = new T_Address(); dc.T_Addresses.InsertOnSubmit(tAddress); } else { tAddress = dc.T_Addresses.SingleOrDefault(a => a.AddressID == entity.AddressID); if (tAddress == null) { throw new ApplicationException("Address not found"); } } tAddress.addrCity = entity.City; tAddress.addrCoords = entity.Coords; if (entity.Country != null) { tAddress.CountryID = dc.T_Countries.First(el => el.cntName == entity.Country.Name).CountryID; } tAddress.addrState = entity.State; tAddress.addrStreet = entity.Street; tAddress.addrZipCode = entity.ZipCode; tAddress.addrCounty = entity.County; dc.SubmitChanges(); return tAddress.AddressID; } }
public bool ChangeStatus(int validationID, int typeID, int status) { using (var dc = new EngageCCTDataClassesDataContext()) { T_ValidationResult tResult = new T_ValidationResult(); tResult = dc.T_ValidationResults.Where(r => r.ValidationID == validationID && r.TypeID == typeID).SingleOrDefault(); if (tResult != null) { var tLead = dc.T_Validations.Where(w => w.ValidationID == validationID).Select(s => s.T_Lead).FirstOrDefault(); if (tLead != null) { tLead.ldAddrVal = status; } tResult.StatusID = status; dc.SubmitChanges(); return true; } return false; } }
public void SaveError(Error error) { using (var dc = new EngageCCTDataClassesDataContext()) { T_Error tError = new T_Error(); tError.ErrorID = (Guid)error.ErrorID; tError.errDateTime = error.DateTime; tError.errMessage = error.Message; tError.errSource = error.Source; tError.errStackTrace = error.StackTrace; dc.T_Errors.InsertOnSubmit(tError); dc.SubmitChanges(); } }
public int SaveOFAC(int validationID, Lead lead, string status) { using (var dc = new EngageCCTDataClassesDataContext()) { //int statusPassed = dc.T_ValidationStatus // .Where(s => s.vsDescription == ValidationConstants.StatusPassed) // .Select(st => st.StatusID) // .First(); //int statusFailed = dc.T_ValidationStatus // .Where(s => s.vsDescription == ValidationConstants.StatusFailed) // .Select(st => st.StatusID) // .First(); //int statusNoInfo = dc.T_ValidationStatus // .Where(s => s.vsDescription == ValidationConstants.StatusNoInformation) // .Select(st => st.StatusID) // .First(); T_ValidationResult tResult = new T_ValidationResult(); LeadValidationManager tLeadVM = new LeadValidationManager(); T_ValidationFail tFail = new T_ValidationFail(); //T_Lead tLead = new T_Lead(); tResult.ValidationID = validationID; tResult.TypeID = dc.T_ValidationTypes .Where(t => t.vtDescription == ValidationConstants.OFAC).Select(tp => tp.TypeID).First(); int validStat = 0; if (status != ValidationConstants.StatusNoInformation) { var resultSearchInPLC = LeadValidationManager.SearchInPLC(lead); var resultSearchInSDN = LeadValidationManager.SearchInSDN(lead); if (resultSearchInPLC == null && resultSearchInSDN == null) { validStat = (int)StatusValidation.Passed; tResult.FailID = null; } else { if (resultSearchInPLC != null) { tFail.vfPLC = tLeadVM.GetXmlPLC(resultSearchInPLC); } if (resultSearchInSDN != null) { tFail.vfSDN = tLeadVM.GetXmlSDN(resultSearchInSDN); } dc.T_ValidationFails.InsertOnSubmit(tFail); dc.SubmitChanges(); tResult.FailID = tFail.FailID; validStat = (int)StatusValidation.Failed; } } else { validStat = (int)StatusValidation.NoInformation; tResult.FailID = null; } // if (resultSearchInPLC != null || resultSearchInSDN != null) // { // if (resultSearchInPLC != null) // { // tFail.vfPLC = tLeadVM.GetXmlPLC(resultSearchInPLC); // } // if (resultSearchInSDN != null) // { // tFail.vfSDN = tLeadVM.GetXmlSDN(resultSearchInSDN); // } // dc.T_ValidationFails.InsertOnSubmit(tFail); // dc.SubmitChanges(); // tResult.FailID = tFail.FailID; // } // if (resultSearchInPLC == null && resultSearchInSDN == null) // { // validStat = (int)StatusValidation.Passed; // tResult.FailID = null; // // // } // else // { // validStat = (int)StatusValidation.Failed; // } //} //else //{ // validStat = (int)StatusValidation.NoInformation; // tResult.FailID = null; //} tResult.StatusID = validStat; dc.T_ValidationResults.InsertOnSubmit(tResult); dc.SubmitChanges(); return validStat; } }
public void AddUserInformation(UserInformation entity) { using (var dc = new EngageCCTDataClassesDataContext()) { var userInfo = new T_UserInformation(); userInfo.Login = entity.Login; userInfo.usrFirstName = entity.FirstName; userInfo.usrLastName = entity.LastName; dc.T_UserInformations.InsertOnSubmit(userInfo); dc.SubmitChanges(); } }
public int SaveAddrValidation(int validationID, Lead lead, string status) { using (var dc = new EngageCCTDataClassesDataContext()) { int addrValStatus = 0; int addressID; T_ValidationResult tResult = new T_ValidationResult(); T_ValidationAddress tAddress = new T_ValidationAddress(); T_ValidationAddressError tError = new T_ValidationAddressError(); tResult.ValidationID = validationID; tResult.TypeID = (int)TypeValidation.AddressValidation; if (status != ValidationConstants.StatusNoInformation) { var validAddress = LeadValidationManager.GetValidAddress(lead.SubjectPropertyAddress); if (validAddress.Error != null) { int errorID; ValidationAddressError error = new ValidationAddressError(); error.Description = validAddress.Error.Description; error.Location = validAddress.Error.Location; error.Number = validAddress.Error.Number; errorID = SaveValidationAddressError(error); addrValStatus = (int)StatusValidation.Failed; tAddress.ErrorID = errorID; } else { // SaveValidationAddress(validAddress); bool isCorrect = LeadValidationManager.CompareAddresses(lead.SubjectPropertyAddress, validAddress); if (isCorrect) { addrValStatus = (int)StatusValidation.Passed; } else { addrValStatus = (int)StatusValidation.Error; } } addressID = SaveValidationAddress(validAddress); tResult.AddressID = addressID; tResult.StatusID = addrValStatus; } else { addrValStatus = (int)StatusValidation.NoInformation; tResult.StatusID = addrValStatus; } dc.T_ValidationResults.InsertOnSubmit(tResult); dc.SubmitChanges(); return addrValStatus; } }
//public void CancelOrRestoreLead(int leadId, int newstatusId) //{ // using (EngageCCTDataClassesDataContext dc = new EngageCCTDataClassesDataContext()) // { // var leads = dc.T_Leads; // var lead = leads.FirstOrDefault(l => l.LeadID == leadId); // if (lead == null) // throw new ApplicationException("There are no this lead!"); // else // { // if (lead.ldIsCancelled == true) // { // lead.ldIsCancelled = false; // } // else // { // lead.ldIsCancelled = true; // } // dc.SubmitChanges(); // } // } //} public void UpdateUserInformation(UserInformation entity) { using (EngageCCTDataClassesDataContext dc = new EngageCCTDataClassesDataContext()) { var user = dc.T_UserInformations.FirstOrDefault(u => u.Login == entity.Login); if (user != null) { user.usrFirstName = entity.FirstName; user.usrLastName = entity.LastName; dc.SubmitChanges(); } else throw new ApplicationException("User is not found!"); } }
public void SaveExcludedIndividuals(IEnumerable<Individual> individuals) { using (var dc = new EngageCCTDataClassesDataContext()) { foreach (var individual in individuals) { T_ExcListIndividual tIndividual = new T_ExcListIndividual(); tIndividual.eliAddressLine1 = individual.AddressLine1; tIndividual.eliAddressLine2 = individual.AddressLine2; tIndividual.eliAddressLine3 = individual.AddressLine3; tIndividual.eliAkaDba = individual.Aka; tIndividual.eliCity = individual.City; tIndividual.eliComments = individual.Comments; tIndividual.eliFirstName = individual.FirstName; tIndividual.eliIssuingState = individual.IssuingState; tIndividual.eliLastName = individual.LastName; tIndividual.eliLicenseNumber = individual.LicenseNumber; tIndividual.eliLicenseType = individual.LicenseType; tIndividual.eliState = individual.State; tIndividual.eliZip = individual.Zip; dc.T_ExcListIndividuals.InsertOnSubmit(tIndividual); } dc.SubmitChanges(); } }
public void SaveActivityLead(int activityID, List<Lead> leads) { using (var dc = new EngageCCTDataClassesDataContext()) { var activityLeads = new List<T_ActivityLead>(); foreach (var lead in leads) { if (!dc.T_ActivityLeads.Any(al => (al.LeadID == lead.LeadID) && (al.ActivityID == activityID))) { if (lead.LeadID.HasValue) { activityLeads.Add(new T_ActivityLead { ActivityID = activityID, LeadID = lead.LeadID.Value }); } } } dc.T_ActivityLeads.InsertAllOnSubmit(activityLeads); dc.SubmitChanges(); } }
public int SaveValidationAddressError(ValidationAddressError error) { using (var dc = new EngageCCTDataClassesDataContext()) { T_ValidationAddressError tError = new T_ValidationAddressError(); tError.erDesc = error.Description; tError.erLocation = error.Location; tError.erNumber = error.Number; dc.T_ValidationAddressErrors.InsertOnSubmit(tError); dc.SubmitChanges(); return tError.ErrorID; } }
public int SaveEmailActivity(Activity entity, int Bcc) { using (var dc = new EngageCCTDataClassesDataContext()) { T_Activity tActivity; if (!entity.ActivityID.HasValue) { tActivity = new T_Activity(); dc.T_Activities.InsertOnSubmit(tActivity); } else { tActivity = dc.T_Activities.SingleOrDefault(a => a.ActivityID == entity.ActivityID); if (tActivity == null) { throw new ApplicationException("Activity not found"); } } tActivity.actCreationDate = entity.CreatedOn; tActivity.actPost = entity.Post; tActivity.actSubject = entity.Subject; tActivity.Author = entity.CreatedBy.Login; tActivity.Owner = entity.Owner.Login; tActivity.PriorityID = entity.Priority.PriorityID; tActivity.RecipientID = (int)entity.Recipient.First().LeadID; tActivity.Sender = entity.Sender.Login; tActivity.TypeID = entity.ActivityType.TypeID; tActivity.StatusID = entity.Status.StatusID; if (entity.Due != null) { tActivity.actDue = entity.Due; } if (entity.Phone != null) { tActivity.actPhone = entity.Phone; } if (entity.Address != null) { tActivity.actAddress = entity.Address; } if (entity.Notes != null) { foreach (Note item in entity.Notes) { if (!item.NoteID.HasValue) { item.NoteID = SaveNote(item, tActivity.ActivityID); } else { T_Note tNote = dc.T_Notes.Single(n => n.NoteID == item.NoteID); if (tNote.ntEdited < item.Edited) { SaveNote(item, tActivity.ActivityID); } } } } dc.SubmitChanges(); this.SaveEmailActivityLead(tActivity.ActivityID, entity.Recipient, Bcc); return tActivity.ActivityID; } }
public void SaveEmailActivityLead(int activityID, List<Lead> leads, int Bcc) { using (var dc = new EngageCCTDataClassesDataContext()) { var activityLeads = new List<T_ActivityLead>(); foreach (var lead in leads) { if (!dc.T_ActivityLeads.Any(al => (al.LeadID == lead.LeadID) && (al.ActivityID == activityID))) { if (lead.LeadID.HasValue) { bool isBcc = false; if (leads.IndexOf(lead) >= Bcc) { isBcc = true; } activityLeads.Add(new T_ActivityLead { ActivityID = activityID, LeadID = lead.LeadID.Value, IsBcc = isBcc }); } } else { bool isBcc = false; if (leads.IndexOf(lead) >= Bcc) { isBcc = true; } var activityLead = dc.T_ActivityLeads.First(al => (al.LeadID == lead.LeadID) && (al.ActivityID == activityID)); activityLead.IsBcc = isBcc; } } dc.T_ActivityLeads.InsertAllOnSubmit(activityLeads); dc.SubmitChanges(); } }
public void AddDeleteNotificationToUser(Guid userID, int notificationID, bool flagAdd) { using (EngageCCTDataClassesDataContext dc = new EngageCCTDataClassesDataContext()) { aspnet_User asp_User = dc.aspnet_Users.SingleOrDefault(a => a.UserId == userID); if (asp_User == null) { throw new ApplicationException("There are no this User"); } T_NotificationType t_Ntype = dc.T_NotificationTypes.SingleOrDefault(n => n.TypeID == notificationID); if (t_Ntype == null) { throw new ApplicationException("There are no this notification"); } T_NotificationUser t_userN = dc.T_NotificationUsers.SingleOrDefault(un => un.UserID == userID && un.TypeID == notificationID); if (t_userN == null && flagAdd == true) { t_userN = new T_NotificationUser() { UserID = userID, TypeID = notificationID }; dc.T_NotificationUsers.InsertOnSubmit(t_userN); dc.SubmitChanges(); } if (t_userN != null && flagAdd == false) { dc.T_NotificationUsers.DeleteOnSubmit(t_userN); dc.SubmitChanges(); } } }