public JsonResult Check(string auser, string apass)
{
channelEntities ch = new channelEntities();
classchannel cs = new classchannel();
try
{
cs.users = (from iduse in ch.users.AsEnumerable()
where iduse.username == auser && iduse.password == apass
select new
{
auser1 = iduse.room.ToString()
}).First();
if (cs.users != null)
{
return(Json(new { status = "200", message = "suc" }));
}
else
{
return(Json(new { status = "500", message = "faill" }));
}
}
catch (Exception e)
{
return(Json(new { status = "500", message = e.Message, data = "error" }));
}
}
public JsonResult Test(string roomat)
{
channelEntities ch = new channelEntities();
classchannel cs = new classchannel();
try
{
cs.users = (from iduse in ch.users.AsEnumerable()
where iduse.room == roomat
select new
{
rooma = iduse.username
}).First();
if (cs.users != null)
{
return(Json(new { status = "200", message = "suc", data = cs.users }));
}
else
{
return(Json(new { status = "500", message = "ไม่มีนะครับ" }));
}
}
catch (Exception e)
{
return(Json(new { status = "500", message = e.Message, data = "ไม่มีนะจ้ะ" }));
}
}
public ActionResult Index()
{
channelEntities ch = new channelEntities();
classchannel cs = new classchannel();
cs.users = (
from full in ch.users.AsEnumerable()
select new
{
id1 = full.id,
username1 = full.username,
password1 = full.password
}).ToList();
return(View(cs));
}
