public ActionResult MonthlyRequisition(FormCollection collection)
{
var filePath = Server.MapPath("~/Files/" + "Monthly_Requisition_Products.xml");
var xmlDocument = XDocument.Load(filePath);
var products = GetTempMonthlyRequsitionProductListFromXml(filePath);
var user = (ViewUser)Session["user"];
MonthlyRequisitionModel model = new MonthlyRequisitionModel
{
Products = products.ToList(),
Quantity = products.Sum(n => n.Quantity),
RequisitionByUserId = user.UserId
};
bool result = _iProductManager.SaveMonthlyRequisitionInfo(model);
if (result)
{
xmlDocument.Root?.Elements().Remove();
xmlDocument.Save(filePath);
TempData["message"] = "Requisition Create Successfully!";
}
else
{
TempData["message"] = "Failed to create Requisition!";
}
return(View());
}
public bool SaveMonthlyRequisitionInfo(MonthlyRequisitionModel model)
{
int maxTrNo = _iProductGateway.GetMaxMonnthlyRequisitionNoOfCurrentYear();
model.RequisitionRef = GenerateMonthlyRequisitionRef(maxTrNo);
int rowAffected = _iProductGateway.SaveMonthlyRequisitionInfo(model);
return(rowAffected > 0);
}
