public static IEnumerable <FaultComplexity> GetActiveComplexities() { using (var Context = new NPDEntities()) { return(Context.FaultComplexities.OrderBy(x => x.Id).ToList()); } }
public static IEnumerable <UsersInfo> GetAllActiveEngineers() { using (var Context = new NPDEntities()) { return(Context.UsersInfoes.Where(x => x.RoleId == 2).OrderBy(x => x.Name).ToList()); } }
public static UsersInfo ValidateUser(UsersInfo user) { using (var Context = new NPDEntities()) { return(Context.UsersInfoes.FirstOrDefault(x => x.Email == user.Email && x.Password == user.Password)); } }
public static Fault GetFaultById(int id) { using (var Context = new NPDEntities()) { return(Context.Faults.FirstOrDefault(x => x.Id == id)); } }
public static IEnumerable <FaultLibrary> GetFilesByFaultId(int id) { using (var Context = new NPDEntities()) { return(Context.FaultLibraries.Where(x => x.FaultId == id).OrderByDescending(x => x.Id).ToList()); } }
public static IEnumerable <CustomFault> GetFaults(Fault fault) { using (var Context = new NPDEntities()) { return((from f in Context.Faults join p in Context.FaultPriorities on f.Priority equals p.Id join c in Context.FaultComplexities on f.Complexity equals c.Id join co in Context.companies on f.CompanyId equals co.Id join u in Context.UsersInfoes on f.AssignedTo equals u.Id where f.Status == 1 select new CustomFault() { CompanyName = co.Name, AssignedTo = u.Name, Complexity = c.Name, FaultDescription = f.FaultDescription, FaultStatus = "", Location = f.Location, MachineDescription = f.MachineDescription, Priority = p.Name, CreatedDate = f.CreatedDate, Id = f.Id, StartDate = f.StartDate }).OrderByDescending(x => x.Complexity).ToList()); } }
public static IEnumerable <company> GetAllActive() { using (var Context = new NPDEntities()) { return(Context.companies.OrderByDescending(x => x.CreatedDate).ToList()); } }
public static int SaveFile(FaultLibrary entity) { using (var Context = new NPDEntities()) { Context.Set <FaultLibrary>().Add(entity); return(Context.SaveChanges()); } }
public static int SaveCompany(company companyEntity) { using (var Context = new NPDEntities()) { Context.Set <company>().Add(companyEntity); return(Context.SaveChanges()); } }
public static int UpdateFault(Fault model) { using (var Context = new NPDEntities()) { var fault = Context.Faults.FirstOrDefault(x => x.Id == model.Id); fault.CompanyId = model.CompanyId; fault.Complexity = model.Complexity; fault.FaultDescription = model.FaultDescription; fault.FaultStatus = model.Priority < 1 ? 0 : 1; fault.Location = model.Location; fault.MachineDescription = model.MachineDescription; fault.ModifiedBy = model.ModifiedBy; fault.ModifiedDate = DateTime.Now; fault.Priority = model.Priority; fault.StartDate = DateTime.Now; fault.AssignedTo = model.AssignedTo; return(Context.SaveChanges()); } }