public WCFDisbursementDetail[] GetDisbursementDetailsOf(int sessionID, int DisbursementNo)
{
List <WCFDisbursementDetail> result = new List <WCFDisbursementDetail>();
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
List <DisbursementDetail> items = AndroidController.GetDisbursementDetailsOf(DisbursementNo);
if (items != null)
{
foreach (var item in items)
{
result.Add(new WCFDisbursementDetail()
{
DisbursementNo = item.DisbursementNo.ToString(),
ItemNo = item.ItemNo.ToString(),
Description = item.StationeryCatalogue.Description,
Needed = item.Needed.ToString(),
Promised = item.Promised.ToString(),
Received = item.Received.ToString()
});
}
}
}
return(result.ToArray());
}
public WCFStationeryCatalogue[] CatalogueSearch(int sessionID, string ItemNo, string Category, string Description, string Bin)
{
List <WCFStationeryCatalogue> result = new List <WCFStationeryCatalogue>();
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
List <StationeryCatalogue> items = AndroidController.SearchCatalogue(ItemNo, Category, Description, Bin);
if (items != null)
{
foreach (var item in items)
{
result.Add(new WCFStationeryCatalogue()
{
Bin = item.Bin,
Category = item.Category,
CurrentQty = item.CurrentQty.ToString(),
Description = item.Description.ToString(),
ItemNo = item.ItemNo.ToString(),
ReorderLevel = item.ReorderLevel.ToString(),
ReorderQty = item.ReorderQty.ToString(),
Supplier1 = item.Supplier1,
Supplier2 = item.Supplier2,
Supplier3 = item.Supplier3,
Uom = item.Uom
});
}
}
}
return(result.ToArray());
}
public WCFDepartment GetDepartment(int sessionID, String deptCode)
{
Department department = null;
WCFDepartment result = null;
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
department = AndroidController.GetDepartment(deptCode);
if (department != null)
{
result = new WCFDepartment()
{
CollectionPointNo = department.CollectionPointNo ?? -1,
ContactName = department.ContactName,
DeptCode = department.DeptCode,
DeptName = department.DeptName,
DeputyEmpNo = department.DeputyEmpNo ?? -1,
FaxNo = department.FaxNo.ToString(),
HeadEmpNo = department.HeadEmpNo ?? -1,
PhoneNo = department.PhoneNo.ToString(),
RepEmpNo = department.RepEmpNo ?? -1
};
}
}
return(result);
}
public WCFDisbursement GetCurrentDisbursementForDepartment(int sessionID, string deptCode)
{
WCFDisbursement result = null;
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
Disbursement disbursement = AndroidController.GetCurrentDisbursementForDepartment(deptCode);
if (disbursement != null)
{
result = new WCFDisbursement()
{
CollectionPointNo = disbursement.CollectionPointNo.ToString(),
DeptCode = disbursement.DeptCode,
DisbursementDate = String.Format("{0:dd/MMM/yyyy}", disbursement.DisbursementDate),
DisbursementNo = disbursement.DisbursementNo.ToString(),
Pin = disbursement.Pin.ToString(),
RepEmpNo = disbursement.RepEmpNo.ToString(),
Status = disbursement.Status
};
}
}
return(result);
}
public WCFRequisition GetRequisitionById(int sessionID, int reqNo)
{
WCFRequisition result = null;
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
Requisition item = AndroidController.GetRequisitionById(reqNo);
if (item != null)
{
result = new WCFRequisition
{
ReqNo = item.ReqNo.ToString(),
DateIssued = item.DateIssued.ToString(),
IssuedBy = item.IssuedBy.ToString(),
ApprovedBy = item.ApprovedBy != null?item.ApprovedBy.ToString() : "",
DateReviewed = item.DateReviewed != null?item.DateReviewed.ToString() : "",
Status = item.Status != null ? item.Status : "",
Remarks = item.Remarks != null ? item.Remarks : ""
};
}
}
return(result);
}
public WCFRequisition[] GetPendingRequisitions(int sessionID, int sessionEmpNo)
{
List <WCFRequisition> result = new List <WCFRequisition>();
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
List <Requisition> items = AndroidController.GetPendingRequisitions(sessionEmpNo);
if (items != null)
{
foreach (var item in items)
{
result.Add(new WCFRequisition
{
ReqNo = item.ReqNo.ToString(),
DateIssued = item.DateIssued.ToString(),
ApprovedBy = item.ApprovedBy.ToString(),
DateReviewed = item.DateReviewed.ToString(),
Status = item.Status,
Remarks = item.Remarks,
IssuedBy = item.IssuedBy.ToString()
});
}
}
}
return(result.ToArray());
}
public WCFDepartment[] GetAllDepartments(int sessionID)
{
List <WCFDepartment> result = new List <WCFDepartment>();
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
List <Department> items = AndroidController.GetAllDepartments();
if (items != null)
{
foreach (var item in items)
{
result.Add(new WCFDepartment()
{
CollectionPointNo = item.CollectionPointNo ?? -1,
ContactName = item.ContactName,
DeptCode = item.DeptCode,
DeptName = item.DeptName,
DeputyEmpNo = item.DeputyEmpNo ?? -1,
FaxNo = item.FaxNo.ToString(),
HeadEmpNo = item.HeadEmpNo ?? -1,
PhoneNo = item.PhoneNo.ToString(),
RepEmpNo = item.RepEmpNo ?? -1
});
}
}
}
return(result.ToArray());
}
public string GetCollectionPoint(int sessionID, int collectionPointNo)
{
String result = "";
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
result = AndroidController.GetCollectionPointOf(collectionPointNo);
}
return(result);
}
public String GetLoggedInEmployeeNumber(int sessionID)
{
String result = "";
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
result = AndroidAuthenticationController.GetEmployeeIdFromSessionId(sessionID).ToString();
}
return(result);
}
public bool SendEmail(int sessionID, String email, String subject, String message)
{
bool result = false;
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
result = EmailBackend.sendEmailStep(email, subject, message);
}
return(result);
}
public String[] GetCatalogueBinList(int sessionID)
{
List <String> result = new List <string>();
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
result = AndroidController.GetBinList();
}
return(result.ToArray());
}
public bool CreateAdjustmentVoucher(int sessionID, string ItemNo, int Qty, string Reason)
{
bool result = false;
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
result = AndroidController.CreateAdjustmentVoucher(sessionID, ItemNo, Qty, Reason);
}
return(result);
}
public string[] GetRolesFromSession(int sessionID)
{
string[] result = null;
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
result = AndroidAuthenticationController.GetRolesOf(sessionID);
}
return(result);
}
public string GetCurrentDisbursementNoForDepartment(int sessionID)
{
String result = "";
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
result = AndroidController.GetDisbursementNoForCurrentDepartmentOf(sessionID);
}
return(result);
}
public bool MarkDisbursementAsCollected(int sessionID, int DisbursementNo, string Pin)
{
bool result = false;
Decimal pin;
if (AndroidAuthenticationController.IsValidSessionId(sessionID) && Decimal.TryParse(Pin, out pin))
{
result = AndroidController.MarkDisbursementAsCollected(DisbursementNo, pin);
}
return(result);
}
public bool UpdateRequisitionDetail(int sessionID, WCFRequisitionDetail removeRequisitionDetail)
{
bool result = false;
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
RequisitionDetail requisition = new RequisitionDetail()
{
ReqNo = removeRequisitionDetail.ReqNo,
ItemNo = removeRequisitionDetail.ItemNo,
Qty = removeRequisitionDetail.Qty
};
result = AndroidController.UpdateRequisitionDetail(requisition);
}
return(result);
}
public WCFRetrieval GetLatestRetrieval(int sessionID)
{
WCFRetrieval result = null;
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
Retrieval latestRetrieval = AndroidController.GetLatestRetrieval();
if (latestRetrieval != null)
{
result = new WCFRetrieval()
{
RetrievalNo = latestRetrieval.RetrievalNo.ToString(),
Date = String.Format("{0:dd/MM/yyyy}", latestRetrieval.Date)
};
}
}
return(result);
}
public int AddRequisitionAndGetReqNo(int sessionID)
{
int result = -1;
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
Requisition requisition = new Requisition();
int issuingEmpNo = AndroidAuthenticationController.GetEmployeeIdFromSessionId(sessionID);
requisition.ReqNo = 0;
requisition.IssuedBy = issuingEmpNo;
requisition.DateIssued = DateTime.Today;
requisition.Status = "Pending";
result = AndroidController.AddRequisition(requisition);
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
ProfileCommon loginProfile;
String result = "0"; // Return 0 if authentication failure
// Arguments can be passed either by get or by post
String username = Request["user"];
String password = Request["pass"];
// If valid, get the employee number and generate the random number
if (Membership.ValidateUser(username, password))
{
// Get the Profile of the User
loginProfile = (ProfileCommon)ProfileCommon.Create(username, true);
result = AndroidAuthenticationController.GenerateAndroidSessionNumber(loginProfile.EmpNo).ToString();
}
Response.Write(result);
}
public bool UpdateDisbursementDetail(int sessionID, WCFDisbursementDetail updatedDisbursementDetail)
{
bool result = false;
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
DisbursementDetail disbursement = new DisbursementDetail()
{
DisbursementNo = int.Parse(updatedDisbursementDetail.DisbursementNo),
ItemNo = updatedDisbursementDetail.ItemNo,
Needed = int.Parse(updatedDisbursementDetail.Needed),
Promised = int.Parse(updatedDisbursementDetail.Promised),
Received = int.Parse(updatedDisbursementDetail.Received)
};
result = AndroidController.UpdateDisbursement(disbursement);
}
return(result);
}
public WCFSessionID AuthenticateUser(String username, String password)
{
ProfileCommon loginProfile;
WCFSessionID result = new WCFSessionID()
{
SessionID = "0"
};
if (Membership.ValidateUser(username, password))
{
// Update the roles of the logged in user
LoginController.setupRolesAfterAuthentication(username);
// Get the Profile of the User
loginProfile = (ProfileCommon)ProfileCommon.Create(username, true);
result.SessionID = AndroidAuthenticationController.GenerateAndroidSessionNumber(loginProfile.EmpNo).ToString();
}
return(result);
}
public bool RemoveRequisition(int sessionID, WCFRequisition removedRequisition)
{
bool result = false;
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
Requisition requisition = new Requisition()
{
ReqNo = Convert.ToInt32(removedRequisition.ReqNo),
DateIssued = Convert.ToDateTime(removedRequisition.DateIssued),
ApprovedBy = Convert.ToInt32(removedRequisition.ApprovedBy),
DateReviewed = Convert.ToDateTime(removedRequisition.DateReviewed),
Status = removedRequisition.Status,
Remarks = removedRequisition.Remarks
};
result = AndroidController.RemoveRequisition(requisition);
}
return(result);
}
public WCFRequisitionDetail[] GetRequisitionDetails(int sessionID, int ReqNo)
{
List <WCFRequisitionDetail> result = new List <WCFRequisitionDetail>();
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
var requisitionDetails = AndroidController.GetRequisitionDetailsOf(ReqNo);
foreach (var item in requisitionDetails)
{
result.Add(new WCFRequisitionDetail()
{
ItemNo = item.ItemNo,
Description = item.StationeryItem.Description,
Qty = item.Qty.HasValue ? item.Qty.Value : 0,
ReqNo = item.ReqNo
});
}
}
return(result.ToArray());
}
public WCFRetrievalDetail[] GetRetrievalDetails(int sessionID, int retrievalNo)
{
List <WCFRetrievalDetail> result = new List <WCFRetrievalDetail>();
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
var retrievalDetails = AndroidController.GetRetrievalDetails(retrievalNo);
// No need for breakup by department for android
foreach (var item in retrievalDetails)
{
WCFRetrievalDetail temp = result.Where(detail => detail.ItemNo.Equals(item.ItemNo)).FirstOrDefault();
if (temp == null)
{
result.Add(new WCFRetrievalDetail()
{
RetrievalNo = item.RetrievalNo,
ItemNo = item.ItemNo,
Description = item.StationeryCatalogue.Description,
Bin = item.StationeryCatalogue.Bin.ToString(),
Needed = item.Needed.HasValue ? item.Needed.Value : 0,
BacklogQty = item.BackLogQty.HasValue ? item.BackLogQty.Value : 0,
// Actual = item.Actual.HasValue ? item.Actual.Value : 0
Actual = (int)item.Needed + (int)item.BackLogQty
});
}
else
{
temp.Needed += item.Needed.HasValue ? item.Needed.Value : 0;
temp.BacklogQty += item.BackLogQty.HasValue ? item.BackLogQty.Value : 0;
//temp.Actual += item.Actual.HasValue ? item.Actual.Value : 0;
temp.Actual += (int)item.Needed + (int)item.BackLogQty;
}
}
}
return(result.ToArray());
}
public WCFEmployee GetEmployeeById(int sessionID, int empNo)
{
WCFEmployee result = null;
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
Employee employee = AndroidController.GetEmployee(empNo);
if (employee != null)
{
result = new WCFEmployee()
{
DeptCode = employee.DeptCode,
Email = employee.Email,
EmpName = employee.EmpName,
EmpNo = employee.EmpNo.ToString(),
SessionExpiry = String.Format("{0:dd/MMM/yyyy}", employee.SessionExpiry),
SessionNo = employee.SessionNo.ToString()
};
}
}
return(result);
}
public WCFTransactionDetail[] GetStockTxnDetails(int sessionID, String itemNo)
{
List <WCFTransactionDetail> result = new List <WCFTransactionDetail>();
if (AndroidAuthenticationController.IsValidSessionId(sessionID))
{
var stockTxnDetails = AndroidController.GetStockTxnDetails(itemNo);
foreach (var item in stockTxnDetails)
{
result.Add(new WCFTransactionDetail()
{
StockTxnNo = item.StockTxnNo,
ItemNo = item.ItemNo,
Date = String.Format("{0:dd/MMM/yyyy}", item.Date),
AdjustQty = item.AdjustQty.HasValue ? item.AdjustQty.Value : 0,
RecordedQty = item.RecordedQty.HasValue ? item.RecordedQty.Value : 0,
Remarks = item.Remarks
});
}
}
return(result.ToArray());
}
public bool TestSessionId(int sessionID)
{
return(AndroidAuthenticationController.IsValidSessionId(sessionID));
}
