static void Main(String[] args) { try { UserAdminModules display = new UserAdminModules(); display.AdminUserOperation(); } catch (Exception e) { Console.WriteLine(e.Message); } Console.ReadLine(); }
public void Login(SqlConnection sqlConnection) { Console.WriteLine(statements.nameString); string adminsName = validation.GetName(); Console.WriteLine(statements.passwordString); string adminspassword = validation.GetPassword(); string sql = "Select_AdminProcedure"; SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; SqlParameter param = new SqlParameter(); param.ParameterName = "@UserId"; param.Value = adminsName; param.SqlDbType = SqlDbType.Char; param.Size = 18; sqlCommand.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@password"; param.Value = adminspassword; param.SqlDbType = SqlDbType.Char; param.Size = 18; sqlCommand.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@Action"; param.Value = 2; param.SqlDbType = SqlDbType.Int; param.Size = 18; sqlCommand.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@RoleOfMemeber"; param.Value = "Admin"; param.SqlDbType = SqlDbType.Char; param.Size = 5; sqlCommand.Parameters.Add(param); SqlDataAdapter dataAdapter = new SqlDataAdapter(); dataAdapter.SelectCommand = sqlCommand; DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet, "REPOSITARY"); AdminClass adminClass = new AdminClass(); foreach (DataRow row in dataSet.Tables["REPOSITARY"].Rows) { UserAdminModules user = new UserAdminModules(); adminClass.adminName = row[0].ToString().Trim(); adminClass.adminPassword = row[1].ToString().Trim(); if (adminClass.adminName == adminsName && adminClass.adminPassword == adminspassword) { Console.WriteLine(statements.loginStirng); user.AdminsWork(); } else { Console.WriteLine(statements.secondLoginString); } } }