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 }