public int DeleteUser(User user)
{
try
{
con.Open();
string query = "DELETE FROM Users "
+ "WHERE UserID = @UserID OR Email = @Email";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@UserID", user.UserID);
cmd.Parameters.AddWithValue("@Email", user.Email);
return cmd.ExecuteNonQuery();
}
catch (SqlException i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return 0;
}
catch (Exception i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return 0;
}
finally
{
con.Close();
}
}
public int InsertUser(User user)
{
try
{
con.Open();
string query = "INSERT Users " +
"(Name, " +
"GroupID, " +
"Email, " +
"Password, " +
"Avatar, " +
"UserTypeId, " +
"GenderID, " +
"AuthenticationTypeID)" +
"VALUES " +
"(@Name, " +
"@GroupID, " +
"@Email, " +
"@Password, " +
"@Avatar, " +
"@UserTypeId, " +
"@GenderID, " +
"@AuthenticationTypeID)";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@UserID", user.UserID);
cmd.Parameters.AddWithValue("@Name", user.Name);
cmd.Parameters.AddWithValue("@GroupID", user.GroupID);
cmd.Parameters.AddWithValue("@Email", user.Email);
cmd.Parameters.AddWithValue("@Password", user.Password);
cmd.Parameters.AddWithValue("@Avatar", user.Avatar);
cmd.Parameters.AddWithValue("@UserTypeID", user.UserTypeID);
cmd.Parameters.AddWithValue("@AuthenticationTypeID", user.AuthenticationTypeID);
return cmd.ExecuteNonQuery();
}
catch (SqlException i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return 0;
}
catch (Exception i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return 0;
}
finally
{
con.Close();
}
}
public int SignUp(User user)
{
throw new NotImplementedException();
}
public DataTable SelectUser(User user)
{
try
{
con = new SqlConnection(connectionString);
con.Open();
string query = "SELECT * " +
"FROM USers " +
"WHERE UserID = @UserID OR Name = @Name OR GroupID = @GroupID OR " +
"Email = @Email OR Password = @Password";
cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@UserID", user.UserID);
cmd.Parameters.AddWithValue("@Name", user.Name);
cmd.Parameters.AddWithValue("@GroupID", user.GroupID);
cmd.Parameters.AddWithValue("@Email", user.Email);
cmd.Parameters.AddWithValue("@Password", user.Password);
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "Users");
DataTable dt = ds.Tables["Users"];
return dt;
}
catch (SqlException i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return null;
}
catch (Exception i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return null;
}
finally
{
con.Close();
}
}
public User Login(User user)
{
throw new NotImplementedException();
}
