public static bool Insert(Customer customer)
{
try
{
QLNXeEntities entities = new QLNXeEntities();
entities.Customers.Add(customer);
entities.SaveChanges();
return true;
}
catch (Exception)
{
return false;
}
}
/// <summary>
/// Insert Ticket
/// </summary>
/// <param name="tk"></param>
/// <returns></returns>
public static bool Insert(Ticket tk)
{
try
{
QLNXeEntities entities = new QLNXeEntities();
entities.Tickets.Add(tk);
entities.SaveChanges();
return true;
}
catch (Exception)
{
return false;
}
}
/// <summary>
/// Delete Ticket
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static bool Delete(Int64 id)
{
try
{
QLNXeEntities entities = new QLNXeEntities();
var ticket = entities.Tickets.First(ob => ob.TicketId == id);
entities.Entry(ticket).State = EntityState.Deleted;
entities.SaveChanges();
return true;
}
catch (Exception)
{
return false;
}
}
public static bool Update(Customer customer)
{
try
{
QLNXeEntities entities = new QLNXeEntities();
var customers = entities.Customers.Find(customer.Id);
entities.Entry(customers).CurrentValues.SetValues(customer);
entities.SaveChanges();
return true;
}
catch (Exception)
{
return false;
}
}
/// <summary>
/// Update Ticket
/// </summary>
/// <param name="tk"></param>
/// <returns></returns>
public static bool Update(Ticket tk)
{
try
{
QLNXeEntities entities = new QLNXeEntities();
var ticket = entities.Tickets.Find(tk.TicketId);
entities.Entry(ticket).CurrentValues.SetValues(tk);
entities.SaveChanges();
return true;
}
catch (Exception)
{
return false;
}
}