public static List<Customer> Select() { try { QLNXeEntities entities = new QLNXeEntities(); return entities.Customers.ToList(); } catch (Exception) { return null; } }
public static Customer Select(Int64 id) { try { QLNXeEntities entities = new QLNXeEntities(); return entities.Customers.FirstOrDefault(ob => ob.Id == id); } catch (Exception) { return null; } }
public static List<Customer> SearchCustomerByText(string txtInput) { try { QLNXeEntities entities = new QLNXeEntities(); return entities.Customers.Where(ob => ob.FullName.Contains(txtInput)).ToList(); } catch (Exception) { return null; } }
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; } }
public static Int64 SelectIdbyName(string name) { try { QLNXeEntities entities = new QLNXeEntities(); var query = from cs in entities.Customers where name.ToLower().Trim() == cs.FullName.ToLower().Trim() select cs.Id; return query.First(); } catch (Exception) { return 0; } }
/// <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; } }
/// <summary> /// /// </summary> /// <param name="searchText"></param> /// <returns></returns> public static IQueryable<String> Suggestion(string searchText) { try { QLNXeEntities entities = new QLNXeEntities(); var query = from pl in entities.Motorbikes select pl.Plate; var namelist = query.Where(n => n.ToLower().StartsWith(searchText.ToLower())); return namelist; } catch (Exception) { return null; } }
/// <summary> /// /// </summary> /// <param name="plate"></param> /// <returns></returns> public static MotorType SelectMotorTypeByPlate(String plate) { try { QLNXeEntities entities = new QLNXeEntities(); var query = from tiket in entities.Tickets where tiket.MotorbikePlate == plate join motor in entities.Motorbikes on tiket.MotorbikePlate equals motor.Plate join motorType in entities.MotorTypes on motor.MotorType equals motorType.Id select motorType; return query.First(); } catch (Exception) { return null; } }
/// <summary> /// Search by custom search query /// </summary> /// <param name="sContent"></param> /// <returns></returns> public static List<Ticket> Search(String sContent) { // Make input valid sContent = (sContent + String.Empty).ToLower(); try { QLNXeEntities entities = new QLNXeEntities(); var query = from tk in entities.Tickets join cus in entities.Customers on tk.CustomerId equals cus.Id where (tk.MotorbikePlate + String.Empty).ToLower().Contains(sContent) || (cus.FullName + String.Empty).ToLower().Contains(sContent) select tk; return query.Take(1000).ToList(); } catch { return new List<Ticket>(); } }
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; } }
public static IQueryable<String> Suggestion(string searchText) { try { QLNXeEntities entities = new QLNXeEntities(); var query = from cs in entities.Customers select cs.FullName; var namelist = query.Where(n => n.ToLower().StartsWith(searchText.ToLower())); return namelist; } catch (Exception) { return null; } }
/// <summary> /// Select All Ticket /// </summary> /// <returns></returns> public static List<Ticket> Select() { try { QLNXeEntities entities = new QLNXeEntities(); return entities.Tickets.ToList(); } catch (Exception) { return null; } }
/// <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; } }
/// <summary> /// Select ticket type by plate /// </summary> /// <param name="plate"></param> /// <returns></returns> public static TicketType SelectTypeByPlate(String plate) { try { QLNXeEntities entities = new QLNXeEntities(); var query = from tk in entities.Tickets where tk.MotorbikePlate == plate join tkType in entities.TicketTypes on tk.TypeId equals tkType.Id select tkType; return query.First(); } catch { return null; } }
/// <summary> /// Select Ticket by Id /// </summary> /// <param name="id"></param> /// <returns></returns> public static Ticket Select(Int64 id) { try { QLNXeEntities entities = new QLNXeEntities(); return entities.Tickets.FirstOrDefault(ob => ob.TicketId == id); } catch (Exception) { return null; } }