private void frmLogin_Load(object sender, EventArgs e)
{
txtUserName.Text = "";
txtPassword.Text = "";
#region loadserverside
try
{
Utils.DbCon dbcon = Utils.Helper.ReadConDb("DBCON");
if (string.IsNullOrEmpty(dbcon.DataSource))
{
return;
}
else
{
Utils.Helper.constr = dbcon.ToString();
}
}
catch (Exception ex)
{
}
#endregion
}
private void btnLogin_Click(object sender, EventArgs e)
{
string err = DataValidate();
Utils.DbCon dbcon = Utils.Helper.ReadConDb("DBCON");
Utils.DbCon empdbcon = Utils.Helper.ReadConDb("EMPDBCON");
if (string.IsNullOrEmpty(dbcon.DataSource))
{
var b = new FrmConnection();
b.typeofcon = "DBCON";
b.ShowDialog();
return;
}
else
{
Utils.Helper.constr = dbcon.ToString();
}
if (string.IsNullOrEmpty(empdbcon.DataSource))
{
var b = new FrmConnection();
b.typeofcon = "EMPDBCON";
b.ShowDialog();
return;
}
else
{
Utils.Helper.Empconstr = empdbcon.ToString();
}
if (string.IsNullOrEmpty(err))
{
string sql = "Select * from MastUser Where UserID = '{0}' and Pass = '******' and Active = 'Y'";
DataSet ds = Utils.Helper.GetData(string.Format(sql, txtUserName.Text, txtPassword.Text), dbcon.ToString());
bool hasrows = ds.Tables.Cast <DataTable>().Any(table => table.Rows.Count != 0);
if (hasrows)
{
Utils.User.GUserID = txtUserName.Text.Trim();
Utils.User.GUserPass = txtPassword.Text.Trim();
Utils.User.IsAdmin = (Convert.ToBoolean(ds.Tables[0].Rows[0]["IsAdmin"])) ? true : false;
Utils.User.GUserName = ds.Tables[0].Rows[0]["UserName"].ToString();
this.Hide();
Program.OpenMDIFormOnClose = true;
this.Close();
}
else
{
MessageBox.Show("Invalid login id or Password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void frmConSetup_Load(object sender, EventArgs e)
{
// _serialPort = new SerialPort();
this.cmbComport.Items.Clear();
this.cmbHandShake.Items.Clear();
this.cmbStopbit.Items.Clear();
this.cmbParity.Items.Clear();
foreach (string s in SerialPort.GetPortNames())
{
this.cmbComport.Items.Add(s);
}
foreach (string s in Enum.GetNames(typeof(Handshake)))
{
this.cmbHandShake.Items.Add(s);
}
foreach (string s in Enum.GetNames(typeof(StopBits)))
{
this.cmbStopbit.Items.Add(s);
}
foreach (string s in Enum.GetNames(typeof(Parity)))
{
this.cmbParity.Items.Add(s);
}
dbcon = Utils.Helper.ReadConDb(typeofcon);
cmbComport.Text = dbcon.ComName;
cmbBuadrate.Text = dbcon.Baudrate;
cmbDatabits.Text = dbcon.Databit;
cmbHandShake.Text = dbcon.HandShake;
cmbParity.Text = dbcon.Parity;
cmbStopbit.Text = dbcon.Stopbit;
chkSTXETX.Checked = dbcon.STXETX;
txtStartWT.Text = dbcon.StartWT.ToString();
txtEndWT.Text = dbcon.EndWT.ToString();
txtInputBufferLen.Text = dbcon.InputBufferLen.ToString();
txtOutputPath.Text = dbcon.OutputPath.ToString();
chkReverseFlg.Checked = dbcon.ReverseFlg;
chkDebug.Checked = dbcon.DebugFlg;
chkCustomFun.Checked = dbcon.CustomFunctionFlg;
txtCustomFunctionBlock.Text = dbcon.CustomFunctionBlock;
chkFromTo.Checked = dbcon.FromToFlg;
}
private void FrmConnection_Load(object sender, EventArgs e)
{
if (typeofcon == "DBCON")
{
this.Text = "Connection Builder : " + " Main Database";
}
else
{
this.Text = "Connection Builder : " + " Employee List Database";
}
txtUserID.Text = "";
txtPassword.Text = "";
txtPassword.Enabled = true;
txtUserID.Enabled = true;
dbcon = Utils.Helper.ReadConDb(typeofcon);
txtDataSource.Text = dbcon.DataSource.ToString();
txtUserID.Text = dbcon.DbUser.ToString();
txtPassword.Text = dbcon.Password.ToString();
txtDataBaseName.Text = dbcon.DbName.ToString();
cmbAuth.Text = (dbcon.WindowsAuthentication) ? "Windows Authentication" : "SQL Server Authentication";
}
private void frmLogin_Load(object sender, EventArgs e)
{
txtUserName.Text = "";
txtPassword.Text = "";
#region loadserverside
try
{
Utils.DbCon dbcon = Utils.Helper.ReadConDb("DBCON");
if (string.IsNullOrEmpty(dbcon.DataSource))
{
return;
}
else
{
Utils.Helper.constr = dbcon.ToString();
}
DataSet ds = Utils.Helper.GetData("Select Top 1 * From MastNetWork", Utils.Helper.constr);
bool hasrows = ds.Tables.Cast <DataTable>().Any(table => table.Rows.Count != 0);
if (hasrows)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
Attendance.Classes.Globals.G_ServerWorkerIP = row["ServerWorkerIP"].ToString();
}
}
string hostName = Dns.GetHostName(); // Retrive the Name of HOST
List <string> localip = Utils.Helper.GetLocalIPAddress();
if (localip.Count > 0)
{
bool found = false;
foreach (string ip in localip)
{
if (ip == Attendance.Classes.Globals.G_ServerWorkerIP)
{
Utils.User.GUserID = "SERVER";
Utils.User.GUserPass = string.Empty;
Utils.User.IsAdmin = false;
Utils.User.GUserName = "******";
found = true;
break;
}
}
if (found)
{
this.Hide();
Program.OpenMDIFormOnClose = true;
this.Close();
}
}
}
catch (Exception ex)
{
}
#endregion
}
