public PurchaseOrderControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK);
InventoryEntities inventory = new InventoryEntities();
supplierBroker = new SupplierBroker(inventory);
itemBroker = new ItemBroker(inventory);
purchaseOrderBroker = new PurchaseOrderBroker(inventory);
itemPriceBroker = new ItemPriceBroker(inventory);
employeeBroker = new EmployeeBroker(inventory);
//reorderList = GetReorderItemList();
purchaseOrder = new PurchaseOrder();
purchaseOrder.Id = purchaseOrderBroker.GetPurchaseOrderId();
purchaseOrder.CreatedBy = Util.GetEmployee(employeeBroker);
purchaseOrder.CreatedDate = DateTime.Now;
purchaseOrder.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW);
poDetailList = new List<PurchaseOrderDetail>();
addedItemList = new Dictionary<Item, List<double>>();
//purchaseOrderDetailList = new System.Data.Objects.DataClasses.EntityCollection<PurchaseOrderDetail>();
// need to load reorder quantity
// need to load unfulfilled quantity
supplierColumn = new DataColumn[] { new DataColumn(supplierColumnName[0]), new DataColumn(supplierColumnName[1])};
dataColumn = new DataColumn[] { new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]),
new DataColumn(columnName[3]),
new DataColumn(columnName[4])};
}
public CreateDiscrepencyReportControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK);
inventory = new InventoryEntities();
discrepancyBroker = new DiscrepancyBroker(inventory);
itemBroker = new ItemBroker(inventory);
item = new Item();
itemPriceBroker = new ItemPriceBroker(inventory);
itemprice = new ItemPrice();
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);
// discrepancyDetailList = new System.Data.Objects.DataClasses.EntityCollection<DiscrepancyDetail>();
dataColumn = new DataColumn[] { new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]),
new DataColumn(columnName[3]),
new DataColumn(columnName[4]),
new DataColumn(columnName[5]) };
}
public ChangePasswordControl()
{
currentEmployee = Util.ValidateUser();
InventoryEntities inventory = new InventoryEntities();
employeeBroker = new EmployeeBroker(inventory);
}
public RequisitionDetailsControl()
{
currentEmployee = Util.ValidateUser();
InventoryEntities inventory = new InventoryEntities();
requisitionBroker = new RequisitionBroker(inventory);
requisitionCollectionBroker = new RequisitionCollectionBroker(inventory);
RequisitionList = requisitionBroker.GetAllRequisition(currentEmployee.Department);
}
public List<CollectionMissed> GetCollectionMissed()
{
InventoryEntities inventory = new InventoryEntities();
//List<CollectionMissed> collectionMissedList =
return null;
}
public NotificationControl()
{
currentEmployee = Util.ValidateUser();
inventory = new InventoryEntities();
notificationBroker = new NotificationBroker(inventory);
notificationList = notificationBroker.GetAllNotification(currentEmployee);
dataColumn = new DataColumn[] { new DataColumn(columnName[0]), new DataColumn(columnName[1]) };
}
// private DataColumn[] discrepancyItemListColumn;
public IssueAdjustmentVoucherControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_SUPERVISOR);
InventoryEntities inventoryEntities = new InventoryEntities();
employeeBroker = new EmployeeBroker(inventoryEntities);
discrepancyBroker = new DiscrepancyBroker(inventoryEntities);
itemBroker = new ItemBroker(inventoryEntities);
// discrepancyList = new System.Data.Objects.DataClasses.EntityCollection<Discrepancy>();
listColumn = new DataColumn[]{new DataColumn(listColumnName[0]),new DataColumn(listColumnName[1]),new DataColumn(listColumnName[2]),new DataColumn(listColumnName[3])
};
detailColumn = new DataColumn[] { new DataColumn(detailColumnName[0]), new DataColumn(detailColumnName[1]), new DataColumn(detailColumnName[2]), new DataColumn(detailColumnName[3]), new DataColumn(detailColumnName[4]) };
}
public ViewStockCardControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK);
InventoryEntities inventory = new InventoryEntities();
itemBroker = new ItemBroker(inventory);
itemPriceBroker = new ItemPriceBroker(inventory);
dataColumn = new DataColumn[] { new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]),
new DataColumn(columnName[3])};
}
/// <summary>
/// To show the Current Temporary Department Head
/// Created By: SanLaPyaye
/// Created Date: 25/01/2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
public AssignTemporaryDepartmentHeadControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.DEPARTMENT_HEAD);
InventoryEntities inventory = new InventoryEntities();
employeeBroker = new EmployeeBroker(inventory);
temporaryDepartmentHead = new Employee();
temporaryDepartmentHead.Role = new Role();
temporaryDepartmentHead.Role.Id = Converter.objToInt(Constants.EMPLOYEE_ROLE.TEMPORARY_DEPARTMENT_HEAD);
temporaryDepartmentHead.Department = currentEmployee.Department;
temporaryDepartmentHead = employeeBroker.GetEmployee(temporaryDepartmentHead);
}
/// <summary>
/// To get all the Employee with role name as "Temporary Department Representative"
/// Created By: SanLaPyaye
/// Created Date: 25/01/2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
public AssignTemporaryDepartmentRepresentativeControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.DEPARTMENT_REPRESENTATIVE);
InventoryEntities inventory = new InventoryEntities();
employeeBroker = new EmployeeBroker(inventory);
temporaryDepartmentRepresentative = new Employee();
temporaryDepartmentRepresentative.Role = new Role();
// temporaryDepartmentRepresentative.Role.Id = Converter.objToInt(Constants.EMPLOYEE_ROLE.TEMPORARY_DEPARTMENT_REPRESENTATIVE);
// temporaryDepartmentRepresentative.Department = currentEmployee.Department;
// temporaryDepartmentRepresentative = employeeBroker.GetEmployee(temporaryDepartmentRepresentative);
}
public ViewStationeryRetrievalListControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK);
InventoryEntities inventory=new InventoryEntities();
retrievalBroker=new RetrievalBroker(inventory);
retrievalList = retrievalBroker.GetAllRetrieval();
dataColumn = new DataColumn[]{ new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]),
new DataColumn(columnName[3]),
new DataColumn(columnName[4]) };
}
/// <summary>
/// The usage of this method is to show the Requisitions List.
/// Created By: SanLaPyaye
/// Created Date: 25/01/2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
public ApproveRejectRequisitionControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.DEPARTMENT_HEAD);
requisitionDetailsControl = new commonController.RequisitionDetailsControl();
InventoryEntities inventory = new InventoryEntities();
requisitionBroker = new RequisitionBroker(inventory);
employeeBroker = new EmployeeBroker(inventory);
pendingRequisitionList = requisitionBroker.GetAllRequisition(Constants.REQUISITION_STATUS.PENDING, currentEmployee.Department);
dataColumn = new DataColumn[] { new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]),
new DataColumn(columnName[3]),
new DataColumn(columnName[4]) };
}
public ManageCollectionPointControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.DEPARTMENT_REPRESENTATIVE);
inventory = new InventoryEntities();
collectionPointBroker = new CollectionPointBroker(inventory);
employeeBroker = new EmployeeBroker(inventory);
allCollectionPoint = collectionPointBroker.GetAllCollectionPoint();
dataColumn = new DataColumn[] { new DataColumn(columnName[2]),
new DataColumn(columnName[0]) };
dataColumnList = new DataColumn[] { new DataColumn(columnName[2]),
new DataColumn(columnName[0]),
new DataColumn(columnName[1]) };
}
public ViewSupplierListControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK);
InventoryEntities inventory = new InventoryEntities();
supplierBroker = new SupplierBroker(inventory);
supplierList = supplierBroker.GetAllSupplier();
dataColumn = new DataColumn[] { new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]),
new DataColumn(columnName[3]),
new DataColumn(columnName[4]),
new DataColumn(columnName[5]),
new DataColumn(columnName[6])};
}
public CreateStationeryRetrievalListControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK);
inventory = new InventoryEntities();
retrievalBroker = new RetrievalBroker(inventory);
requisitionCollectionBroker = new RequisitionCollectionBroker(inventory);
itemBroker = new ItemBroker(inventory);
employeeBroker = new EmployeeBroker(inventory);
//retrievalList = retrievalBroker.GetAllRetrieval();
requisitionCollectionList = requisitionCollectionBroker.GetAllRequisitionCollection(Constants.COLLECTION_STATUS.NEED_TO_RETRIEVE);
collectionDataColumn = new DataColumn[] { new DataColumn(collectionColumnName[0]),
new DataColumn(collectionColumnName[1]),
new DataColumn(collectionColumnName[2]),
new DataColumn(collectionColumnName[3]) };
}
public UpdateStationeryRetrievalControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK);
inventory = new InventoryEntities();
collectionMissedBroker = new CollectionMissedBroker(inventory);
employeeBroker = new EmployeeBroker(inventory);
retrievalBroker = new RetrievalBroker(inventory);
requisitionCollectionBroker = new RequisitionCollectionBroker(inventory);
//collectionList = requisitionCollectionBroker.GetAllRequisitionCollection();
dataColumn = new DataColumn[] { new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]),
new DataColumn(columnName[3]),
new DataColumn(columnName[4]),
new DataColumn(columnName[5]) };
}
public BlacklistDepartmentControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_MANAGER);
InventoryEntities inventory = new InventoryEntities();
departmentBroker = new DepartmentBroker(inventory);
collectionMissedBroker = new CollectionMissedBroker(inventory);
cleanDepartmentList = departmentBroker.GetAllDepartment(Constants.DEPARTMENT_STATUS.SHOW);
unblacklistDepartmentList = departmentBroker.GetAllDepartment(Constants.DEPARTMENT_STATUS.UNBLACKLIST);
blacklistDepartmentList = departmentBroker.GetAllDepartment(Constants.DEPARTMENT_STATUS.BLACKLIST);
dataColumn = new DataColumn[]{ new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]),
new DataColumn(columnName[3]),
new DataColumn(columnName[4]),
};
}
public ViewAdjustmentVoucherListControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_SUPERVISOR);
InventoryEntities inventory = new InventoryEntities();
discrepancyBroker = new DiscrepancyBroker(inventory);
stockAdjustmentList = discrepancyBroker.GetAllStockAdjustment();
dataColumn = new DataColumn[] { new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]),
new DataColumn(columnName[3]) };
detailDataColumn = new DataColumn[] { new DataColumn(detailColumnName[0]),
new DataColumn(detailColumnName[1]),
new DataColumn(detailColumnName[2]) };
}
// return true if default page for supervisor is IssueAdjustmentVoucher
public static bool CheckAdjustment()
{
InventoryEntities inventory = new InventoryEntities();
IDiscrepancyBroker discrepancyBroker = new DiscrepancyBroker(inventory);
foreach (Discrepancy discrepancy in discrepancyBroker.GetAllDiscrepancy().ToList())
{
if (discrepancy.Status == Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW))
{
foreach (DiscrepancyDetail dd in discrepancy.DiscrepancyDetails.ToList())
{
//if(dd.Status == Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW) && dd.DiscrepancyType == Converter.objToInt(Constants.DISCREPANCY_TYPE.SUPERVISOR)){
// return true;
//}
}
}
}
return false;
}
public ReceiveOrderControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK);
InventoryEntities inventory = new InventoryEntities();
purchaseOrderBroker = new PurchaseOrderBroker(inventory);
itemBroker = new ItemBroker(inventory);
employeeBroker = new EmployeeBroker(inventory);
purchaseOrderList = purchaseOrderBroker.GetAllPurchaseOrder();
dataColumn = new DataColumn[]{ new DataColumn(columnName[0]),
new DataColumn(columnName[1])
};
detailColumn = new DataColumn[]{new DataColumn(detail[0]),
new DataColumn(detail[1]),new DataColumn(detail[2]),new DataColumn(detail[3])};
}
public RequestStationeryControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.EMPLOYEE);
InventoryEntities inventory = new InventoryEntities();
requisitionBroker = new RequisitionBroker(inventory);
itemBroker = new ItemBroker(inventory);
employeeBroker = new EmployeeBroker(inventory);
requisition = new Requisition();
requisition.CreatedBy = Util.GetEmployee(employeeBroker);
requisition.Department = requisition.CreatedBy.Department;
requisition.Status = Converter.objToInt(Constants.REQUISITION_STATUS.PENDING);
requisition.Id = requisitionBroker.GetRequisitionId(requisition);
itemAdded = 0;
dataColumn = new DataColumn[] { new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]) };
}
//private DataColumn[] collectionDataColumn; // for drop down list
public GenerateDisbursementControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK);
inventory = new InventoryEntities();
retrievalBroker = new RetrievalBroker(inventory);
requisitionCollectionBroker = new RequisitionCollectionBroker(inventory);
requisitionBroker = new RequisitionBroker(inventory);
employeeBroker = new EmployeeBroker(inventory);
retrievalList = retrievalBroker.GetAllRetrieval();
requisitionCollectionList = new Dictionary<RequisitionCollection, DateTime>();
dataColumn = new DataColumn[]{ new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]),
new DataColumn(columnName[3]) };
//collectionDataColumn = new DataColumn[] { new DataColumn(collectionColumnName[0]),
// new DataColumn(collectionColumnName[1]) };
}
public SubmitRequestToStoreControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.DEPARTMENT_REPRESENTATIVE);
inventory = new InventoryEntities();
requisitionBroker = new RequisitionBroker(inventory);
requisitionCollectionBroker = new RequisitionCollectionBroker(inventory);
employeeBroker = new EmployeeBroker(inventory);
Employee employee = new Employee();
employee.Id = currentEmployee.Id;
employee = employeeBroker.GetEmployee(employee);
requisitionCollection = new RequisitionCollection(requisitionCollectionBroker.GetRequisitionCollectionId(), employee.Department, employee.Department.CollectionPoint, DateTime.Now, employee, Converter.objToInt(Constants.COLLECTION_STATUS.NEED_TO_COLLECT));
approvedRequisitionList = requisitionBroker.GetAllRequisition(Constants.REQUISITION_STATUS.APPROVED, currentEmployee.Department);
dataColumn = new DataColumn[] { new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]),
new DataColumn(columnName[3]) };
}
/// <summary>
/// The usage of this method to call GetEmployee() for show the Current Department Representative
/// Created By: SanLaPyaye
/// Created Date: 25/01/2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
public AssignDepartmentRepresentativeControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.DEPARTMENT_HEAD);
InventoryEntities inventory = new InventoryEntities();
employeeBroker = new EmployeeBroker(inventory);
departmentRepresentative = currentEmployee.Department.Representative;
temporaryDepartmentRepresentative = new Employee();
temporaryDepartmentRepresentative.Role = new Role();
temporaryDepartmentRepresentative.Role.Id = Converter.objToInt(Constants.EMPLOYEE_ROLE.TEMPORARY_DEPARTMENT_REPRESENTATIVE);
temporaryDepartmentRepresentative.Department = currentEmployee.Department;
temporaryDepartmentRepresentative = employeeBroker.GetEmployee(temporaryDepartmentRepresentative);
dataColumn = new DataColumn[] { new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]) };
employeeDataColumn = new DataColumn[] { new DataColumn(employeeColumnName[0]),
new DataColumn(employeeColumnName[1]) };
}
//private string[] columnName = new string[] { "RequisitionID", "requisitionDate", "RequisitionBy", "remarks" };
public CheckRequisitionControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.EMPLOYEE);
inventory = new InventoryEntities();
requisitionBroker = new RequisitionBroker(inventory);
employeeBroker = new EmployeeBroker(inventory);
// itemBroker = new ItemBroker(inventory);
//pendingRequisitionList = requisitionBroker.GetAllRequisition(Constants.REQUISITION_STATUS.PENDING);
// pendingRequisitionList = requisitionBroker.GetAllRequisitionByStatus(Util.GetEmployee().Id);
pendingRequisitionList = requisitionBroker.GetAllRequisitionByEmployee(Util.GetEmployee().Id);
dataColumn = new DataColumn[] { new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]),
new DataColumn(columnName[3]),
new DataColumn(columnName[4]) };
//requisitionList = new System.Data.Objects.DataClasses.EntityCollection<Requisition>();
//requisitionList = requisitionBroker.GetAllRequisition();
}
public UpdateCollectionDetailsByRequisitionItemControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.DEPARTMENT_REPRESENTATIVE);
inventory = new InventoryEntities();
requisitionCollectionBroker = new RequisitionCollectionBroker(inventory);
requisitionCollectionItemBroker = new RequisitionCollectionItemBroker(inventory);
itemBroker = new ItemBroker(inventory);
employeeBroker = new EmployeeBroker(inventory);
requisitionCollectionList = requisitionCollectionBroker.GetAllRequisitionCollection(currentEmployee.Department, Constants.COLLECTION_STATUS.NEED_TO_COLLECT);
//collectedRequisitionCollectionList = requisitionCollectionBroker.GetAllRequisitionCollection(currentEmployee.Department, Constants.COLLECTION_STATUS.COLLECTED);
collectionListDataColumn = new DataColumn[] { new DataColumn(collectionListColumnName[0]),
new DataColumn(collectionListColumnName[1]),
new DataColumn(collectionListColumnName[2]),
new DataColumn(collectionListColumnName[3]),
new DataColumn(collectionListColumnName[4]) };
itemDetailDataColumn = new DataColumn[] { new DataColumn(itemDetailColumnName[0]),
new DataColumn(itemDetailColumnName[1]),
new DataColumn(itemDetailColumnName[2]),
new DataColumn(itemDetailColumnName[3]) };
}
public RetrievalBroker(InventoryEntities inventory)
{
this.inventory = inventory;
}
public static DataTable GetEmployeesByDepartments()
{
InventoryEntities inventory = new InventoryEntities();
IEmployeeBroker employeeBroker = new EmployeeBroker(inventory);
List<Employee> lEmployee = employeeBroker.GetEmployeeByDepartments(Util.GetEmployee());
DataTable dtEmployee = new DataTable();
dtEmployee.Columns.Add("employeeID");
dtEmployee.Columns.Add("employeeName");
foreach (Employee emp in lEmployee)
{
DataRow dr = dtEmployee.NewRow();
dr[0] = emp.Id;
dr[1] = emp.Name;
dtEmployee.Rows.Add(dr);
}
return dtEmployee;
}
public static DataTable GetCurrentTemporaryRepresentative()
{
InventoryEntities inventory = new InventoryEntities();
IEmployeeBroker employeeBroker = new EmployeeBroker(inventory);
Employee lEmployee = employeeBroker.GetCurrentTempRep(Util.GetEmployee());
if (lEmployee != null)
{
DataTable dtEmployee = new DataTable();
dtEmployee.Columns.Add("EmployeeID");
dtEmployee.Columns.Add("EmployeeName");
dtEmployee.Columns.Add("Designation");
dtEmployee.Columns.Add("JoiningDate");
//foreach (Employee emp in lEmployee)
//{
DataRow dr = dtEmployee.NewRow();
dr["EmployeeID"] = lEmployee.Id;
dr["EmployeeName"] = lEmployee.Name;
dr["Designation"] = SystemStoreInventorySystemUtil.Converter.GetDesignationText(SystemStoreInventorySystemUtil.Converter.objToDesignation(lEmployee.Designation));
dr["JoiningDate"] = SystemStoreInventorySystemUtil.Converter.dateTimeToString(Converter.DATE_CONVERTER.DATE, lEmployee.CreatedDate);
dtEmployee.Rows.Add(dr);
//}
return dtEmployee;
}
return null;
}
public static DataTable GetCurrentTemporaryHead()
{
InventoryEntities inventory = new InventoryEntities();
IEmployeeBroker employeeBroker = new EmployeeBroker(inventory);
Employee lEmployee = employeeBroker.GetCurrentTemporaryDeptHead(Util.GetEmployee());
if (lEmployee != null)
{
DataTable dtEmployee = new DataTable();
dtEmployee.Columns.Add("EmployeeID");
dtEmployee.Columns.Add("EmployeeName");
dtEmployee.Columns.Add("Designation");
dtEmployee.Columns.Add("JoiningDate");
//foreach (Employee emp in lEmployee)
//{
DataRow dr = dtEmployee.NewRow();
dr[0] = lEmployee.Id;
dr[1] = lEmployee.Name;
dr[2] = SystemStoreInventorySystemUtil.Converter.GetDesignationText(SystemStoreInventorySystemUtil.Converter.objToDesignation(lEmployee.Designation));
dr[3] = lEmployee.CreatedDate;
dtEmployee.Rows.Add(dr);
//}
return dtEmployee;
}
return null;
}
