public static void getAllDepts()
{
List <Object> olist2 = RequisitionDAO.getAllDepInvolved();
foreach (Object o in olist2)
{
Console.WriteLine(o.ToString().Substring(12, 4));
depList.Add(o.ToString().Substring(12, 4));
}
}
public static void submitRejected(string reqListNumber, string comment)
{
RequisitionDAO.changeReqListStatusRejected(reqListNumber, comment);
Employee e = RequisitionDAO.getEmp(reqListNumber);
string receiverEmail = e.Email;
string depCode = e.DepartmentCode;
Employee head = EmployeeDAO.getDepHeadEmployee(depCode);
string senderEmail = head.Email;
MailMessage m = new MailMessage(senderEmail, receiverEmail);
m.Subject = "";
m.Body = "Your request has been rejected";
SmtpClient c = new SmtpClient("lynx.iss.nus.edu.sg");
c.Send(m);
RequisitionDAO.changeReqListStatusApproved(reqListNumber);
}
public static void submitApproval(string reqListNumber, string mobileORweb)
{
if (mobileORweb == "web")
{
RequisitionDAO.changeReqListStatusApproved(reqListNumber);
}
else if (mobileORweb == "mobile")
{
Employee e = RequisitionDAO.getEmp(reqListNumber);
string receiverEmail = e.Email;
string depCode = e.DepartmentCode;
Employee head = EmployeeDAO.getDepHeadEmployee(depCode);
string senderEmail = head.Email;
MailMessage m = new MailMessage(senderEmail, receiverEmail);
m.Subject = "";
m.Body = "Your request has been approved";
SmtpClient c = new SmtpClient("lynx.iss.nus.edu.sg");
c.Send(m);
RequisitionDAO.changeReqListStatusApproved(reqListNumber);
}
//RequisitionDAO.changeReqListStatusApproved(reqListNumber);
}
public static string getApprovedByWho(string depName)
{
return(RequisitionDAO.getApprovedBy(depName));
}
public static void submitCart(string empNum)
{
RequisitionDAO.createRequisitionDetails(empNum);
CartDAO.deleteEmployeeCart(empNum);
}
public static void submitRejected(string reqListNumber)
{
RequisitionDAO.changeReqListStatusRejected(reqListNumber, "rejected from mobile");
}
public static List <RequisitionDetail> reqDetailsW(string reqListNumber) //for WCF
{
return(RequisitionDAO.getDetialsOfListW(reqListNumber));
}
/** added by nitin for wcf
* */
public static List <RequisitionList> getAllPendingReq(string empNum) /// for WCF
{
string s = EmployeeDAO.getDepCodetOfEmp(empNum);
return(RequisitionDAO.getAllPendingReqDataW(s));
}
public static List <Object> pupulateDetails(string reqListNumber)
{
return(RequisitionDAO.getDetialsOfList(reqListNumber));
}
public static List <Object> populateAllPendingReq(string empNum)
{
string s = EmployeeDAO.getDepCodetOfEmp(empNum);
return(RequisitionDAO.getAllPendingReqData(s));
}
public static void generateDisbursementList()
{
Dictionary <string, List <ConsolidatedRequisitionListDetail> > consolidatedDictionary = new Dictionary <string, List <ConsolidatedRequisitionListDetail> >();
List <string> dlist = new List <string>();
List <ConsolidatedRequisitionList> el;
el = ConsolidatedRequisitionListEFFacade.getAllDepInvolved();
foreach (ConsolidatedRequisitionList e in el)
{
dlist.Add(e.DepartmentCode);
}
List <string> deplist = RequisitionDAO.getAllReqDepartments();
if (deplist.Count() != 0)
{
for (int p = 0; p < deplist.Count(); p++)
{
if (dlist.Contains(deplist[p]))
{
ConsolidatedRequisitionList cl = ConsolidatedRequisitionListEFFacade.getOpenListForDept(deplist[p]);
int listid = cl.ConsolidatedListID;
List <string> itemlist = ConsolidatedRequisitionListEFFacade.getAllItemsOfList(listid);
List <Object> olist1 = RequisitionDAO.getAllApprovedOfDep(deplist[p]);
for (int i = 0; i < olist1.Count(); i++)
{
string itmeNum;
itmeNum = olist1[i].ToString().Substring(15, 4);
if (itemlist.Contains(itmeNum))
{
ConsolidatedRequisitionListEFFacade.addRequestedQtyForItem(listid, itmeNum, Convert.ToInt32(olist1[i].ToString().Substring(32, ((olist1[i].ToString().Length) - 34))));
}
else
{
ConsolidatedRequisitionListEFFacade.addDetailToList(listid, itmeNum, Convert.ToInt32(olist1[i].ToString().Substring(32, ((olist1[i].ToString().Length) - 34))), (RequisitionDAO.getTheFirstDatetDate(deplist[p])), 0);
}
}
}
if (dlist.Contains(deplist[p]) == false)
{
List <Object> olist = RequisitionDAO.getAllApprovedDetails(deplist[p]);
List <ConsolidatedRequisitionListDetail> crl = new List <ConsolidatedRequisitionListDetail>();
for (int i = 0; i < olist.Count(); i++)
{
ConsolidatedRequisitionListDetail c = new ConsolidatedRequisitionListDetail();
c.ItemNumber = olist[i].ToString().Substring(15, 4);
c.QuantityRequested = Convert.ToInt32(olist[i].ToString().Substring(32, ((olist[i].ToString().Length) - 34)));
c.DateRequest = RequisitionDAO.getTheFirstDatetDate(deplist[p]);
c.ActualQuantity = 0;
crl.Add(c);
}
consolidatedDictionary.Add(deplist[p], crl);
}
}
ConsolidatedRequisitionListEFFacade.createNewConsolidatedRequisitionList(consolidatedDictionary);
RequisitionDAO.changeApprovedToClosed();
}
}