public async Task Update(Company_Contact entity) { try { var vList = adbContext.company_contact.Where(w => w.Company_Contact_Id == entity.Company_Contact_Id).FirstOrDefault(); if (vList != null) { vList.Company_Id = entity.Company_Id; vList.Contact_Type = entity.Contact_Type.Trim(); vList.Contact_Value = entity.Contact_Value.Trim(); vList.isDefault = entity.isDefault; vList.isActive = entity.isActive; vList.UpdatedBy = entity.UpdatedBy; vList.UpdatedOn = DateTime.Now; adbContext.company_contact.Update(vList); await Task.FromResult(adbContext.SaveChanges()); } else { throw new Exception("Data Not Available"); } } catch (Exception ex) { throw ex; } }
public async Task <IActionResult> Edit(Company_Contact Company_Contact) { ResponseHelper objHelper = new ResponseHelper(); if (!ModelState.IsValid) { objHelper.Status = StatusCodes.Status424FailedDependency; objHelper.Message = "Invalid Model State"; return(BadRequest(objHelper)); } try { if (company_contactRepository.Exists(Company_Contact)) { objHelper.Status = StatusCodes.Status200OK; objHelper.Message = "Data already available"; return(Ok(objHelper)); } await company_contactRepository.Update(Company_Contact); objHelper.Status = StatusCodes.Status200OK; objHelper.Message = "Saved Successfully"; return(Ok(objHelper)); } catch { objHelper.Status = StatusCodes.Status500InternalServerError; objHelper.Message = "Save Unsuccessful"; return(StatusCode(StatusCodes.Status500InternalServerError, objHelper)); } }
public bool DeleteCompany_Contact(int id) { using (SUPERPEntities sup = new SUPERPEntities(false)) { Company_Contact contact = sup.Company_Contact.Where(p => p.id == id).FirstOrDefault(); sup.Entry(contact).State = System.Data.Entity.EntityState.Deleted; sup.SaveChanges(); } return(true); }
public int CreateCompany_Contact(Company_Contact contact) { using (SUPERPEntities sup = new SUPERPEntities(false)) { sup.Company_Contact.Add(contact); sup.SaveChanges(); Company_Contact cont = sup.Company_Contact.OrderByDescending(p => p.id).First(); return((int)cont.id); } }
public async Task Insert(Company_Contact entity) { try { entity.AddedOn = DateTime.Now; adbContext.company_contact.Add(entity); await Task.FromResult(adbContext.SaveChanges()); } catch (Exception ex) { throw ex; } }
public bool EditCompany_Contact(Company_Contact contact) { using (SUPERPEntities sup = new SUPERPEntities(false)) { Company_Contact contactBdd = sup.Company_Contact.Where(p => p.id == contact.id).FirstOrDefault(); if (contactBdd != null) { sup.Entry(contactBdd).CurrentValues.SetValues(contact); sup.SaveChanges(); } } return(true); }
public void TestCreateCompany_Contact() { Company_Contact cont = new Company_Contact(); cont.firstname = "pierre"; cont.lastname = "Geogre"; cont.gender = 1; cont.email = "*****@*****.**"; cont.phone = "0506"; cont.company_id = 1; Assert.IsTrue(clientService.CreateCompany_Contact(cont) > 0); }
public bool Exists(Company_Contact entity) { int intCount = 0; if (entity.Company_Contact_Id > 0) //Update Validation { intCount = adbContext.company_contact.Where(w => w.Company_Id == entity.Company_Id && w.Company_Contact_Id != entity.Company_Contact_Id && (w.Contact_Type == entity.Contact_Type && w.Contact_Value == entity.Contact_Value)).Count(); } else //Insert Validation { intCount = adbContext.company_contact.Where(w => w.Company_Id != entity.Company_Id && w.Contact_Type == entity.Contact_Type && w.Contact_Value == entity.Contact_Value).Count(); } return(intCount > 0 ? true : false); }
public void testEditCompany_contact() { Company_Contact cont = new Company_Contact(); cont.id = 4; cont.firstname = "pierreT"; cont.lastname = "George"; cont.gender = 1; cont.email = "*****@*****.**"; cont.phone = "0506"; cont.company_id = 1; Assert.IsTrue(clientService.EditCompany_Contact(cont)); }
public void TestGetCompany_Contact() { Company_Contact cont = new Company_Contact(); cont.firstname = "jacques"; cont.lastname = "Geogre"; cont.gender = 1; cont.email = "*****@*****.**"; cont.phone = "0506"; cont.company_id = 2; int id = clientService.CreateCompany_Contact(cont); Company_Contact contGet; contGet = clientService.GetCompany_Contact(id); Assert.AreEqual("jacques", contGet.firstname); Assert.AreEqual("Geogre", contGet.lastname); Assert.AreEqual(1, contGet.gender); Assert.AreEqual("*****@*****.**", contGet.email); Assert.AreEqual("0506", contGet.phone); Assert.AreEqual(2, contGet.company_id); }
public bool EditCompany_Contact(Company_Contact contact) { return(ContactBLL.EditCompany_Contact(contact)); }
public int CreateCompany_Contact(Company_Contact contact) { return(ContactBLL.CreateCompany_Contact(contact)); }