public CashierLogStatus LastStatus(Int64 CashierID, out long CashierLogsID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT Status, CashierLogsID FROM tblCashierLogs WHERE UID = @UID ORDER BY LoginDate DESC LIMIT 1; ";
cmd.Parameters.AddWithValue("UID", CashierID);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
CashierLogStatus status = CashierLogStatus.LoggedOut;
CashierLogsID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
status = (CashierLogStatus)Enum.Parse(typeof(CashierLogStatus), dr["Status"].ToString());
CashierLogsID = Int64.Parse(dr["CashierLogsID"].ToString());
}
return(status);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public CashierLogStatus Status(Int64 CashierID, DateTime LoginDate, int BranchID, string TerminalNo)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT " +
"Status " +
"FROM tblCashierLogs " +
"WHERE UID = @UID " +
"AND CAST(LoginDate AS DATE) = CAST(@LoginDate AS DATE) " +
"AND BranchID = @BranchID " +
"AND TerminalNo = @TerminalNo " +
"ORDER BY LoginDate DESC; ";
cmd.Parameters.AddWithValue("UID", CashierID);
cmd.Parameters.AddWithValue("LoginDate", LoginDate);
cmd.Parameters.AddWithValue("BranchID", BranchID);
cmd.Parameters.AddWithValue("TerminalNo", TerminalNo);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
CashierLogStatus status = CashierLogStatus.LoggedOut;
foreach (System.Data.DataRow dr in dt.Rows)
{
status = (CashierLogStatus)Enum.Parse(typeof(CashierLogStatus), dr["Status"].ToString());
}
return(status);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
