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;
}
