public List <Person> ChargerContacts() { using (ContactsEntities context = new ContactsEntities()) { return((from C in context.Persons select C).ToList()); } }
async Task <ContactModel> IContactRepo.AddorUpdateContact(ContactModel contactModel) { var model = new ContactInfo { ContactId = contactModel.ContactId, Email = contactModel.Email, FirstName = contactModel.FirstName, LastName = contactModel.LastName, Phone = contactModel.Phone, Status = contactModel.Status }; using (var ctx = new ContactsEntities()) { var contact = ctx.ContactInfoes.FirstOrDefault(x => x.Email == model.Email); if (contact == null) { // Add new contact to list ctx.ContactInfoes.Add(model); await ctx.SaveChangesAsync(); return(contactModel); } contact.Phone = contactModel.Phone; contact.FirstName = contactModel.FirstName; contact.LastName = contactModel.LastName; contact.Status = contactModel.Status; await ctx.SaveChangesAsync(); return(contactModel); } }
static void Main(string[] args) { using (ContactsEntities entities = new ContactsEntities()) { Address doeaddress = new Address() { Street = "1 Broadway", ZipCode = "01234" }; Address doeaddress2 = new Address() { Street = "2 Broadway", ZipCode = "01234" }; entities.Addresses.Add(doeaddress); entities.Persons.Add(new Person() { FirstName = "Jane", LastName = "Doe", Address = doeaddress }); entities.Persons.Add(new Person() { FirstName = "John", LastName = "Doe", Address = doeaddress }); entities.Persons.Add(new Person() { FirstName = "Jim", LastName = "Doe", Address = doeaddress2 }); entities.SaveChanges(); } Console.WriteLine("Press Enter to exit..."); Console.ReadLine(); }
public IHttpActionResult PostContact(ContactViewModel contact) { if (!ModelState.IsValid) { return(BadRequest("Invalid Data")); } try { using (var ctx = new ContactsEntities()) { ctx.Contacts.Add(new Contact() { ContactId = Guid.NewGuid(), FirstName = contact.FirstName, LastName = contact.LastName, Email = contact.Email, PhoneNumber = contact.PhoneNumber, Status = contact.IsActive, CreateDate = DateTime.Now, }); ctx.SaveChanges(); } } catch (HttpResponseException ex) { BadRequest(ex.Message); } return(Ok()); }
public IHttpActionResult GetContact(Guid id) { ContactViewModel contacts = null; try { using (var cts = new ContactsEntities()) { contacts = cts.Contacts .Where(s => s.ContactId == id) .Select(s => new ContactViewModel() { ContactId = s.ContactId, FirstName = s.FirstName, LastName = s.LastName, Email = s.Email, PhoneNumber = s.PhoneNumber, IsActive = s.Status, CreateDate = s.CreateDate }).FirstOrDefault <ContactViewModel>(); } if (contacts == null) { return(NotFound()); } } catch (HttpResponseException ex) { BadRequest(ex.Message); } return(Ok(contacts)); }
public IHttpActionResult GetAllContact() { IList <ContactViewModel> contacts = null; try { using (var cts = new ContactsEntities()) { contacts = cts.Contacts.Select(s => new ContactViewModel() { ContactId = s.ContactId, FirstName = s.FirstName, LastName = s.LastName, Email = s.Email, PhoneNumber = s.PhoneNumber, IsActive = s.Status, Status = s.Status ? "Active" : "Inactive", CreateDate = s.CreateDate }).ToList <ContactViewModel>(); } if (contacts.Count == 0) { return(NotFound()); } } catch (HttpResponseException ex) { return(BadRequest(ex.Message)); } return(Ok(contacts)); }
private void btn_ChangePass_Click(object sender, EventArgs e) { if (tb_newpass.Text.Length < 5) { MessageBox.Show(@"رمز عبور باید حداقل 4 حرف باشد"); } if (tb_newpass.Text != tb_newpass2.Text) { MessageBox.Show(@"رمز عبور جدید با تکرار آن مطابقت ندارد"); } else { ContactsEntities db = new ContactsEntities(); var pcon = db.Configs.FirstOrDefault(p => p.ConfigKey == "Password"); if (pcon != null) { pcon.ConfigValue = tb_newpass.Text; } else { db.Configs.Add(new Configs { ConfigKey = "Password", ConfigValue = tb_newpass.Text }); } db.SaveChanges(); } }
public IHttpActionResult PutContact(ContactViewModel contact) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } try { using (var ctx = new ContactsEntities()) { var existingContact = ctx.Contacts.Where(s => s.ContactId == contact.ContactId).FirstOrDefault <Contact>(); if (existingContact != null) { existingContact.FirstName = contact.FirstName; existingContact.LastName = contact.LastName; existingContact.Email = contact.Email; existingContact.PhoneNumber = contact.PhoneNumber; existingContact.Status = contact.IsActive; existingContact.CreateDate = contact.CreateDate; ctx.SaveChanges(); } else { return(NotFound()); } } } catch (HttpResponseException ex) { BadRequest(ex.Message); } return(Ok()); }
public int SaveContact(int?ID, string contact) { JObject jContact = JObject.Parse(contact); string Fname = (string)jContact["Fname"]; string Lname = (string)jContact["Lname"]; Contact contactModel = new Contact(); contactModel.Id = (int)ID; contactModel.Fname = Fname; contactModel.Lname = Lname; using (ContactsEntities db = new ContactsEntities()) { if (ID == 0) { db.Contacts.Add(contactModel); db.SaveChanges(); } else { db.Entry(contactModel).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return((int)ID); } }
public ActionResult LoadContactsData() { using (ContactsEntities db = new ContactsEntities()) { List <Contact> Contacts = db.Contacts.ToList <Contact>(); return(Json(Contacts, JsonRequestBehavior.AllowGet)); } }
////////////Address Section public ActionResult LoadAddressData(int ContactId) { using (ContactsEntities db = new ContactsEntities()) { List <Address> Address = db.Addresses.Where(w => w.Contact_id == ContactId).ToList(); return(Json(Address, JsonRequestBehavior.AllowGet)); } }
public int DeleteContact(int?ID, string contact) { Contact contactModel = new Contact(); using (ContactsEntities db = new ContactsEntities()) { contactModel = db.Contacts.Where(x => x.Id == ID).FirstOrDefault <Contact>(); db.Contacts.Remove(contactModel); db.SaveChanges(); return((int)ID); } }
private void SearchContacts_Load(object sender, EventArgs e) { ContactsEntities db = new ContactsEntities(); var g = db.ContactGroupDef.ToList(); foreach (ContactGroupDef contactGroupDef in g) { clb_Groups.Items.Add(contactGroupDef); } clb_Groups.DisplayMember = "GroupName"; _allperson = db.ContactPerson.ToList(); }
public void LoadGroup() { dataGV_group.Rows.Clear(); ContactsEntities db = new ContactsEntities(); foreach (ContactGroupDef contactGroupDef in db.ContactGroupDef.ToList()) { dataGV_group.Rows.Add(new object[] { contactGroupDef.Id, contactGroupDef.GroupName }); } }
public void Setup() { _contacts = SetUpContacts(); _dbEntities = new Mock <ContactsEntities>().Object; _contactRepository = SetUpContactRepository(); var dbOperation = new Mock <DbOperation>(); dbOperation.SetupGet(s => s.ContactRepository).Returns(_contactRepository); _dbOperation = dbOperation.Object; _contactService = new ContactServices(_dbOperation); _client = new HttpClient { BaseAddress = new Uri(ServiceBaseURL) }; }
private void btn_addGroup_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(tb_groupName.Text)) { ContactsEntities db = new ContactsEntities(); db.ContactGroupDef.Add(new ContactGroupDef() { GroupName = tb_groupName.Text }); db.SaveChanges(); LoadGroup(); MessageBox.Show("با موفقیت اضافه شد"); } }
public bool DeleteContact(Person contact) { if (contact.Id > 0) { using (ContactsEntities context = new ContactsEntities()) { context.Persons.Attach(contact); context.Entry(contact).State = EntityState.Deleted; context.SaveChanges(); } return(true); } return(false); }
private void AddContact_Load(object sender, EventArgs e) { ContactsEntities db = new ContactsEntities(); var g = db.ContactGroupDef.ToList(); foreach (ContactGroupDef contactGroupDef in g) { clb_Groups.Items.Add(contactGroupDef); } clb_Groups.DisplayMember = "GroupName"; if (_contactid > 0) { LoadContact(_contactid); } }
private void btn_removeGroup_Click(object sender, EventArgs e) { foreach (DataGridViewRow selectedRow in dataGV_group.SelectedRows) { int groupid; if (int.TryParse(selectedRow.Cells[0].Value.ToString(), out groupid)) { ContactsEntities db = new ContactsEntities(); db.Database.ExecuteSqlCommand("DELETE FROM ContactGroupDef WHERE Id=" + groupid); db.Database.ExecuteSqlCommand("DELETE FROM ContactGroup WHERE GroupId=" + groupid); db.SaveChanges(); LoadGroup(); MessageBox.Show("با موفقیت حذف شد"); } } }
private void dataGV_person_MouseDoubleClick(object sender, MouseEventArgs e) { if (dataGV_person.SelectedRows.Count == 1) { this.Hide(); int cotacatid; int.TryParse(dataGV_person.SelectedRows[0].Cells[0].Value.ToString(), out cotacatid); var form = new AddContact(cotacatid); form.ShowDialog(); this.Show(); this.Focus(); ContactsEntities db = new ContactsEntities(); _allperson = db.ContactPerson.ToList(); Search(); } }
private void Import_Load(object sender, EventArgs e) { var col = (DataGridViewComboBoxColumn)dataGV_group.Columns[1]; col.DataSource = MyConfigs.DataModels; col.ValueMember = "Modelkey"; col.DisplayMember = "ModelName"; btn_import.Enabled = false; ContactsEntities db = new ContactsEntities(); var g = db.ContactGroupDef.ToList(); foreach (ContactGroupDef contactGroupDef in g) { clb_Groups.Items.Add(contactGroupDef); } clb_Groups.DisplayMember = "GroupName"; }
private void LoadContact(int contactid) { ContactsEntities db = new ContactsEntities(); var per = db.ContactPerson.FirstOrDefault(p => p.Id == contactid); if (per != null) { tb_firstname.Text = per.FirstName; tb_LastName.Text = per.LastName; tb_Birthdate.Text = per.DateOfBirth.ToString(); tb_postname.Text = per.PostName; this.Text = "ویرایش مخاطب"; btn_add.Text = "ویرایش مخاطب"; btn_delete.Visible = true; foreach (ContactPhone contactPhone in per.ContactPhone) { AddCallBox((int)contactPhone.PhoneType, contactPhone.PhoneNumber); } foreach (ContactAddress contactaddress in per.ContactAddress) { AddAddressBox((int)contactaddress.AddressType, contactaddress.Address); } foreach (ContactEmail contactemail in per.ContactEmail) { AddEmailBox((int)contactemail.EmailType, contactemail.Email); } foreach (ContactGroup contactGroup in per.ContactGroup) { int index = 0; foreach (ContactGroupDef cGroup in db.ContactGroupDef.ToList()) { if (cGroup.Id == contactGroup.GroupId) { clb_Groups.SetItemChecked(index, true); } index++; } } } else { MessageBox.Show("مخاطبی یافت نشد"); this.Close(); } }
public int SaveContact(Person contact) { using (ContactsEntities context = new ContactsEntities()) { if (contact.Id > 0) { context.Persons.Attach(contact); context.Entry(contact).State = EntityState.Modified; context.SaveChanges(); } else { context.Persons.Add(contact); context.SaveChanges(); } } return(contact.Id); }
private void btn_ClearAll_Click(object sender, EventArgs e) { if (MessageBox.Show(@"آیااز این کار مطمعن هستید؟", @"هشدار", MessageBoxButtons.YesNo , MessageBoxIcon.Warning) == DialogResult.Yes) { ContactsEntities db = new ContactsEntities(); db.Database.ExecuteSqlCommand("delete from ContactAddress;"); db.Database.ExecuteSqlCommand("delete from sqlite_sequence where name='ContactAddress';"); db.Database.ExecuteSqlCommand("delete from ContactEmail; "); db.Database.ExecuteSqlCommand("delete from sqlite_sequence where name='ContactEmail';"); db.Database.ExecuteSqlCommand("delete from ContactGroup; "); db.Database.ExecuteSqlCommand("delete from sqlite_sequence where name='ContactGroup';"); db.Database.ExecuteSqlCommand("delete from ContactPerson; "); db.Database.ExecuteSqlCommand("delete from sqlite_sequence where name='ContactPerson';"); db.Database.ExecuteSqlCommand("delete from ContactPhone; "); db.Database.ExecuteSqlCommand("delete from sqlite_sequence where name='ContactPhone';"); MessageBox.Show(@"پاک سازی با موفقیت انجام شد"); } }
public IHttpActionResult DeleteContact(Guid id) { if (id == null) { return(BadRequest("Not a valid contact id")); } try { using (var ctx = new ContactsEntities()) { var contact = ctx.Contacts.Where(s => s.ContactId == id).FirstOrDefault(); ctx.Contacts.Remove(contact); ctx.SaveChanges(); } } catch (HttpResponseException ex) { BadRequest(ex.Message); } return(Ok()); }
private void btn_delete_Click(object sender, EventArgs e) { ContactsEntities db = new ContactsEntities(); if (_contactid > 0) { var con = db.ContactPerson.FirstOrDefault(p => p.Id == _contactid); if (con != null) { db.ContactPerson.Remove(con); db.SaveChanges(); db.Database.ExecuteSqlCommand("DELETE FROM ContactPhone WHERE ContactPersonID=" + _contactid); db.Database.ExecuteSqlCommand("DELETE FROM ContactAddress WHERE ContactPersonID=" + _contactid); db.Database.ExecuteSqlCommand("DELETE FROM ContactEmail WHERE ContactPersonID=" + _contactid); db.Database.ExecuteSqlCommand("DELETE FROM ContactGroup WHERE ContactPersonID=" + _contactid); } } MessageBox.Show("تغییرات خواسته شده اعمال شد"); this.Close(); }
async Task <ContactModel> IContactRepo.DeleteContact(int id) { using (var ctx = new ContactsEntities()) { var contact = ctx.ContactInfoes.Find(id); if (contact == null) { throw new ContactException("No Data Found for given id"); } if (contact.Status == "Inactive") { contact.Status = "Active"; // save contact object back to data base. await ctx.SaveChangesAsync(); return(new ContactModel { ContactId = contact.ContactId, Email = contact.Email, FirstName = contact.FirstName, LastName = contact.LastName, Phone = contact.Phone, Status = contact.Status }); } contact.Status = "Inactive"; // save contact object back to data base. await ctx.SaveChangesAsync(); return(new ContactModel { ContactId = contact.ContactId, Email = contact.Email, FirstName = contact.FirstName, LastName = contact.LastName, Phone = contact.Phone, Status = contact.Status }); } }
async Task <List <ContactModel> > IContactRepo.GetContact() { using (var ctx = new ContactsEntities()) { var contacts = await ctx.ContactInfoes.ToListAsync(); if (!contacts.Any()) { throw new ContactException("No Data Found for given id"); } return(contacts.ConvertAll(x => new ContactModel { ContactId = x.ContactId, Email = x.Email, FirstName = x.FirstName, LastName = x.LastName, Phone = x.Phone, Status = x.Status })); } }
protected override void ProcessRecord() { if (String.IsNullOrWhiteSpace(LastName)) { throw new ArgumentNullException(nameof(LastName)); } // Auswertung der Parameter var contact = new Contact { FirstName = this.FirstName, LastName = this.LastName }; try { WriteDebug("Datenbankverbindung wird geöffnet"); using (ContactsEntities model = new ContactsEntities()) { WriteDebug("Datenbankverbindung geöffnet"); model.Contacts.Add(contact); model.SaveChanges(); WriteDebug("Schließe Datenbankverbindung"); } WriteObject(contact); } catch (Exception e) { // Auswertung des Fehlers... WriteError(new ErrorRecord(e, "1", ErrorCategory.WriteError, null)); } }
public void GetContactByIdAndPipeline() { // Testvorbereitung var contactone = new Contact() { FirstName = "Hans", LastName = "Mustermann" }; var contacttwo = new Contact() { FirstName = "Franz", LastName = "Heinrich" }; using (ContactsEntities model = new ContactsEntities()) { model.Contacts.Add(contactone); model.Contacts.Add(contacttwo); model.SaveChanges(); } var script = $@"Import-Module '{_assemblyname}' {contactone.Id}, {contacttwo.Id} | Get-Contact | Export-Csv -Path 'D:\personen.txt' "; var result = RunScript(script); Write(result); var contactresult = result.Output.OfType <Contact>(); //Assert.NotNull(contactresult); //Assert.True(contactresult.Count() == 2); //Assert.Contains(contactresult, c => c.Id == contactone.Id); //Assert.Contains(contactresult, c => c.Id == contacttwo.Id); }