public bool Add(Models.DBModel.Contact item)
{
try
{
conDB.Contacts.Add(item);
conDB.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool Update(Models.DBModel.Contact item)
{
try
{
//conDB.Entry(item).State = EntityState.Modified;
conDB.Contacts.AddOrUpdate(item); //requires using System.Data.Entity.Migrations;
conDB.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public int CheckDuplicates(Models.DBModel.Contact item)
{
try
{
var e = conDB.Contacts.FirstOrDefault(c => c.Email == item.Email);
var p = conDB.Contacts.FirstOrDefault(c => c.PhoneNumber == item.PhoneNumber);
if (e != null && e.Id != item.Id)
{
return(1);
}
else if (p != null && p.Id != item.Id)
{
return(2);
}
else
{
return(0);
}
}
catch
{
return(3);
}
}
