Example #1
0
 public string UpdateUIPageSettings(int PageID, int ObjID, int PgNbr, int PgSize, int MainID, int EmpID, int OrderID, int VendorID, int CustID, int SuppID, int SpeciesID, int LocID, int ShipID, int ItemID, int MgrID,
                                    int GroupID, int SortID, int LoadID, int OtherID, double Nbr, string StartDt, string EndDt, string TargetDt, string ItemCode, string ItemName, string TagNbr, string CustCode, string VendorCode, string LocCode, string SpeciesCode,
                                    string SuppCode, string ThickCode, string GradeCode, string StatusCode, int iType, int ByID)
 {
     try
     {
         DateTime?sdate = null;
         DateTime?edate = null;
         DateTime?tdate = null;
         if (!String.IsNullOrWhiteSpace(StartDt))
         {
             sdate = Convert.ToDateTime(StartDt);
         }
         if (!String.IsNullOrWhiteSpace(EndDt))
         {
             edate = Convert.ToDateTime(EndDt);
         }
         if (!String.IsNullOrWhiteSpace(TargetDt))
         {
             tdate = Convert.ToDateTime(TargetDt);
         }
         PaginationFn pg = new PaginationFn();
         DataTable    dt = pg.UpdateUIPageSettings(PageID, ObjID, PgNbr, PgSize, MainID, EmpID, OrderID, VendorID, CustID, SuppID, SpeciesID, LocID, ShipID, ItemID, MgrID, GroupID, SortID, LoadID, OtherID, Nbr, sdate, edate, tdate,
                                                   ItemCode, ItemName, TagNbr, CustCode, VendorCode, LocCode, SpeciesCode, SuppCode, ThickCode, GradeCode, StatusCode, iType, ByID);
         return(JsonHelper.toJSONfmTbl(dt));
     }
     catch (Exception ex)
     {
         Commands cmd     = new Commands();
         int      iResult = cmd.LogApplicationError("DataMngt", ObjID, ByID, "Err: " + ex.Message, 0, "UpdateUIPageSettings function", ByID);
         System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer();
         return(js.Serialize(new { Success = false, Message = ex.Message }));
     }
 }
Example #2
0
 public string UpdateUIPageSetting(int PageID, int ObjID, int iType, int Nbr, DateTime?dte, string Value, int ByID)
 {
     try
     {
         PaginationFn pg = new PaginationFn();
         DataTable    dt = pg.UpdateUIPageSetting(PageID, ObjID, iType, Nbr, dte, Value, ByID);
         return(JsonHelper.toJSONfmTbl(dt));
     }
     catch (Exception ex)
     {
         Commands cmd     = new Commands();
         int      iResult = cmd.LogApplicationError("DataMngt", ObjID, ByID, "Err: " + ex.Message, 0, "UpdateUIPageSetting function", ByID);
         System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer();
         return(js.Serialize(new { Success = false, Message = ex.Message }));
     }
 }