public static int SaveContact(DBContact contact)
{
int contactId = contact.Id;
using (ApplicationContext db = new ApplicationContext())
{
DBContact cnt;
if (contactId < 1)
{
contactId = db.Contacts.OrderBy(x => x.Id).LastOrDefault()?.Id ?? 1;
contactId++;
db.Contacts.Add(contact);
}
else
{
cnt = db.Contacts.FirstOrDefault(x => x.Id == contactId);
if (cnt == null)
{
throw new Exception($"Нет записи user с таким Id = {contactId}");
}
db.Entry(cnt).CurrentValues.SetValues(contact);
//db.Update(usr);
}
db.SaveChanges();
}
return(contactId);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtID.Text != "")
{
;
}
{
Contact c = new Contact();
c.Id = Int32.Parse(txtID.Text);
c.NomComplet = txtNom.Text;
c.DateNaiss = txtDateNaiss.Value.Date;
c.Email = txtEmail.Text;
c.Tel = txtTel.Text;
c.Genre = txtGenre.Text;
MemoryStream ms = new MemoryStream();
txtPictureContact.Image.Save(ms, txtPictureContact.Image.RawFormat);
byte[] img = ms.ToArray();
c.Photo = img;
DBContact.UpdateContact(c);
var lst = new BindingList <Contact>(DBContact.GetListContact());
dgvContacts.DataSource = lst;
MessageBox.Show(
"Contact Bien Modifié",
"Modification",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
}
}
/// <summary>
/// Get all contact list
/// </summary>
/// <returns>IEnumerable<ContactViewModel></returns>
public IEnumerable <ContactViewModel> GetAll()
{
DataTable dtContacts = DBContact.DBGetContactList();
List <ContactViewModel> lstContacts = dtContacts.ConvertDataTableToList <ContactViewModel>();
return(lstContacts);
}
public static DBContact GetContact(int Id)
{
var contact = new DBContact();
using (ApplicationContext db = new ApplicationContext())
{
contact = db.Contacts.Where(x => x.Id == Id).FirstOrDefault();
}
return(contact);
}
private void frmListContact_Load(object sender, EventArgs e)
{
BindingList <Contact> lst = new BindingList <Contact>(DBContact.GetListContact());
dgvContacts.DataSource = lst;
dgvContacts.AutoResizeColumns();
dgvContacts.AllowUserToResizeColumns = true;
dgvContacts.AllowUserToOrderColumns = true;
dgvContacts.Columns["Photo"].Visible = false;
dgvContacts.AllowUserToAddRows = false;
nbContact.Text = "Nombre Contact : " + dgvContacts.Rows.Count;
}
static void Main()
{
DBContact.AddContact(new Contact("Mohamed Ali", DateTime.Parse("01/01/1984"), "*****@*****.**", "98 44 88 47", "M", null));
DBContact.AddContact(new Contact("Hassan Ali", DateTime.Parse("01/11/1988"), "*****@*****.**", "99 44 98 27", "M", null));
DBContact.AddContact(new Contact("Mohamed Alamin", DateTime.Parse("01/12/1974"), "*****@*****.**", "90 87 87 77", "M", null));
DBContact.AddContact(new Contact("Fatim Ali", DateTime.Parse("31/01/1994"), "*****@*****.**", "84 24 24 24", "F", null));
DBContact.AddContact(new Contact("khadidjia Ali", DateTime.Parse("31/12/1988"), "*****@*****.**", "93 23 24 24", "F", null));
DBContact.AddContact(new Contact("Boubacar Ali", DateTime.Parse("11/11/1989"), "*****@*****.**", "84 84 84 47", "M", null));
DBContact.AddContact(new Contact("Maryam Ali", DateTime.Parse("31/12/1990"), "*****@*****.**", "99 44 88 77", "F", null));
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new FrmMenu());
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (txtSearch.Text != "")
{
var lst = new BindingList <Contact>(DBContact.SearchContact(txtSearch.Text));
dgvContacts.DataSource = lst;
}
else
{
var lst = new BindingList <Contact>(DBContact.GetListContact());
dgvContacts.DataSource = lst;
}
nbContact.Text = "Nombre Contact :" + dgvContacts.Rows.Count;
}
static void Main()
{
MemoryStream ms = new MemoryStream();
Bitmap bmp = Properties.Resources._default;
bmp.Save(ms, bmp.RawFormat);
byte[] img = ms.ToArray();
DBContact.AddContact(new Contact("APETSI Ange E", DateTime.Parse("01/01/2001"), "*****@*****.**", "47 26 80 43", "M", img));
DBContact.AddContact(new Contact("KOUAME Wilfried", DateTime.Parse("23/10/2002"), "*****@*****.**", "09 96 28 06", "M", img));
DBContact.AddContact(new Contact("OUATTARA Ibrahima", DateTime.Parse("16/09/1999"), "*****@*****.**", "47 11 02 33", "M", img));
DBContact.AddContact(new Contact("ZADJI Rebecca", DateTime.Parse("31/01/2003"), "*****@*****.**", "51 16 83 23", "F", img));
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new frmMenu());
}
private void btnPrint_Click(object sender, EventArgs e)
{
ReportDataSource rs = new ReportDataSource();
rs.Name = "DataSetListContact";
rs.Value = DBContact.SearchContact(txtSearch.Text);
frmPrint frm = new frmPrint();
frm.Rpv.LocalReport.DataSources.Clear();
frm.Rpv.LocalReport.DataSources.Add(rs);
frm.Rpv.LocalReport.ReportEmbeddedResource = "AppEContact.WinForm.RpListContact.rdlc";
frm.Rpv.Dock = DockStyle.Fill;
frm.Controls.Add(frm.Rpv);
frm.Rpv.RefreshReport();
frm.StartPosition = FormStartPosition.CenterScreen;
frm.WindowState = FormWindowState.Maximized;
frm.ShowDialog();
}
private void btnSave_Click(object sender, EventArgs e)
{
Contact c = new Contact();
c.NomComplet = txtNom.Text;
c.DateNaiss = txtDateNaiss.Value.Date;
c.Email = txtEmail.Text;
c.Tel = txtTel.Text;
c.Genre = txtGenre.Text;
MemoryStream ms = new MemoryStream();
txtPictureContact.Image.Save(ms, txtPictureContact.Image.RawFormat);
byte[] bImage = ms.ToArray();
c.Photo = bImage;
int res = DBContact.AddContact(c);
MessageBox.Show("Contact bien ajouté ID : " + res, "Ajout contact", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (txtID.Text != "")
{
DialogResult res = MessageBox.Show(
"Voulez vous vraiment supprimer ce contact",
"supprisson", MessageBoxButtons.YesNo, MessageBoxIcon.Warning
);
if (res == DialogResult.Yes)
{
DBContact.DeleteContact(Int32.Parse(txtID.Text));
var lst = new BindingList<Contact>(DBContact.GetListContacts());
dgvContacts.DataSource = lst;
nbContact.Text = "Nombre Contact :" + dgvContacts.Rows.Count;
}
}
}
static void Main()
{
MemoryStream ms = new MemoryStream();
Bitmap bmp = Properties.Resources._default;
bmp.Save(ms, bmp.RawFormat);
byte[] img = ms.ToArray();
DBContact.AddContact(new Contact("Mohamed ali", DateTime.Parse("12/03/2000"), "*****@*****.**", "06 06 06 06 06", "M", img));
DBContact.AddContact(new Contact("mohamed jhaoui", DateTime.Parse("12/01/1984"), "*****@*****.**", "06 60 00 06 01", "M", img));
DBContact.AddContact(new Contact("jamila jamal", DateTime.Parse("13/03/1980"), "*****@*****.**", "06 60 00 06 01", "F", img));
DBContact.AddContact(new Contact("zinab alami", DateTime.Parse("06/02/1984"), "*****@*****.**", "06 60 00 06 01", "F", img));
DBContact.AddContact(new Contact("khafid jawi", DateTime.Parse("05/03/2000"), "*****@*****.**", "06 60 00 06 01", "M", img));
DBContact.AddContact(new Contact("mustapha jamal", DateTime.Parse("13/06/1984"), "*****@*****.**", "06 60 00 06 01", "M", img));
DBContact.AddContact(new Contact("sanae lwali", DateTime.Parse("13/12/2000"), "*****@*****.**", "06 60 00 06 01", "F", img));
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new frmMenu());
}
static void Main()
{
MemoryStream ms = new MemoryStream();
Bitmap bmp = Properties.Resources._default;
bmp.Save(ms, bmp.RawFormat);
byte[] img = ms.ToArray();
DBContact.AddContact(new Contact("Zakaria Oumar", DateTime.Parse("31/12/1978"), "*****@*****.**", "88 45 55 55", "M", img));
DBContact.AddContact(new Contact("Diallo Aoudi", DateTime.Parse("31/12/1965"), "*****@*****.**", "91 05 01 74", "M", img));
DBContact.AddContact(new Contact("Boubé Abdou", DateTime.Parse("01/01/1963"), "*****@*****.**", "96 59 42 12", "M", img));
//DBContact.AddContact(new Contact("Jamila Soumaila", DateTime.Parse("03/12/1982"), "*****@*****.**","94 45 65 25", "F", img));
//DBContact.AddContact(new Contact("Ibrahima Mahamad", DateTime.Parse("28/02/1983"), "*****@*****.**","97 23 48 15", "M", img));
DBContact.AddContact(new Contact("Marie Rose", DateTime.Parse("31/12/1979"), "*****@*****.**", "98 36 00 06", "F", img));
//DBContact.AddContact(new Contact("Doudou Aminatou", DateTime.Parse("03/12/1985"), "*****@*****.**", "98 71 00 71", "F", img));
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new frmMenu());
}
/// <summary>
/// Get contact list by id
/// </summary>
/// <param name="ContactID"></param>
/// <returns>ContactViewModel: model class </returns>
public ContactViewModel GetContactsByID(int ContactID)
{
DataTable dtContacts = DBContact.DBGetContactById(ContactID);
ContactViewModel objcontact = null;
var convertedList = (from rw in dtContacts.AsEnumerable()
select new ContactViewModel()
{
ContactID = Convert.ToInt32(rw["ContactID"]),
FirstName = Convert.ToString(rw["FirstName"]),
LastName = Convert.ToString(rw["LastName"]),
EmailID = Convert.ToString(rw["EmailID"]),
MobileNumber = Convert.ToString(rw["MobileNumber"]),
Status = Convert.ToBoolean(rw["Status"])
}).FirstOrDefault();
objcontact = convertedList;
return(objcontact);
}
public bool updateContacts([FromBody] dynamic stringContent)
{
clsContact objContact = JsonConvert.DeserializeObject(stringContent, typeof(clsContact));
return(DBContact.DBUpdateContact(objContact));
}
public bool DeleteContactsByID(int ContactID)
{
return(DBContact.DBDeleteContact(ContactID));
}
public bool addContacts([FromBody] dynamic contects)
{
clsContact objContact = JsonConvert.DeserializeObject(contects, typeof(clsContact));
return(DBContact.DBAddContact(objContact));
}
