public ActionResult Lobby() { string email = Session["email"].ToString(); MySqlConnection con = new MySqlConnection("host=localhost;user=Lancher;password=123456;database=lancherdb"); string strSQL = "SELECT * FROM post"; con.Open(); MySqlCommand cmd = new MySqlCommand(strSQL, con); var model = new List <post_model>(); string keepphoto = Session["Photo"].ToString(); MySqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { var post_m = new post_model(); post_m.Title = dr.GetString(1); post_m.PostMoney = dr.GetString(5); post_m.PostDescrip = dr.GetString(2); post_m.PostMany = dr.GetString(3); post_m.TypePost = dr.GetString(4); post_m.DeadlinePost = Convert.ToDateTime(dr.GetString(6)); post_m.ImagUser = keepphoto; ViewBag.showImag = post_m.ImagUser; model.Add(post_m); } } catch { } return(View(model)); }
public ActionResult Post() { string email = Session["email"].ToString(); MySqlConnection con = new MySqlConnection("host=localhost;user=Lancher;password=123456;database=lancherdb"); string strSQL = "SELECT * FROM post WHERE PostEmailID = '" + email + "'"; con.Open(); MySqlCommand cmd = new MySqlCommand(strSQL, con); var model = new List <post_model>(); MySqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { var post_m = new post_model(); post_m.PostID = dr.GetString(0); post_m.Title = dr.GetString(1); post_m.PostMoney = dr.GetString(5); post_m.PostDescrip = dr.GetString(2); post_m.PostMany = dr.GetString(3); post_m.TyprPost = dr.GetString(4); post_m.DeadlinePost = Convert.ToDateTime(dr.GetString(6)); model.Add(post_m); } } catch { } /*try * { * while (rd.Read()) * { * ViewBag.idpost = rd.GetString(0); * ViewBag.Title = rd.GetString(1); * ViewBag.pucket = rd.GetString(5); * ViewBag.des = rd.GetString(2); * ViewBag.Many = rd.GetString(3); * ViewBag.type = rd.GetString(4); * ViewBag.Deadline = rd.GetString(6); * } * * } * catch * { * * }*/ return(View(model)); }
// GET: Post public ActionResult Post() { string email = Session["email"].ToString(); string idpost = Request.Form["111"]; MySqlConnection con = new MySqlConnection("host=localhost;user=Lancher;password=123456;database=lancherdb"); string strSQL = "SELECT post.* FROM post WHERE PostEmailID = '" + email + "'"; //string strSQL = "SELECT post.* , posting.EmailID , posting.PostID FROM posting inner join user on posting.EmailID = user.EmailID inner join post on posting.PostID = post.PostID WHERE posting.PostID = '" + idpost + "' OR post.PostEmailID = '" + email + "'"; con.Open(); MySqlCommand cmd = new MySqlCommand(strSQL, con); var model = new List <post_model>(); //var model = new List<ThreeTableViewModel>(); string keepphoto = Session["Photo"].ToString(); MySqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { //var post_m = new ThreeTableViewModel(); var post_m = new post_model(); post_m.PostID = dr.GetString(0); post_m.Title = dr.GetString(1); post_m.PostMoney = dr.GetString(5); post_m.PostDescrip = dr.GetString(2); post_m.PostMany = dr.GetString(3); post_m.TypePost = dr.GetString(4); post_m.DeadlinePost = Convert.ToDateTime(dr.GetString(6)); //post_m.EmailID = dr["EmailID"].ToString(); //three.EmailID = dr.GetString(0); //ViewBag.EmailID = post_m.EmailID; post_m.ImagUser = keepphoto; Session["Photo"] = post_m.ImagUser; model.Add(post_m); //model1.Add(three); } return(View(model)); } catch { } return(View(model)); }