public bool Insert(Customer cus)
{
try
{
ManageCustomersEntities ctx = new ManageCustomersEntities();
ctx.Customers.Add(cus);
ctx.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool Delete(int id)
{
try
{
using (ManageCustomersEntities ctx = new ManageCustomersEntities())
{
var _ob = ctx.Customers.SingleOrDefault(b => b.ID == id);
if (_ob != null)
{
ctx.Customers.Remove(_ob);
ctx.SaveChanges();
}
}
return(true);
}
catch
{
return(false);
}
}
public bool Update(int id, Customer cus)
{
try
{
using (ManageCustomersEntities ctx = new ManageCustomersEntities())
{
var _ob = ctx.Customers.SingleOrDefault(b => b.ID == id);
if (_ob != null)
{
_ob.Name = cus.Name.Trim();
_ob.Phone = cus.Phone.Trim();
_ob.Email = cus.Email.Trim();
_ob.Address = cus.Address.Trim();
ctx.SaveChanges();
}
}
return(true);
}
catch
{
return(false);
}
}
public BaseDal()
{
_entities = new ManageCustomersEntities(ConnectionString);
}
public Customer GetByID(int id)
{
ManageCustomersEntities ctx = new ManageCustomersEntities();
return(ctx.Customers.Where(c => c.ID == id).ToArray()[0] as Customer);
}
public Customer[] GetALL()
{
ManageCustomersEntities ctx = new ManageCustomersEntities();
return(ctx.Customers.ToArray());
}
