void Work()
{
MR_DL objMRDL = new MR_DL(ConnectionStringClass.GetConnection());
Stock_DL objStockDL = new Stock_DL(ConnectionStringClass.GetConnection());
try
{
int count = objMRDL.GET_Approval_Count(CurrentUser.EmployeeID, MR.Status.Initial);
if (count > 0)
{
TipType = 1;
TipText = TipText + "-- " + count + " Material Requisition(s) for approval.\n";
}
int count1 = objMRDL.GET_Issue_Count(CurrentUser.EmployeeID, MR.Status.Approved);
if (count1 > 0)
{
TipType = 2;
TipText = TipText + "-- " + count1 + " Material Requisition(s) for Item Issue.\n";
}
int count2 = objStockDL.Get_ReorderLevel_Below_Count(CurrentUser.EmployeeID);
if (count2 > 0)
{
TipType = 3;
TipText = TipText + "-- Quantity of " + count2 + " item(s) in the store low than reorder level.\n";
}
}
catch (Exception ex)
{
}
finally
{
objMRDL = null;
}
}