public JsonResult AddRequisitionProductToXmlFile(ViewCreateGeneralRequsitionModel model)
        {
            SuccessErrorModel msgSuccessErrorModel = new SuccessErrorModel();

            try
            {
                var filePath    = GetGeneralRequisitionXmlFilePath();
                var id          = model.RequisitionForId.ToString("D2") + model.ProductId;
                var product     = _iProductManager.GetAll().ToList().Find(n => n.ProductId == model.ProductId);
                var xmlDocument = XDocument.Load(filePath);
                xmlDocument.Element("Products")?.Add(
                    new XElement("Product", new XAttribute("Id", id),
                                 new XElement("ProductId", product.ProductId),
                                 new XElement("ProductName", product.ProductName),
                                 new XElement("Quantity", model.Quantity),
                                 new XElement("RequisitionForId", model.RequisitionForId)
                                 ));
                xmlDocument.Save(filePath);
            }
            catch (Exception exception)
            {
                msgSuccessErrorModel.Message = "<p style='colore:red'>" + exception.Message + "</p>";
            }
            return(Json(msgSuccessErrorModel, JsonRequestBehavior.AllowGet));
        }
        public ActionResult GeneralRequisition()
        {
            var user = (ViewUser)Session["user"];
            ViewCreateGeneralRequsitionModel model =
                new ViewCreateGeneralRequsitionModel {
                RequisitionByUserId = user.UserId
            };

            CreateTempRequisitionXmlFile();
            List <RequisitionFor> requisitionFors = _iCommonManager.GetAllRequisitionForList().ToList();

            ViewBag.RequisitionForId = new SelectList(requisitionFors, "RequisitionForId", "Description");
            return(View(model));
        }
        public ActionResult GeneralRequisition(FormCollection collection)
        {
            var user  = (ViewUser)Session["user"];
            var model = new ViewCreateGeneralRequsitionModel
            {
                RequisitionByUserId = user.UserId
            };

            try
            {
                var products = GetProductFromXmalFile(GetGeneralRequisitionXmlFilePath());
                if (products.Count() != 0)
                {
                    var xmlData     = XDocument.Load(GetGeneralRequisitionXmlFilePath());
                    var requisition = new GeneralRequisitionModel
                    {
                        RequisitionModels   = products.ToList(),
                        RequisitionByUserId = user.UserId,
                        Quantity            = products.Sum(n => n.Quantity),
                        RequisitionDate     = Convert.ToDateTime(collection["RequisitionDate"]),
                        RequisitionRemarks  = collection["RequisitionRemarks"]
                    };
                    int rowAffected = _iProductManager.SaveGeneralRequisitionInfo(requisition);
                    if (rowAffected > 0)
                    {
                        xmlData.Root?.Elements().Remove();
                        xmlData.Save(GetGeneralRequisitionXmlFilePath());
                        TempData["message"] = "Requisition Create  Successfully!";
                    }
                    else
                    {
                        TempData["message"] = "Failed to create Requisition!";
                    }
                }

                List <RequisitionFor> requisitionFors = _iCommonManager.GetAllRequisitionForList().ToList();
                ViewBag.RequisitionForId = new SelectList(requisitionFors, "RequisitionForId", "Description");
                return(View(model));
            }
            catch (Exception exception)
            {
                List <RequisitionFor> requisitionFors = _iCommonManager.GetAllRequisitionForList().ToList();
                ViewBag.RequisitionForId = new SelectList(requisitionFors, "RequisitionForId", "Description");
                Log.WriteErrorLog(exception);
                return(View(model));
            }
        }
 public ActionResult GeneralRequisition()
 {
     try
     {
         var user = (ViewUser)Session["user"];
         ViewCreateGeneralRequsitionModel model =
             new ViewCreateGeneralRequsitionModel {
             RequisitionByUserId = user.UserId
         };
         CreateTempRequisitionXmlFile();
         List <RequisitionFor> requisitionFors = _iCommonManager.GetAllRequisitionForList().ToList();
         ViewBag.RequisitionForId = new SelectList(requisitionFors, "RequisitionForId", "Description");
         return(View(model));
     }
     catch (Exception exception)
     {
         Log.WriteErrorLog(exception);
         return(PartialView("_ErrorPartial", exception));
     }
 }