public DataSet SelectUserContactsbasedonIDFilter(string ContactName, string Designation, string city, string state, string country, string emailid, string contactno, int FKid, string alpha) { objEmailCampDataContext = new EmailCampDataContext(); lstUserContacts = new List <UserContacts>(); var Select = (from cde in objEmailCampDataContext.spUserContacts_AllActions(null, null, ContactName, Designation, alpha, city, state, country, emailid, null, contactno, FKid, null, null, null, null, "e") select cde).ToList(); if (Select.Count > 0) { lstUserContacts = new List <UserContacts>(); foreach (var item in Select) { objUserContacts = new UserContacts(); objUserContacts.Addressline1 = Convert.ToString(item.Addressline1); objUserContacts.City1 = Convert.ToString(item.City1); objUserContacts.CreatedBy = item.CreatedBy; objUserContacts.CreatedOn = item.CreatedOn; objUserContacts.UpdatedBy = item.UpdatedBy; objUserContacts.UpdatedOn = item.UpdatedOn; objUserContacts.Email_id = item.email_id; objUserContacts.FK_UserID = item.FK_UserID; objUserContacts.ContactName = item.ContactName; objUserContacts.PK_ContactID = Convert.ToInt16(item.PK_ContactID.ToString()); objUserContacts.State1 = item.State1; objUserContacts.ContactNo = item.ContactNo; objUserContacts.Country1 = item.Country1; objUserContacts.Designation = item.Designation; objUserContacts.MailContent = item.MailContent; objUserContacts.DateofBirth = item.DateofBirth; lstUserContacts.Add(objUserContacts); } } objEmailCampDataContext = null; objUserContacts = null; DataSet converted = new DataSet(); if (lstUserContacts.Count > 0) { converted.Tables.Add(ListToDataSet.newTable(lstUserContacts)); return(converted); } else { converted.Tables.Add(ListToDataSet.newTableColumnAlone(lstUserContacts)); return(converted); } }
public int SelectUserContactsCountbasedonID(int FKid) { objEmailCampDataContext = new EmailCampDataContext(); var Select = (from cde in objEmailCampDataContext.spUserContacts_AllActions(null, FKid, null, null, null, null, null, null, null, null, null, null, null, null, null, null, "a") select cde).ToList(); int countrec = 0; if (Select.Count > 0) { countrec = Select.Count; } objEmailCampDataContext = null; return(countrec); }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 30-3-2015 /// Comments :: Updation function of UserContacts details. /// </summary> #region Delete_UserContactsCreation public void UserContactsDelete(int UserContactsid) { try { objEmailCampDataContext = new EmailCampDataContext(); var Delete = (from cde in objEmailCampDataContext.spUserContacts_AllActions(UserContactsid, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, "d") select cde).ToList(); Delete = null; objUserContacts = null; objEmailCampDataContext = null; } catch (Exception ex) { ex.ToString(); } }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 30-3-2015 /// Comments :: Updation function of UserContacts details. /// </summary> #region Update_UserContactsCreation public void UserContactsUpdate(UserContacts objUserContacts) { try { objEmailCampDataContext = new EmailCampDataContext(); var Update = (from cde in objEmailCampDataContext.spUserContacts_AllActions(objUserContacts.PK_ContactID, objUserContacts.FK_UserID, objUserContacts.ContactName, objUserContacts.Designation, objUserContacts.Addressline1, objUserContacts.City1, objUserContacts.State1, objUserContacts.Country1, objUserContacts.Email_id, objUserContacts.MailContent, objUserContacts.ContactNo, objUserContacts.CreatedBy, objUserContacts.CreatedOn, objUserContacts.UpdatedBy, objUserContacts.UpdatedOn, objUserContacts.DateofBirth, "u") select cde).ToList(); Update = null; objUserContacts = null; objEmailCampDataContext = null; } catch (Exception ex) { ex.ToString(); } }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 25-4-2015 /// Comments :: Delete duplicate mail id from UserContacts. /// </summary> #region Delete_DuplicateEmailid_Uploading public void DeleteDuplicateEmailidUploading(int Contactlistid, int CreatedBy) { try { objEmailCampDataContext = new EmailCampDataContext(); var Delete = (from cde in objEmailCampDataContext.spUserContacts_AllActions(null, null, null, null, null, null, null, null, null, null, null, CreatedBy, null, null, null, null, "c") select cde).ToList(); Delete = null; objUserContacts = null; objEmailCampDataContext = null; } catch (Exception ex) { ex.ToString(); } }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 30-3-2015 /// Comments :: Select all records for UserContacts details. /// </summary> #region Select_All_Records_CreateUserContacts public List <UserContacts> UserContactsSelectforgrid(int contlistid) { objEmailCampDataContext = new EmailCampDataContext(); lstUserContacts = new List <UserContacts>(); var Select = (from cde in objEmailCampDataContext.spUserContacts_AllActions(contlistid, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, "s") select cde).ToList(); if (Select.Count > 0) { lstUserContacts = new List <UserContacts>(); foreach (var item in Select) { objUserContacts = new UserContacts(); objUserContacts.Addressline1 = Convert.ToString(item.Addressline1); objUserContacts.City1 = Convert.ToString(item.City1); objUserContacts.CreatedBy = item.CreatedBy; objUserContacts.CreatedOn = item.CreatedOn; objUserContacts.UpdatedBy = item.UpdatedBy; objUserContacts.UpdatedOn = item.UpdatedOn; objUserContacts.Email_id = item.email_id; objUserContacts.FK_UserID = item.FK_UserID; objUserContacts.ContactName = item.ContactName; objUserContacts.PK_ContactID = Convert.ToInt16(item.PK_ContactID.ToString()); objUserContacts.State1 = item.State1; objUserContacts.ContactNo = item.ContactNo; objUserContacts.Country1 = item.Country1; objUserContacts.Designation = item.Designation; objUserContacts.MailContent = item.MailContent; objUserContacts.DateofBirth = item.DateofBirth; lstUserContacts.Add(objUserContacts); } } objEmailCampDataContext = null; objUserContacts = null; return(lstUserContacts); }