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