public Result<List<Diem_ett>> select_by_fields(string input, string how)
{
Result<List<Diem_ett>> rs = new Result<List<Diem_ett>>();
try
{
List<Diem_ett> lst = new List<Diem_ett>();
IQueryable<tbl_diem> dt = null;
switch (how)
{
case "masv":
dt = db.tbl_diems.Where(o => o.masv.Contains(input));
break;
case "tensv":
break;
case "mamon":
dt = db.tbl_diems.Where(o => o.mamon.Contains(input));
break;
case "tenmon":
break;
case "diem":
dt = db.tbl_diems.Where(o => o.diem.Contains(input));
break;
default:
break;
}
if (dt.Count() > 0)
{
foreach (tbl_diem item in dt)
{
Diem_ett temp = new Diem_ett(item);
lst.Add(temp);
}
rs.data = lst;
rs.errorCode = ErrorCode.Sucess;
} else
{
rs.data = null;
rs.errorCode = ErrorCode.NaN;
rs.errorInfor = Constants.empty_data;
}
return rs;
}
catch (Exception e)
{
rs.data = null;
rs.errorCode = ErrorCode.False;
rs.errorInfor = e.ToString();
return rs;
}
}
public Result<List<Diem_ett>> select_all_diem()
{
Result<List<Diem_ett>> rs = new Result<List<Diem_ett>>();
try
{
List<Diem_ett> lst = new List<Diem_ett>();
var dt = db.tbl_diems;
if (dt.Count() > 0)
{
foreach (tbl_diem item in dt)
{
Diem_ett temp = new Diem_ett(item);
lst.Add(temp);
}
rs.data = lst;
rs.errorCode = ErrorCode.Sucess;
}
else
{
rs.data = null;
rs.errorCode = ErrorCode.NaN;
rs.errorInfor = Constants.empty_data;
}
return rs;
}
catch (Exception e)
{
rs.data = null;
rs.errorCode = ErrorCode.False;
rs.errorInfor = e.ToString();
return rs;
}
}