public ActionResult Edit(AssetReceivedModel Data) { try { if (Session["_intCurrentID"] == null) { return(RedirectToAction("Login", "Account")); } try { if (bool.Parse(Session["AssetReceivedEditAccess"].ToString()) == false && bool.Parse(Session["AssetReceivedViewAccess"].ToString()) == false) { return(RedirectToAction("List", "AssetReceived")); } } catch { return(RedirectToAction("List", "AssetReceived")); } MyWSContext ws = new MyWSContext(); string _strWhereStatement = Session["CurrentID"] + "`````````````````````"; using (DataTable _DTRecord = ws.AMSWebService.LoadSettingReceivingfromSupplier_Where(_strWhereStatement, Session["CustomerID"].ToString())) { foreach (DataRow DR in _DTRecord.Rows) { Data.cbCurrency = GetDropDownItem(false, "Currency"); Data.cbSupplier = GetDropDownItem(false, "Supplier"); Data.cbWarehouse = GetDropDownItem(false, "Warehouse"); Data.cbTransactionBy = GetDropDownItem(false, "Employees"); Data.cbReceviedBy = GetDropDownItem(false, "Employees"); Data.CurrentID = DR[0].ToString(); Data.fldDateEncoded = DateTime.Parse(DR[1].ToString()); Data.fldCode = DR[2].ToString(); Data.fldSupplierCode = DR[3].ToString(); Data.fldPONo = DR[4].ToString(); Data.fldDRNo = DR[5].ToString(); Data.fldDRDate = DateTime.Parse(DR[6].ToString()); Data.fldCurrency = DR[7].ToString(); Data.fldWarehouseCode = DR[8].ToString(); Data.fldRemarks = DR[9].ToString(); Data.fldTransactionByCode = DR[10].ToString(); Data.fldReceivedByCode = DR[11].ToString(); Session["fldAuthorizedStatus"] = DR[16].ToString(); } } return(View(Data)); } catch { } return(View(Data)); }
public PartialViewResult ViewSuppliersFilter() { AssetReceivedModel Data = new AssetReceivedModel(); Data.cbNature = GetDropDownItem(true, "NATURES"); Data.cbPageLimit = GetDropDownPageLimit(); Data.fldPageLimit = 10; ViewBag.PageNo = 1; return(PartialView(Data)); }
public PartialViewResult ViewAssetsSelection(string _strFilter) { DataTable dt = new DataTable(); AssetReceivedModel Data = new AssetReceivedModel(); try { _strFilter = _strFilter.Replace("undefined", ""); Data.fldPageLimit = 8; try { Data.fldSearchText = _strFilter.Split('`')[6]; Data.fldPageNo = int.Parse(_strFilter.Split('`')[5]); } catch { Data.fldPageNo = 1; } MyWSContext ws = new MyWSContext(); using (DataTable _DTRecord = ws.AMSWebService.LoadSettingAssetWOAsset_Where(_strFilter, Session["CustomerID"].ToString())) { ViewBag.RecordCount = _DTRecord.Rows.Count; try { ViewBag.Pagging = _DTRecord.Rows.Count / Data.fldPageLimit; if ((_DTRecord.Rows.Count > (Data.fldPageLimit * ViewBag.Pagging)) && ViewBag.Pagging > 0) { ViewBag.Pagging = _DTRecord.Rows.Count / Data.fldPageLimit + 1; } _DTRecord.DefaultView.Sort = "fldAssetLevel,fldName"; dt = _DTRecord.Select().Skip((Data.fldPageLimit * Data.fldPageNo) - Data.fldPageLimit).Take(Data.fldPageLimit).CopyToDataTable(); } catch { } ViewData["AssetWOAssetRecordData"] = dt; Data.cbPageLimit = GetDropDownPageLimit(); Data.cbPurchasingUOM = GetDropDownItem(false, "UOM"); Data.cbCostCenter = GetDropDownItem(true, "CostCenter"); ViewBag.fldPageNo = Data.fldPageNo; Session["fldPageNo"] = Data.fldPageNo; } } catch { ViewData["AssetWOAssetRecordData"] = dt; } return(PartialView(Data)); }
//// //Warehouse public PartialViewResult ViewWarehouseSearch(string _strFilter) { DataTable dt = new DataTable(); AssetReceivedModel Data = new AssetReceivedModel(); try { _strFilter = _strFilter.Replace("undefined", ""); Data.fldPageLimit = 10; try { Data.fldSearchTextWarehouse = _strFilter.Split('`')[1]; Data.fldPageNo = int.Parse(_strFilter.Split('`')[0]); } catch { Data.fldPageNo = 1; } MyWSContext ws = new MyWSContext(); string _strWhereStatement = "```" + Data.fldSearchTextWarehouse + "`"; using (DataTable _DTRecord = ws.AMSWebService.LoadSettingWarehouse_Where(_strWhereStatement, Session["CustomerID"].ToString())) { ViewBag.RecordCount = _DTRecord.Rows.Count; try { ViewBag.Pagging = _DTRecord.Rows.Count / Data.fldPageLimit; if ((_DTRecord.Rows.Count > (Data.fldPageLimit * ViewBag.Pagging)) && ViewBag.Pagging > 0) { ViewBag.Pagging = _DTRecord.Rows.Count / Data.fldPageLimit + 1; } _DTRecord.DefaultView.Sort = "fldName"; dt = _DTRecord.Select().Skip((Data.fldPageLimit * Data.fldPageNo) - Data.fldPageLimit).Take(Data.fldPageLimit).CopyToDataTable(); } catch { } ViewData["AssetWarehouseRecordData"] = dt; Data.cbPageLimit = GetDropDownPageLimit(); ViewBag.PageNo = Data.fldPageNo; Session["fldPageNo"] = Data.fldPageNo; } } catch { ViewData["AssetWarehouseRecordData"] = dt; } return(PartialView(Data)); }
public PartialViewResult ViewAssetsFilter(string _strSearchtext) { AssetReceivedModel Data = new AssetReceivedModel(); Data.cbClassification = GetDropDownItem(true, "Classification"); Data.cbCategory = GetDropDownItem(true, "Category"); Data.cbType = GetDropDownItem(true, "Type"); Data.cbBrand = GetDropDownItem(true, "Brand"); Data.cbModel = GetDropDownItem(true, "Model"); Data.cbPageLimit = GetDropDownPageLimit(); Data.fldPageLimit = 10; ViewBag.PageNo = 1; Data.fldSearchText = _strSearchtext; return(PartialView(Data)); }
public ActionResult Add() { if (Session["_intCurrentID"] == null) { return(RedirectToAction("Login", "Account")); } try { if (bool.Parse(Session["AssetReceivedCreateAccess"].ToString()) != true) { return(RedirectToAction("List", "AssetReceived")); } } catch { return(RedirectToAction("List", "AssetReceived")); } AssetReceivedModel Data = new AssetReceivedModel(); try { Data.fldCode = "AR" + DateTime.Now.ToString().Remove(DateTime.Now.ToString().Length - 2).Replace("/", "").Replace(" ", "").Replace(":", ""); Data.fldDateEncoded = DateTime.Now; Data.cbCurrency = GetDropDownItem(false, "Currency"); Data.cbSupplier = GetDropDownItem(false, "Supplier"); Data.cbWarehouse = GetDropDownItem(false, "Warehouse"); Data.cbTransactionBy = GetDropDownItem(false, "Employees"); Data.cbReceviedBy = GetDropDownItem(false, "Employees"); Data.fldTransactionByCode = Session["_strCurrentUserCode"].ToString(); Session["fldAuthorizedStatus"] = ""; } catch { } //List_Asset(Data.fldCode); return(View(Data)); }
public JsonResult Update(AssetReceivedModel Data) { try { MyWSContext ws = new MyWSContext(); string _strInput = Data.CurrentID + "`" + String.Format("{0:MM/dd/yyyy HH:mm}", DateTime.Now) + "`" + Data.fldCode + "`" + Data.fldSupplierCode + "`" + Data.fldPONo + "`" + Data.fldDRNo + "`" + Data.fldDRDate + "`" + Data.fldCurrency + "`" + Data.fldWarehouseCode + "`" + Data.fldRemarks + "`" + Data.fldTransactionByCode + "`" + Data.fldReceivedByCode + "`" + String.Format("{0:MM/dd/yyyy HH:mm}", DateTime.Now) + "`" + Data.fldAuthorizedByCode + "`" + Data.fldAuthorizedDateTime + "`" + Data.fldAuthorizedComment + "`" + Data.fldAuthorizedStatus; string[] _strOutput = ws.AMSWebService.SettingReceivingfromSupplier_SaveRecord(true, "", _strInput, Session["CustomerID"].ToString()).Split('`'); if (_strOutput[0] == "true") { ModelState.AddModelError("", _strOutput[1]); return(Json(new { Success = true, msg = _strOutput[1] }, JsonRequestBehavior.AllowGet)); } else { ModelState.AddModelError("", _strOutput[1]); return(Json(new { Success = false, msg = _strOutput[1] }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(new { Success = false, msg = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public JsonResult CheckCode(AssetReceivedModel Data) { try { MyWSContext ws = new MyWSContext(); string _strInput = Data.fldCode; string[] _strOutput = ws.AMSWebService.ReceivingfromSupplier_CheckCode(false, "", _strInput, Session["CustomerID"].ToString()).Split('`'); if (_strOutput[0] == "true") { ModelState.AddModelError("", _strOutput[1]); return(Json(new { Success = true, msg = _strOutput[1] }, JsonRequestBehavior.AllowGet)); } else { ModelState.AddModelError("", _strOutput[1]); return(Json(new { Success = false, msg = _strOutput[1] }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(new { Success = false, msg = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public JsonResult Delete(AssetReceivedModel Data) { try { MyWSContext ws = new MyWSContext(); string[] _strOutput = ws.AMSWebService.DeleteRecord_RecordID(Data.CurrentID, "ASSETRECEIVEDS", Session["CustomerID"].ToString()).Split('`'); if (_strOutput[0] == "true") { ViewBag.SystemError = ""; ViewBag.SystemSuccess = _strOutput[1]; return(Json(new { Success = true, msg = ViewBag.SystemSuccess }, JsonRequestBehavior.AllowGet)); } else { ViewBag.SystemError = _strOutput[1]; ViewBag.SystemSuccess = ""; } } catch { } return(Json(new { Success = false, msg = "" }, JsonRequestBehavior.AllowGet)); }
public ActionResult List() { if (!__isLogIn()) { return(RedirectToAction("Login", "Account")); } try { if (bool.Parse(Session["AssetReceived"].ToString()) == false) { return(RedirectToAction("Index", "Home")); } } catch { return(RedirectToAction("Index", "Home")); } Session["CurrentMenu"] = "InventoryManagement"; AssetReceivedModel Data = new AssetReceivedModel(); if (Session["fldPageLimit"] == null || Data.fldPageLimit == 0) { Data.fldPageLimit = 10; } else { Data.fldPageLimit = int.Parse(Session["fldPageLimit"].ToString()); } ViewBag.From = Session["_strFromDate"]; ViewBag.To = Session["_strToDate"]; ViewBag.Search = Session["fldSearchText"]; ViewBag.fldSupplierCode = Session["fldSupplierCode"]; ViewBag.fldWarehouseCode = Session["fldWarehouseCode"]; Data.fldFromDate = ViewBag.From == "" | ViewBag.From == null? null:String.Format("{0:yyyy-MM-dd}", DateTime.Parse(ViewBag.From)); Data.fldToDate = ViewBag.To == "" | ViewBag.To == null ? null : String.Format("{0:yyyy-MM-dd}", DateTime.Parse(ViewBag.To)); Data.fldSearchText = ViewBag.Search; Data.fldSupplierCode = ViewBag.fldSupplierCode; Data.fldWarehouseCode = ViewBag.fldWarehouseCode; try { MyWSContext ws = new MyWSContext(); string _strWhereStatement = "`" + ViewBag.From + "`" + ViewBag.To + "`" + (Data.fldSearchText == null ? "" : Data.fldSearchText) + "`" + Data.fldSupplierCode + "`" + Data.fldWarehouseCode; using (DataTable _DTRecord = ws.AMSWebService.LoadSettingReceivingfromSupplier_Where(_strWhereStatement, Session["CustomerID"].ToString())) { ViewBag.SystemError = ""; ViewBag.SystemSuccess = ""; ViewBag.RecordCount = _DTRecord.Rows.Count; DataTable dt = new DataTable(); try { ViewBag.Pagging = _DTRecord.Rows.Count / Data.fldPageLimit; if ((_DTRecord.Rows.Count > (Data.fldPageLimit * ViewBag.Pagging)) && ViewBag.Pagging > 0) { ViewBag.Pagging = _DTRecord.Rows.Count / Data.fldPageLimit + 1; } if (Session["fldPageNo"] == null || int.Parse(Session["fldPageNo"].ToString()) == 0 || ViewBag.Pagging == 1) { Session["fldPageNo"] = 1; Data.fldPageNo = 1; } else { Data.fldPageNo = int.Parse(Session["fldPageNo"].ToString()); } _DTRecord.DefaultView.Sort = "fldDRDate desc"; dt = _DTRecord.Select().Skip((Data.fldPageLimit * Data.fldPageNo) - Data.fldPageLimit).Take(Data.fldPageLimit).CopyToDataTable(); } catch { } ViewData["RecordData"] = dt; ViewBag.PageNo = Data.fldPageNo; Session["fldPageNo"] = Data.fldPageNo; } Data.cbPageLimit = GetDropDownPageLimit(); Data.cbSupplier = GetDropDownItem(true, "Supplier"); Data.cbWarehouse = GetDropDownItem(true, "Warehouse"); if (Session["fldSupplierCode"] != null) { if (Session["fldSupplierCode"].ToString() != "") { Data.fldSupplierCode = Session["fldSupplierCode"].ToString(); } } if (Session["fldWarehouseCode"] != null) { if (Session["fldWarehouseCode"].ToString() != "") { Data.fldWarehouseCode = Session["fldWarehouseCode"].ToString(); } } } catch { } return(View(Data)); }
public JsonResult GetEditRecord(AssetReceivedModel Data) { Session["CurrentID"] = Data.CurrentID; return(Json(new { Success = true, msg = "" }, JsonRequestBehavior.AllowGet)); }
public ActionResult List(AssetReceivedModel Data) { try { if (Session["_intCurrentID"] == null) { return(RedirectToAction("Login", "Account")); } if (Session["fldPageLimit"] == null || Data.fldPageLimit == 0) { Data.fldPageLimit = 10; } MyWSContext ws = new MyWSContext(); string _strFromDate = Data.fldFromDate == null ? "" : String.Format("{0:MM/dd/yyyy HH:mm}", DateTime.Parse(Data.fldFromDate.ToString())); string _strToDate = Data.fldToDate == null ? "" : String.Format("{0:MM/dd/yyyy HH:mm}", DateTime.Parse(Data.fldToDate.ToString())); string _strWhereStatement = "`" + _strFromDate + "`" + _strToDate + "`" + (Data.fldSearchText == null ? "" : Data.fldSearchText) + "`" + Data.fldSupplierCode + "`" + Data.fldWarehouseCode; using (DataTable _DTRecord = ws.AMSWebService.LoadSettingReceivingfromSupplier_Where(_strWhereStatement, Session["CustomerID"].ToString())) { Session["_strFromDate"] = _strFromDate; Session["_strToDate"] = _strToDate; Session["fldSearchText"] = Data.fldSearchText; Session["fldPageLimit"] = Data.fldPageLimit; Session["fldSupplierCode"] = Data.fldSupplierCode; Session["fldWarehouseCode"] = Data.fldWarehouseCode; ViewBag.RecordCount = _DTRecord.Rows.Count; DataTable dt = new DataTable(); try { ViewBag.Pagging = _DTRecord.Rows.Count / Data.fldPageLimit; if ((_DTRecord.Rows.Count > (Data.fldPageLimit * ViewBag.Pagging)) && ViewBag.Pagging > 0) { ViewBag.Pagging = _DTRecord.Rows.Count / Data.fldPageLimit + 1; } if (Data.fldPageCommand != null) { if (Session["fldPageNo"] == null) { Session["fldPageNo"] = 1; } else { Data.fldPageNo = int.Parse(Session["fldPageNo"].ToString()); } if (Data.fldPageCommand.Contains(">>")) { if (ViewBag.Pagging > Data.fldPageNo) { Data.fldPageNo++; } } else { Data.fldPageNo--; } if (Data.fldPageNo < 1) { Data.fldPageNo = 1; } } else { Data.fldPageNo = 1; } _DTRecord.DefaultView.Sort = "fldDRDate desc"; dt = _DTRecord.Select().Skip((Data.fldPageLimit * Data.fldPageNo) - Data.fldPageLimit).Take(Data.fldPageLimit).CopyToDataTable(); } catch { } ViewData["RecordData"] = dt; ViewBag.PageNo = Data.fldPageNo; Session["fldPageNo"] = Data.fldPageNo; } Data.cbPageLimit = GetDropDownPageLimit(); Data.cbSupplier = GetDropDownItem(true, "Supplier"); Data.cbWarehouse = GetDropDownItem(true, "Warehouse"); if (Session["fldSupplierCode"] != null) { if (Session["fldSupplierCode"].ToString() != "") { Data.fldSupplierCode = Session["fldSupplierCode"].ToString(); } } if (Session["fldWarehouseCode"] != null) { if (Session["fldWarehouseCode"].ToString() != "") { Data.fldWarehouseCode = Session["fldWarehouseCode"].ToString(); } } } catch { } return(View("List", Data)); }