public AuthResult[] acknowledgecollectitems(ProductWCF[] itemsList)
{
List <ConsolidatedRequisitionListDetail> detailList = new List <ConsolidatedRequisitionListDetail>();
foreach (ProductWCF p in itemsList)
{
ConsolidatedRequisitionListDetail detail = new ConsolidatedRequisitionListDetail();
detail.ConsolidatedListID = p.ConsolidatedListID;
detail.ItemNumber = p.ItemNumber;
detail.QuantityRequested = p.QuantityRequested;
detail.ActualQuantity = p.ActualQuantityAccepted;
detail.DateRequest = DateTime.Now;
detailList.Add(detail);
}
bool result = DeliverRequestController.acknowledgeCollectItems(detailList);
List <AuthResult> resultList = new List <AuthResult>();
AuthResult bo = new AuthResult();
bo.SuccessResult = result;
resultList.Add(bo);
return(resultList.ToArray <AuthResult>());
}
public static void setActualQuantityForItem(int consolidatedListId, string itemCode, int quantity)
{
UniversityStoreEntities context = new UniversityStoreEntities();
var query = from x in context.ConsolidatedRequisitionListDetails
where x.ConsolidatedListID == consolidatedListId && x.ItemNumber == itemCode
select x;
ConsolidatedRequisitionListDetail detailItem = query.First();
detailItem.ActualQuantity = quantity;
context.SaveChanges();
}
public static void updateStationaryCollection(int conListID, string itemNum, int actualQty)
{
UniversityStoreEntities context = new UniversityStoreEntities();
var q = from x in context.ConsolidatedRequisitionListDetails
where x.ConsolidatedListID == conListID && x.ItemNumber == itemNum
select x;
ConsolidatedRequisitionListDetail c = q.First <ConsolidatedRequisitionListDetail>();
c.ActualQuantity = actualQty;
context.SaveChanges();
}
//public static void acknowledgeCollectItems1(List<ConsolidatedRequisitionListDetail> detailsList)
//{
// foreach (ConsolidatedRequisitionListDetail detailItem in detailsList)
// {
// ConsolidatedRequisitionListDetail item = ConsolidatedRequisitionListEFFacade.getItemWithMatchingListIDAndItemCode(detailItem.ConsolidatedListID, detailItem.ItemNumber);
// if (detailItem.ActualQuantity < item.ActualQuantity)
// {
// int difference = (int)item.ActualQuantity - (int)detailItem.ActualQuantity;
// ConsolidatedRequisitionListEFFacade.setActualQuantityForItem(detailItem.ConsolidatedListID, detailItem.ItemNumber, (int)detailItem.ActualQuantity);
// //raise voucher and update unfulfilled here
// //1. update unfulfilled items table
// updateUnfulfilledList(detailItem, difference);
// //2. raise adjustment voucher
// raiseNewAdjustmentVoucher(detailItem, difference);
// //3. update stock
// ProductDAO.UpdateStock(detailItem.ItemNumber, difference);
// }
// }
//}
private static void updateUnfulfilledList(ConsolidatedRequisitionListDetail detailItem, int quantity)
{
Department dept = ConsolidatedRequisitionListEFFacade.getListForConsolidatedItem(detailItem);
Unfulfilled uf = new Unfulfilled();
uf.ItemNumber = detailItem.ItemNumber;
uf.DepartmentCode = dept.DepartmentCode;
uf.UnfulfilledQuantity = quantity;
uf.Status = UnfulfilledDAO.STATUS_PENDING;
uf.DateCreated = DateTime.Now;
UnfulfilledDAO.CreateUnfulfilled(uf);
}
public static void addRequestedQtyForItem(int consolidatedListId, string itemCode, int qty)
{
UniversityStoreEntities context = new UniversityStoreEntities();
var query = from x in context.ConsolidatedRequisitionListDetails
where x.ConsolidatedListID == consolidatedListId && x.ItemNumber == itemCode
select x;
ConsolidatedRequisitionListDetail detailItem = query.First();
int k = Convert.ToInt32(detailItem.QuantityRequested);
detailItem.QuantityRequested = qty + k;
context.SaveChanges();
}
public static Department getListForConsolidatedItem(ConsolidatedRequisitionListDetail item)
{
UniversityStoreEntities context = new UniversityStoreEntities();
var query = from x in context.ConsolidatedRequisitionLists
from y in context.ConsolidatedRequisitionListDetails
where x.ConsolidatedListID == y.ConsolidatedListID
select x;
ConsolidatedRequisitionList list = query.First();
Department dept = list.Department;
return(dept);
}
public static void addDetailToList(int listID, string itemCode, int qtyReq, DateTime dateCreated, int actualQty)
{
UniversityStoreEntities context = new UniversityStoreEntities();
ConsolidatedRequisitionListDetail c2 = new ConsolidatedRequisitionListDetail();
c2.ConsolidatedListID = listID;
c2.ItemNumber = itemCode;
c2.QuantityRequested = qtyReq;
c2.DateRequest = dateCreated;
c2.ActualQuantity = 0;
context.AddToConsolidatedRequisitionListDetails(c2);
context.SaveChanges();
}
private static void raiseNewAdjustmentVoucher(ConsolidatedRequisitionListDetail item, int quantity)
{
MakeAdjustmentItem adjustmentItem = new MakeAdjustmentItem();
adjustmentItem.Comment = "Damaged";
adjustmentItem.ItemNumber = item.ItemNumber;
adjustmentItem.Quantity = quantity;
adjustmentItem.Status = AdjustmentVoucherEFFacade.STATUS_DECREASE;
List <MakeAdjustmentItem> list = new List <MakeAdjustmentItem>();
list.Add(adjustmentItem);
MakeAdjustmentVoucherController.makeNewAdjustmentVoucher(list);
}
/** end by ashwin
* */
/** added by lee
* */
public static bool acknowledgeCollectItems(List <ConsolidatedRequisitionListDetail> detailsList)
{
List <int> listIDs = new List <int>();
foreach (ConsolidatedRequisitionListDetail detailItem in detailsList)
{
ConsolidatedRequisitionListDetail item = ConsolidatedRequisitionListEFFacade.getItemWithMatchingListIDAndItemCode(detailItem.ConsolidatedListID, detailItem.ItemNumber);
if (detailItem.ActualQuantity < item.ActualQuantity)
{
int difference = (int)item.ActualQuantity - (int)detailItem.ActualQuantity;
ConsolidatedRequisitionListEFFacade.setActualQuantityForItem(detailItem.ConsolidatedListID, detailItem.ItemNumber, (int)detailItem.ActualQuantity);
//raise voucher and update unfulfilled here
//1. update unfulfilled items table
updateUnfulfilledList(detailItem, difference);
//2. raise adjustment voucher
raiseNewAdjustmentVoucher(detailItem, difference);
//3. update stock
ProductDAO.UpdateStock(detailItem.ItemNumber, difference);
}
if (!listIDs.Contains(detailItem.ConsolidatedListID))
{
listIDs.Add(detailItem.ConsolidatedListID);
}
}
foreach (int id in listIDs)
{
ConsolidatedRequisitionListEFFacade.setListStatusToClosed(id);
}
return(true);
}
public static void generateConsolidatedListFromUnfullfilled()
{
List <string> dlist = new List <string>();
List <ConsolidatedRequisitionList> el;
el = ConsolidatedRequisitionListEFFacade.getAllDepInvolved();
foreach (ConsolidatedRequisitionList e in el)
{
dlist.Add(e.DepartmentCode);
}
List <string> deplist = UnfulfilledDAO.getAllUnfullfilledDepartments();
Dictionary <string, List <ConsolidatedRequisitionListDetail> > consolidatedDictionary = new Dictionary <string, List <ConsolidatedRequisitionListDetail> >();
if (deplist.Count() != 0)
{
for (int p = 0; p < deplist.Count(); p++)
{
if (dlist.Contains(deplist[p]))
{
ConsolidatedRequisitionList cl = ConsolidatedRequisitionListEFFacade.getOpenListForDept(deplist[p]);
int listid = cl.ConsolidatedListID;
List <string> itemlist = ConsolidatedRequisitionListEFFacade.getAllItemsOfList(listid);
List <Object> olist1 = UnfulfilledDAO.getAllUnfuffilledOfDep(deplist[p]);
for (int i = 0; i < olist1.Count(); i++)
{
string itmeNum;
itmeNum = olist1[i].ToString().Substring(15, 4);
if (itemlist.Contains(itmeNum))
{
ConsolidatedRequisitionListEFFacade.addRequestedQtyForItem(listid, itmeNum, Convert.ToInt32(olist1[i].ToString().Substring(32, ((olist1[i].ToString().Length) - 34))));
}
else
{
ConsolidatedRequisitionListEFFacade.addDetailToList(listid, itmeNum, Convert.ToInt32(olist1[i].ToString().Substring(32, ((olist1[i].ToString().Length) - 34))), (UnfulfilledDAO.getTheFirstDatetDate(deplist[p])), 0);
}
}
}
if (dlist.Contains(deplist[p]) == false)
{
List <Object> olist2 = UnfulfilledDAO.getAllUnfuffilledOfDep(deplist[p]);
List <ConsolidatedRequisitionListDetail> crl = new List <ConsolidatedRequisitionListDetail>();
for (int i = 0; i < olist2.Count(); i++)
{
ConsolidatedRequisitionListDetail c = new ConsolidatedRequisitionListDetail();
c.ItemNumber = olist2[i].ToString().Substring(15, 4);
c.QuantityRequested = Convert.ToInt32(olist2[i].ToString().Substring(32, ((olist2[i].ToString().Length) - 34)));
c.DateRequest = UnfulfilledDAO.getTheFirstDatetDate(deplist[p]);
c.ActualQuantity = 0;
crl.Add(c);
}
consolidatedDictionary.Add(deplist[p], crl);
ConsolidatedRequisitionListEFFacade.createNewConsolidatedRequisitionList(consolidatedDictionary);
}
}
UnfulfilledDAO.changeOpenToClosed();
}
}