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