public bool saveContact(string txtFirstName, string txtLastname, string ddlTitle, string ddlAreaCode, string txtPhoneNumber, string txtAddress, string ddlState, string txtEmail, string txtComment, bool chkRemember, DateTime dob, int userID) { try { LINQContactInformationDataContext cid = new LINQContactInformationDataContext(); ContactInformation ci = new ContactInformation { FirstName = txtFirstName, LastName = txtLastname, Title = ddlTitle, AreaCode = ddlAreaCode, PhoneNumber = txtPhoneNumber, Address = txtAddress, State = ddlState, Email = txtEmail, Comment = txtComment, RememberDob = chkRemember, Dob = dob, UserID = userID }; cid.ContactInformations.InsertOnSubmit(ci); cid.SubmitChanges(); } catch (Exception) { return false; } return true; }
public bool phoneExists(string phone, int userID) { LINQContactInformationDataContext ci = new LINQContactInformationDataContext(); var count = (from p in ci.ContactInformations where p.PhoneNumber == phone && p.UserID == userID select p).Count(); if (count > 0) return true; return false; }
public bool fullNameExists(string firstName, string lastName, int userID) { LINQContactInformationDataContext ci = new LINQContactInformationDataContext(); var count = (from p in ci.ContactInformations where p.FirstName == firstName && p.LastName == lastName && p.UserID == userID select p).Count(); if (count > 0) return true; return false; }
public bool updateContact(string txtFirstName, string txtLastname, string ddlAreaCode, string txtPhoneNumber, string txtAddress, string ddlState, string txtEmail, DateTime dob, int lblID) { try { LINQContactInformationDataContext ci = new LINQContactInformationDataContext(); IQueryable<ContactInformation> results = (from p in ci.ContactInformations where p.ID == lblID select p); foreach (ContactInformation result in results) { result.FirstName = txtFirstName; result.LastName = txtLastname; result.AreaCode = ddlAreaCode; result.PhoneNumber = txtPhoneNumber; result.Address = txtAddress; result.State = ddlState; result.Email = txtEmail; result.Dob = dob; ci.SubmitChanges(); } } catch (Exception) { return false; } return true; }
public IQueryable<ContactInformation> remindBirthday() { LINQContactInformationDataContext ci = new LINQContactInformationDataContext(); var result = (from p in ci.ContactInformations where p.RememberDob == true && p.Dob.Month == DateTime.Now.Month && p.Dob.Day == DateTime.Now.Day && p.UserID == (int)this.Session["login"] select p); return result; }
public IQueryable<ContactInformation> getContact(string[] value, string type, int userID) { if (type == "Name") { LINQContactInformationDataContext ci = new LINQContactInformationDataContext(); var result = (from p in ci.ContactInformations where p.FirstName == value[0] && p.LastName == value[1] && p.UserID == userID select p); return result; } else if (type == "Phone") { LINQContactInformationDataContext ci = new LINQContactInformationDataContext(); var result = (from p in ci.ContactInformations where p.PhoneNumber == value[0] select p); return result; } return null; }