Exemple #1
0
 public static void Delete(int ContactId)
 {
     using (SimpleContactListEntities db = new SimpleContactListEntities())
     {
         db.Contact_Delete(ContactId);
     }
 }
Exemple #2
0
 public static int Insert(
     string ContactType,
     string LastName,
     string FirstName,
     string MiddleName,
     string Gender,
     string EmailAddress,
     string Number,
     string Address1,
     string Address2,
     string City,
     string State_Province_County,
     string Country,
     string Zipcode)
 {
     using (SimpleContactListEntities db = new SimpleContactListEntities())
     {
         return(db.Contact_Insert(
                    ContactType,
                    LastName,
                    FirstName,
                    MiddleName,
                    Gender,
                    EmailAddress,
                    Number,
                    Address1,
                    Address2,
                    City,
                    State_Province_County,
                    Country,
                    Zipcode
                    ).ElementAt(0).Value);
     }
 }
Exemple #3
0
 public static List <Contact_GetAll_Result> GetAll()
 {
     using (SimpleContactListEntities db = new SimpleContactListEntities())
     {
         return(db.Contact_GetAll().ToList());
     }
 }
Exemple #4
0
 public static Contact_GetById_Result GetById(int ContactId)
 {
     using (SimpleContactListEntities db = new SimpleContactListEntities())
     {
         return(db.Contact_GetById(ContactId).ElementAtOrDefault(0));
     }
 }
 public static int Insert(
     string ContactType,
     string LastName,
     string FirstName,
     string MiddleName,
     string Gender,
     string EmailAddress,
     string Number,
     string Address1,
     string Address2,
     string City,
     string State_Province_County,
     string Country,
     string Zipcode)
 {
     using (SimpleContactListEntities db = new SimpleContactListEntities())
     {
         return db.Contact_Insert(
             ContactType,
             LastName,
             FirstName,
             MiddleName,
             Gender,
             EmailAddress,
             Number,
             Address1,
             Address2,
             City,
             State_Province_County,
             Country,
             Zipcode
         ).ElementAt(0).Value;
     }
 }
 public static Contact_GetById_Result GetById(int ContactId)
 {
     using (SimpleContactListEntities db = new SimpleContactListEntities())
     {
         return db.Contact_GetById(ContactId).ElementAtOrDefault(0);
     }
 }
 public static List<Contact_GetAll_Result> GetAll()
 {
     using (SimpleContactListEntities db = new SimpleContactListEntities())
     {
         return db.Contact_GetAll().ToList();
     }
 }
        public static void Update(
            int ContactId,
            string ContactType,
            string LastName,
            string FirstName,
            string MiddleName,
            string Gender,
            string EmailAddress,
            string Number,
            string Address1,
            string Address2,
            string City,
            string State_Province_County,
            string Country,
            string Zipcode)
        {
            using (SimpleContactListEntities db = new SimpleContactListEntities())
            {
                db.Contact_Update(
                    ContactId,
                    ContactType,
                    LastName,
                    FirstName,
                    MiddleName,
                    Gender,
                    EmailAddress,
                    Number,
                    Address1,
                    Address2,
                    City,
                    State_Province_County,
                    Country,
                    Zipcode
                );
            }

        }
Exemple #9
0
 public static void Update(
     int ContactId,
     string ContactType,
     string LastName,
     string FirstName,
     string MiddleName,
     string Gender,
     string EmailAddress,
     string Number,
     string Address1,
     string Address2,
     string City,
     string State_Province_County,
     string Country,
     string Zipcode)
 {
     using (SimpleContactListEntities db = new SimpleContactListEntities())
     {
         db.Contact_Update(
             ContactId,
             ContactType,
             LastName,
             FirstName,
             MiddleName,
             Gender,
             EmailAddress,
             Number,
             Address1,
             Address2,
             City,
             State_Province_County,
             Country,
             Zipcode
             );
     }
 }
 public static void Delete(int ContactId)
 {
     using (SimpleContactListEntities db = new SimpleContactListEntities())
     {
         db.Contact_Delete(ContactId);
     }
 }