public static void SaveReq(SRequisition sr)
{
using (var db = new ADDbContext())
{
SRequisition s = new SRequisition();
ReqItem ri = new ReqItem();
if (db.SRequisition.Where(x => x.Id == sr.Id).Any())
{
s = db.SRequisition.Where(x => x.Id == sr.Id).FirstOrDefault();
if (s.ListItem != null)
{
if (s.ListItem.Sum(x => x.Quant) != 0)
{
foreach (var item in sr.ListItem)
{
if (s.ListItem.Where(x => x.item.ItemCode == item.item.ItemCode).Any())
{
s.ListItem.Where(x => x.item.ItemCode == item.item.ItemCode).FirstOrDefault().Quant = sr.ListItem.Where(x => x.item.ItemCode == item.item.ItemCode).FirstOrDefault().Quant;
}
else
{
ri.item = item.item;
ri.emp = item.emp;
ri.Quant = item.Quant;
s.ListItem.Add(ri);
}
}
}
else
{
foreach (var item in sr.ListItem)
{
item.Quant = 0;
}
}
}
}
else
{
s.ListItem = new List <ReqItem>();
foreach (var item in sr.ListItem)
{
item.emp = db.Employee.Where(x => x.Id == item.emp.Id).FirstOrDefault();
item.item = db.Item.Where(x => x.Id == item.item.Id).FirstOrDefault();
db.ReqItem.Add(item);
s.ListItem.Add(item);
}
db.SaveChanges();
db.SRequisition.Add(s);
}
db.SaveChanges();
}
}
internal static void CreatePO(List <ItemSupplier> listrr)
{
PurchaseOrder po = new PurchaseOrder();
po.items = new List <ItemSupplier>();
ItemSupplier xx = new ItemSupplier();
int sId = listrr.FirstOrDefault().item.Id;
int iId = listrr.FirstOrDefault().supplier.Id;
using (var db = new ADDbContext())
{
foreach (ItemSupplier its in listrr)
{
if (db.ItemSupplier.Where(x => x.item.Id == its.item.Id && x.supplier.Id == its.supplier.Id).Any())
{
xx = db.ItemSupplier.Where(x => x.item.Id == its.item.Id && x.supplier.Id == its.supplier.Id).FirstOrDefault();
}
po.items.Add(xx);
}
po.RequestDelivDate = DateTime.Today.AddDays(15);
po.status = "pending";
db.PurchaseOrder.Add(po);
db.SaveChanges();
}
}
public static void AddToStock(Item item, DateTime dt, int supId, double price, int quant, int balance)
{
StockCard sc = new StockCard();
Item it = new Item();
if (quant < 0)
{
throw new Exception("Add in quantity must be positive number");
}
using (var db = new ADDbContext())
{
if (db.Item.Where(x => x.Id == item.Id).Any())
{
it = db.Item.Where(x => x.Id == item.Id).FirstOrDefault();
}
sc.date = dt;
sc.item = it;
sc.supplierId = supId;
sc.uprice = price;
sc.quant = quant;
sc.comment = "Add In";
sc.balance = balance + quant;
db.StockCard.Add(sc);
db.SaveChanges();
}
}
public static void WithdrawFromStockRecord(Item item, DateTime dt, Department dep, int quant, int balance)
{
StockCard sc = new StockCard();
Item it = new Item();
if (quant < 0)
{
throw new Exception("Withdraw quantity must be in minus");
}
using (var db = new ADDbContext())
{
if (db.Item.Where(x => x.Id == item.Id).Any())
{
it = db.Item.Where(x => x.Id == item.Id).FirstOrDefault();
}
sc.date = dt;
sc.item = it;
sc.department = dep;
sc.quant = -quant;
sc.comment = "Withdraw";
sc.balance = balance - quant;
sc.uprice = StockCardData.GetLatestPriceByItem(it);
db.StockCard.Add(sc);
db.SaveChanges();
}
}
internal static void AddDemand(int depId, int itemId, int quant)
{
Department d = new Department();
using (var db = new ADDbContext())
{
if (db.Department.Where(x => x.Id == depId).Any())
{
d = db.Department.Where(x => x.Id == depId).FirstOrDefault();
}
if (d.demandingItem != null)
{
if (d.demandingItem.ContainsKey(itemId))
{
d.demandingItem[itemId] += quant;
}
else
{
d.demandingItem.Add(itemId, quant);
}
}
else
{
d.demandingItem = new Dictionary <int, int>();
d.demandingItem.Add(itemId, quant);
}
db.SaveChanges();
}
}
internal static void GiveDelegate(int empId)
{
using (var db = new ADDbContext())
{
Employee e = db.Employee.Where(x => x.Id == empId).FirstOrDefault();
e.Delegated = true;
db.SaveChanges();
}
}
internal static void CreateDelegation(int userid, DateTime sdate, DateTime edate, int empId)
{
Delegation deleg = new Delegation(userid, sdate, edate, empId);
using (var db = new ADDbContext())
{
db.Delegation.Add(deleg);
db.SaveChanges();
}
}
internal static void CreateInvAdj(Item item, int quant, string reason)
{
InventoryAdj invadj = new InventoryAdj(item, quant, reason);
using (var db = new ADDbContext())
{
db.InventoryAdj.Add(invadj);
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 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 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 void SetRoleToRep(int id)
{
Employee emp = new Employee();
using (var db = new ADDbContext())
{
if (db.Employee.Where(x => x.Id == id).Any())
{
emp = db.Employee.Where(x => x.Id == id).FirstOrDefault();
}
emp.Role = "DepRep";
db.SaveChanges();
}
}
internal static void RemoveById(int dId)
{
Delegation deleg = new Delegation();
using (var db = new ADDbContext())
{
if (db.Delegation.Where(x => x.Id == dId).Any())
{
deleg = db.Delegation.Where(x => x.Id == dId).FirstOrDefault();
}
db.Delegation.Remove(deleg);
db.SaveChanges();
}
}
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();
}
}
public static SRequisition CreateRequisition(List <ReqItem> listreqitem)
{
SRequisition sreq = new SRequisition();
sreq.ListItem = listreqitem;
using (var db = new ADDbContext())
{
foreach (ReqItem reqitem in listreqitem)
{
int i = reqitem.emp.Id;
if (!db.ReqItem.Where(x => x.item.Id == reqitem.item.Id).Any())
{
db.ReqItem.Add(reqitem);
}
}
db.SaveChanges();
//int j = db.ReqItem.Where(x => x.item.Id == 1).FirstOrDefault().emp.Id;
db.SRequisition.Add(sreq);
db.SaveChanges();
}
return(sreq);
}
internal static void SetPriceById(int isId, double newprice)
{
ItemSupplier itsu = new ItemSupplier();
using (var db = new ADDbContext())
{
if (db.ItemSupplier.Where(x => x.Id == isId).Any())
{
itsu = db.ItemSupplier.Where(x => x.Id == isId).FirstOrDefault();
}
itsu.UnitPrice = newprice;
db.SaveChanges();
}
}
internal static void CreatReqItem(int itemId, int empId, int dif, string v)
{
ReqItem reitem = new ReqItem();
using (var db = new ADDbContext())
{
reitem.item = db.Item.Where(x => x.Id == itemId).FirstOrDefault();
reitem.emp = db.Employee.Where(x => x.Id == empId).FirstOrDefault();
reitem.Status = v;
reitem.Quant = dif;
db.ReqItem.Add(reitem);
db.SaveChanges();
}
}
internal static void CreateMonthlyReport(int itemId, string dt, int mcons, int sbalance)
{
MonthlyReport monthlyreport = new MonthlyReport();
using (var db = new ADDbContext())
{
monthlyreport.date = dt;
monthlyreport.itemId = itemId;
monthlyreport.consumption = mcons;
monthlyreport.stockbalance = sbalance;
db.MonthlyReport.Add(monthlyreport);
db.SaveChanges();
}
}
internal static void SetReceived(int dId, int itemId, int v)
{
DepOrder deporder = 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())
{
deporder = db.DepOrder.Where(x => x.dep.Id == dId && x.item.Id == itemId && x.status.Equals("collected")).FirstOrDefault();
}
deporder.deliveredquant = v;
deporder.status = "delivered";
deporder.signindate = DateTime.Today;
db.SaveChanges();
}
}
internal static bool SetReqItemCollected(int empId, int itemId)
{
ReqItem reitem = new ReqItem();
bool status = false;
using (var db = new ADDbContext())
{
if (db.ReqItem.Where(x => x.item.Id == itemId && x.emp.Id == empId && x.Status.Equals("approved")).Any())
{
reitem = db.ReqItem.Where(x => x.item.Id == itemId && x.emp.Id == empId && x.Status.Equals("approved")).FirstOrDefault();
reitem.Status = "collected";
status = true;
}
db.SaveChanges();
}
return(status);
}
internal static void RejectInvAdj(int invAdjId, string remark)
{
InventoryAdj invadj = new InventoryAdj();
using (var db = new ADDbContext())
{
if (db.InventoryAdj.Where(x => x.Id == invAdjId).Any())
{
invadj = db.InventoryAdj.Where(x => x.Id == invAdjId).FirstOrDefault();
invadj.Status = "rejected";
invadj.Remark = remark;
db.SaveChanges();
}
}
}
internal static void DeleteInvAdj(int itemId)
{
InventoryAdj invadj = new InventoryAdj();
using (var db = new ADDbContext())
{
if (db.InventoryAdj.Where(x => x.Id == itemId).Any())
{
invadj = db.InventoryAdj.Where(x => x.Id == itemId).FirstOrDefault();
db.InventoryAdj.Remove(invadj);
db.SaveChanges();
}
}
}
internal static void SetCollected(int depId, int itemId, int v)
{
DepOrder deporder = new DepOrder();
using (var db = new ADDbContext())
{
if (db.DepOrder.Where(x => x.item.Id == itemId && x.dep.Id == depId && x.status.Equals("acknowledged")).Any())
{
deporder = db.DepOrder.Where(x => x.item.Id == itemId && x.dep.Id == depId && x.status.Equals("acknowledged")).FirstOrDefault();
}
deporder.collectedquant = v;
deporder.status = "collected";
db.SaveChanges();
}
}
internal static void deleteReqById(int id)
{
SRequisition sr = new SRequisition();
using (var db = new ADDbContext())
{
if (db.SRequisition.Where(x => x.Id == id).Any())
{
sr = db.SRequisition.Where(x => x.Id == id).FirstOrDefault();
List <ReqItem> list = sr.ListItem.ToList();
for (int i = 0; i < sr.ListItem.Count; i++)
{
db.ReqItem.Remove(list[i]);
}
db.SRequisition.Remove(sr);
}
db.SaveChanges();
}
}
public static void CreateDepOrder(int depId, int itemId, int quant, double price)
{
DepOrder dorder = new DepOrder();
using (var db = new ADDbContext())
{
Department d = db.Department.Where(x => x.Id == depId).FirstOrDefault();
Item i = db.Item.Where(x => x.Id == itemId).FirstOrDefault();;
dorder.dep = d;
dorder.item = i;
dorder.quant = quant;
dorder.uprice = price;
db.DepOrder.Add(dorder);
db.SaveChanges();
}
}
public static void AdjustStockRecord(DateTime dt, InventoryAdj invadj, int balance)
{
StockCard sc = new StockCard();
Item it = new Item();
using (var db = new ADDbContext())
{
if (db.Item.Where(x => x.Id == invadj.item.Id).Any())
{
it = db.Item.Where(x => x.Id == invadj.item.Id).FirstOrDefault();
}
sc.date = dt;
sc.item = it;
sc.quant = invadj.Quant;
sc.comment = "Stock Adjustment--" + invadj.Reason;
sc.balance = balance + invadj.Quant;
db.StockCard.Add(sc);
db.SaveChanges();
}
}
internal static void UpdateSupplier(Supplier sup)
{
Supplier s = new Supplier();
using (var db = new ADDbContext())
{
if (db.Supplier.Where(x => x.Code.Equals(sup.Code)).Any())
{
s = db.Supplier.Where(x => x.Code.Equals(sup.Code)).FirstOrDefault();
}
if (sup.Name != null)
{
s.Name = sup.Name;
}
if (sup.ContactName != null)
{
s.ContactName = sup.ContactName;
}
if (sup.Phone != null)
{
s.Phone = sup.Phone;
}
if (sup.Fax != null)
{
s.Fax = sup.Fax;
}
if (sup.Address != null)
{
s.Address = sup.Address;
}
if (sup.Emailaddress != null)
{
s.Emailaddress = sup.Emailaddress;
}
db.SaveChanges();
}
}
internal static void SetSupplier()
{
ItemSupplier its1 = new ItemSupplier();
ItemSupplier its2 = new ItemSupplier();
ItemSupplier its3 = new ItemSupplier();
Item it = new Item();
using (var db = new ADDbContext())
{
foreach (int itId in db.Item.ToList().Select(x => x.Id))
{
it = db.Item.Where(x => x.Id == itId).FirstOrDefault();
its1 = db.ItemSupplier.Where(x => x.item.Id == itId && x.supplier.Id == 1).FirstOrDefault();
it.Supplier1 = its1;
its2 = db.ItemSupplier.Where(x => x.item.Id == itId && x.supplier.Id == 2).FirstOrDefault();
it.Supplier2 = its2;
its3 = db.ItemSupplier.Where(x => x.item.Id == itId && x.supplier.Id == 3).FirstOrDefault();
it.Supplier3 = its3;
}
db.SaveChanges();
}
}
public static bool RejectRequisition(int srid, string remark)
{
SRequisition sreq = new SRequisition();
using (var db = new ADDbContext())
{
if (db.SRequisition.Where(x => x.Id == srid).Any())
{
sreq = db.SRequisition.Where(x => x.Id == srid).FirstOrDefault();
foreach (ReqItem ri in sreq.ListItem)
{
ri.Status = "rejected";
}
sreq.status = "rejected";
sreq.remark = remark;
db.SaveChanges();
return(true);
}
}
return(false);
}
public static bool ApproveRequisition(int srid, string remark)
{
using (var db = new ADDbContext())
{
SRequisition sreq = new SRequisition();
if (db.SRequisition.Where(x => x.Id == srid).Any())
{
sreq = db.SRequisition.Where(x => x.Id == srid).FirstOrDefault();
foreach (ReqItem ri in sreq.ListItem)
{
ri.Status = "approved";
DepartmentData.AddDemand(ri.emp.department.Id, ri.item.Id, ri.Quant);
}
sreq.status = "approved";
sreq.remark = remark;
db.SaveChanges();
return(true);
}
}
return(false);
}
