public ActionResult Edit(UsersEditViewmodel model)
{
int numberofDay = Weeklist.CheckCronoDay(model.CronoDay);
_userServices.UpdateUser(model.User_id, model.User, model.email, model.First_name, model.Last_name, numberofDay);
return(RedirectToAction("Edit"));
}
public List <UsersEditViewmodel> Getuser(int id, string sql)
{
postgres m = new postgres();
System.Data.DataTable dt = new DataTable();
List <UsersEditViewmodel> mt = new List <UsersEditViewmodel>();
dt = m.SqlQuery(sql, postgres.list = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@id", id)
});
foreach (DataRow dr in dt.Rows)
{
UsersEditViewmodel r = new UsersEditViewmodel();
r.User_id = (int)dr["user_id"];
r.User = dr["username"].ToString();
r.email = (string)dr["email"];
r.First_name = (string)dr["fname"];
r.Last_name = (string)dr["last_name"];
r.CronoDay = Weeklist.CheckCronoNumber((int)dr["day_of_slumpcron"]);
mt.Add(r);
}
return(mt);
}
// GET: Users
public ActionResult Edit()
{
int id = Convert.ToInt32(User.Identity.Name);
UsersEditViewmodel us = new UsersEditViewmodel();
List <UsersEditViewmodel> list = new List <UsersEditViewmodel>();
list = _userServices.Getuser(id, "SELECT users.user_id,users.username,users.email,users.last_name, users.fname, usersettings.day_of_slumpcron FROM public.users LEFT JOIN usersettings ON setting_id = users.settings_id WHERE user_id =@id");
us.First_name = list[0].First_name;
us.email = list[0].email;
us.User = list[0].User;
us.Last_name = list[0].Last_name;
us.CronoDay = list[0].CronoDay;
ViewBag.weeklist = Weeklist.List();
us.User_id = id;
return(View(us));
}
