public static Int32 SaveUser(UsersRegistration user)
{
try
{
sqlConnection = new SqlConnection(dataAccess.ConnectionString());
sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "sp_UserReg";
sqlConnection.Close();
sqlCommand.Connection.Open();
sqlCommand.Parameters.AddWithValue("@UserId", user.UserId);
sqlCommand.Parameters.AddWithValue("@UserName", user.UserName);
sqlCommand.Parameters.AddWithValue("@Email", user.UserEmail);
sqlCommand.Parameters.AddWithValue("@Password", user.Password);
int result = sqlCommand.ExecuteNonQuery();
sqlCommand.Connection.Close();
sqlConnection.Close();
return(result);
}
catch (Exception Err)
{
throw new Exception(Err.Message);
}
}
public Int32 SaveUser(UsersRegistration users)
{
try
{
int success = 0;
UsersRegistration user = new UsersRegistration();
user.UserId = users.UserId;
user.UserName = users.UserName;
user.UserEmail = users.UserEmail;
user.Password = users.Password;
if (UserManager.SaveUser(users) > 0)
{
success = 1;
}
else
{
success = 0;
}
return(success);
}
catch (Exception excp)
{
throw excp;
}
}
public static List <UsersRegistration> GetUsersList()
{
try
{
sqlConnection = new SqlConnection(dataAccess.ConnectionString());
sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.Text;
sqlCommand.CommandText = "Select * from tblUsers";
List <UsersRegistration> userList = null;
sqlConnection.Close();
sqlCommand.Connection.Open();
SqlDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.HasRows)
{
userList = new List <UsersRegistration>();
while (dataReader.Read())
{
UsersRegistration user = new UsersRegistration();
user.UserId = Convert.ToInt32(dataReader["UserId"]);
user.UserName = dataReader["UserName"].ToString();
user.UserEmail = dataReader["Email"].ToString();
user.Password = dataReader["Password"].ToString();
userList.Add(user);
}
}
dataReader.Close();
sqlCommand.Connection.Close();
sqlConnection.Close();
return(userList);
}
catch (Exception Err)
{
throw new Exception(Err.Message);
}
}
public static Int32 SaveUser(UsersRegistration user)
{
return(UserGateWay.SaveUser(user));
}
