private void cmdlogin_Click(object sender, EventArgs e)
{
bool bMatch = false;
string sUserName = "";
string sUserCode = "";
string sUserType = "";
if (txtUserName.Text == "")
{
MessageBox.Show("Please supply username field");
return;
}
using (PsqlConnection oConn = new PsqlConnection(Solsage_Process_Management_System.Classes.Connect.sConnStr))
{
oConn.Open();
string sSql = "Select UserName,Psswrd,Code,UserType, CreditInvoice from SOLUS where UserName = '******'";
PsqlDataReader rdReader = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql, oConn).ExecuteReader();
while (rdReader.Read())
{
if (txtPassword.Text == rdReader["Psswrd"].ToString().Trim())
{
bMatch = true;
sUserName = rdReader["UserName"].ToString().Trim();
sUserCode = rdReader["Code"].ToString().Trim();
sUserType = rdReader["UserType"].ToString().Trim();
Global.iCreditInvoice = Convert.ToInt32(rdReader["CreditInvoice"]);
}
}
rdReader.Close();
oConn.Dispose();
}
if (bMatch == true)
{
this.Visible = false;
Cursor = System.Windows.Forms.Cursors.WaitCursor;
Main frmMain = new Solsage_Process_Management_System.Main();
Global.sLogedInUserName = sUserName;
Global.sLogedInUserCode = sUserCode;
Global.sLogedInUserType = sUserType;
Global.frmLogin = this;
Global.bUseBackground = chkUseBackground.Checked;
Global.frmMain = frmMain;
frmMain.Show();
Cursor = System.Windows.Forms.Cursors.Default;
}
else
{
MessageBox.Show("Login Failed");
cmdClearFields();
}
}
private void txtUserName_Leave(object sender, EventArgs e)
{
if (txtUserName.Text == sMasterUserName)
{
this.Visible = false;
Cursor = System.Windows.Forms.Cursors.WaitCursor;
Main frmMain = new Solsage_Process_Management_System.Main();
Global.sLogedInUserName = sMasterUserName;
Global.sLogedInUserCode = "00001";
Global.sLogedInUserType = "99";
Global.iCreditInvoice = 1;
Global.bUseBackground = chkUseBackground.Checked;
Solsage_Process_Management_System.Classes.Global.frmLogin = this;
Solsage_Process_Management_System.Classes.Global.frmMain = frmMain;
frmMain.Show();
Cursor = System.Windows.Forms.Cursors.Default;
}
}
