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)); }