public User_Status GetUserStatus(User_Status userstatus)
{
string fetchUserStatus = $"SELECT * FROM Mobifix_DB.USER_STATUS WHERE LOWER (USER_STATUS_CD) = '{userstatus.UserStatus.ToString() }'";
var dtResult = MySqlUserStatusHelper.ExecuteQuery(fetchUserStatus);
var getuserstatus = FillUserStatusModel(dtResult);
return(getuserstatus.FirstOrDefault <User_Status>());
}
public IHttpActionResult UpdateUserStatus([FromBody] User_Status userstatus)
{
var userstatusRepo = new UserStatusRepository();
var result = userstatusRepo.UpdateUserStatus(userstatus);
if (result <= 0)
{
return(Ok("Error occurred while updating the user status"));
}
return(Ok("User Status updated"));
}
public IHttpActionResult GetUserStatus([FromBody] User_Status userstatus)
{
var userstatusRepo = new UserStatusRepository();
var getuserstatus = userstatusRepo.GetUserStatus(userstatus);
if (getuserstatus == null)
{
return(NotFound());
}
return(Ok(getuserstatus));
}
private IList <User_Status> FillUserStatusModel(DataTable dtUserStatus)
{
var userstatusList = new List <User_Status>();
if (null != dtUserStatus && dtUserStatus.Rows.Count > 0)
{
foreach (DataRow row in dtUserStatus.Rows)
{
var userstatus = new User_Status();
userstatus.UserStatus = Convert.ToString(row["USER_STATUS_CD"]);
userstatus.UserStatusDescription = Convert.ToString(row["USER_STATUS_DESC"]);
userstatusList.Add(userstatus);
}
}
return(userstatusList);
}
public static void Initialize(AppDataContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.User_Statuses.Any())
{
return; // DB has been seeded
}
var user_statuses = new User_Status[]
{
new User_Status {
User_status = "Admin"
},
new User_Status {
User_status = "User"
}
};
foreach (User_Status u_s in user_statuses)
{
context.User_Statuses.Add(u_s);
}
context.SaveChanges();
// Look for any students.
// if (context.Blog_Statuses.Any())
// {
// return; // DB has been seeded
// }
var blog_statuses = new Blog_Status[]
{
new Blog_Status {
blog_status = "Accept"
},
new Blog_Status {
blog_status = "Decline"
},
new Blog_Status {
blog_status = "Waiting"
}
};
foreach (Blog_Status b_s in blog_statuses)
{
context.Blog_Statuses.Add(b_s);
}
context.SaveChanges();
// Look for any students.
if (context.Users.Any())
{
return; // DB has been seeded
}
var users = new User {
Name = "Dmitriy", Login = "******", Password = "******", User_status_id = 1
};
context.Users.Add(users);
context.SaveChanges();
}
public int UpdateUserStatus(User_Status userstatus)
{
string updateUserStatusInfo = $"UPDATE Mobifix_DB.USER_STATUS SET USER_STATUS_DESC = '{userstatus.UserStatusDescription}' WHERE LOWER(USER_STATUS_CD) = '{userstatus.UserStatus.ToString()}' ";
return(MySqlUserStatusHelper.ExecuteNonQuery(updateUserStatusInfo));
}
