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