public List <ContactDal> GetAll() { List <ContactDal> la = new List <ContactDal>(); using (SqlConnection con = new SqlConnection()) { con.ConnectionString = connectionString; using (SqlCommand command = con.CreateCommand()) { command.CommandText = "select * from VueContact"; con.Open(); using (SqlDataReader read = command.ExecuteReader()) { while (read.Read()) { ContactDal a = new ContactDal(); a.contactId = (int)read["contactId"]; a.adCodePostal = (string)read["adCodePostal"]; a.adNumero = (string)read["adNumero"]; a.adVille = (string)read["adVille"]; //a.clientPwd = (string)read["biereImage"]; a.adRue = (string)read["adRue"]; a.mailInfon = (string)read["mailInfon"]; a.nomBrasserie = (string)read["nomBrasserie"]; a.telephone = (string)read["telephone"]; la.Add(a); } } } } return(la); }
public ContactDal GetOne(int id) { ContactDal b = new ContactDal(); using (SqlConnection con = new SqlConnection()) { con.ConnectionString = connectionString; using (SqlCommand command = con.CreateCommand()) { command.CommandText = "Select * from Contact where contactId=@id"; command.Parameters.AddWithValue("id", id); con.Open(); using (SqlDataReader dataReader = command.ExecuteReader()) { while (dataReader.Read()) { b.contactId = (int)dataReader["contactId"]; b.brasserieId = (int?)dataReader["brasserieId"]; b.adCodePostal = (string)dataReader["adCodePostal"]; b.adNumero = (string)dataReader["adNumero"]; b.adRue = (string)dataReader["adRue"]; b.adVille = (string)dataReader["adVille"]; b.telephone = (string)dataReader["telephone"]; } } } } return(b); }
public List <ContactDal> GetAll() { List <ContactDal> lb = new List <ContactDal>(); using (SqlConnection con = new SqlConnection()) { con.ConnectionString = connectionString; using (SqlCommand command = con.CreateCommand()) { command.CommandText = "Select * from Contact"; con.Open(); using (SqlDataReader dataReader = command.ExecuteReader()) { while (dataReader.Read()) { ContactDal b = new ContactDal(); b.contactId = (int)dataReader["contactId"]; b.brasserieId = (int?)dataReader["brasserieId"]; b.adCodePostal = (string)dataReader["adCodePostal"]; b.adNumero = (string)dataReader["adNumero"]; b.adRue = (string)dataReader["adRue"]; b.adVille = (string)dataReader["adVille"]; b.telephone = (string)dataReader["telephone"]; lb.Add(b); } } } } return(lb); }
public int Create(ContactDal parametre) { using (SqlConnection con = new SqlConnection()) { con.ConnectionString = connectionString; using (SqlCommand command = con.CreateCommand()) { command.CommandText = "AddContactBis"; SqlParameter pid = new SqlParameter(); pid.ParameterName = "ID"; pid.Value = 0; pid.Direction = System.Data.ParameterDirection.Output; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue(nameof(parametre.adCodePostal), parametre.adCodePostal); command.Parameters.AddWithValue(nameof(parametre.adNumero), parametre.adNumero); command.Parameters.AddWithValue(nameof(parametre.adRue), parametre.adRue); command.Parameters.AddWithValue(nameof(parametre.adVille), parametre.adVille); command.Parameters.AddWithValue(nameof(parametre.telephone), parametre.telephone); command.Parameters.Add(pid); con.Open(); command.ExecuteNonQuery(); int id = (int)command.Parameters["ID"].Value; return(id); } } }
public static ContactDal GetContactDal(this ContactWPF wpf) { ContactDal dal = new ContactDal(); dal.adNumero = wpf.adNumero; dal.adCodePostal = wpf.adCodePostal; dal.adRue = wpf.adRue; dal.adVille = wpf.adVille; dal.brasserieId = wpf.brasserieId; dal.contactId = wpf.contactId; dal.telephone = wpf.telephone; return(dal); }
public static ContactWPF GetContactWPF(this ContactDal dal) { ContactWPF wpf = new ContactWPF(); wpf.adCodePostal = dal.adCodePostal; wpf.adNumero = dal.adNumero; wpf.adRue = dal.adRue; wpf.adVille = dal.adVille; wpf.brasserieId = dal.brasserieId; wpf.contactId = dal.contactId; wpf.telephone = dal.telephone; return(wpf); }
public static ContactDal GetContactDal(this ContactAPI contactAPI) { ContactDal contactDal = new ContactDal(); contactDal.adCodePostal = contactAPI.adCodePostal; contactDal.adNumero = contactAPI.adNumero; contactDal.adRue = contactAPI.adRue; contactDal.adVille = contactAPI.adVille; contactDal.contactId = contactAPI.contactId; contactDal.mailInfon = contactAPI.mailInfon; contactDal.nomBrasserie = contactAPI.nomBrasserie; contactDal.telephone = contactAPI.telephone; return(contactDal); }
/// <summary> /// Deleted a contact /// </summary> /// <param name="id">Id contact to deleted</param> /// <param name="objContex">Get table to object</param> public static void Delete(int id, ModelUnibookContainer objContex) { try { ContactDal.Delete(id, objContex); } catch (DbEntityValidationException ex) { throw ex; } catch (Exception ex) { throw ex; } }
private void Test_Click(object sender, RoutedEventArgs e) { // MessageBox.Show("Hello, world!"); ContactDal cdal = new ContactDal(); List <Contact> contacts = cdal.ReadInfos(); // MessageBox.Show(contacts.ToString()); foreach (Contact c in contacts) { lvContacts.ItemsSource = contacts; //MessageBox.Show(c.ToString()); // Console.WriteLine(c.FirstName); } }
public ActionResult Submit() { Contact newContact = new Contact(); newContact.name = Request.Form["name"]; newContact.subject = Request.Form["subject"]; newContact.massage = Request.Form["massage"]; ContactDal cdal = new ContactDal(); cdal.contacts.Add(newContact); cdal.SaveChanges(); return(View("Thanks")); }
/// <summary> /// Get contact by id /// </summary> /// <param name="id">Id contact to search</param> /// <returns>Return object contact</returns> public static Contact Get(int id, ModelUnibookContainer objContex) { Contact contact = null; try { contact = ContactDal.Get(id, objContex); } catch (DbEntityValidationException ex) { throw ex; } catch (Exception ex) { throw ex; } return(contact); }
/// <summary> /// Insert a contact /// </summary> /// <param name="contact">Object contact to insert</param> /// <param name="objContex">Get table to object</param> public static void Insert(ContactDto contactDto, ModelUnibookContainer objContex) { try { Contact contact = new Contact(); contact.ContactId = contactDto.ContactId; contact.Data = contactDto.Data; contact.Description = contactDto.Description; contact.Person = PersonBrl.Get(contactDto.Person.PersonId, objContex); ContactDal.Insert(contact, objContex); } catch (DbEntityValidationException ex) { throw ex; } catch (Exception ex) { throw ex; } }
/// <summary> /// Update a contact /// </summary> /// <param name="objContex">Get table to object</param> public static void Update(ContactDto contactDto, ModelUnibookContainer objContex) { try { Contact contact = ContactDal.Get(contactDto.ContactId, objContex); contact.Data = contactDto.Data; contact.Description = contactDto.Description; contact.Deleted = contactDto.Deleted; contact.Person = PersonBrl.Get(contactDto.Person.PersonId, objContex); ContactDal.Update(objContex); } catch (DbEntityValidationException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public void Update(ContactDal parametre) { using (SqlConnection con = new SqlConnection()) { con.ConnectionString = connectionString; using (SqlCommand command = con.CreateCommand()) { command.CommandText = "EditContact"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue(nameof(parametre.contactId), parametre.contactId); command.Parameters.AddWithValue(nameof(parametre.adCodePostal), parametre.adCodePostal); command.Parameters.AddWithValue(nameof(parametre.adNumero), parametre.adNumero); command.Parameters.AddWithValue(nameof(parametre.adRue), parametre.adRue); command.Parameters.AddWithValue(nameof(parametre.adVille), parametre.adVille); command.Parameters.AddWithValue(nameof(parametre.telephone), parametre.telephone); con.Open(); command.ExecuteNonQuery(); } } }