public static DBActionStatus <bool> UpdateUser(string email, UserGetUpdate user)
{
try
{
using (var connection = new SqlConnection(connString + ";Database=" + dbName))
{
using (var command = new SqlCommand("update_user", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@Surname", user.Surname));
command.Parameters.Add(new SqlParameter("@Name", user.Name));
command.Parameters.Add(new SqlParameter("@Email", email));
command.Parameters.Add(new SqlParameter("@MobilePhone", user.Mobilephone));
connection.Open();
command.ExecuteNonQuery();
return(new DBActionStatus <bool> {
status = ResultType.Success, message = "User updated: " + email, data = true
});
}
}
}
catch (Exception e)
{
return(new DBActionStatus <bool> {
status = ResultType.Error, message = "Unable yo update user: "******" Error: " + e.Message, data = false
});
}
}
public static DBActionStatus <UserGetUpdate> GetUser(string email)
{
try
{
using (var connection = new SqlConnection(connString + ";Database=" + dbName))
{
using (var command = new SqlCommand("get_user", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@Email", email));
connection.Open();
var data = command.ExecuteReader();
if (data.Read())
{
UserGetUpdate user = new UserGetUpdate();
user.Surname = data.GetValue(0).ToString();
user.Name = data.GetValue(1).ToString();
user.Email = data.GetValue(2).ToString();
user.Mobilephone = data.GetValue(3).ToString();
return(new DBActionStatus <UserGetUpdate> {
status = ResultType.Success, message = "User found", data = user
});
}
else
{
return new DBActionStatus <UserGetUpdate> {
status = ResultType.Error, message = "User not found " + email, data = null
}
};
}
}
}
catch (Exception e)
{
return(new DBActionStatus <UserGetUpdate> {
status = ResultType.Error, message = "Error while searching user: "******" Error: " + e.Message, data = null
});
}
}
public ActionResult Update(UserGetUpdate model)
{
if (ModelState.IsValid)
{
string currEmail = User.Identity.Name;
DBActionStatus <bool> result = DBAccess.UpdateUser(currEmail, model);
if (result.status == ResultType.Success)
{
DBAccess.WriteLog("Event", result.message, DateTime.Now);
return(RedirectToAction("Get", "User"));
}
else
{
DBAccess.WriteLog("Error", result.message, DateTime.Now);
ModelState.AddModelError("", result.message);
}
}
else
{
ModelState.AddModelError("", "Invalid data");
}
return(View(model));
}
