public static string GetRole(string username) { string role = ""; using (var db = new ADDbContext()) { if (db.Employee.Where(x => x.UserName.Equals(username)).Any()) { role = db.Employee.Where(x => x.UserName.Equals(username)).FirstOrDefault().Role; } } return(role); }
internal static Employee FindByUserName(string username) { Employee user = new Employee(); using (var db = new ADDbContext()) { if (db.Employee.Where(x => x.UserName.Equals(username)).Any()) { user = db.Employee.Include("department").Where(x => x.UserName.Equals(username)).FirstOrDefault(); } } return(user); }
internal static string GetNameById(int empid) { string user = ""; using (var db = new ADDbContext()) { if (db.Employee.Where(x => x.Id == empid).Any()) { user = db.Employee.Where(x => x.Id == empid).FirstOrDefault().Name; } } return(user); }
internal static bool GetDelegateStatusByUserName(string user) { bool s = false; using (var db = new ADDbContext()) { if (db.Employee.Where(x => x.UserName.Equals(user)).Any()) { s = db.Employee.Where(x => x.UserName.Equals(user)).FirstOrDefault().Delegated; } } return(s); }
internal static int FindDepIdByUsername(string v) { int id = 0; using (var db = new ADDbContext()) { if (db.Employee.Where(x => x.UserName.Equals(v)).Any()) { id = db.Employee.Where(x => x.UserName.Equals(v)).FirstOrDefault().department.Id; } } return(id); }
internal static Supplier GetSupplierByCode(string code) { Supplier sup = new Supplier(); using (var db = new ADDbContext()) { if (db.Supplier.Where(x => x.Code.Equals(code)).Any()) { sup = db.Supplier.Where(x => x.Code.Equals(code)).FirstOrDefault(); } } return(sup); }
public static string GetPassword(string username) { string pw = ""; using (var db = new ADDbContext()) { if (db.Employee.Where(x => x.UserName.Equals(username)).Any()) { pw = db.Employee.Where(x => x.UserName.Equals(username)).FirstOrDefault().PassWord; } } return(pw); }
internal static Supplier GetSupplierById(int sid) { Supplier sup = new Supplier(); using (var db = new ADDbContext()) { if (db.Supplier.Where(x => x.Id == sid).Any()) { sup = db.Supplier.Where(x => x.Id == sid).FirstOrDefault(); } } return(sup); }
internal static List <Supplier> FindAllSupplier() { List <Supplier> list = new List <Supplier>(); using (var db = new ADDbContext()) { if (db.Supplier.Any()) { list = db.Supplier.ToList(); } } return(list); }
internal static List <Delegation> GetAll() { List <Delegation> list = new List <Delegation>(); using (var db = new ADDbContext()) { if (db.Delegation.Any()) { list = db.Delegation.ToList(); } } return(list); }
public static int GetId(string username) { int id = 0; using (var db = new ADDbContext()) { if (db.Employee.Where(x => x.UserName.Equals(username)).Any()) { id = db.Employee.Where(x => x.UserName.Equals(username)).FirstOrDefault().Id; } } return(id); }
internal static List <PurchaseOrder> GetSentPO() { List <PurchaseOrder> listPO = new List <PurchaseOrder>(); using (var db = new ADDbContext()) { if (db.PurchaseOrder.Where(x => x.status.Equals("sent")).Any()) { listPO = db.PurchaseOrder.Include("items.item").Include("items.supplier").Where(x => x.status.Equals("sent")).ToList(); } } return(listPO); }
internal static List <Delegation> GetAllByManagerId(int uId) { List <Delegation> list = new List <Delegation>(); using (var db = new ADDbContext()) { if (db.Delegation.Where(x => x.ManagerId == uId).Any()) { list = db.Delegation.Where(x => x.ManagerId == uId).ToList(); } } return(list); }
internal static DepOrder GetDeliveringOrderByDepAndItem(int dId, int itemId) { DepOrder depo = new DepOrder(); using (var db = new ADDbContext()) { if (db.DepOrder.Where(x => x.dep.Id == dId && x.item.Id == itemId && x.status.Equals("collected")).Any()) { depo = db.DepOrder.Include("dep").Include("item").Where(x => x.dep.Id == dId && x.item.Id == itemId && x.status.Equals("collected")).FirstOrDefault(); } } return(depo); }
internal static List <DepOrder> GetDeliveredDepOrderByDepId(int id) { List <DepOrder> listdepo = new List <DepOrder>(); using (var db = new ADDbContext()) { if (db.DepOrder.Where(x => x.dep.Id == id && x.status.Equals("delivered")).Any()) { listdepo = db.DepOrder.Include("dep").Include("item").Where(x => x.dep.Id == id && x.status.Equals("delivered")).ToList(); } } return(listdepo); }
internal static ItemSupplier GetByItemIdAndSupplierId(int itemId, int supId) { ItemSupplier isup = new ItemSupplier(); using (var db = new ADDbContext()) { if (db.ItemSupplier.Where(x => x.item.Id == itemId && x.supplier.Id == supId).Any()) { isup = db.ItemSupplier.Include("item").Include("supplier").Where(x => x.item.Id == itemId && x.supplier.Id == supId).FirstOrDefault(); } } return(isup); }
internal static PurchaseOrder GetPOById(int pId) { PurchaseOrder p = new PurchaseOrder(); using (var db = new ADDbContext()) { if (db.PurchaseOrder.Where(x => x.Id == pId).Any()) { p = db.PurchaseOrder.Include("items.item").Include("items.supplier").Where(x => x.Id == pId).FirstOrDefault(); } } return(p); }
internal static SRequisition FindReqById(int reqId) { SRequisition sr = new SRequisition(); using (var db = new ADDbContext()) { if (db.SRequisition.Where(x => x.Id == reqId).Any()) { sr = db.SRequisition.Include("ListItem.item").Where(x => x.Id == reqId).FirstOrDefault(); } } return(sr); }
internal static List <SRequisition> FindAllByUsername(string user) { List <SRequisition> list = new List <SRequisition>(); using (var db = new ADDbContext()) { if (db.SRequisition.Where(x => x.ListItem.FirstOrDefault().emp.UserName.Equals(user)).Any()) { list = db.SRequisition.Include("ListItem.item").Where(x => x.ListItem.FirstOrDefault().emp.UserName.Equals(user)).ToList(); } } return(list); }
internal static List <SRequisition> FindAllPendingByDepId(int depId) { List <SRequisition> list = new List <SRequisition>(); using (var db = new ADDbContext()) { if (db.SRequisition.Where(x => x.ListItem.FirstOrDefault().emp.department.Id == depId && x.status.Equals("pending")).Any()) { list = db.SRequisition.Include("ListItem.item").Include("ListItem.emp").Where(x => x.ListItem.FirstOrDefault().emp.department.Id == depId && x.status.Equals("pending")).ToList(); } } return(list); }
public static List <StockCard> GetStockCardByItem(Item item) { List <StockCard> sclist = new List <StockCard>(); using (var db = new ADDbContext()) { if (db.StockCard.Where(x => x.item.Equals(item)).Any()) { sclist = db.StockCard.Where(x => x.item.Equals(item)).ToList(); } } return(sclist); }
internal static Delegation GetById(int deleId) { Delegation dele = new Delegation(); using (var db = new ADDbContext()) { if (db.Delegation.Where(x => x.Id == deleId).Any()) { dele = db.Delegation.Where(x => x.Id == deleId).FirstOrDefault(); } } return(dele); }
internal static List <ItemSupplier> GetAllBySupplierId(int sid) { List <ItemSupplier> list = new List <ItemSupplier>(); using (var db = new ADDbContext()) { if (db.ItemSupplier.Where(x => x.supplier.Id == sid).Any()) { list = db.ItemSupplier.Include("item").Include("supplier").Where(x => x.supplier.Id == sid).ToList(); } } return(list); }
internal static void SetColPoint(int id, string cp) { Department d = new Department(); using (var db = new ADDbContext()) { if (db.Department.Where(x => x.Id == id).Any()) { d = db.Department.Where(x => x.Id == id).FirstOrDefault(); } d.CollectPoint = cp; db.SaveChanges(); } }
internal static void UpdateReOrderQuantByItemId(int itemId, int newreorderquant) { Item it = new Item(); using (var db = new ADDbContext()) { if (db.Item.Where(x => x.Id == itemId).Any()) { it = db.Item.Where(x => x.Id == itemId).FirstOrDefault(); } it.ReorderQty = newreorderquant; db.SaveChanges(); } }
internal static int GetMonthlyStockbalanceByMonthAndItemId(string m, int id) { MonthlyReport monthlyreport = new MonthlyReport(); int mstockbalance = 0; using (var db = new ADDbContext()) { if (db.MonthlyReport.Where(x => x.date.Equals(m) && x.itemId == id).Any()) { mstockbalance = db.MonthlyReport.Where(x => x.date.Equals(m) && x.itemId == id).FirstOrDefault().stockbalance; } } return(mstockbalance); }
internal static int FindIdByDepAndItem(int depId, int itemId) { int id = 0; using (var db = new ADDbContext()) { if (db.DepOrder.Where(x => x.dep.Id == depId && x.item.Id == itemId).Any()) { id = db.DepOrder.Where(x => x.dep.Id == depId && x.item.Id == itemId).FirstOrDefault().Id; } } return(id); }
internal static void SetRep(int dId, int empId) { Department d = new Department(); using (var db = new ADDbContext()) { if (db.Department.Where(x => x.Id == dId).Any()) { d = db.Department.Where(x => x.Id == dId).FirstOrDefault(); } d.DepRepId = empId; db.SaveChanges(); } }
internal static Department GetDepById(int depId) { { Department dep = new Department(); using (var db = new ADDbContext()) { if (db.Department.Where(x => x.Id == depId).Any()) { dep = db.Department.Include("Employees").Where(x => x.Id == depId).FirstOrDefault(); } } return(dep); } }
internal static void setStatus(int id, string v) { PurchaseOrder p = new PurchaseOrder(); using (var db = new ADDbContext()) { if (db.PurchaseOrder.Where(x => x.Id == id).Any()) { p = db.PurchaseOrder.Where(x => x.Id == id).FirstOrDefault(); } p.status = v; db.SaveChanges(); } }