//check disbursement
public static bool checkDisbursmentID(string Dis_ID, string RepID)
{
bool isDisbursmentIDCorrect = false;
using (InventorySysDBEntities cntx = new InventorySysDBEntities())
{
Staff Rep = cntx.Staffs.Find(RepID);
// whether disbursment exist
Disbursement dis = cntx.Disbursements.Find(Dis_ID);
if (dis != null)
{
// Rep only can see its own disbursment
if (dis.RepStaff_ID == Rep.Staff_ID)
{
// only the submitted disbursment can be seen
switch (dis.Status)
{
case "Received":
break;
case "Submitted":
isDisbursmentIDCorrect = true;
break;
}
}
}
return(isDisbursmentIDCorrect);
}
}
public static void ConfirmRecivedItems(string DI, List <DisbursementDetail> ddlist)
{
Staff rep = new Staff();
using (InventorySysDBEntities cntx = new InventorySysDBEntities())
{
//update disbursmentdetail
foreach (DisbursementDetail dd in ddlist)
{
updateDisbursmentDetail(cntx, dd);
}
//update disbursment
Disbursement disbursment = cntx.Disbursements.Find(DI);
rep = StaffController.getRepByDepID(disbursment.Dept_ID);
disbursment.Receive_Date = DateTime.Now;
disbursment.Status = "Recieved";
// update Requisition
List <Requisition> reqList = getRequisitionsByDI(DI);
foreach (Requisition req in reqList)
{
Requisition reqData = cntx.Requisitions.Find(req.Requisition_ID);
reqData.Status = "Received";
}
cntx.SaveChanges();
}
SendNotificationController.SendNotificaition(rep, DI);
}
////staff List get by dept
//public static List<Staff> getStaffListByDepIDandroleID(string DepID, string roleID)
//{
// using (InventorySysDBEntities cntx = new InventorySysDBEntities())
// {
// var q = from x in cntx.Staffs
// where x.Dept_ID == DepID
// where x.Role_ID == roleID
// select x;
// Console.Write(q.ToString());
// return q.ToList();
// }
//}
//update collection point according to staff and collection point
public static Staff GetRepByDeptID(string deptID)
{
using (InventorySysDBEntities cntx = new InventorySysDBEntities())
{
var q = from x in cntx.Staffs where x.Dept_ID == deptID && x.Role_ID == "RepStaff" select x;
return(q.First());
}
}
public static void updateDisbursmentDetail(InventorySysDBEntities cntx, DisbursementDetail newDD)
{
// update disbursmentDetailRow
string DI = newDD.Disbursement_ID;
string itemID = newDD.Item_ID;
DisbursementDetail oldDD = cntx.DisbursementDetails.Find(DI, itemID);
oldDD.Quantity = newDD.Quantity;
}
//collection List
public static List <CollectionPoint> getAllCollection()
{
using (InventorySysDBEntities cntx = new InventorySysDBEntities())
{
var q = from x in cntx.CollectionPoints
select x;
return(q.ToList());
}
}
//confirm received
public static List <Requisition> getRequisitionsByDI(string DI)
{
using (InventorySysDBEntities cntx = new InventorySysDBEntities())
{
var q = from req in cntx.Requisitions
where req.Disbursement_ID == DI
select req;
return(q.ToList());
}
}
//staff List get by dept
public static List <Staff> getStaffListByDepID(string DepID)
{
using (InventorySysDBEntities cntx = new InventorySysDBEntities())
{
var q = from x in cntx.Staffs
where x.Dept_ID == DepID && (x.Role_ID == "Staff" || x.Role_ID == "RepStaff")
select x;
Console.Write(q.ToString());
return(q.ToList());
}
}
//collection get by dept
public static CollectionPoint getCollectionInfoByDepID(string DepId)
{
using (InventorySysDBEntities cntx = new InventorySysDBEntities())
{
var q = from d in cntx.Departments
where d.Dept_ID == DepId
select d.CollectionPoint;
return(q.ToList().First());
}
}
//public static bool ChangeRepToStaff(string deptID)
//{
// using (InventorySysDBEntities cntx = new InventorySysDBEntities())
// {
// Staff stf = GetRepByDeptID(deptID);
// Staff repStaff = cntx.Staffs.Find(stf.Staff_ID);
// if (repStaff != null)
// {
// repStaff.Role_ID = "Staff";
// cntx.SaveChanges();
// return true;
// }
// else
// return false;
// }
//}
//public static bool ChangeStaffToRep(string staffID)
//{
// using (InventorySysDBEntities cntx = new InventorySysDBEntities())
// {
// var q = from x in cntx.Staffs where x.Staff_ID == staffID select x;
// if (q.ToList().Count > 0)
// {
// q.First().Role_ID = "RepStaff";
// cntx.SaveChanges();
// return true;
// }
// else
// return false;
// }
//}
public static void UpdateCollectionPoint(string DeptID, string ColID)
{
using (InventorySysDBEntities cntx = new InventorySysDBEntities())
{
var q = from x in cntx.Departments where x.Dept_ID == DeptID select x;
Department d = q.First();
d.Collection_ID = ColID;
cntx.SaveChanges();
}
}
public static List <DisbursmentItemModel_M> getDisbursmentItems(string Dis_ID)
{
using (InventorySysDBEntities cntx = new InventorySysDBEntities())
{
var q = from ri in cntx.RequisitionItems
where ri.Requisition.Disbursement_ID == Dis_ID
group ri by ri.Item_ID into g
join i in cntx.Items on g.Key equals i.Item_ID
select new DisbursmentItemModel_M
{
ItemCode = g.Key,
ItemDes = i.Item_Name,
NeedQty = g.Sum(m => m.Required_Qty),
UOM = i.UOM
};
return(q.ToList());
}
}
public static bool UpdateCollectionPoint(string DeptID, string staffID, string ColID)
{
using (InventorySysDBEntities cntx = new InventorySysDBEntities())
{
using (var dbContextTransaction = cntx.Database.BeginTransaction())
{
try
{
//make here the changes
Staff stf = GetRepByDeptID(DeptID);
Staff repStaff = cntx.Staffs.Find(stf.Staff_ID);
repStaff.Role_ID = "Staff";
var changeStaffTRep = from x in cntx.Staffs where x.Staff_ID == staffID select x;
changeStaffTRep.First().Role_ID = "RepStaff";
var updateCollectionPoint = from x in cntx.Departments where x.Dept_ID == DeptID select x;
Department d = updateCollectionPoint.First();
d.Collection_ID = ColID;
cntx.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
return(false);
}
}
}
}