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);
}
}
}
