public void PrepareGINEdit(string punIds, Guid ID) { DataTable PUNTable = ECX.DataAccess.SQLHelper.getDataTable(ConnectionString, "GetPickupNoticesEdit", punIds, ID); punList = new List <PickupNoticeModel>(); foreach (DataRow r in PUNTable.Rows) { PickupNoticeModel pnm = new PickupNoticeModel(); Common.DataRow2Object(r, pnm); punList.Add(pnm); } }
public void Search(string clientIdNo, int whrNo, string status, Guid warehouseID, DateTime expirationDateFrom, DateTime expirationDateTo) { DataTable dt = SQLHelper.getDataTable(ConnectionString, "PickupNoticeSearch", clientIdNo, whrNo, status, warehouseID, expirationDateFrom.Date, expirationDateTo.Date); lstSearch = new List <PickupNoticeModel>(); foreach (DataRow dr in dt.Rows) { PickupNoticeModel o = new PickupNoticeModel(); Common.DataRow2Object(dr, o); lstSearch.Add(o); } }
public static List <PickupNoticeModel> PreparePUNId(string punIds) { List <PickupNoticeModel> punList = new List <PickupNoticeModel>(); DataTable dt = SQLHelper.getDataTable(ConnectionString, "PreparePUN", punIds); foreach (DataRow dr in dt.Rows) { PickupNoticeModel o = new PickupNoticeModel(); Common.DataRow2Object(dr, o); punList.Add(o); } return(punList); }
public static List <GINModel> getUnApprovedPSA(string clientIdNo, int whrNo, Guid?licID, string PSANo, Guid warehouseId) { DataTable dt = SQLHelper.getDataTable(ConnectionString, "getUnApprovedPSA", clientIdNo, PSANo, whrNo, licID, warehouseId); List <GINModel> gmList = new List <GINModel>(); foreach (DataRow dr in dt.Rows) { GINModel gm = new GINModel(); Common.DataRow2Object(dr, gm); PickupNoticeModel pnm = new PickupNoticeModel(); Common.DataRow2Object(dr, pnm); gm.punList.Add(pnm); gmList.Add(gm); } return(gmList); }
public static List <PickupNoticeModel> PrintPUNChecking(string Id) { List <PickupNoticeModel> lst = new List <PickupNoticeModel>(); DataTable dt = SQLHelper.getDataTable(ConnectionString, "CheckunPrint", Id, WarehouseApplication.BLL.UserBLL.CurrentUser.UserId); Guid punId = Guid.Empty; foreach (DataRow dr in dt.Rows) { PickupNoticeModel o = new PickupNoticeModel(); Common.DataRow2Object(dr, o); lst.Add(o); punId = o.ID; } return(lst); }
//-------- Update END ------- NOV 27 2013 public static List <GINModel> SearchGIN(string clientIdNo, int whrNo, string status, string GINNo, Guid warehouseId) { DataTable dt = SQLHelper.getDataTable(ConnectionString, "GINSearch", clientIdNo, GINNo, whrNo, status, warehouseId); List <GINModel> gmList = new List <GINModel>(); foreach (DataRow dr in dt.Rows) { GINModel gm = new GINModel(); Common.DataRow2Object(dr, gm); PickupNoticeModel pnm = new PickupNoticeModel(); Common.DataRow2Object(dr, pnm); gm.punList.Add(pnm); gmList.Add(gm); } return(gmList); }
//-------- Create END ------- March 20 2015 public static GINModel GetGIN(string GINNo) { GINModel gm = new GINModel(); DataTable dt = SQLHelper.getDataTable(ConnectionString, "GINGet", GINNo); Common.DataRow2Object(dt.Rows[0], gm); List <Guid> pnIdList = new List <Guid>(); List <Guid> sIdList = new List <Guid>(); foreach (DataRow dr in dt.Rows) { Guid pnID = new Guid(dr["PUNID"].ToString()); if (!pnIdList.Exists(s => s == pnID)) { pnIdList.Add(pnID); PickupNoticeModel pnm = new PickupNoticeModel(); Common.DataRow2Object(dr, pnm); pnm.ID = pnID; gm.punList.Add(pnm); } } foreach (DataRow dr in dt.Rows) { StackTransactionModel sm = new StackTransactionModel(gm); Common.DataRow2Object(dr, sm); if (sm.StackTransactionID == Guid.Empty) { break; } if (!sIdList.Exists(s => s == sm.StackTransactionID)) { sIdList.Add(sm.StackTransactionID); sm.ID = sm.StackTransactionID; gm.stackList.Add(sm); } } return(gm); }
public static void SelectPickupNotice(PickupNoticeModel notice, bool select, DateTime dnPresentedDate) { notice.Selected = select; }