public User loginDA(User user) { PasswordProtection pp = new PasswordProtection(); var hashedPassowrd = pp.GenerateSHA256(user.password); Dictionary <string, SqlParameter> queryParameters = new Dictionary <string, SqlParameter>(); queryParameters["userName"] = new SqlParameter("userName", user.userName); queryParameters["password"] = new SqlParameter("password", hashedPassowrd); try { SqlDataReader reader = SqlDatabaseUtility.ExecuteQuery("[dbo].[Login]", queryParameters); while (reader.Read() == true) { if (reader.GetInt32(reader.GetOrdinal("id")) > 0) { user.id = reader.GetInt32(reader.GetOrdinal("id")); user.userName = reader.GetString(reader.GetOrdinal("userName")); user.role = reader.GetInt32(reader.GetOrdinal("role")); } else { user.userName = null; user.role = 0; } } } catch (Exception e) { Console.WriteLine("OOPs, something went wrong.\n" + e); } return(user); }
public string UpdatePasswordDA(User user) { string msg = ""; PasswordProtection pp = new PasswordProtection(); var hashedPassowrd = pp.GenerateSHA256(user.password); Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>(); cmdParameters["id"] = new SqlParameter("id", user.id); cmdParameters["password"] = new SqlParameter("password", hashedPassowrd); int rc = SqlDatabaseUtility.ExecuteCommand("[dbo].[UpdateUsers]", cmdParameters); if (rc == -1) { msg = "Password updated successfully...!"; } else { msg = "OOPs, something went wrong...!"; } return(msg); }
public string CreateUsersDA(User user) { string msg = ""; PasswordProtection pp = new PasswordProtection(); var hashedPassowrd = pp.GenerateSHA256(user.password); Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>(); cmdParameters["userName"] = new SqlParameter("userName", user.userName); cmdParameters["password"] = new SqlParameter("password", hashedPassowrd); cmdParameters["role"] = new SqlParameter("role", user.role); int rc = SqlDatabaseUtility.ExecuteCommand("[dbo].[InsertUser]", cmdParameters); if (rc == -1) { msg = "user create successfully...!"; } else { msg = "OOPs, something went wrong...!"; } return(msg); }