public void Logout(CashierLogsDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "UPDATE tblCashierLogs SET " +
"LogoutDate = @LogoutDate, "+
"Status = @Status "+
"WHERE UID = @UID "+
"AND LoginDate = @LoginDate "+
"AND BranchID = @BranchID "+
"AND TerminalNo = @TerminalNo "+
"AND IPAddress = @IPAddress; ";
cmd.Parameters.AddWithValue("BranchID", Details.BranchID);
cmd.Parameters.AddWithValue("TerminalNo", Details.TerminalNo);
cmd.Parameters.AddWithValue("UID", Details.CashierID);
cmd.Parameters.AddWithValue("LoginDate", Details.LoginDate);
cmd.Parameters.AddWithValue("IPAddress", Details.IPAddress);
cmd.Parameters.AddWithValue("LogoutDate", Details.LogoutDate);
cmd.Parameters.AddWithValue("Status", CashierLogStatus.LoggedOut.ToString("d"));
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(CashierLogsDetails Details)
{
try
{
string SQL = "CALL procSaveCashierLogs(@BranchID, @TerminalNo, @SyncID, @CashierLogsID, @UID, @LoginDate, @IPAddress, @LogoutDate, @Status, @BranchCode, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("BranchID", Details.BranchID);
cmd.Parameters.AddWithValue("TerminalNo", Details.TerminalNo);
cmd.Parameters.AddWithValue("SyncID", Details.SyncID);
cmd.Parameters.AddWithValue("CashierLogsID", Details.CashierLogsID);
cmd.Parameters.AddWithValue("UID", Details.CashierID);
cmd.Parameters.AddWithValue("LoginDate", Details.LoginDate);
cmd.Parameters.AddWithValue("IPAddress", Details.IPAddress);
cmd.Parameters.AddWithValue("LogoutDate", Details.LogoutDate);
cmd.Parameters.AddWithValue("Status", Details.Status);
cmd.Parameters.AddWithValue("BranchCode", Details.BranchCode);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 UpdateBeginningBalance(CashierLogsDetails Details, decimal BeginningBalanceAmount)
{
Int64 iRetValue = Insert(Details);
Data.CashierReports clsCashierReport = new Data.CashierReports(base.Connection, base.Transaction);
clsCashierReport.UpdateBeginningBalance(Details.BranchID, Details.TerminalNo, Details.CashierID, BeginningBalanceAmount);
Data.TerminalReport clsTerminalReport = new Data.TerminalReport(base.Connection, base.Transaction);
clsTerminalReport.UpdateBeginningBalance(Details.BranchID, Details.TerminalNo, BeginningBalanceAmount);
return iRetValue;
}
public Int64 UpdateBeginningBalance(CashierLogsDetails Details, decimal BeginningBalanceAmount)
{
Int64 iRetValue = Insert(Details);
Data.CashierReports clsCashierReport = new Data.CashierReports(base.Connection, base.Transaction);
clsCashierReport.UpdateBeginningBalance(Details.BranchID, Details.TerminalNo, Details.CashierID, BeginningBalanceAmount);
Data.TerminalReport clsTerminalReport = new Data.TerminalReport(base.Connection, base.Transaction);
clsTerminalReport.UpdateBeginningBalance(Details.BranchID, Details.TerminalNo, BeginningBalanceAmount);
return(iRetValue);
}
public void Update(CashierLogsDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 Insert(CashierLogsDetails Details)
{
try
{
Save(Details);
return(Int64.Parse(base.getLAST_INSERT_ID(this)));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public CashierLogsDetails Details(Int64 CashierLogsID)
{
try
{
string SQL = SQLSelect() + "WHERE CashierLogsID = @CashierLogsID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmCashierLogsID = new MySqlParameter("@CashierLogsID", MySqlDbType.Int64);
prmCashierLogsID.Value = CashierLogsID;
cmd.Parameters.Add(prmCashierLogsID);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
CashierLogsDetails Details = new CashierLogsDetails();
while (myReader.Read())
{
Details.CashierLogsID = CashierLogsID;
Details.CashierID = myReader.GetInt64("CashierID");
Details.LoginDate = myReader.GetDateTime("LoginDate");
Details.BranchID = myReader.GetInt32("BranchID");
Details.BranchCode = "" + myReader["BranchCode"].ToString();
Details.TerminalNo = "" + myReader["TerminalNo"].ToString();
Details.IPAddress = "" + myReader["IPAddress"].ToString();
Details.LogoutDate = myReader.GetDateTime("LogoutDate");
Details.Status = (CashierLogStatus)Enum.Parse(typeof(CashierLogStatus), myReader.GetString("Status"));
}
myReader.Close();
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private bool InitializeBeginningCashierID()
{
CashierLogsDetails clsLogDetails = new CashierLogsDetails();
clsLogDetails.CashierID = miCashierID;
clsLogDetails.LoginDate = DateTime.Now;
clsLogDetails.BranchID = TerminalDetails.BranchID;
clsLogDetails.TerminalNo = TerminalDetails.TerminalNo;
clsLogDetails.IPAddress = System.Net.Dns.GetHostName();
clsLogDetails.Status = CashierLogStatus.LoggedIn;
CashierLogs clsCashierLogs = new CashierLogs();
clsCashierLogs.UpdateBeginningBalance(clsLogDetails, Convert.ToDecimal(txtAmount.Text));
clsCashierLogs.CommitAndDispose();
return true;
}
public Int64 Insert(CashierLogsDetails Details)
{
try
{
Save(Details);
return Int64.Parse(base.getLAST_INSERT_ID(this));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Logout(CashierLogsDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "UPDATE tblCashierLogs SET " +
"LogoutDate = @LogoutDate, " +
"Status = @Status " +
"WHERE UID = @UID " +
"AND LoginDate = @LoginDate " +
"AND BranchID = @BranchID " +
"AND TerminalNo = @TerminalNo " +
"AND IPAddress = @IPAddress; ";
cmd.Parameters.AddWithValue("BranchID", Details.BranchID);
cmd.Parameters.AddWithValue("TerminalNo", Details.TerminalNo);
cmd.Parameters.AddWithValue("UID", Details.CashierID);
cmd.Parameters.AddWithValue("LoginDate", Details.LoginDate);
cmd.Parameters.AddWithValue("IPAddress", Details.IPAddress);
cmd.Parameters.AddWithValue("LogoutDate", Details.LogoutDate);
cmd.Parameters.AddWithValue("Status", CashierLogStatus.LoggedOut.ToString("d"));
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public CashierLogsDetails Details(Int64 CashierLogsID)
{
try
{
string SQL= SQLSelect() + "WHERE CashierLogsID = @CashierLogsID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmCashierLogsID = new MySqlParameter("@CashierLogsID",MySqlDbType.Int64);
prmCashierLogsID.Value = CashierLogsID;
cmd.Parameters.Add(prmCashierLogsID);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
CashierLogsDetails Details = new CashierLogsDetails();
while (myReader.Read())
{
Details.CashierLogsID = CashierLogsID;
Details.CashierID = myReader.GetInt64("CashierID");
Details.LoginDate = myReader.GetDateTime("LoginDate");
Details.BranchID = myReader.GetInt32("BranchID");
Details.BranchCode = "" + myReader["BranchCode"].ToString();
Details.TerminalNo = "" + myReader["TerminalNo"].ToString();
Details.IPAddress = "" + myReader["IPAddress"].ToString();
Details.LogoutDate = myReader.GetDateTime("LogoutDate");
Details.Status = (CashierLogStatus)Enum.Parse(typeof(CashierLogStatus), myReader.GetString("Status"));
}
myReader.Close();
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(CashierLogsDetails Details)
{
try
{
string SQL = "CALL procSaveCashierLogs(@BranchID, @TerminalNo, @SyncID, @CashierLogsID, @UID, @LoginDate, @IPAddress, @LogoutDate, @Status, @BranchCode, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("BranchID", Details.BranchID);
cmd.Parameters.AddWithValue("TerminalNo", Details.TerminalNo);
cmd.Parameters.AddWithValue("SyncID", Details.SyncID);
cmd.Parameters.AddWithValue("CashierLogsID", Details.CashierLogsID);
cmd.Parameters.AddWithValue("UID", Details.CashierID);
cmd.Parameters.AddWithValue("LoginDate", Details.LoginDate);
cmd.Parameters.AddWithValue("IPAddress", Details.IPAddress);
cmd.Parameters.AddWithValue("LogoutDate", Details.LogoutDate);
cmd.Parameters.AddWithValue("Status", Details.Status);
cmd.Parameters.AddWithValue("BranchCode", Details.BranchCode);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(CashierLogsDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void DoLogin()
{
try
{
LogInWnd login = new LogInWnd();
login.AccessType = AccessTypes.LoginFE;
login.Header = "Enter user name and password to login.";
login.TerminalDetails = mclsTerminalDetails;
login.ShowDialog(this);
DialogResult loginResult = login.Result;
Int64 UserID = login.UserID;
DialogResult loginresult = login.Result;
login.Close();
login.Dispose();
if (loginresult == DialogResult.OK)
{
clsEvent.AddEventLn("UID: [" + UserID.ToString() + "] successfully logged-in.", true);
clsEvent.AddEventLn("Checking if beggining balance already initialized.", true);
// check if already initialize beginning balance.
if (!IsBeginningBalanceInitialized(UserID))
{
clsEvent.AddEventLn("Not yet initialized and cancelled.");
return;
}
clsEvent.AddEventLn("Done. Balance is already initialized.", true);
Cursor.Current = Cursors.WaitCursor;
// ZRead and Beginning balance is already initialize
// Process Transaction.
lblPress.Tag = DateTime.Now.ToString("MMM/dd/yyyy hh:mm:ss tt");
CashierLogsDetails clsLogDetails = new CashierLogsDetails();
clsLogDetails.CashierID = UserID;
clsLogDetails.LoginDate = Convert.ToDateTime(lblPress.Tag.ToString());
clsLogDetails.BranchID = mclsTerminalDetails.BranchID;
clsLogDetails.TerminalNo = mclsTerminalDetails.TerminalNo;
clsLogDetails.IPAddress = System.Net.Dns.GetHostName();
clsLogDetails.LogoutDate = clsLogDetails.LoginDate;
clsLogDetails.Status = CashierLogStatus.LoggedIn;
CashierLogs clsCashierLogs = new CashierLogs(mConnection, mTransaction);
mConnection = clsCashierLogs.Connection; mTransaction = clsCashierLogs.Transaction;
lblCashierName.Tag = clsCashierLogs.Insert(clsLogDetails).ToString();
this.UnLock(UserID);
this.LoadOptions(); // need to do this to reload the defaults
this.InitializeTransaction(UserID, false);
clsCashierLogs.CommitAndDispose();
txtBarCode.Focus();
InsertAuditLog(AccessTypes.LoginFE, "System login at terminal no. " + mclsTerminalDetails.TerminalNo + " @ Branch: " + mclsTerminalDetails.BranchDetails.BranchCode);
clsEvent.AddEventLn("System is now ready for transaction. Current user: "******"ERROR!!! System login: TRACE: ");
Cursor.Current = Cursors.Default;
throw ex;
}
}
