private void Init()
{
ACMSDAL.TblLocker sqlLocker = new ACMSDAL.TblLocker();
DataTable table = sqlLocker.GetOccupiedLocker(myPOS.StrBranchCode, myPOS.StrMembershipID);
if (table == null || table.Rows.Count == 0)
{
MessageBox.Show(this, "No lockers have been rented");
gridControl1.DataSource = null;
return;
}
if (table.Rows.Count > 0)
{
DataColumn colStatus = new DataColumn("Status", typeof(string));
table.Columns.Add(colStatus);
// Only show those no yet pass grace period
ACMSDAL.TblBranch sqlBranch = new ACMSDAL.TblBranch();
sqlBranch.StrBranchCode = myPOS.StrBranchCode;
sqlBranch.SelectOne();
int gracePeriod = ACMS.Convert.ToInt32(sqlBranch.NLockerGracePeriod);
foreach (DataRow lockerRow in table.Rows)
{
DateTime dtExpiryDate = ACMS.Convert.ToDateTime(lockerRow["dtExpiry"]);
TimeSpan span = DateTime.Today.Subtract(dtExpiryDate.Date);
if (span.Days > gracePeriod)
{
lockerRow["Status"] = "Exceed Grace Period";
}
else
{
lockerRow["Status"] = "Allow to return.";
}
}
foreach (DataRow detailRow in myPOS.ReceiptItemsTable.Rows)
{
string nLockerNoThatReturnCurrently = detailRow["strCode"].ToString();
DataRow[] rowsToDelete = table.Select("nLockerNo = " + nLockerNoThatReturnCurrently);
foreach (DataRow rowToDelete in rowsToDelete)
{
rowToDelete.Delete();
}
}
gridControl1.DataSource = table;
}
}
private void Init()
{
ACMSDAL.TblLocker sqllocker = new ACMSDAL.TblLocker();
DataTable table = sqllocker.GetAvailableLocker(myPOS.StrBranchCode);
foreach (DataRow r in myPOS.ReceiptItemsTable.Rows)
{
string nLockerNo = r["strCode"].ToString();
DataRow[] rowsToDelete = table.Select("nLockerNo = " + nLockerNo);
foreach (DataRow r2 in rowsToDelete)
{
r2.Delete();
}
}
gridControl1.DataSource = table;
}
private void Init()
{
ACMSDAL.TblLocker sqllocker = new ACMSDAL.TblLocker();
DataTable table = sqllocker.GetAvailableLocker(myPOS.StrBranchCode);
foreach (DataRow r in myPOS.ReceiptItemsTable.Rows)
{
string nLockerNo = r["strCode"].ToString();
DataRow[] rowsToDelete = table.Select("nLockerNo = " + nLockerNo);
foreach (DataRow r2 in rowsToDelete)
{
r2.Delete();
}
}
gridControl1.DataSource = table;
}
private void Init()
{
ACMSDAL.TblLocker sqllocker = new ACMSDAL.TblLocker();
DataTable table = sqllocker.GetOccupiedLocker(myPOS.StrBranchCode, myPOS.StrMembershipID);
foreach (DataRow row in myPOS.ReceiptItemsTable.Rows)
{
string nLockerNo = row["strCode"].ToString();
DataRow[] rowsToDelete = table.Select("nLockerNo = " + nLockerNo);
foreach (DataRow rowToDelete in rowsToDelete)
{
rowToDelete.Delete();
}
}
if (table.Rows.Count > 0)
{
gridControl1.DataSource = table;
}
}
private void Init()
{
ACMSDAL.TblLocker sqllocker = new ACMSDAL.TblLocker();
DataTable table = sqllocker.GetOccupiedLocker(myPOS.StrBranchCode, myPOS.StrMembershipID);
foreach (DataRow row in myPOS.ReceiptItemsTable.Rows)
{
string nLockerNo = row["strCode"].ToString();
DataRow[] rowsToDelete = table.Select("nLockerNo = " + nLockerNo);
foreach (DataRow rowToDelete in rowsToDelete)
{
rowToDelete.Delete();
}
}
if (table.Rows.Count > 0)
{
gridControl1.DataSource = table;
}
}
public override void Refresh()
{
if (strMembershipID.Length != 0)
{
ACMSDAL.TblLocker locker = new ACMSDAL.TblLocker();
locker.StrMembershipID = strMembershipID;
myDataTable = locker.SelectAllWstrMembershipIDLogic();
Init();
}
else
{
myDataTable = new DataTable();
Init();
}
}
