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