private Message proceedAll(List <Requisition> approvedList)
{
try
{
foreach (Requisition item in approvedList)
{
rc.actionRequisitionStatusChangeToProcessing(item.id);
if (existingData(item))
{
oldRF.requested_quantity += item.quantity;
oldRF.fulfill_quantity += calculateQty(item.stationery, item.quantity);
Console.WriteLine("Updating Requisition Fulfillment successful !" + data.SaveChanges());
}
else
{
RequisitionFullfillment newRF = new RequisitionFullfillment();
newRF.department = item.department;
newRF.stationery = item.stationery;
newRF.requested_quantity = item.quantity;
newRF.fulfill_quantity = calculateQty(item.stationery, item.quantity);
newRF.unfulfill_quantity = 0;
data.RequisitionFullfillments.AddObject(newRF);
Console.WriteLine("Creating New Requisition Fullfillment successful !" + data.SaveChanges());
}
}
}
catch (Exception e)
{
}
return(new Message());
}
public void actionUpdateFulfillmentByObject(RequisitionFullfillment rf, int unfulfillQty)
{
RequisitionFullfillment requisitionFulfillment = rf;
requisitionFulfillment.requested_quantity = unfulfillQty;
requisitionFulfillment.fulfill_quantity = 0;
requisitionFulfillment.unfulfill_quantity = unfulfillQty;
data.SaveChanges();
}
public void updateFulfillQtyForDiscrepancy(int stationeryId, int damageQty)
{
// Last record by department
RequisitionFullfillment rf = (from r in data.RequisitionFullfillments
where r.stationery == stationeryId
orderby r.id descending
select r).FirstOrDefault();
rf.fulfill_quantity -= damageQty;
data.SaveChanges();
}
public void actionUpdateToDisbursement(int req_dept, int stationery)
{
FulfillmentController fc = new FulfillmentController();
rf = fc.actionGetFulfillmentByDepartmentAndStationery(req_dept, stationery);
// -------------- Disbursement Table Process ----------
disbursement = actionGetDisbursementByDepartmentAndTodayDate(req_dept);
if (disbursement == null)
{
actionCreateDisbursementTable(req_dept, getDeptRept(req_dept));
}
disbursementId = actionGetDisbursementIdByDepartmentAndDate(req_dept, disbursement.distributed_date);
// -------------- Disbursement Detail Table Process ----------
disbursementDetail = actionGetDisbursementDetailByDepartmentAndStationery(stationery);
if (disbursementDetail == null)
{
actionCreateDisbursementDetailTable();
}
else
{
actionUpdateDisbursementDetailTable();
}
// -------------- Update Stationery Process ----------
new StationeryController().actionUpdateQty(rf.stationery, rf.fulfill_quantity);
// -------------- Update StockTransaction Process ----------
new StockTransactionController().actionCreateStockTransaction(stationery, new StationeryController().actionGetQtyInStock(stationery),
"Disbursement", "- " + rf.fulfill_quantity.ToString());
// -------------- Remaining Requisition Fulfillment Process ----------
unfulfillQty = rf.requested_quantity - rf.fulfill_quantity;
if (unfulfillQty == 0)
{
fc.actionDeleteFulfillmentByObject(rf);
}
else
{
fc.actionUpdateFulfillmentByObject(rf, unfulfillQty);
}
// -------------- Update Requisition Status Process ----------
new RequisitionController().actionRequisitionStatusChangeToDistributedByDepartment(stationery, req_dept);
}
public void actionUpdateQty(int deptId, int stationeryId, int originalQty, int editableQty)
{
oldRF = actionGetFulfillmentByDepartmentAndStationery(deptId, stationeryId);
oldRF.fulfill_quantity = editableQty;
int changedQty = originalQty - editableQty;
Stationery statoinery = (from s in data.Stationeries
where s.id == stationeryId
select s)
.FirstOrDefault();
statoinery.pending_quantity_to_distribute -= changedQty;
data.SaveChanges();
}
private bool existingData(Requisition item)
{
oldRF = actionGetFulfillmentByDepartmentAndStationery(item.department, item.stationery);
return(oldRF != null?true:false);
}
public void actionDeleteFulfillmentByObject(RequisitionFullfillment rf)
{
data.RequisitionFullfillments.DeleteObject(rf);
data.SaveChanges();
}
public void actionUpdateFulfillmentByObject(RequisitionFullfillment rf, int unfulfillQty)
{
RequisitionFullfillment requisitionFulfillment = rf;
requisitionFulfillment.requested_quantity = unfulfillQty;
requisitionFulfillment.fulfill_quantity = 0;
requisitionFulfillment.unfulfill_quantity = unfulfillQty;
data.SaveChanges();
}
public void actionDeleteFulfillmentByObject(RequisitionFullfillment rf)
{
data.RequisitionFullfillments.DeleteObject(rf);
data.SaveChanges();
}
private Message proceedAll(List<Requisition> approvedList)
{
try
{
foreach (Requisition item in approvedList)
{
rc.actionRequisitionStatusChangeToProcessing(item.id);
if (existingData(item))
{
oldRF.requested_quantity += item.quantity;
oldRF.fulfill_quantity += calculateQty(item.stationery, item.quantity);
Console.WriteLine("Updating Requisition Fulfillment successful !"+data.SaveChanges());
}
else
{
RequisitionFullfillment newRF = new RequisitionFullfillment();
newRF.department = item.department;
newRF.stationery = item.stationery;
newRF.requested_quantity = item.quantity;
newRF.fulfill_quantity = calculateQty(item.stationery, item.quantity);
newRF.unfulfill_quantity = 0;
data.RequisitionFullfillments.AddObject(newRF);
Console.WriteLine("Creating New Requisition Fullfillment successful !" + data.SaveChanges());
}
}
}
catch (Exception e)
{
}
return new Message();
}
private bool existingData(Requisition item)
{
oldRF = actionGetFulfillmentByDepartmentAndStationery(item.department, item.stationery);
return (oldRF!=null?true:false);
}
public void actionUpdateQty(int deptId, int stationeryId, int originalQty, int editableQty)
{
oldRF = actionGetFulfillmentByDepartmentAndStationery(deptId, stationeryId);
oldRF.fulfill_quantity = editableQty;
int changedQty = originalQty - editableQty;
Stationery statoinery = (from s in data.Stationeries
where s.id==stationeryId
select s)
.FirstOrDefault();
statoinery.pending_quantity_to_distribute -= changedQty;
data.SaveChanges();
}
public void actionUpdateToDisbursement(int req_dept, int stationery)
{
FulfillmentController fc = new FulfillmentController();
rf=fc.actionGetFulfillmentByDepartmentAndStationery(req_dept, stationery);
// -------------- Disbursement Table Process ----------
disbursement = actionGetDisbursementByDepartmentAndTodayDate(req_dept);
if (disbursement == null)
actionCreateDisbursementTable(req_dept, getDeptRept(req_dept));
disbursementId=actionGetDisbursementIdByDepartmentAndDate(req_dept, disbursement.distributed_date);
// -------------- Disbursement Detail Table Process ----------
disbursementDetail = actionGetDisbursementDetailByDepartmentAndStationery(stationery);
if (disbursementDetail == null)
actionCreateDisbursementDetailTable();
else
actionUpdateDisbursementDetailTable();
// -------------- Update Stationery Process ----------
new StationeryController().actionUpdateQty(rf.stationery, rf.fulfill_quantity);
// -------------- Update StockTransaction Process ----------
new StockTransactionController().actionCreateStockTransaction(stationery, new StationeryController().actionGetQtyInStock(stationery),
"Disbursement", "- "+rf.fulfill_quantity.ToString());
// -------------- Remaining Requisition Fulfillment Process ----------
unfulfillQty = rf.requested_quantity - rf.fulfill_quantity;
if (unfulfillQty == 0)
fc.actionDeleteFulfillmentByObject(rf);
else
fc.actionUpdateFulfillmentByObject(rf, unfulfillQty);
// -------------- Update Requisition Status Process ----------
new RequisitionController().actionRequisitionStatusChangeToDistributedByDepartment(stationery, req_dept);
}
