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();
}
}
}
