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