protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.User.IsInRole("Department Employee") != true)
{
Response.Redirect("/Presentation/Login.aspx");
}
if (!IsPostBack)
{
int id;
int.TryParse(Request.QueryString["requisitionId"].ToString(),out id);
req=se.ShowRequisitionDetail(id);
if (req != null)
{
lblReqStatus.Text = req.ReqStatus;
lblRDate.Text = req.ReqDate.ToShortDateString();
if (req.ReqApproveEmpID == null)
{
lblEName.Text = "Still Pending";
}
else
{
lblEName.Text = req.employee.EmployeeName;
}
if (req.ReqReason == null||req.ReqReason==" "||req.ReqReason==string.Empty)
{
lblReason.Text = "Still Pending";
}
else
{
lblReason.Text = req.ReqReason;
}
if (req.ReqApproveDate.ToString() == null||req.ReqApproveDate.ToString()==" "|| req.ReqApproveDate.ToString()==string.Empty)
{
lblADate.Text = "Still Pending";
}
else
{
lblADate.Text = req.ReqApproveDate.ToString();
}
}
if (req.ReqStatus == "pending")
{
btnDelete.Visible = true;
}
else
{
btnDelete.Visible = false;
}
Binding();
}
}
public requisition GetRequisitionDetailsByID(int searchReqID)
{
try
{
requisition currentreq=new requisition();
currentreq = (from r in entities.requisitions
where r.ReqID == searchReqID
select r).FirstOrDefault();
return currentreq;
}
catch (Exception ex)
{
throw ex;
}
}
public int createRequisition(requisition r)
{
try
{
requisition req = new requisition();
req.ReqEmpId = r.ReqEmpId;
req.ReqStatus = r.ReqStatus;
req.ReqDate = r.ReqDate;
req.ReqDepID = r.ReqDepID;
cntx.requisitions.Add(req);
cntx.SaveChanges();
int id = req.ReqID;
return id;
}
catch (Exception ex)
{
throw ex;
}
}
//method to manage outstanding requests
public void CheckForOutStanding(Disbursement_M disbl)
{
List<requisitiondetail> rdlist = new List<requisitiondetail>();
checkdate = DateTime.Today; //checking requestions brfore today
//checkdate = DateTime.Today.AddDays(2);
requisitiondetail rcheck = new requisitiondetail();
//checking
requisition rq = new requisition();
var m = from r in se.requisitiondetails
where
r.ReqItemID == disbl.ItemID &&
r.requisition.ReqDepID == disbl.DepID &&
r.ReqStatus=="approved" &&
r.requisition.ReqApproveDate < checkdate
select r;
rdlist = m.ToList();
rcheck = m.FirstOrDefault();
foreach (requisitiondetail rd in rdlist)
{
//if (rd.requisition.ReqReason == "outstanding")
//{
// //rd.ReqStatus = "confirmed";
// //se.SaveChanges();
// //totalcount = totalcount + rd.ReqQuantityReq;
// outstandingReqList.Add(rd);
//}
//else
//{
// normalReqList.Add(rd);
// //changing the status to confirmed
// //rd.ReqStatus = "confirmed";
// //se.SaveChanges();
// //totalcount = totalcount + rd.ReqQuantityReq; //getting the count of items ordered by the dep
//}
rd.ReqStatus = "confirmed";
try
{
se.SaveChanges();
}
catch (Exception ex)
{
string error;
if (ex.InnerException != null)
{
Exception ex1;
ex1 = ex.InnerException;
error = ex1.InnerException.StackTrace;
}
else
{
string error1;
error1 = ex.InnerException.Message;
}
}
}
if (disbl.QuantinHand < disbl.RequiredQuant)
{
int outstanding = disbl.RequiredQuant - disbl.QuantinHand;
requisition outreq = new requisition();
requisitiondetail outreqdet = new requisitiondetail();
//creating an oustanding request automatically
outreq.ReqApproveEmpID = rcheck.requisition.ReqApproveEmpID;
outreq.ReqApproveDate = rcheck.requisition.ReqApproveDate; // come back here to make sure your logic is right
outreq.ReqStatus = "outstanding";
outreq.ReqDate = rcheck.requisition.ReqDate;
outreq.ReqDepID = rcheck.requisition.ReqDepID;
outreq.ReqEmpId = rcheck.requisition.ReqEmpId;
outreq.ReqReason = "outstanding";
try
{
se.requisitions.Add(outreq);
se.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
//creating an autogenerated requestdetails for that particular item
outreqdet.ReqID = outreq.ReqID;
outreqdet.ReqItemID = disbl.ItemID;
outreqdet.ReqQuantityReq = outstanding;
outreqdet.ReqStatus = "approved";
try
{
se.requisitiondetails.Add(outreqdet);
se.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
}
}
public requisition ShowRequisitionDetail(int reqId)
{
requisition rr = new requisition();
try
{
var q = (from f in cntx.requisitions
where f.ReqID == reqId //&& f.ReqStatus!="pending"
select f).FirstOrDefault();
rr = q;
}
catch (Exception ex)
{
throw ex;
}
return rr;
}
