public ActionResult addnew(RequisitionFormDetail form_detail_obj)
{
employee_utility eu = new employee_utility();
eu.add_new_form_detail_row(form_detail_obj);
return(RedirectToAction("addcart"));
}
public void GenerateRetrievalForm()
{
List <RequisitionForm> rf = db.RequisitionForms.ToList();
List <RequisitionFormDetail> rfd = db.RequisitionFormDetails.ToList();
List <Employee> emp = db.Employees.ToList();
StationeryRetrievalForm newStationeryRetrievalForm = new StationeryRetrievalForm
{
FormNumber = (db.StationeryRetrievalForms.Count() + 1).ToString(),
Date = DateTime.Today,
Status = "Pending"
};
var srfdList = (from requisitionForm in rf
join requisitionFormDetail in rfd on requisitionForm.FormNumber equals requisitionFormDetail.FormNumber into table1
from requisitionFormDetail in table1
join employees in emp on requisitionForm.EmployeeId equals employees.Id into table2
from employees in table2
where (requisitionForm.Status == "Read" && requisitionFormDetail.Status == "Pending") || (requisitionForm.Status == "Read" && requisitionFormDetail.Status == "Received")
group requisitionFormDetail by new { requisitionFormDetail.ItemNumber, employees.DepartmentCode } into group1
select new StationeryRetrievalFormDetail
{
FormNumber = newStationeryRetrievalForm.FormNumber,
ItemNumber = group1.Key.ItemNumber,
DepartmentCode = group1.Key.DepartmentCode,
Needed = group1.Sum(x => x.Quantity),
Actual = 0
}).ToList();
var requisitionFormDetailList = (from requisitionForm in rf
join requisitionFormDetail in rfd on requisitionForm.FormNumber equals requisitionFormDetail.FormNumber into table1
from requisitionFormDetail in table1
where (requisitionForm.Status == "Read" && requisitionFormDetail.Status == "Pending") || (requisitionForm.Status == "Read" && requisitionFormDetail.Status == "Received")
select requisitionFormDetail).ToList();
if (srfdList.Count > 0)
{
db.StationeryRetrievalForms.Add(newStationeryRetrievalForm);
db.SaveChanges();
int count = (db.StationeryRetrievalFormDetails.Count() + 1);
foreach (StationeryRetrievalFormDetail srfd in srfdList)
{
srfd.FormDetailsNumber = count.ToString();
db.StationeryRetrievalFormDetails.Add(srfd);
count++;
}
foreach (RequisitionFormDetail requisition in requisitionFormDetailList)
{
RequisitionFormDetail existingRequisitionFormDetail = db.RequisitionFormDetails.Find(requisition.FormDetailsNumber);
existingRequisitionFormDetail.Status = "Awaiting Retrieval";
}
db.SaveChanges();
}
}
public ActionResult removerequestitem(string form_no, string form_detail_no, string sid)
{
using (ModelDBContext db = new ModelDBContext())
{
RequisitionFormDetail old_rec_to_update = (from f in db.RequisitionFormDetails
where f.FormDetailsNumber == form_detail_no && f.FormNumber == form_no
select f).FirstOrDefault();
Debug.WriteLine(old_rec_to_update.ToString());
if (old_rec_to_update != null)
{
db.RequisitionFormDetails.Remove(old_rec_to_update);
}
db.SaveChanges();
}
return(RedirectToAction("addcart", new { sid = sid }));
}
