public List<Discrepancy> GetAllDiscrepancy(Constants.VISIBILITY_STATUS visibilityStatus)
{
try
{
int status = Converter.objToInt(visibilityStatus);
discrepancyListObj = inventory.Discrepancies.Where(x=> x.Status == status).ToList<Discrepancy>();
}
catch (Exception e)
{
discrepancyListObj = null;
}
return discrepancyListObj;
}
public static Constants.DB_STATUS Assign(IEmployeeBroker employeeBroker, int employeeId, Constants.EMPLOYEE_ROLE role)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
Employee employee = new Employee();
employee.Id = employeeId;
employee = employeeBroker.GetEmployee(employee);
Role assignRole = new Role();
assignRole.Id = Converter.objToInt(role);
assignRole = employeeBroker.GetRole(assignRole);
employee.Role = assignRole;
status = employeeBroker.Update(employee);
return status;
}
public static string GetDepartmentStatusText(Constants.DEPARTMENT_STATUS departmentStatus)
{
string departmentStatusText = null;
switch (departmentStatus)
{
case Constants.DEPARTMENT_STATUS.BLACKLIST:
departmentStatusText = "Blacklist";
break;
case Constants.DEPARTMENT_STATUS.HIDDEN:
departmentStatusText = "Hidden";
break;
case Constants.DEPARTMENT_STATUS.SHOW:
departmentStatusText = "Show";
break;
case Constants.DEPARTMENT_STATUS.UNBLACKLIST:
departmentStatusText = "Unblacklist";
break;
}
return departmentStatusText;
}
public static string GetCollectionStatusText(Constants.COLLECTION_STATUS collectionStatus)
{
string status = null;
switch (collectionStatus)
{
case Constants.COLLECTION_STATUS.NEED_TO_RETRIEVE:
status = "Need to Retrieve";
break;
case Constants.COLLECTION_STATUS.NEED_TO_COLLECT:
status = "Need to Collect";
break;
case Constants.COLLECTION_STATUS.COLLECTED:
status = "Collected";
break;
case Constants.COLLECTION_STATUS.UNCOLLECTED:
status = "Uncollected";
break;
case Constants.COLLECTION_STATUS.INCOMPLETE:
status = "Incomplete";
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>
/// Get the list of CollectionMissed by department Id and status
/// </summary>
/// <param name="department"></param>
/// <param name="status"></param>
/// <returns>
/// List of CollectionMissed
/// </returns>
public List<CollectionMissed> GetAllCollectionMissed(Department department, Constants.VISIBILITY_STATUS status)
{
try
{
//get the collectionMissed List by checking department Id of collecion Missed Table and check the Visibility Status
collectionMissedList = inventory.CollectionMisseds.Where(c => c.Department.Id == department.Id || status.Equals("SHOW")).ToList();
}
catch (Exception e)
{
collectionMissedList = null;
}
return collectionMissedList;
}
/// <summary>
/// Get all of the Notification data by employeeId and NOTIFICATION_STATUS
/// </summary>
/// <param name="employee"></param>
/// <param name="notificationStatus"></param>
/// <returns>
/// Return lists of Notifications
/// </returns>
public List<Notification> GetAllNotification(Employee employee, Constants.NOTIFICATION_STATUS notificationStatus)
{
try
{
//get the collectionMissed List by checking department Id of collecion Missed Table and check the Visibility Status
notificationList = inventory.Notifications.Where(n => n.Employee.Id == employee.Id || notificationStatus.Equals("SHOW")).ToList();
}
catch (Exception e)
{
notificationList = null;
}
return notificationList;
}
/// <summary>
/// Change List to DataTable
/// 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 void ListToDataTable(List<Department> deptList, Constants.VISIBILITY_STATUS collectionMissedStatus)
{
foreach (Department dep in deptList)
{
dr = dt.NewRow();
dr[columnName[0]] = dep.Name;
List<CollectionMissed> missedTime = collectionMissedBroker.GetAllCollectionMissed(dep);
List<CollectionMissed> newList = new List<CollectionMissed>();
foreach (CollectionMissed temp in missedTime)
{
if (temp.Status != Converter.objToInt(Constants.VISIBILITY_STATUS.HIDDEN))
{
newList.Add(temp);
}
}
int count = newList.Count;
//if (missedTime != null)
//{
// foreach (CollectionMissed times in missedTime)
// {
// count++;
// }
//}
string black = null;
Constants.DEPARTMENT_STATUS departmentStatus = Converter.objToDepartmentStatus(dep.Status);
if (departmentStatus == Constants.DEPARTMENT_STATUS.SHOW || departmentStatus == Constants.DEPARTMENT_STATUS.UNBLACKLIST)
{
black = Converter.GetDepartmentStatusText(Constants.DEPARTMENT_STATUS.BLACKLIST);
}
else if (Converter.objToDepartmentStatus(dep.Status) == Constants.DEPARTMENT_STATUS.BLACKLIST)
{
black = Converter.GetDepartmentStatusText(Constants.DEPARTMENT_STATUS.UNBLACKLIST);
}
dr[columnName[1]] = count;
dr[columnName[2]] = Converter.GetDepartmentStatusText(Converter.objToDepartmentStatus(dep.Status));
dr[columnName[3]] = black;
dr[columnName[4]] = dep.Id;
dt.Rows.Add(dr);
}
// return dt;
}
public static Employee ValidateUser(Constants.EMPLOYEE_ROLE allowedRole)
{
Employee employee = ValidateUser();
//if (!CheckPermission(allowedRole, GetRolePermission(Converter.objToEmployeeRole(employee.Role.Id))))
if (!CheckPermission(Converter.objToEmployeeRole(employee.Role.Id), GetRolePermission(allowedRole)) && !(Converter.objToEmployeeRole(employee.Role.Id) == Constants.EMPLOYEE_ROLE.ADMIN))
{
commonController.LogOutControl logOutControl = new commonController.LogOutControl();
}
return employee;
}
/// <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;
}
public static string GetUnitOfMeasureText(Constants.UNIT_OF_MEASURE unitOfMeasure)
{
string unit = null;
switch (unitOfMeasure)
{
case Constants.UNIT_OF_MEASURE.BOX:
unit = "Box";
break;
case Constants.UNIT_OF_MEASURE.DOZEN:
unit = "Dozen";
break;
case Constants.UNIT_OF_MEASURE.EACH:
unit = "Each";
break;
case Constants.UNIT_OF_MEASURE.SET:
unit = "Set";
break;
case Constants.UNIT_OF_MEASURE.PACKET:
unit = "Packet";
break;
}
return unit;
}
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;
}
public static string GetItemCategoryText(Constants.ITEM_CATEGORY itemCategory)
{
string category = null;
switch (itemCategory)
{
case Constants.ITEM_CATEGORY.CLIP:
category = "Clip";
break;
case Constants.ITEM_CATEGORY.DISK:
category = "Disk";
break;
case Constants.ITEM_CATEGORY.ENVELOPE:
category = "Envelope";
break;
case Constants.ITEM_CATEGORY.ERASER:
category = "Eraser";
break;
case Constants.ITEM_CATEGORY.EXERCISE:
category = "Exercise";
break;
case Constants.ITEM_CATEGORY.FILE:
category = "File";
break;
case Constants.ITEM_CATEGORY.PAD:
category = "Pad";
break;
case Constants.ITEM_CATEGORY.PAPER:
category = "Paper";
break;
case Constants.ITEM_CATEGORY.PEN:
category = "Pen";
break;
case Constants.ITEM_CATEGORY.PUNCHER:
category = "Puncher";
break;
case Constants.ITEM_CATEGORY.RULER:
category = "Ruler";
break;
case Constants.ITEM_CATEGORY.SCISSORS:
category = "Scissors";
break;
case Constants.ITEM_CATEGORY.SHARPENER:
category = "Sharpener";
break;
case Constants.ITEM_CATEGORY.SHORTHAND:
category = "Shorthand";
break;
case Constants.ITEM_CATEGORY.STAPLER:
category = "Stapler";
break;
case Constants.ITEM_CATEGORY.TACKS:
category = "Tacks";
break;
case Constants.ITEM_CATEGORY.TAPE:
category = "Tape";
break;
case Constants.ITEM_CATEGORY.TPARENCY:
category = "Trapency";
break;
case Constants.ITEM_CATEGORY.TRAY:
category = "Tray";
break;
}
return category;
}
public static string GetDesignationText(Constants.DESIGNATION designation)
{
string designationText = null;
switch (designation)
{
case Constants.DESIGNATION.PROFESSOR:
designationText = "Professor";
break;
case Constants.DESIGNATION.SENIOR_PROFESSOR:
designationText = "Senior Professor";
break;
case Constants.DESIGNATION.ACCOUNTANT:
designationText = "Accountant";
break;
case Constants.DESIGNATION.SENIOR_ACCOUNTANT:
designationText = "Senior Accountant";
break;
}
return designationText;
}
public List<Department> GetAllDepartment(Constants.DEPARTMENT_STATUS departmentStatus)
{
int status = Converter.objToInt(departmentStatus);
return inventory.Departments.Where(iObj => iObj.Status == status).ToList<Department>();
}
public static List<Constants.EMPLOYEE_ROLE> GetRolePermission(Constants.EMPLOYEE_ROLE employeeType)
{
List<Constants.EMPLOYEE_ROLE> permission = new List<Constants.EMPLOYEE_ROLE>();
// Department
if (employeeType == SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.EMPLOYEE)
{
permission.Add(SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.EMPLOYEE);
employeeType = Constants.EMPLOYEE_ROLE.DEPARTMENT_REPRESENTATIVE;
}
if (employeeType == SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.DEPARTMENT_REPRESENTATIVE || employeeType == SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.TEMPORARY_DEPARTMENT_REPRESENTATIVE)
{
permission.Add(SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.DEPARTMENT_REPRESENTATIVE);
permission.Add(SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.TEMPORARY_DEPARTMENT_REPRESENTATIVE);
employeeType = SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.DEPARTMENT_HEAD;
}
if (employeeType == SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.DEPARTMENT_HEAD || employeeType == SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.TEMPORARY_DEPARTMENT_HEAD)
{
permission.Add(SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.DEPARTMENT_HEAD);
permission.Add(SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.TEMPORARY_DEPARTMENT_HEAD);
}
// end of Department
// Store
if (employeeType == SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.STORE_CLERK)
{
permission.Add(SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.STORE_CLERK);
employeeType = Constants.EMPLOYEE_ROLE.STORE_SUPERVISOR;
}
if (employeeType == SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.STORE_SUPERVISOR)
{
permission.Add(SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.STORE_SUPERVISOR);
employeeType = SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.STORE_MANAGER;
}
if (employeeType == SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.STORE_MANAGER || employeeType == Constants.EMPLOYEE_ROLE.ADMIN)
{
permission.Add(SystemStoreInventorySystemUtil.Constants.EMPLOYEE_ROLE.STORE_MANAGER);
}
// end of Store
return permission;
}
public Constants.ACTION_STATUS SetCollectionStatus(Constants.COLLECTION_STATUS collectionStatus, List<string> collectionIdList)
{
foreach (string collectionId in collectionIdList)
{
RequisitionCollection requisitionCollection = new RequisitionCollection();
requisitionCollection.Id = Converter.objToInt(collectionId);
requisitionCollection = requisitionCollectionBroker.GetRequisitionCollection(requisitionCollection);
requisitionCollection.Status = Converter.objToInt(collectionStatus);
requisitionCollectionBroker.Update(requisitionCollection);
if (collectionStatus == Constants.COLLECTION_STATUS.UNCOLLECTED)
{
CollectionMissed collectionMissed = new CollectionMissed();
collectionMissed.Id = collectionMissedBroker.GetCollectionMissedId();
collectionMissed.Department = requisitionCollection.Department;
collectionMissed.CreatedBy = Util.GetEmployee(employeeBroker);
collectionMissed.CreatedDate = DateTime.Now;
collectionMissed.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW);
collectionMissedBroker.Insert(collectionMissed);
}
}
return SystemStoreInventorySystemUtil.Constants.ACTION_STATUS.UNKNOWN;
}
public static bool CheckPermission(Constants.EMPLOYEE_ROLE employeeType, List<Constants.EMPLOYEE_ROLE> permission)
{
return permission.Contains(employeeType);
}
private Constants.ACTION_STATUS SelectActionRequisition(Dictionary<string, string> remarks, Constants.REQUISITION_STATUS requisitionStatus)
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
// employeeBroker = new EmployeeBroker(inventory);
if (remarks.Count > 0)
{
status = Constants.ACTION_STATUS.SUCCESS;
Requisition requisition;
Employee employee = new Employee();
employee.Id = currentEmployee.Id;
employee = employeeBroker.GetEmployee(employee);
foreach (string key in remarks.Keys)
{
requisition = pendingRequisitionList.ElementAt(Converter.objToInt(key));
requisition.Status = Converter.objToInt(requisitionStatus);
requisition.Remarks = remarks[key];
requisition.ApprovedBy = employee;
requisition.ApprovedDate = DateTime.Now;
pendingRequisitionList[Converter.objToInt(key)] = requisition;
//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;
}