public static void InsertAuditLog(Data.TerminalDetails TerminalDetails, string Username, AccessTypes AccessType, string Remarks)
{
Security.AuditTrailDetails clsAuditDetails = new Security.AuditTrailDetails();
clsAuditDetails.BranchID = TerminalDetails.BranchDetails.BranchID;
clsAuditDetails.TerminalNo = TerminalDetails.TerminalNo;
clsAuditDetails.ActivityDate = DateTime.Now;
clsAuditDetails.User = Username;
clsAuditDetails.IPAddress = System.Net.Dns.GetHostName();
clsAuditDetails.Activity = AccessType.ToString("G");
clsAuditDetails.Remarks = "FE:" + Remarks;
Security.AuditTrail clsAuditTrail = new Security.AuditTrail();
clsAuditTrail.Insert(clsAuditDetails);
clsAuditTrail.CommitAndDispose();
}
public static void InsertAuditLog(Data.TerminalDetails TerminalDetails, string Username, AccessTypes AccessType, string Remarks)
{
Security.AuditTrailDetails clsAuditDetails = new Security.AuditTrailDetails();
clsAuditDetails.BranchID = TerminalDetails.BranchDetails.BranchID;
clsAuditDetails.TerminalNo = TerminalDetails.TerminalNo;
clsAuditDetails.ActivityDate = DateTime.Now;
clsAuditDetails.User = Username;
clsAuditDetails.IPAddress = System.Net.Dns.GetHostName();
clsAuditDetails.Activity = AccessType.ToString("G");
clsAuditDetails.Remarks = "FE:" + Remarks;
Security.AuditTrail clsAuditTrail = new Security.AuditTrail();
clsAuditTrail.Insert(clsAuditDetails);
clsAuditTrail.CommitAndDispose();
}
public Int64 Login(string UserName, string Password, AccessTypes accesstype, out string pstrName)
{
try
{
pstrName = string.Empty;
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT a.UID, Name FROM sysAccessUsers a " +
"INNER JOIN sysAccessRights b ON a.UID = b.UID " +
"INNER JOIN sysAccessTypes c ON b.TranTypeID = c.TypeID " +
"INNER JOIN sysAccessUserDetails d ON a.UID = d.UID " +
"WHERE UserName = @UserName " +
" AND Password = @Password AND Deleted = 0 " +
" AND TranTypeID = @TranTypeID AND AllowWrite = 1 AND Enabled =1 ";
cmd.Parameters.AddWithValue("UserName", UserName);
cmd.Parameters.AddWithValue("Password", Password);
cmd.Parameters.AddWithValue("TranTypeID", accesstype.ToString("d"));
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);
Int64 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int64.Parse(dr["UID"].ToString());
pstrName = dr["Name"].ToString();
}
return(iID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void InsertAuditLog(AccessTypes AccessType, string Remarks)
{
//Methods.InsertAuditLog(mclsTerminalDetails, mCashierName, AccessType, Remarks);
this.bgwAuditLogs.RunWorkerAsync(AccessType.ToString("d") + "|" + Remarks);
// Wait for the BackgroundWorker to finish the download.
while (this.bgwAuditLogs.IsBusy)
{
//prgBar.Increment(1);
// Keep UI messages moving, so the form remains
// responsive during the asynchronous operation.
Application.DoEvents();
}
}
public DialogResult GetWriteAccessAndLogin(Int64 UID, AccessTypes AccessType, string OverridingHeader = "")
{
DialogResult loginresult = GetWriteAccess(mclsSalesTransactionDetails.CashierID, AccessType);
if (loginresult == DialogResult.None)
{
string strHeader = OverridingHeader;
if (string.IsNullOrEmpty(strHeader))
{
switch (AccessType)
{
case AccessTypes.PrintTransactionHeader: strHeader = "Print Transaction Header"; break;
case AccessTypes.ChangeQuantity: strHeader = "Change Quantity"; break;
case AccessTypes.ChangePrice: strHeader = "Change Price"; break;
case AccessTypes.ReturnItem: strHeader = "Return Item Access"; break;
case AccessTypes.ApplyItemDiscount: strHeader = "Apply Item Discount"; break;
case AccessTypes.Contacts: strHeader = "Update customer information"; break;
case AccessTypes.SuspendTransaction: strHeader = "Suspend Transaction No. " + mclsSalesTransactionDetails.TransactionNo; break;
case AccessTypes.ResumeTransaction: strHeader = "Resume Suspended Transaction"; break;
case AccessTypes.ResumeSuspendedOpenTransaction: strHeader = "Resume Suspended Open Transaction"; break;
case AccessTypes.VoidTransaction: strHeader = "Void Transaction No. " + mclsSalesTransactionDetails.TransactionNo; break;
case AccessTypes.Withhold: strHeader = "WithHold Amount"; break;
case AccessTypes.Disburse: strHeader = "Disburse Amount"; break;
case AccessTypes.PaidOut: strHeader = "Paid-Out Amount"; break;
case AccessTypes.MallForwarder: strHeader = "Mall Data Forwarder"; break;
case AccessTypes.VoidItem: strHeader = "Void Item"; break;
case AccessTypes.CashCount: strHeader = "Issue Cash Count"; break;
case AccessTypes.EnterFloat: strHeader = "Enter Float or Beginning Balance"; break;
case AccessTypes.InitializeZRead: strHeader = "Initialize Z-Read"; break;
case AccessTypes.CreateTransaction: strHeader = "Create Transaction"; break;
case AccessTypes.CloseTransaction: strHeader = "Close Transaction"; break;
case AccessTypes.ReleaseItems: strHeader = "Release Items"; break;
case AccessTypes.LogoutFE: strHeader = "Logout"; break;
case AccessTypes.ApplyTransDiscount: strHeader = "Apply Transaction Discount"; break;
case AccessTypes.ChargeType: strHeader = "Apply Transaction Charge"; break;
case AccessTypes.OpenDrawer: strHeader = "Open Drawer"; break;
case AccessTypes.CreditPayment: strHeader = "Enter Credit Payment"; break;
case AccessTypes.RefundTransaction: strHeader = "Refund Transaction"; break;
case AccessTypes.RewardCardIssuance: strHeader = "Issue new Reward Card"; break;
case AccessTypes.RewardCardChange: strHeader = "Reward Card Replacement"; break;
case AccessTypes.CreditCardIssuance: strHeader = "Issue new Credit Card"; break;
case AccessTypes.CreditCardChange: strHeader = "Credit Card Replacement"; break;
case AccessTypes.PackUnpackTransaction: strHeader = "Pack/Unpack Transaction Access Validation"; break;
case AccessTypes.ReprintTransaction: strHeader = "Reprint Transaction Access Validation"; break;
case AccessTypes.PrintZRead: strHeader = "Print ZRead Access Validation"; break;
case AccessTypes.PrintXRead: strHeader = "Print XRead Access Validation"; break;
case AccessTypes.PrintHourlyReport: strHeader = "Print Hourly Report Access Validation"; break;
case AccessTypes.PrintGroupReport: strHeader = "Print Group/Dept. Report Access Validation"; break;
case AccessTypes.PrintPLUReport: strHeader = "Print PLU Report Access Validation"; break;
case AccessTypes.PrintElectronicJournal: strHeader = "Print EJournal Report Access Validation"; break;
default: strHeader = AccessType.ToString(); break;
}
}
LogInWnd login = new LogInWnd();
login.AccessType = AccessType;
login.Header = strHeader;
login.TerminalDetails = mclsTerminalDetails;
login.ShowDialog(this);
loginresult = login.Result;
AccessUserDetails clsAccessUserDetails = login.AccessUserDetails;
login.Close();
login.Dispose();
if (loginresult != System.Windows.Forms.DialogResult.OK)
loginresult = System.Windows.Forms.DialogResult.Cancel;
else
{
// 06Jun2015 : do an override event log
if (UID != clsAccessUserDetails.UID)
{
clsEvent.AddEventLn("[Override: " + AccessType.ToString("") + "] " + clsAccessUserDetails.Name + ": " + strHeader, true);
}
}
}
return loginresult;
}
public Int64 Login(string UserName, string Password, AccessTypes accesstype, out string pstrName)
{
try
{
pstrName = string.Empty;
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL ="SELECT a.UID, Name FROM sysAccessUsers a " +
"INNER JOIN sysAccessRights b ON a.UID = b.UID " +
"INNER JOIN sysAccessTypes c ON b.TranTypeID = c.TypeID " +
"INNER JOIN sysAccessUserDetails d ON a.UID = d.UID " +
"WHERE UserName = @UserName " +
" AND Password = @Password AND Deleted = 0 " +
" AND TranTypeID = @TranTypeID AND AllowWrite = 1 AND Enabled =1 ";
cmd.Parameters.AddWithValue("UserName", UserName);
cmd.Parameters.AddWithValue("Password", Password);
cmd.Parameters.AddWithValue("TranTypeID", accesstype.ToString("d"));
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);
Int64 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int64.Parse(dr["UID"].ToString());
pstrName = dr["Name"].ToString();
}
return iID;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public DialogResult GetWriteAccessAndLogin(Int64 UID, AccessTypes AccessType, string OverridingHeader = "")
{
DialogResult loginresult = GetWriteAccess(CashierID, AccessType);
if (loginresult == DialogResult.None)
{
string strHeader = OverridingHeader;
if (string.IsNullOrEmpty(strHeader))
{
switch (AccessType)
{
case AccessTypes.PrintTransactionHeader: strHeader = "Print Transaction Header"; break;
case AccessTypes.ChangeQuantity: strHeader = "Change Quantity"; break;
case AccessTypes.ChangePrice: strHeader = "Change Price"; break;
case AccessTypes.ReturnItem: strHeader = "Return Item Access"; break;
case AccessTypes.ApplyItemDiscount: strHeader = "Apply Item Discount"; break;
case AccessTypes.Contacts: strHeader = "Update customer information"; break;
case AccessTypes.SuspendTransaction: strHeader = "Suspend Transaction No. "; break;
case AccessTypes.ResumeTransaction: strHeader = "Resume Suspended Transaction"; break;
case AccessTypes.ResumeSuspendedOpenTransaction: strHeader = "Resume Suspended Open Transaction"; break;
case AccessTypes.VoidTransaction: strHeader = "Void Transaction No. "; break;
case AccessTypes.Withhold: strHeader = "WithHold Amount"; break;
case AccessTypes.Disburse: strHeader = "Disburse Amount"; break;
case AccessTypes.PaidOut: strHeader = "Paid-Out Amount"; break;
case AccessTypes.MallForwarder: strHeader = "Mall Data Forwarder"; break;
case AccessTypes.VoidItem: strHeader = "Void Item"; break;
case AccessTypes.CashCount: strHeader = "Issue Cash Count"; break;
case AccessTypes.EnterFloat: strHeader = "Enter Float or Beginning Balance"; break;
case AccessTypes.InitializeZRead: strHeader = "Initialize Z-Read"; break;
case AccessTypes.CreateTransaction: strHeader = "Create Transaction"; break;
case AccessTypes.CloseTransaction: strHeader = "Close Transaction"; break;
case AccessTypes.ReleaseItems: strHeader = "Release Items"; break;
case AccessTypes.LogoutFE: strHeader = "Logout"; break;
case AccessTypes.ApplyTransDiscount: strHeader = "Apply Transaction Discount"; break;
case AccessTypes.ChargeType: strHeader = "Apply Transaction Charge"; break;
case AccessTypes.OpenDrawer: strHeader = "Open Drawer"; break;
case AccessTypes.CreditPayment: strHeader = "Enter Credit Payment"; break;
case AccessTypes.RefundTransaction: strHeader = "Refund Transaction"; break;
case AccessTypes.RewardCardIssuance: strHeader = "Issue new Reward Card"; break;
case AccessTypes.RewardCardChange: strHeader = "Reward Card Replacement"; break;
case AccessTypes.CreditCardIssuance: strHeader = "Issue new Credit Card"; break;
case AccessTypes.CreditCardChange: strHeader = "Credit Card Replacement"; break;
case AccessTypes.PackUnpackTransaction: strHeader = "Pack/Unpack Transaction Access Validation"; break;
case AccessTypes.ReprintTransaction: strHeader = "Reprint Transaction Access Validation"; break;
case AccessTypes.PrintZRead: strHeader = "Print ZRead Access Validation"; break;
case AccessTypes.PrintXRead: strHeader = "Print XRead Access Validation"; break;
case AccessTypes.PrintHourlyReport: strHeader = "Print Hourly Report Access Validation"; break;
case AccessTypes.PrintGroupReport: strHeader = "Print Group/Dept. Report Access Validation"; break;
case AccessTypes.PrintPLUReport: strHeader = "Print PLU Report Access Validation"; break;
case AccessTypes.PrintElectronicJournal: strHeader = "Print EJournal Report Access Validation"; break;
default: strHeader = AccessType.ToString(); break;
}
}
LogInWnd login = new LogInWnd();
login.AccessType = AccessType;
login.Header = strHeader;
login.TerminalDetails = mclsTerminalDetails;
login.ShowDialog(this);
loginresult = login.Result;
login.Close();
login.Dispose();
if (loginresult != System.Windows.Forms.DialogResult.OK)
{
loginresult = System.Windows.Forms.DialogResult.Cancel;
}
}
return(loginresult);
}
public static string ToString(this AccessTypes accessType)
{
return(accessType.ToString());
}
