public IEnumerable <ListUserLogin> Manage_Partial(Detail data)
{
List <ListUserLogin> results = new List <ListUserLogin>();
try
{
ListUserLogin value = new ListUserLogin();
UserDataContext DropD = new UserDataContext();
var dep = (from xx in DropD.MAS_USER_As
orderby xx.US_ID
select xx).GroupBy(x => x.ANAME).Select(grp => grp.First());
//value.Dep = new SelectList(dep, "US_ID", "ANAME");
var sh = data.sh;
using (UserDataContext Context = new UserDataContext())
{
IQueryable <VW_USER_FOR_LE> DataUser;
DataUser = Context.VW_USER_FOR_LEs;
if (sh.Length > 0)
{
DataUser = DataUser.Where(x => x.STCODE.Contains(sh) || x.NAME.Contains(sh) || x.DPCODE.Contains(sh));
}
List <USER_LOGIN> UserAns = new List <USER_LOGIN>();
foreach (var dx in DataUser)
{
USER_LOGIN ux = new USER_LOGIN();
ux.ID = dx.US_ID;
ux.STCODE = dx.STCODE;
ux.FULLNAME = dx.NAME;
ux.DEP = dx.DPCODE;
ux.A_NAME = dx.ANAME;
UserAns.Add(ux);
//PhoneModels.RowPhone.Add(ipn);
}
value.Userloginid = UserAns;
}
value.sh = sh;
results.Add(value);
}
catch (Exception ex)
{
//Detail res = new Detail();
//res.status = "F";
//res.message = ex.Message;
//results.Add(res);
}
return(results.ToArray());
}
public ActionResult Manage_Partial(int page = 1, string sh = "")
{
UserViewModels Model = new UserViewModels();
data_userDataContext DropD = new data_userDataContext();
var dep = (from xx in DropD.MAS_USER_As
orderby xx.US_ID
select xx).GroupBy(x => x.ANAME).Select(grp => grp.First());
ViewBag.Dep = new SelectList(dep, "US_ID", "ANAME");
sh = sh.Trim();
List <USER_LOGIN> list = new List <USER_LOGIN>();
using (data_userDataContext Context = new data_userDataContext())
{
IQueryable <VW_USER_FOR_LE> DataUser;
DataUser = Context.VW_USER_FOR_LEs;
if (sh.Length > 0)
{
DataUser = DataUser.Where(x => x.STCODE.Contains(sh) || x.NAME.Contains(sh) || x.DPCODE.Contains(sh));
}
foreach (var dx in DataUser)
{
USER_LOGIN ux = new USER_LOGIN();
ux.ID = dx.US_ID;
ux.STCODE = dx.STCODE;
ux.FULLNAME = dx.NAME;
ux.DEP = dx.DPCODE;
ux.A_NAME = dx.ANAME;
list.Add(ux);
//PhoneModels.RowPhone.Add(ipn);
}
//Model.RowUser = list;
}
ViewBag.sh = sh;
return(PartialView(list.ToPagedList(page, 20)));
}