//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 static string GetRequisitionStatusText(Constants.REQUISITION_STATUS requisitionStatus)
{
string status = null;
switch (requisitionStatus)
{
case Constants.REQUISITION_STATUS.PENDING:
status = "Pending";
break;
case Constants.REQUISITION_STATUS.APPROVED:
status = "Approved";
break;
case Constants.REQUISITION_STATUS.REJECTED:
status = "Rejected";
break;
case Constants.REQUISITION_STATUS.SUBMITTED:
status = "Submitted";
break;
case Constants.REQUISITION_STATUS.WITHDRAW:
status = "Withdraw";
break;
case Constants.REQUISITION_STATUS.COMPLETE:
status = "Complete";
break;
}
return(status);
}
/// <summary>
/// Converts object to Requisition Status
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static Constants.REQUISITION_STATUS objToRequisitionStatus(object obj)
{
Constants.REQUISITION_STATUS status = Constants.REQUISITION_STATUS.UNKNOWN;
switch (objToShort(obj))
{
case 1:
status = Constants.REQUISITION_STATUS.PENDING;
break;
case 2:
status = Constants.REQUISITION_STATUS.APPROVED;
break;
case 3:
status = Constants.REQUISITION_STATUS.REJECTED;
break;
case 4:
status = Constants.REQUISITION_STATUS.SUBMITTED;
break;
case 5:
status = Constants.REQUISITION_STATUS.WITHDRAW;
break;
case 7:
status = Constants.REQUISITION_STATUS.COMPLETE;
break;
}
return(status);
}
/// <summary>
/// Retreive All of the requisition information according to status
/// </summary>
/// <param name="requisitionStatus"></param>
/// <returns></returns>
public List <Requisition> GetAllRequisition(Constants.REQUISITION_STATUS requisitionStatus)
{
try
{
int status = Converter.objToInt(requisitionStatus);
requisitionList = inventory.Requisitions.Where(reqObj => reqObj.Status == status).ToList <Requisition>();
}
catch (Exception e)
{
requisitionList = null;
}
return(requisitionList);
}
/// <summary>
/// Retreive All of the requisition information according to status
/// </summary>
/// <param name="requisitionStatus"></param>
/// <returns></returns>
public List <Requisition> GetAllRequisition(Constants.REQUISITION_STATUS requisitionStatus, Department department)
{
try
{
int status = Converter.objToInt(requisitionStatus);
requisitionList = inventory.Requisitions.Where(reqObj => reqObj.Status == status && reqObj.Department.Id.Contains(department.Id)).OrderByDescending(reqObj => reqObj.CreatedDate).ToList <Requisition>();
}
catch (Exception e)
{
requisitionList = null;
}
return(requisitionList);
}
/// <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>
/// Retrieve All of the Requisition information according to the status
/// </summary>
/// <returns>
/// List of Requisition
/// </returns>
public List <Requisition> GetAllRequisitionByEmployee(int employeeID)
{
Constants.REQUISITION_STATUS requisitionStatus = Constants.REQUISITION_STATUS.HIDDEN;
try
{
int status = Converter.objToInt(requisitionStatus);
requisitionList = inventory.Requisitions.Where(reqObj => reqObj.CreatedBy.Id == employeeID && reqObj.Status != status).OrderByDescending(reqObj => reqObj.CreatedDate).ToList <Requisition>();
}
catch (Exception e)
{
requisitionList = null;
}
return(requisitionList);
}
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);
}
