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