Esempio n. 1
0
 public virtual dsLogon.employeeDataTable GetData(string password)
 {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((password == null))
     {
         throw new global::System.ArgumentNullException("password");
     }
     else
     {
         this.Adapter.SelectCommand.Parameters[0].Value = ((string)(password));
     }
     dsLogon.employeeDataTable dataTable = new dsLogon.employeeDataTable();
     this.Adapter.Fill(dataTable);
     return(dataTable);
 }
Esempio n. 2
0
        public virtual int Fill(dsLogon.employeeDataTable dataTable, string password)
        {
            this.Adapter.SelectCommand = this.CommandCollection[0];
            if ((password == null))
            {
                throw new global::System.ArgumentNullException("password");
            }
            else
            {
                this.Adapter.SelectCommand.Parameters[0].Value = ((string)(password));
            }
            if ((this.ClearBeforeFill == true))
            {
                dataTable.Clear();
            }
            int returnValue = this.Adapter.Fill(dataTable);

            return(returnValue);
        }
Esempio n. 3
0
        public void ValidatePassword(string connectionString, string password, out string opName, out string opCode, out string error)
        {
            opName = "";
            opCode = "";
            error  = "";
            try
            {
                using (var eta = new employeeTableAdapter())
                {
                    eta.Connection.ConnectionString = connectionString;
                    dsLogon.employeeDataTable edt = eta.GetData(password);

                    if (edt.Rows.Count > 0)
                    {
                        opName = edt[0].name;
                        opCode = edt[0].operator_code;
                    }
                }
            }
            catch (SqlException ex)
            {
                if (ex.InnerException != null)
                {
                    error = "Sql Exception: " + ex.InnerException.ToString();
                }
                else
                {
                    error = "Sql Exception: " + ex.Message;
                }
            }
            catch (Exception ex)
            {
                if (ex.InnerException != null)
                {
                    error = "Exception: " + ex.InnerException.ToString();
                }
                else
                {
                    error = "Exception: " + ex.Message;
                }
            }
        }
Esempio n. 4
0
 public virtual int Update(dsLogon.employeeDataTable dataTable)
 {
     return(this.Adapter.Update(dataTable));
 }