/// <summary> /// Created By: Ashwajit bansod /// Created Date : 03-Oct-2018 /// Created For: to edit PO as per POId /// </summary> /// <param name="POId"></param> /// <param name="LocationId"></param> /// <returns></returns> public ActionResult EditPOByPOId(string POId, long LocationId) { eTracLoginModel ObjLoginModel = null; long Id = 0; var objPOTypeModel = new POTypeDataModel(); try { if (Session["eTrac"] != null) { ObjLoginModel = (eTracLoginModel)(Session["eTrac"]); } if (!string.IsNullOrEmpty(POId)) { ViewBag.UpdateMode = true; POId = Cryptography.GetDecryptedData(POId, true); long.TryParse(POId, out Id); } if (Id > 0) { var DataPO = _IPOTypeDetails.GetPODetailsById(Id); ViewBag.Vendor = DataPO.Vendor; ViewBag.POTypeDate = DataPO.POType; ViewBag.PONumberData = DataPO.PONumber; ViewBag.POType = _IPOTypeDetails.POTypeList(); ViewBag.VendorList = _IPOTypeDetails.GetCompany_VendorList(LocationId, false); return(View("Index", DataPO)); } else { ViewBag.AlertMessageClass = new AlertMessageClass().Danger; ViewBag.Message = Result.DoesNotExist; } } catch (Exception ex) { ViewBag.Message = ex.Message; ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger; } return(View("Index")); }
/// <summary> /// Created By : Ashwajit Bansod /// Created Date : 17-April-2019 /// Created For : To get PO Details ad facility list by PO id /// </summary> /// <param name="POId"></param> /// <param name="_search"></param> /// <param name="UserId"></param> /// <param name="rows"></param> /// <param name="page"></param> /// <param name="TotalRecords"></param> /// <param name="sord"></param> /// <param name="txtSearch"></param> /// <param name="sidx"></param> /// <param name="UserType"></param> /// <returns></returns> public JsonResult GetAllPODetailByPOId(long POId, string _search, long?UserId, int?rows = 20, int?page = 1, int?TotalRecords = 10, string sord = null, string txtSearch = null, string sidx = null, string UserType = null) { eTracLoginModel ObjLoginModel = null; var getResult = new POTypeDataModel(); var resultPayment = new BillPayment(); if (Session["eTrac"] != null) { ObjLoginModel = (eTracLoginModel)(Session["eTrac"]); } try { var obj = new PaymentModel(); obj.BillNo = POId; var getPOByBillNo = _IPaymentManager.GetPODetails(null, obj); getResult = _IPOTypeDetails.GetPODetailsById(getPOByBillNo.POId); if (getResult != null) { getResult.IssueDateDisplay = getResult.IssueDate.ToString(); getResult.DeliveryDateDisplay = getResult.DeliveryDate.ToString(); JQGridResults result = new JQGridResults(); List <JQGridRow> rowss = new List <JQGridRow>(); decimal? grandTotal = 0; sord = string.IsNullOrEmpty(sord) ? "desc" : sord; sidx = string.IsNullOrEmpty(sidx) ? "UserEmail" : sidx; txtSearch = string.IsNullOrEmpty(txtSearch) ? "" : txtSearch; //UserType = Convert.ToInt64(Helper.UserType.ITAdministrator); getResult.NewPOTypeDetails = _IPOTypeDetails.GetAllPOFacilityByPOIdList(ObjLoginModel.UserId, getPOByBillNo.POId, rows, TotalRecords, sidx, sord); foreach (var poFacilityList in getResult.NewPOTypeDetails.rows) { grandTotal += poFacilityList.UnitPrice * poFacilityList.Quantity; poFacilityList.TotalPrice = grandTotal; //poFacilityList.TotalPrice = poFacilityList.UnitPrice * poFacilityList.Quantity; poFacilityList.Total = poFacilityList.UnitPrice * poFacilityList.Quantity; JQGridRow row = new JQGridRow(); row.id = Cryptography.GetEncryptedData(Convert.ToString(poFacilityList.COM_FacilityId), true); row.cell = new string[10]; row.cell[0] = poFacilityList.COM_FacilityId.ToString(); row.cell[1] = poFacilityList.CostCode.ToString(); row.cell[2] = poFacilityList.FacilityType.ToString(); row.cell[3] = poFacilityList.COM_Facility_Desc.ToString(); row.cell[4] = poFacilityList.UnitPrice.ToString(); row.cell[5] = poFacilityList.Tax.ToString(); row.cell[6] = poFacilityList.Quantity.ToString(); row.cell[7] = poFacilityList.Total.ToString(); row.cell[8] = poFacilityList.TotalPrice.ToString(); row.cell[9] = poFacilityList.CostCodeName.ToString(); rowss.Add(row); } result.rows = rowss.ToArray(); result.page = Convert.ToInt32(page); result.total = (int)Math.Ceiling((decimal)Convert.ToInt32(TotalRecords.Value) / rows.Value); result.records = Convert.ToInt32(TotalRecords.Value); } } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } return(Json(getResult, JsonRequestBehavior.AllowGet)); }