public ActionResult Update(ForumItemModel model) { ForumItem forumTarget = GetSession.Get <ForumItem>(Convert.ToInt64(Request.Form["Id"])); forumTarget.Admin = GetSession.Get <Employee>(Convert.ToInt64(Request.Form["Admin"])); forumTarget.Title = Request.Form["Title"]; forumTarget.Active = (Request.Form["Active"] == "on") ? true : false; GetSession.Update(forumTarget); #region ADO.NET //string theTitle = Request.Form["Title"]; //long theAdmin = Convert.ToInt32(Request.Form["Admin"]); //long theId = Convert.ToInt32(Request.Form["Id"]); //bool theActive = (Request.Form["Active"] == "on") ? true : false; //SqlConnection sqlConnection1 = new SqlConnection(cs); //SqlCommand cmd = new SqlCommand(); //Int32 rowsAffected; //cmd.CommandText = "UPDATE portal_ForumItem SET Title = '" + theTitle + "', Admin_id = " + theAdmin + ", Active = '" + theActive + "' WHERE Id = " + theId + ""; ////cmd.CommandText = "UPDATE portal_ForumItem SET Title = '" + theTitle + "', Admin_id = " + theAdmin + ", Active = '" + theActive + "' WHERE Id = "+theId+""; //cmd.CommandType = CommandType.Text; //cmd.Connection = sqlConnection1; //sqlConnection1.Open(); //rowsAffected = cmd.ExecuteNonQuery(); //sqlConnection1.Close(); #endregion return(Redirect("/ForumItems/")); }
public ActionResult Create() { var users = GetSession.QueryOver <Employee>().List(); ViewBag.users = users; var model = new ForumItemModel(); return(View(model)); ViewBag.list = GetSession.QueryOver <ForumItem>().List(); }
public ActionResult Create(ForumItemModel model) { var results = Request.Form["ForumUsers[]"]; long adminId; if (!string.IsNullOrEmpty(Request.Form["Admin"])) { adminId = Convert.ToInt64(Request.Form["Admin"]); } else { adminId = GetEmployeeId; } ForumItem newForum = new ForumItem() { Title = !string.IsNullOrEmpty(Request.Form["Title"]) ? Request.Form["Title"] : " פורום חדש", Active = (Request.Form["Active"] == "on") ? true : false, ForumUsers = Request.Form["ForumUsers[]"], Admin = GetSession.Get <Employee>(adminId) }; GetSession.Save(newForum); #region ado.net //string theTitle = Request.Form["Title"]; //long theAdmin = Convert.ToInt32(Request.Form["Admin"]); //bool theActive = (Request.Form["Active"] == "on") ? true : false; //SqlConnection sqlConnection1 = new SqlConnection(cs); //SqlCommand cmd = new SqlCommand(); //Int32 rowsAffected; //cmd.CommandText = "INSERT into portal_ForumItem(Title,Active,Admin_id,ForumUsers) values ('" + theTitle + "', '" + theActive + "', " + theAdmin + ", '" + results + "')"; //cmd.CommandType = CommandType.Text; //cmd.Connection = sqlConnection1; //sqlConnection1.Open(); //rowsAffected = cmd.ExecuteNonQuery(); //sqlConnection1.Close(); #endregion return(Redirect("/ForumItems/")); }
public JavaScriptResult UpdateUsers(ForumItemModel model, string[] users, long id) { string result = ""; if (users != null) { if (users.Length > 0) { result = string.Join(",", users); //return Redirect("/ForumItems/"); } } ForumItem forumTarget = GetSession.Get <ForumItem>(id); forumTarget.ForumUsers = result; GetSession.Save(forumTarget); #region ado.net //string theTitle = Request.Form["Title"]; //long theAdmin = Convert.ToInt32(Request.Form["Admin"]); //long theId = Convert.ToInt32(Request.Form["Id"]); //bool theActive = (Request.Form["Active"] == "on") ? true : false; //SqlConnection sqlConnection1 = new SqlConnection(cs); //SqlCommand cmd = new SqlCommand(); //Int32 rowsAffected; //cmd.CommandText = "UPDATE portal_ForumItem SET Title = '" + theTitle + "', Admin_id = " + theAdmin + ", Active = '" + theActive + "', ForumUsers = '" + result + "' WHERE Id = " + theId + ""; ////cmd.CommandText = "UPDATE portal_ForumItem SET Title = '" + theTitle + "', Admin_id = " + theAdmin + ", Active = '" + theActive + "' WHERE Id = "+theId+""; //cmd.CommandType = CommandType.Text; //cmd.Connection = sqlConnection1; //sqlConnection1.Open(); //rowsAffected = cmd.ExecuteNonQuery(); //sqlConnection1.Close(); #endregion //return RedirectToAction("index"); string js = @"alert('עודכן בהצלחה')"; return(JavaScript(js)); }