//
// GET: /Nuoi trong man ngot no/
public ActionResult Index(ViewModelSearchNT_NUOC_MANLO Searchmodel)
{
ApplicationUser curUser = this.getCurrentUser();
//Load danh mục:
this.LoadDanhMuc(Searchmodel);
var models = _context.NT_NUOC_MANLO.Where(o => ((string.IsNullOrEmpty(Searchmodel.TThanhPho) && (string.IsNullOrEmpty(curUser.MA_TINHTP) || curUser.MA_TINHTP.StartsWith("Z"))) || (string.IsNullOrEmpty(Searchmodel.TThanhPho) && o.MA_TINHTP == curUser.MA_TINHTP) || o.MA_TINHTP == Searchmodel.TThanhPho) &&
(Searchmodel.Thang == null || o.THANG == Searchmodel.Thang) &&
(Searchmodel.Nam == null || o.NAM == Searchmodel.Nam) &&
(Searchmodel.LoaiBaoCao == null || o.LOAI_BAO_CAO == Searchmodel.LoaiBaoCao) &&
(Searchmodel.TuNgay == null || (o.NGAY_BAO_CAO_TU >= Searchmodel.TuNgay)) &&
(Searchmodel.DenNgay == null || (o.NGAY_BAO_CAO_DEN <= Searchmodel.DenNgay)) &&
(Searchmodel.DoiTuongNuoi == null || o.DSNT_NuocManNoDetail.Any(d => d.ID_DOITUONG_NUOI_MANLO == Searchmodel.DoiTuongNuoi)) &&
(Searchmodel.HinhThucNuoi == null || o.DSNT_NuocManNoDetail.Any(d => d.ID_HINHTHUC_NUOI == Searchmodel.HinhThucNuoi))
)
;
ViewBag.TotalRow = models.Count().ToString();
models = models.OrderByDescending(m => m.ID);
//Phân trang ở đây:
var pageIndex = Searchmodel.Page ?? 1;
Searchmodel.SearchResults = models.ToPagedList(pageIndex, FDB.Common.Constants.PageSize);
return(View(Searchmodel));
}
//Nếu dùng Jquery Validate thì hàm này có thể bỏ
//private String GenderHTML(List<int> lstInt, FormCollection _form, ref int MaxID)
//{
// String strHTML = "";
// int _maxID = 0;
// if (lstInt != null && lstInt.Count > 0)
// {
// List<DM_NHOMDOITUONG_NUOI> lstDMNhomDoiTuongNuoi = _context.DM_NHOMDOITUONG_NUOI.ToList();
// List<DM_DOITUONG_NUOI> lstDMDoiTuongNuoi = _context.DM_DOITUONG_NUOI.ToList();
// List<DM_DOITUONG_NUOI> lstDMDoiTuongNuoiSelected = new List<DM_DOITUONG_NUOI>();
// int ID_NhomDoiTuongSelected = 1;
// for (int i = 0; i < lstInt.Count; i++)
// {
// strHTML += "<tr><td><select class=\"selectNhomNghe\" name=\"ddlID_NUOITRONG_NHOMDOITUONG_" + lstInt[i].ToString() + "\" id=\"ddlID_NUOITRONG_NHOMDOITUONG_" + lstInt[i].ToString() + "\">";
// lstDMNhomDoiTuongNuoi.ForEach(d =>
// {
// if (d.ID.ToString() == _form["ddlID_NUOITRONG_NHOMDOITUONG_" + lstInt[i].ToString()])
// {
// ID_NhomDoiTuongSelected = d.ID;
// strHTML += "<option value=\"" + d.ID.ToString() + "\" selected=\"selected\">" + d.TEN_NHOM + "</option>";
// }
// else
// strHTML += "<option value=\"" + d.ID.ToString() + "\" >" + d.TEN_NHOM + "</option>";
// }
// );
// strHTML += "</td>";
// lstDMDoiTuongNuoiSelected = lstDMDoiTuongNuoi.Where(o => o.DM_NHOMDOITUONG_NUOIID == ID_NhomDoiTuongSelected).ToList();
// strHTML += "<td><select class=\"form-control\" name=\"ddlID_NUOITRONG_DOITUONG_" + lstInt[i].ToString() + "\" id=\"ddlID_NUOITRONG_DOITUONG_" + lstInt[i].ToString() + "\"><option value></option>";
// lstDMDoiTuongNuoiSelected.ForEach(d =>
// {
// if (d.ID.ToString() == _form["ddlID_NUOITRONG_DOITUONG_" + lstInt[i].ToString()])
// strHTML += "<option value=\"" + d.ID.ToString() + "\" selected=\"selected\">" + d.TEN_DOI_TUONG + "</option>";
// else
// strHTML += "<option value=\"" + d.ID.ToString() + "\" >" + d.TEN_DOI_TUONG + "</option>";
// }
// );
// strHTML += "</select>";
// strHTML += "</td>";
// strHTML += "<td><input type=\"text\" value=\"" + _form["txtDIEN_TICH_" + lstInt[i].ToString()] + "\" class=\"form-control\" name=\"txtDIEN_TICH_" + lstInt[i].ToString() + "\"/></td>";
// strHTML += "<td><input type=\"text\" value=\"" + _form["txtSAN_LUONG_" + lstInt[i].ToString()] + "\" class=\"form-control\" name=\"txtSAN_LUONG_" + lstInt[i].ToString() + "\"/></td>";
// strHTML += "<td><input type=\"text\" value=\"" + _form["txtNANG_SUAT_TU_" + lstInt[i].ToString()] + "\" class=\"form-control\" name=\"txtNANG_SUAT_TU_" + lstInt[i].ToString() + "\"/></td>";
// strHTML += "<td><input type=\"text\" value=\"" + _form["txtNANG_SUAT_DEN_" + lstInt[i].ToString()] + "\" class=\"form-control\" name=\"txtNANG_SUAT_DEN_" + lstInt[i].ToString() + "\"/></td>";
// strHTML += "<td><input type=\"text\" value=\"" + _form["txtDIEN_TICH_GAP_" + lstInt[i].ToString()] + "\" class=\"form-control\" name=\"txtDIEN_TICH_GAP_" + lstInt[i].ToString() + "\"/></td>";
// strHTML += "<td><input type=\"text\" value=\"" + _form["txtDIEN_TICH_NUOI_CDK_" + lstInt[i].ToString()] + "\" class=\"form-control\" name=\"txtDIEN_TICH_NUOI_CDK_" + lstInt[i].ToString() + "\"/></td>";
// strHTML += "<td><select class=\"form-control\" name=\"ddlID_MOHINH_NUOI_" + lstInt[i].ToString() + "\">";
// CategoryCommon.DM_MOHINH_NUOIs.ForEach(d =>
// {
// if (d.ID.ToString() == _form["ddlID_MOHINH_NUOI_" + lstInt[i].ToString()])
// strHTML += "<option value=\"" + d.ID.ToString() + "\" selected=\"selected\">" + d.TEN + "</option>";
// else
// strHTML += "<option value=\"" + d.ID.ToString() + "\" >" + d.TEN + "</option>";
// }
// );
// strHTML += "</select>";
// strHTML += "</td>";
// strHTML += "<td><label class=\"BtnPlus\" style=\"cursor:pointer\"><img src=\"/fonts/button-add-icon.png\" title=\"Thêm mới\" /></label>";
// strHTML += "<label class=\"BtnMinus\" id=\"lblDetail_\"" + (i + 1).ToString() + " style=\"cursor:pointer\"><img src=\"/fonts/DELETE.GIF\" title=\"Xóa\" /></label></td>";
// strHTML += "</tr>";
// if (lstInt[i] > _maxID)
// _maxID = lstInt[i];
// }
// }
// MaxID = _maxID;
// return strHTML;
//}
public void LoadDanhMuc(ViewModelSearchNT_NUOC_MANLO Searchmodel)
{
//Load danh mục:
ApplicationUser curUser = this.getCurrentUser();
var tinh = _context.DTINHTP.Where(u => (curUser.MA_TINHTP == null || curUser.MA_TINHTP.StartsWith("Z")) || u.MA_TINHTP == curUser.MA_TINHTP)
.Except(_context.DTINHTP.Where(d => d.MA_TINHTP.StartsWith("Z")));
ViewBag.DMTThanhPho = new SelectList(tinh, "MA_TINHTP", "TEN_TINHTP", Searchmodel.TThanhPho);
// ViewBag.DMQhuyen = new SelectList(_context.DQUANHUYEN, "MA_QUANHUYEN", "TEN_QUANHUYEN", Searchmodel.Qhuyen);
ViewBag.DMMoHinhNuoi = new SelectList(_context.DM_HINHTHUC_NUOI, "ID", "TEN_HINH_THUC", Searchmodel.HinhThucNuoi);
var doituongManLo = _context.DM_DOITUONG_NUOI_MANLO.Where(d => d.LOAI_DOI_TUONG == Searchmodel.DoiTuongNuoi);
ViewBag.DMDoiTuongNuoi = new SelectList(doituongManLo, "ID", "TEN_DOI_TUONG", Searchmodel.DoiTuongNuoi);
ViewBag.DEFAULT_VALUE_DDL = CategoryCommon.DEFAULT_VALUE_DDL;
}
