private List <ViewRequisitionModel> ViewPendingRequisitionList()
{
var list = new List <ViewRequisitionModel>();
var filePath = Server.MapPath("~/Files/" + "Create_Trip_File.xml");
var requisitionRefs = GetProductFromXmalFile(filePath).ToList().Select(n => n.RequisitionRef).Distinct().ToList();
List <ViewRequisitionModel> requsitionList = new List <ViewRequisitionModel>();
foreach (string requisitionRef in requisitionRefs)
{
requsitionList.Add(_iProductManager.GetRequsitionsByStatus(0).ToList()
.Find(n => n.RequisitionRef.Equals(requisitionRef)));
}
List <ViewRequisitionModel> viewRequisitionModels = _iProductManager.GetPendingRequsitions().ToList();
foreach (ViewRequisitionModel model in viewRequisitionModels)
{
ViewRequisitionModel viewRequisitionModel =
requsitionList.ToList().Find(m => m.RequisitionRef.Equals(model.RequisitionRef));
if (viewRequisitionModel == null)
{
list.Add(model);
}
}
return(list);
}
public ActionResult Create(FormCollection collection)
{
ViewUser user = (ViewUser)Session["user"];
var filePath = GetBranchWishRequisitionXmlFilePath();
List <RequisitionModel> productList = GetProductFromXmalFile(filePath).ToList();
if (productList.Count != 0)
{
var xmlData = XDocument.Load(filePath);
int toBranchId = Convert.ToInt32(collection["ToBranchId"]);
ViewRequisitionModel aRequisitionModel = new ViewRequisitionModel
{
Products = productList,
ToBranchId = toBranchId,
RequisitionByUserId = user.UserId,
RequisitionDate = Convert.ToDateTime(collection["RequisitionDate"])
};
int rowAffected = _iProductManager.SaveRequisitionInfo(aRequisitionModel);
if (rowAffected > 0)
{
xmlData.Root?.Elements().Remove();
xmlData.Save(filePath);
TempData["message"] = "Requisition Create Successfully!";
}
else
{
TempData["message"] = "Failed to create Requisition!";
}
}
return(View());
}
public int SaveRequisitionInfo(ViewRequisitionModel aRequisitionModel)
{
int maxTrNo = _iProductGateway.GetMaxRequisitionNoOfCurrentYear();
aRequisitionModel.RequisitionRef = GenerateRequisitionRef(maxTrNo);
int rowAffected = _iProductGateway.SaveRequisitionInfo(aRequisitionModel);
return(rowAffected);
}
