public void updateRequisitionStatus(Requisition re)
{
requisitiongf.updateRequisitionStatusGF(re);
}
//requsition--------------
public void insertRequisition(Requisition re)
{
requisitiongf.insertRequisitionGF(re);
}
public void updateRequisitionStatusGF(Requisition re)
{
requisition x = ctx.requisitions.FirstOrDefault(o => o.requisitionId == re.RequisitionId);
x.status = re.Status;
x.rejectreason = re.RejectReason;
ctx.SaveChanges();
// gaofan
}
public List<Requisition> getAllPendingRequisitionByDepartmentIdGF(string departmentId)
{
var item = from x in ctx.requisitions
where x.departmentId == departmentId && x.status == "Pending"
select new
{
a1 = x.requisitionId,
a2 = x.date,
a3 = x.userId,
a4 = x.status,
a5 = x.user.name,
a6 = x.departmentId,
a7 = x.rejectreason
};
List<Requisition> list = new List<Requisition>();
foreach (var a in item)
{
Requisition re = new Requisition();
re.RequisitionId = a.a1;
re.Date = Convert.ToDateTime(a.a2);
re.UserId = a.a3;
re.Status = a.a4;
re.UserName = a.a5;
re.DepartmentId = a.a6;
re.RejectReason = a.a7;
list.Add(re);
}
return list;
//gaofan
}
public void insertRequisitionGF(Requisition re)
{
requisition newre = new requisition();
newre.requisitionId = re.RequisitionId;
newre.date = re.Date;
newre.userId = re.UserId;
newre.departmentId = re.DepartmentId;
newre.rejectreason = re.RejectReason;
newre.status = re.Status;
ctx.requisitions.Add(newre);
ctx.SaveChanges();
//gaofan
UserFacade userFacade = new UserFacade();
List<User> userCollection = userFacade.getUsersWithRole("departmentDeputy", re.DepartmentId);
if(userCollection.Count==0)
{
userCollection = userFacade.getUsersWithRole("departmentHead", re.DepartmentId);
}
string subject = "New Requisition Submitted.";
string bodyStart = "<HTML>"
+ "<HEAD>"
+ "</HEAD>"
+ "<BODY>"
+ "<BR/>"
+ "<P>Dear ";
string body = ",</P><BR/><P>A requisition has been raised from your department.</P>";
body = body
+ "<BR/>"
+ "<a href=\"http://10.10.1.155/SSISWebApplication/WebPages/ApproveRejectRequisition\">Click this link to view the requisition</a>"//TODO LINK
+ "<BR/>"
+ "<P>From,</P>"
+ "<P>SSIS.</P>"
+ "</BODY>"
+ "</HTML>";
NotifyUserController notifyUserController = new NotifyUserController();
foreach (User user in userCollection)
{
notifyUserController.sendEmail(user.Email, subject, bodyStart + user.UserName + body);
}
}