/// <summary>
/// Insert stock card details and update purchase order
/// Created By:JinChengCheng
/// Created Date:28-01-2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
/// <param name="purchaseOrderNumber"></param>
/// <returns>The return type of this method is status.</returns>
public Constants.ACTION_STATUS SelectReceived(DataTable purchaseOrderDetailTable)
{
Constants.ACTION_STATUS receivedStatus = Constants.ACTION_STATUS.UNKNOWN;
if (purchaseOrderList.Count > 0)
{
int index = 0;
foreach (PurchaseOrderDetail purchaseOrderDetail in purchaseOrder.PurchaseOrderDetails)
{
purchaseOrderDetail.AcceptedQty = Converter.objToInt(purchaseOrderDetailTable.Rows[index++][columnName[2]]);
//purchaseOrderDetail. = Converter.objToInt(purchaseOrderDetailTable.Rows[index++][columnName[2]]); Need to add Remarks!!!! Arghhhhh
}
if (purchaseOrderBroker.Update(purchaseOrder) == Constants.DB_STATUS.SUCCESSFULL)
{
receivedStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
receivedStatus = Constants.ACTION_STATUS.FAIL;
}
}
else
{
receivedStatus = Constants.ACTION_STATUS.FAIL;
}
return(receivedStatus);
}
//public RequisitionDetail SelectRequisitionID(string requisitionId)
//{
// //requisition = new Requisition();
// RequisitionDetail requisitionDetail = new RequisitionDetail();
// requisitionDetail.Id = requisitionId;
// RequisitionDetail resultRequisitionDetail=requisitionBroker.GetRequisitionDetail(requisitionDetail);
//}
/// <summary>
/// Refresh requisition list after withdraw one requisition
/// Created By:JinChengCheng
/// Created Date:26-01-2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
/// <param name="requisitionId"></param>
/// <returns>The return type of this method is datatable.</returns>
public Constants.ACTION_STATUS SelectWithdraw(string requisitionId, string remarks)
{
Constants.REQUISITION_STATUS requisitionStatus = Constants.REQUISITION_STATUS.WITHDRAW;
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
//Employee employee = new Employee();
//employee.Id = currentEmployee.Id;
//employee = employeeBroker.GetEmployee(employee);
requisition = new Requisition();
requisition.Id = requisitionId;
requisition = requisitionBroker.GetRequisition(requisition);
requisition.Remarks = (remarks == null ? String.Empty : remarks);
//requisition.ApprovedBy = employee;
//requisition.ApprovedDate = DateTime.Now;
requisition.Status = Converter.objToInt(requisitionStatus);
if (requisitionBroker.Update(requisition) == Constants.DB_STATUS.FAILED)
{
status = Constants.ACTION_STATUS.FAIL;
}
else
{
status = Constants.ACTION_STATUS.SUCCESS;
}
return(status);
//Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
//Constants.DB_STATUS dbStatus = requisitionBroker.Delete(requisition);
//dbStatus = Constants.DB_STATUS.SUCCESSFULL;
//if (requisitionList.Count == 1)
// return null;
//else
// return GetRequisitionList();
}
public Constants.ACTION_STATUS AddItem(string itemId, int qty, double price)
{
Constants.ACTION_STATUS addStatus = Constants.ACTION_STATUS.UNKNOWN;
Item item = new Item();
item.Id = itemId;
item = itemBroker.GetItem(item);
if (item != null && qty > 0 && price > 0)
{
if (!addedItemList.ContainsKey(item))
{
List <double> other = new List <double>();
other.Add(qty);
other.Add(price);
addedItemList.Add(item, other);
addStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
addStatus = Constants.ACTION_STATUS.FAIL;
}
}
else
{
addStatus = Constants.ACTION_STATUS.FAIL;
}
return(addStatus);
}
//public Constants.ACTION_STATUS SelectRemove(DiscrepancyDetail discrepancyDetail)
//{
// Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
// discrepancyDetailList.Remove(discrepancyDetail);
// status = Constants.ACTION_STATUS.SUCCESS;
// return status;
//}
/// <summary>
/// Refresh the discrepancy list after remove one
/// Created By:JinChengCheng
/// Created Date:26-01-2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
/// <param name="discrepancyDetail"></param>
/// <returns>The return type of this method is datatable.</returns>
public Constants.ACTION_STATUS SelectRemove(int index)
{
Constants.ACTION_STATUS removeStatus = Constants.ACTION_STATUS.UNKNOWN;
if (discrepancy.DiscrepancyDetails.Count >= index)
{
discrepancy.DiscrepancyDetails.Remove(discrepancy.DiscrepancyDetails.ElementAt(index));
//List<DiscrepancyDetail> discrepancyDetails = discrepancy.DiscrepancyDetails.ToList<DiscrepancyDetail>();
//discrepancy = new Discrepancy();
//discrepancy.Id = discrepancyBroker.GetDiscrepancyId();
//discrepancy.CreatedDate = DateTime.Now;
//discrepancy.CreatedBy = Util.GetEmployee(new EmployeeBroker(inventory));
//discrepancy.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW);
//foreach (DiscrepancyDetail discrepancyDetail in discrepancyDetails)
//{
// discrepancy.DiscrepancyDetails.Add(discrepancyDetail);
//}
removeStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
removeStatus = Constants.ACTION_STATUS.FAIL;
}
return(removeStatus);
}
public Constants.ACTION_STATUS SetDeliveryDate(int retrievalNo, DateTime deliveryDate)
{
Constants.ACTION_STATUS setStatus = Constants.ACTION_STATUS.UNKNOWN;
Retrieval retrieval = retrievalList.Find(delegate(Retrieval r) { return(r.Id == retrievalNo); });
foreach (RetrievalDetail retrievalDetail in retrieval.RetrievalDetails)
{
Requisition requisition = new Requisition();
requisition.Id = retrievalDetail.Requisition.Id;
requisition = requisitionBroker.GetRequisition(requisition);
RequisitionCollectionDetail requisitionCollectionDetail = requisitionCollectionBroker.GetRequisitionCollectionDetail(requisition);
RequisitionCollection requisitionCollection = new RequisitionCollection();
requisitionCollection.Id = requisitionCollectionDetail.RequisitionCollection.Id;
requisitionCollection = requisitionCollectionBroker.GetRequisitionCollection(requisitionCollection);
requisitionCollection.DeliveryDate = DateTime.Now;
requisitionCollection.DeliveryBy = Util.GetEmployee(employeeBroker);
requisitionCollectionBroker.Update(requisitionCollection);
}
return(setStatus);
}
public Constants.ACTION_STATUS SelectLogin(string username, string password)
{
Constants.ACTION_STATUS isLogin = Constants.ACTION_STATUS.UNKNOWN;
User user = new User();
user.UserName = username;
user.Password = password;
user = employeeBroker.GetUser(user); // get user object
// if user is null means username and password is incorrect
if (user != null)
{
Employee employee = new Employee();
employee.User = user;
employee = employeeBroker.GetEmployee(employee);
Util.SetEmployee(employee); // put employee object to session for validating user later
Util.PutSession("Uname", employee.Name);
isLogin = Constants.ACTION_STATUS.SUCCESS;
}
else
{
isLogin = Constants.ACTION_STATUS.FAIL;
}
return(isLogin);
}
public Constants.ACTION_STATUS SelectRequest(Dictionary <string, int> quantity)
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
foreach (string itemId in quantity.Keys)
{
if (requisition.RequisitionDetails.Where(x => x.Item.Id == itemId).Count() > 0)
{
requisition.RequisitionDetails.Where(x => x.Item.Id == itemId).First().Qty = quantity[itemId];
}
}
//int index = 0;
//foreach (RequisitionDetail requisitionDetail in requisition.RequisitionDetails)
//{
// requisitionDetail.Qty = Converter.objToInt(requisitionDetailTable.Rows[index++][columnName[2]]);
//}
if (requisitionBroker.Insert(requisition) == Constants.DB_STATUS.SUCCESSFULL)
{
status = Constants.ACTION_STATUS.SUCCESS;
}
else
{
status = Constants.ACTION_STATUS.FAIL;
}
return(status);
}
public Constants.ACTION_STATUS SelectRejectRequisition(Requisition requisition)
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
requisition.Status = (int)Constants.REQUISITION_STATUS.REJECTED;
requisitionBroker.Update(requisition);
status = Constants.ACTION_STATUS.SUCCESS;
return(status);
}
public Constants.ACTION_STATUS CreateAdjustment()
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
Constants.DB_STATUS dbStatus = discrepancyBroker.Insert(stockAdjustment);
if (dbStatus == Constants.DB_STATUS.SUCCESSFULL)
{
status = Constants.ACTION_STATUS.SUCCESS;
}
else
{
status = Constants.ACTION_STATUS.FAIL;
}
// discrepancy.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.HIDDEN);
List <DiscrepancyDetail> dd = GetList(discrepancy.DiscrepancyDetails.ToList());
foreach (DiscrepancyDetail temp in dd)
{
StockCardDetail stockCardDetail = new StockCardDetail();
stockCardDetail.Id = itemBroker.GetStockCardDetailId();
stockCardDetail.Item = temp.Item;
stockCardDetail.Description = "Stock Adjsutment " + stockAdjustment.Id;
stockCardDetail.Qty = temp.Qty;
stockCardDetail.CreatedDate = DateTime.Now;
stockCardDetail.CreatedBy = Util.GetEmployee(employeeBroker);
stockCardDetail.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW);
stockCardDetail.Balance = itemBroker.GetCurrentBalance(temp.Item) + Converter.objToInt(temp.Qty);
itemBroker.Insert(stockCardDetail);
temp.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.HIDDEN);
//discrepancyBroker.Update(temp);
}
bool flag = false;
foreach (DiscrepancyDetail temp in discrepancy.DiscrepancyDetails)
{
if (temp.Status == Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW))
{
flag = true;
break;
}
}
if (!flag)
{
discrepancy.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.HIDDEN);
}
else
{
discrepancy.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW);
}
discrepancyBroker.Update(discrepancy);
return(status);
}
/// <summary>
/// Show all departments list except hidden departments
/// Created By:Zin Mar Thwin
/// Created Date:28-01-2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
/// <param name="itemDescription"></param>
/// <returns>The return value of this method is resultItem.</returns>
//private List<Department> GetDepaermentList()
//{
// List<Department> list = new List<Department>();
// List<Department> newList = new List<Department>();
// list = departmentBroker.GetAllDepartment();
// foreach (Department dep in list)
// {
// if (dep.Status != (int)Constants.DEPARTMENT_STATUS.HIDDEN)
// {
// newList.Add(dep);
// }
// }
// return newList;
//}
/// <summary>
/// Set blacklist/unblacklist according to the department list that user clicks
/// Created By:Zin Mar Thwin
/// Created Date:28-01-2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
/// <param name="itemDescription"></param>
/// <returns>The return value of this method is resultItem.</returns>
public Constants.ACTION_STATUS SelectLink(string departmentId)
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
Department department = new Department();
department.Id = departmentId;
department = departmentBroker.GetDepartment(department);
if (department != null)
{
switch (Converter.objToDepartmentStatus(department.Status))
{
case Constants.DEPARTMENT_STATUS.BLACKLIST:
department = blacklistDepartmentList.Find(delegate(Department dep) { return(dep.Id == departmentId); });
// if(department!=null)
department.Status = Converter.objToInt(Constants.DEPARTMENT_STATUS.UNBLACKLIST);
foreach (CollectionMissed cm in department.CollectionMisseds.ToList())
{
cm.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.HIDDEN);
collectionMissedBroker.Update(cm);
}
unblacklistDepartmentList.Add(department);
blacklistDepartmentList.Remove(department);
break;
case Constants.DEPARTMENT_STATUS.UNBLACKLIST:
department = unblacklistDepartmentList.Find(delegate(Department dep) { return(dep.Id == departmentId); });
department.Status = Converter.objToInt(Constants.DEPARTMENT_STATUS.BLACKLIST);
blacklistDepartmentList.Add(department);
unblacklistDepartmentList.Remove(department);
break;
case Constants.DEPARTMENT_STATUS.SHOW:
department = cleanDepartmentList.Find(delegate(Department dep) { return(dep.Id == departmentId); });
department.Status = Converter.objToInt(Constants.DEPARTMENT_STATUS.BLACKLIST);
blacklistDepartmentList.Add(department);
unblacklistDepartmentList.Remove(department);
break;
}
departmentBroker.Update(department);
status = Constants.ACTION_STATUS.SUCCESS;
}
else
{
status = Constants.ACTION_STATUS.FAIL;
}
return(status);
}
/// <summary>
/// Show requisition detail according to the selected requisition
/// Created By:JinChengCheng
/// Created Date:26-01-2012
/// Modified By:Thazin Win
/// Modified Date:02-02-2012
/// Modification Reason:To retrieve detail data
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
/// <param name="requisitionId"></param>
/// <returns>The return type of this method is datatable.</returns>
public Constants.ACTION_STATUS SelectRequisitionID(string requisitionId)
{
Constants.ACTION_STATUS selectStatus = Constants.ACTION_STATUS.UNKNOWN;
requisition = pendingRequisitionList.Find(delegate(Requisition req) { return(req.Id.Contains(requisitionId)); });
if (requisition != null)
{
selectStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
selectStatus = Constants.ACTION_STATUS.FAIL;
}
return(selectStatus);
// dt = new DataTable();
// dt.Columns.Add("itemNo");
// dt.Columns.Add("itemDescription");
// dt.Columns.Add("requiredQty");
// dt.Columns.Add("receivedQty");
// dt.Columns.Add("remainingQty");
// List<RequisitionDetail> requistionDetailList;
// requisition = new Requisition();
// itemBroker = new ItemBroker(inventory);
// requisition.Id = requisitionId;
// requisitionDetail=new RequisitionDetail();
// requisitionDetail.Requisition=requisition;
// requistionDetailList = requisitionBroker.GetAllRequisitionDetailByObj(requisitionDetail);
//foreach (RequisitionDetail temp in requistionDetailList)
// {
// dr = dt.NewRow();
// Item item = new Item();
// item =temp.Item ;
// item = itemBroker.GetItem(item);
// dr["itemNo"] = item.Id;
// dr["itemDescription"] = item.Description;
// dr["requiredQty"] = temp.Qty;
// dr["receivedQty"] = temp.DeliveredQty.HasValue ? temp.DeliveredQty.Value : 0;
// if (temp.DeliveredQty.Equals(null))
// dr["remainingQty"] = 0;
// else
// dr["remainingQty"] = temp.Qty - temp.DeliveredQty;
// dt.Rows.Add(dr);
// }
// return dt;
}
/// <summary>
/// Refresh requisition list after withdraw one requisition
/// Created By:JinChengCheng
/// Created Date:26-01-2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
/// <param name="requisitionId"></param>
/// <returns>The return type of this method is datatable.</returns>
public Constants.ACTION_STATUS Setstatus(string requisitionId, Constants.REQUISITION_STATUS Reqstatus, string remarks, DataTable dt)
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
requisition = RequisitionList.Find(delegate(Requisition req) { return(req.Id.Contains(requisitionId)); });
if (Reqstatus != Constants.REQUISITION_STATUS.REJECTED)
{
foreach (RequisitionDetail temp in requisition.RequisitionDetails)
{
DataRow[] dr = dt.Select(" ItemCode = '" + temp.Item.Id + "'");
if (dr != null && dr.Length > 0)
{
temp.Qty = Convert.ToInt16(dr[0][1].ToString());
temp.DeliveredQty = Convert.ToInt16(dr[0][2].ToString());
}
}
}
requisition.Remarks = remarks;
requisition.Status = (int)(Reqstatus);
requisitionBroker.Update(requisition);
if (Reqstatus == Constants.REQUISITION_STATUS.COMPLETE)
{
RequisitionCollection RC = null;
//Get all submitted requisitions
RequisitionCollectionDetail rcDetails = requisitionCollectionBroker.GetAllRequisitionCollectionDetail(requisitionId);
if (rcDetails != null)
{
RC = requisitionCollectionBroker.GetAllRequisitionCollectionByRequisitionCollectionID(rcDetails.RequisitionCollection.Id.ToString());
}
foreach (RequisitionCollectionDetail rcd in RC.RequisitionCollectionDetails)
{
if (rcd.Requisition.Status == (int)Constants.REQUISITION_STATUS.COMPLETE)
{
RC.Status = (int)Constants.COLLECTION_STATUS.COLLECTED;
}
else
{
RC.Status = (int)Constants.COLLECTION_STATUS.NEED_TO_COLLECT;
}
}
requisitionCollectionBroker.Update(RC);
}
return(status);
}
/// <summary>
/// Show requisition detail according to the selected requisition
/// Created By:JinChengCheng
/// Created Date:26-01-2012
/// Modified By:Thazin Win
/// Modified Date:02-02-2012
/// Modification Reason:To retrieve detail data
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
/// <param name="requisitionId"></param>
/// <returns>The return type of this method is datatable.</returns>
public Constants.ACTION_STATUS SelectRequisitionID(string requisitionId)
{
Constants.ACTION_STATUS selectStatus = Constants.ACTION_STATUS.UNKNOWN;
requisition = RequisitionList.Find(delegate(Requisition req) { return(req.Id.Contains(requisitionId)); });
if (requisition != null)
{
selectStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
selectStatus = Constants.ACTION_STATUS.FAIL;
}
return(selectStatus);
}
/// <summary>
/// The usage of this method is to assign the Department Representative from Search Result
/// Created By: SanLaPyaye
/// Created Date: 25/01/2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
/// <returns>Return the status of assign whether Successful or Fail. </returns>
public Constants.ACTION_STATUS SelectAssign(int employeeId)
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
if (Util.Assign(employeeBroker, employeeId, Constants.EMPLOYEE_ROLE.DEPARTMENT_REPRESENTATIVE) == Constants.DB_STATUS.SUCCESSFULL)
{
status = Constants.ACTION_STATUS.SUCCESS;
}
else
{
status = Constants.ACTION_STATUS.FAIL;
}
return(status);
}
//public Employee GetTemporaryDepartmentRepresentative()
//{
// List<Employee> employeeList = employeeBroker.GetAllEmployee();
// Employee e = null;
// foreach (Employee employee in employeeList)
// {
// if (employee.Role.Name.Equals("TemporaryDepartmentRepresentative"))
// {
// e = employee;
// break;
// }
// }
// return e;
//}
/// <summary>
/// The usage of this method is to remove the selected Employee
/// Created By: SanLaPyaye
/// Created Date: 25/01/2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
/// <param name="employeeId"> Employee Id which selected from UI.</param>
/// <returns>Return the Employee list to show</returns>
public Constants.ACTION_STATUS SelectRemove(int employeeId)
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
//temporaryDepartmentRepresentative.Id = employeeId;
//temporaryDepartmentRepresentative = employeeBroker.GetEmployee(temporaryDepartmentRepresentative);
if (Util.Assign(employeeBroker, employeeId, Constants.EMPLOYEE_ROLE.EMPLOYEE) == Constants.DB_STATUS.SUCCESSFULL)
{
status = Constants.ACTION_STATUS.SUCCESS;
}
else
{
status = Constants.ACTION_STATUS.FAIL;
}
return(status);
}
public Constants.ACTION_STATUS SelectSave(string supplierCode, string deliveryAddress, string attn, DateTime expectedDate)
{
Constants.ACTION_STATUS saveStatus = Constants.ACTION_STATUS.UNKNOWN;
Supplier supplier = new Supplier();
supplier.Id = supplierCode;
supplier = supplierBroker.GetSupplier(supplier);
purchaseOrder.Supplier = supplier;
purchaseOrder.DeliverAddress = deliveryAddress;
purchaseOrder.Attn = attn;
purchaseOrder.ExpectedDate = expectedDate;
PurchaseOrderDetail purchaseOrderDetail;
int addedDetail = 0;
// reorder item
foreach (Item temp in reorderList)
{
item = new Item();
item.Id = temp.Id;
item = itemBroker.GetItem(item);
purchaseOrderDetail = new PurchaseOrderDetail(purchaseOrderBroker.GetPurchaseOrderDetailId() + (addedDetail++), purchaseOrder, item, temp.Cost, temp.ReorderQty, 0);
purchaseOrder.PurchaseOrderDetails.Add(purchaseOrderDetail);
}
// manually added item
foreach (Item item in addedItemList.Keys)
{
purchaseOrderDetail = new PurchaseOrderDetail(purchaseOrderBroker.GetPurchaseOrderDetailId() + (addedDetail++), purchaseOrder, item, (decimal)Converter.objToDouble(addedItemList[item][1]), Converter.objToInt(addedItemList[item][0]), 0);
purchaseOrder.PurchaseOrderDetails.Add(purchaseOrderDetail);
}
if (purchaseOrderBroker.Insert(purchaseOrder) == Constants.DB_STATUS.SUCCESSFULL)
{
saveStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
saveStatus = Constants.ACTION_STATUS.FAIL;
}
return(saveStatus);
}
protected void btnCreate_Click(object sender, EventArgs e)
{
//DataTable dt = (DataTable)Session["DiscrepencyItems"];
//for (int i = 0; i < dt.Rows.Count; i++)
// lblItemNumber.Text += dt.Rows[i].ItemArray[0].ToString();
Constants.ACTION_STATUS status = createDiscrepancyReportControl.SelectCreate();
if (status == Constants.ACTION_STATUS.SUCCESS)
{
btnAdd.Visible = false;
btnApprove.Visible = false;
btnDelete.Visible = false;
btnGetItem.Visible = false;
// add success message
}
}
public Constants.ACTION_STATUS SelectRemove(List <int> index)
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
if (requisition.RequisitionDetails.Count > 0)
{
RequisitionDetail requisitionDetail;
List <RequisitionDetail> requisitionDetailToBeRemoved = new List <RequisitionDetail>();
int totalDeleted = 0;
foreach (int i in index)
{
requisitionDetail = requisition.RequisitionDetails.ElementAt(i - (totalDeleted++));
//requisitionDetail = requisition.RequisitionDetails.ElementAt(i);
requisition.RequisitionDetails.Remove(requisitionDetail);
//if (requisitionDetail != null)
//{
// requisitionDetailToBeRemoved.Add(requisitionDetail);
status = Constants.ACTION_STATUS.SUCCESS;
//}
//else
//{
// status = Constants.ACTION_STATUS.FAIL;
// break;
//}
}
//if (status == Constants.ACTION_STATUS.SUCCESS)
//{
// foreach (RequisitionDetail rd in requisitionDetailToBeRemoved)
// {
// requisition.RequisitionDetails.Remove(rd);
// }
// itemAdded -= totalDeleted;
// requisition.RequisitionDetails.OrderBy(x=> x.Id);
//}
}
else
{
status = Constants.ACTION_STATUS.FAIL;
}
return(status);
}
public Constants.ACTION_STATUS SelectStockAdjustmentVoucher(string stockAdjustmentId)
{
Constants.ACTION_STATUS selectStatus = Constants.ACTION_STATUS.UNKNOWN;
stockAdjustment = stockAdjustmentList.Find(delegate(StockAdjustment sAdjustment) { return(sAdjustment.Id.Equals(stockAdjustmentId)); });
if (stockAdjustment != null)
{
selectStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
selectStatus = Constants.ACTION_STATUS.FAIL;
}
return(selectStatus);
}
public Constants.ACTION_STATUS SelectAllPurchaseOrderDetails(int index)
{
Constants.ACTION_STATUS selectStatus = Constants.ACTION_STATUS.UNKNOWN;
if (purchaseOrderList.Count >= index)
{
purchaseOrder = purchaseOrderList.ElementAt(index - 1);
selectStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
selectStatus = Constants.ACTION_STATUS.FAIL;
}
return(selectStatus);
}
/// <summary>
/// Show the item according the item description entered
/// Created By:JinChengCheng
/// Created Date:26-01-2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
/// <param name="itemDescription"></param>
/// <returns>The return value of this method is resultItem.</returns>
public Constants.ACTION_STATUS SelectItemDescription(string itemDescription)
{
Constants.ACTION_STATUS selectStatus = Constants.ACTION_STATUS.UNKNOWN;
item = Util.GetItem(itemBroker, itemDescription);
if (item != null)
{
selectStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
selectStatus = Constants.ACTION_STATUS.FAIL;
}
return(selectStatus);
}
public Constants.ACTION_STATUS SelectSave(int collectionPointId)
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
try
{
Employee employee = new Employee();
employee.Id = currentEmployee.Id;
employee = employeeBroker.GetEmployee(employee);
CollectionPoint collectionPoint = new CollectionPoint();
collectionPoint.Id = collectionPointId;
collectionPoint = collectionPointBroker.GetCollectionPoint(collectionPoint);
if (collectionPoint != null)
{
employee.Department.CollectionPoint = collectionPoint;
if (employeeBroker.Update(employee) == SystemStoreInventorySystemUtil.Constants.DB_STATUS.SUCCESSFULL)
{
currentEmployee = employee;
Util.SetEmployee(currentEmployee);
status = SystemStoreInventorySystemUtil.Constants.ACTION_STATUS.SUCCESS;
}
else
{
status = SystemStoreInventorySystemUtil.Constants.ACTION_STATUS.FAIL;
}
}
else
{
status = Constants.ACTION_STATUS.FAIL;
}
if (status == Constants.ACTION_STATUS.SUCCESS)
{
inventory.SaveChanges();
}
}
catch (Exception e)
{
status = Constants.ACTION_STATUS.FAIL;
}
return(status);
}
private Constants.ACTION_STATUS SelectActionRequisition(Dictionary <string, string> remarks, Constants.REQUISITION_STATUS requisitionStatus)
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
if (remarks.Count > 0)
{
status = Constants.ACTION_STATUS.SUCCESS;
Requisition requisition;
Employee employee = new Employee();
employee.Id = currentEmployee.Id;
employee = employeeBroker.GetEmployee(employee);
int actionIndex = 0;
foreach (string key in remarks.Keys)
{
requisition = pendingRequisitionList.ElementAt(Converter.objToInt(key) - (actionIndex++));
requisition.Status = Converter.objToInt(requisitionStatus);
requisition.Remarks = remarks[key];
requisition.ApprovedBy = employee;
requisition.ApprovedDate = DateTime.Now;
pendingRequisitionList.Remove(requisition);
if (requisitionBroker.Update(requisition) == Constants.DB_STATUS.FAILED)
{
status = Constants.ACTION_STATUS.FAIL;
break;
}
}
}
else
{
status = Constants.ACTION_STATUS.FAIL;
}
return(status);
}
public Constants.ACTION_STATUS SelectItemDescription(string itemDescription, string supplierId)
{
Constants.ACTION_STATUS selectStatus = Constants.ACTION_STATUS.UNKNOWN;
item = Util.GetItem(itemBroker, itemDescription);
itemPrice = new ItemPrice();
itemPrice.SupplierId = supplierId;
itemPrice.ItemId = item.Id;
itemPrice = itemPriceBroker.GetItemPrice(itemPrice);
if (item != null && itemPrice != null)
{
selectStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
selectStatus = Constants.ACTION_STATUS.FAIL;
}
return(selectStatus);
}
public Constants.ACTION_STATUS UpdateRequisitionCollection(Dictionary <string, int> itemsCollected)
{
Constants.ACTION_STATUS updateStatus = Constants.ACTION_STATUS.UNKNOWN;
int addedItem = 0;
foreach (string key in itemsCollected.Keys)
{
if (requisitionCollection.RequisitionCollectionItems.Where(x => x.Item.Id == key).Count() > 0)
{
RequisitionCollectionItem requisitionCollectionItem = requisitionCollection.RequisitionCollectionItems.Where(x => x.Item.Id == key).First();
requisitionCollectionItem.Qty = itemsCollected[key];
}
else
{
Item item = new Item();
item.Id = key;
item = itemBroker.GetItem(item);
Employee employee = new Employee();
employee.Id = currentEmployee.Id;
employee = employeeBroker.GetEmployee(employee);
requisitionCollection.RequisitionCollectionItems.Add(new RequisitionCollectionItem(requisitionCollectionItemBroker.GetRequisitionCollectionItemId() + (addedItem++), requisitionCollection, item, itemsCollected[key], DateTime.Now, employee, Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW)));
}
}
if (requisitionCollectionBroker.Update(requisitionCollection) == Constants.DB_STATUS.SUCCESSFULL)
{
updateStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
updateStatus = Constants.ACTION_STATUS.FAIL;
}
return(updateStatus);
}
/// <summary>
/// Create discrepancy
/// Created By:JinChengCheng
/// Created Date:26-01-2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
/// <param name=""></param>
/// <returns>The return type of this method is status.</returns>
public Constants.ACTION_STATUS SelectCreate()
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
int totalAdded = 0;
foreach (DiscrepancyDetail discrepancyDetail in discrepancy.DiscrepancyDetails)
{
discrepancyDetail.Id = discrepancyBroker.GetDiscrepancyDetailId() + (totalAdded++);
}
if (discrepancyBroker.Insert(discrepancy) == Constants.DB_STATUS.SUCCESSFULL)
{
status = Constants.ACTION_STATUS.SUCCESS;
}
else
{
status = Constants.ACTION_STATUS.FAIL;
}
return(status);
}
public Constants.ACTION_STATUS SelectChange(string oldPassword, string newPassword)
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
if (currentEmployee.User.Password.CompareTo(oldPassword) == 0)
{
currentEmployee.User.Password = newPassword;
if (employeeBroker.Update(currentEmployee.User) == Constants.DB_STATUS.SUCCESSFULL)
{
Util.PutSession(Util.employeeSessionKey, currentEmployee);
status = Constants.ACTION_STATUS.SUCCESS;
}
else
{
status = Constants.ACTION_STATUS.FAIL;
}
}
else
{
status = Constants.ACTION_STATUS.FAIL;
}
return(status);
}
public Constants.ACTION_STATUS SelectSubmit()
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
try
{
foreach (Requisition requisition in approvedRequisitionList)
{
requisition.Status = Converter.objToInt(Constants.REQUISITION_STATUS.SUBMITTED);
requisitionCollection.RequisitionCollectionDetails.Add(new RequisitionCollectionDetail(requisitionCollectionBroker.GetRequisitionCollectionDetailId(), requisition, requisitionCollection));
if (requisitionBroker.Update(requisition) == Constants.DB_STATUS.SUCCESSFULL)
{
status = Constants.ACTION_STATUS.SUCCESS;
}
else
{
status = Constants.ACTION_STATUS.FAIL;
break;
}
}
if (status == Constants.ACTION_STATUS.SUCCESS)
{
approvedRequisitionList = new List <Requisition>();
requisitionCollectionBroker.Insert(requisitionCollection);
//inventory.SaveChanges();
}
}
catch (Exception e)
{
status = Constants.ACTION_STATUS.FAIL;
}
return(status);
}
public Constants.ACTION_STATUS AddToTable(string itemId)
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
RequisitionDetail requisitionDetail;
Item item = new Item();
item.Id = itemId;
item = itemBroker.GetItem(item);
if (item != null)
{
if (requisition.RequisitionDetails.Where(x => x.Item.Id == itemId).Count() == 0)
{
requisitionDetail = new RequisitionDetail();
requisitionDetail.Id = requisitionBroker.GetRequisitionDetailId() + (itemAdded++);
requisitionDetail.Requisition = requisition;
requisitionDetail.Item = item;
requisitionDetail.Qty = 1;
requisition.RequisitionDetails.Add(requisitionDetail);
status = Constants.ACTION_STATUS.SUCCESS;
}
else
{
status = Constants.ACTION_STATUS.FAIL;
}
}
else
{
status = Constants.ACTION_STATUS.FAIL;
}
return(status);
}
public Constants.ACTION_STATUS SelectCollection(int collectionId)
{
Constants.ACTION_STATUS selectStatus = Constants.ACTION_STATUS.UNKNOWN;
this.requisitionCollection = null;
setRequisitionCollection(collectionId, requisitionCollectionList);
if (this.requisitionCollection == null)
{
setRequisitionCollection(collectionId, collectedRequisitionCollectionList);
}
if (this.requisitionCollection != null)
{
selectStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
selectStatus = Constants.ACTION_STATUS.FAIL;
}
return(selectStatus);
}
