public ActionResult GetCustomerGroup(int?page, string search = "") { int pageSize = 50; int pageNumber = (page ?? 1); var data = db.BS_CustomerGroups.Where(p => p.CustomerGroupCode.Contains(search)).OrderByDescending(p => p.CreationDate).Select(p => new { CustomerGroupID = p.CustomerGroupID, CustomerGroupName = p.CustomerGroupName, CustomerGroupCode = p.CustomerGroupCode, Company = p.Company, ConatctPhone = p.ConatctPhone, ContactEmail = p.ContactEmail, ContactAddress = p.ContactAddress, PaymentMethodID = p.PaymentMethodID }).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", page = pageNumber, pageSize = pageSize, toltalSize = data.Count(), data = data.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getThanhVien(int?page, string search = "") { int pageSize = 50; int pageNumber = (page ?? 1); var matruong = new SqlParameter("@MaTruong", MaTruong); var namhoc = new SqlParameter("@NamHoc", NamHoc); //var thanhvien = new SqlParameter("@ThanhVien", true); var data = db.Database.SqlQuery <DMThanhVien>("GET_THANHVIEN_ALL @MaTruong, @NamHoc", matruong, namhoc).ToList(); //var data = db.DM_ThanhVien.Where(p => p.TenThanhVien.Contains(search) && p.MaTruong == MaTruong && p.NamHoc == NamHoc).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", page = pageNumber, pageSize = pageSize, toltalSize = data.Count(), data = data.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetDistrict(int?page, string search = "") { int pageSize = 50; int pageNumber = (page ?? 1); var data = db.BS_Districts.Where(p => p.ProvinceID == search).ToList(); if (search == "") { data = db.BS_Districts.OrderBy(p => p.ProvinceID).ToList(); } ResultInfo result = new ResultWithPaging() { error = 0, msg = "", page = pageNumber, pageSize = pageSize, toltalSize = data.Count(), data = data.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getHocSinhMN(string namhoc) { var data = db.DM_HocSinhMN.Where(p => p.MaTruong == MaTruong).ToList().OrderBy(p => p.NamHoc); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", data = data }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getMenubyID(string id) { var data = db.UMS_GroupMenu.Where(p => p.Type == id).OrderBy(p => p.Position).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", data = data }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getNhomNguoiDung() { var data = db.UMS_UserGroups.Where(p => p.MaTruong == MaTruong || p.MaTruong == "ADMIN").ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", data = data }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getTieuChi(string idtieuchuan) { var id = new SqlParameter("@IDTieuChuan", idtieuchuan); var data = db.Database.SqlQuery <TieuChuanTieuChi>("GET_DM_TIEUCHUAN_TIEUCHI @IDTieuChuan", id).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", data = data }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getTieuChuan() { var caphoc = new SqlParameter("@CapHoc", CapHoc); var data = db.Database.SqlQuery <TieuChuanTieuChi>("GET_TIEUCHUAN @CapHoc", caphoc).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", data = data }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getChiSo(string idtieuchi) { var id = new SqlParameter("@IDTieuChi", idtieuchi); var data = db.Database.SqlQuery <TieuChiChiSo>("GET_CHISO @IDTieuChi", id).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", data = data }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getBaoCao() { //var namhoc = new SqlParameter("@NamHoc", NamHoc); //var matruong = new SqlParameter("@MaTruong", MaTruong); // var data = db.Database.SqlQuery<BaoCaoTieuChuan>("GET_BAOCAOTIEUCHUAN @MaTruong, @NamHoc", matruong, namhoc).ToList(); var data = db.DM_VietTat.Where(p => p.MaTruong == MaTruong).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", data = data }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getTieuChi(string idtieuchuan) { var id = new SqlParameter("@IDTieuChuan", idtieuchuan); var matruong = new SqlParameter("@MaTruong", MaTruong); var namhoc = new SqlParameter("@NamHoc", NamHoc); var data = db.Database.SqlQuery <TieuChuanTieuChi>("GET_TIEUCHI_TIEUCHUAN_MINHCHUNG @IDTieuChuan,@MaTruong,@NamHoc", id, matruong, namhoc).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", data = data }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getTieuChuanbyID(string idquydinh) { //var data = from p in db.HT_TieuChi join t in db.HT_TieuChuan on p.IDTieuChuan equals t.GuiID where t.IDTieuChuan == (idtieuchuan) orderby p.IDTieuChi select p; // var id = new SqlParameter("@idtieuchuan", idtieuchuan); // var ch = new SqlParameter("@idcaphoc", CapHoc); // var data = db.Database.SqlQuery<GET_TIEUCHI_BY_IDTIEUCHUAN>("GET_TIEUCHI_BY_IDTIEUCHUAN @idtieuchuan,@idcaphoc", id, ch).ToList(); var data = db.HT_TieuChuan.Where(p => p.IDQuyDinh == idquydinh).OrderBy(p => p.IDQuyDinh).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", data = data }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getTieuChibyID(int idtieuchuan, string idquydinh) { //var data = from p in db.HT_TieuChi join t in db.HT_TieuChuan on p.IDTieuChuan equals t.GuiID where t.IDTieuChuan == (idtieuchuan) orderby p.IDTieuChi select p; var id = new SqlParameter("@idtieuchuan", idtieuchuan); var qd = new SqlParameter("@idquydinh", idquydinh); var data = db.Database.SqlQuery <GET_TIEUCHI_BY_IDTIEUCHUAN>("GET_TIEUCHI_BY_IDTIEUCHUAN @idtieuchuan,@idquydinh", id, qd).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", toltalSize = data.Count(), data = data }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getTieuChiDuKienbyID(string guiid) { var check = db.DM_DuKienMinhChung.Where(p => p.IDTieuChi == guiid && p.MaTruong == MaTruong && p.NamHoc == NamHoc).FirstOrDefault(); ResultInfo result = new ResultWithPaging(); if (check == null) { result.error = 0; result.data = check; } else { result.error = 1; result.data = check; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult gethocsinh(int?page, string search = "") { int pageSize = 50; int pageNumber = (page ?? 1); var data = db.DM_HocSinh.Where(p => p.MaTruong == MaDonVi && p.Ten.Contains(search) && p.TrangThai == 2).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", page = pageNumber, pageSize = pageSize, toltalSize = data.Count(), data = data.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getDanhGiaTieuChi(string idtieuchi) { var check = db.DM_DanhGiaTieuChi.Where(p => p.IDTieuChi == idtieuchi && p.MaTruong == MaTruong && p.NamHoc == NamHoc).FirstOrDefault(); ResultInfo result = new ResultWithPaging(); if (check == null) { result.error = 0; result.data = check; } else { result.error = 1; result.data = check; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getNguoiDung(int?page) { int pageSize = 50; int pageNumber = (page ?? 1); var data = db.AspNetUsers.Where(p => p.MaTruong == MaTruong).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", page = pageNumber, pageSize = pageSize, toltalSize = data.Count(), data = data.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getTieuChiDuKien(string idtieuchi, string idtieuchuan) { int id = int.Parse(idtieuchi) + 1; var guiid = db.HT_TieuChi.Where(p => p.IDTieuChuan == idtieuchuan && p.IDTieuChi == id).Select(p => p.GuiID).FirstOrDefault(); var check = db.DM_DuKienMinhChung.Where(p => p.IDTieuChi == guiid && p.MaTruong == MaTruong && p.NamHoc == NamHoc).FirstOrDefault(); ResultInfo result = new ResultWithPaging(); if (check == null) { result.error = 0; result.data = guiid; } else { result.error = 1; result.data = guiid; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getMCbyID(int idfrom, int idto) { //var data = from p in db.HT_TieuChi join t in db.HT_TieuChuan on p.IDTieuChuan equals t.GuiID where t.IDTieuChuan == (idtieuchuan) orderby p.IDTieuChi select p; var ifrom = new SqlParameter("@idtieuchuanfrom", idfrom); var ito = new SqlParameter("@idtieuchuanto", idto); var mt = new SqlParameter("@MaTruong", MaTruong); var nh = new SqlParameter("@NamHoc", NamHoc); var data = db.Database.SqlQuery <GET_MINHCHUNG_BYIDTIEUCHUAN>("GET_MINHCHUNG_BYIDTIEUCHUAN @idtieuchuanfrom,@idtieuchuanto,@MaTruong,@NamHoc", ifrom, ito, mt, nh).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", toltalSize = data.Count(), data = data }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getTieuChiChiSo(int?page, string search = "") { int pageSize = 50; int pageNumber = (page ?? 1); var idcaphoc = new SqlParameter("@IDCapHoc", CapHoc); var data = db.Database.SqlQuery <TIEUCHUAN_TIEUCHI_CHISO>("TIEUCHUAN_TIEUCHI_CHISO @IDCapHoc", idcaphoc).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", page = pageNumber, pageSize = pageSize, toltalSize = data.Count(), data = data.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getChiSoMoTa(string guiid) { var matruong = new SqlParameter("@MaTruong", MaTruong); var namhoc = new SqlParameter("@NamHoc", NamHoc); var id = new SqlParameter("@idtieuchi", guiid); var check = db.Database.SqlQuery <ChiSoMoTa>("GET_CHISOMOTA @idtieuchi,@MaTruong, @NamHoc", id, matruong, namhoc).ToList(); ResultInfo result = new ResultWithPaging(); if (check == null) { result.error = 0; result.data = check; } else { result.error = 1; result.data = check; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetDocument(int?page, string fromDate, string toDate, string postId, string employeeId) { int pageSize = 50; int pageNumber = (page ?? 1); if (String.IsNullOrEmpty(fromDate) || String.IsNullOrEmpty(toDate)) { fromDate = DateTime.Now.ToString("dd/MM/yyyy"); toDate = DateTime.Now.ToString("dd/MM/yyyy"); } DateTime paserFromDate = DateTime.Now; DateTime paserToDate = DateTime.Now; try { paserFromDate = DateTime.ParseExact(fromDate, "dd/MM/yyyy", null); paserToDate = DateTime.ParseExact(toDate, "dd/MM/yyyy", null); } catch { paserFromDate = DateTime.Now; paserToDate = DateTime.Now; } var data = db.EMPLOYEE_DEBIT_ALL(paserFromDate.ToString("yyyy-MM-dd"), paserToDate.ToString("yyyy-MM-dd"), postId).Where(p => p.EmployeeID.Contains(employeeId)).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", page = pageNumber, pageSize = pageSize, toltalSize = data.Count(), data = data.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getPriceMatrix(int?page, string fromDate, string toDate, string search = "") { int pageSize = 50; int pageNumber = (page ?? 1); if (String.IsNullOrEmpty(fromDate) || String.IsNullOrEmpty(toDate)) { fromDate = DateTime.Now.ToString("dd/MM/yyyy"); toDate = DateTime.Now.ToString("dd/MM/yyyy"); } DateTime paserFromDate = DateTime.Now; DateTime paserToDate = DateTime.Now; try { paserFromDate = DateTime.ParseExact(fromDate, "dd/MM/yyyy", null); paserToDate = DateTime.ParseExact(toDate, "dd/MM/yyyy", null); } catch { paserFromDate = DateTime.Now; paserToDate = DateTime.Now; } var data = db.BS_PriceMaTrixs.Where(p => p.CreateDate >= paserFromDate.Date && p.CreateDate <= paserToDate.Date).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", page = pageNumber, pageSize = pageSize, toltalSize = data.Count(), data = data.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetReason(int?page, string search = "") { int pageSize = 50; int pageNumber = (page ?? 1); var data = db.BS_ReturnReasons.Where(p => p.ReasonName.Contains(search)).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", page = pageNumber, pageSize = pageSize, toltalSize = data.Count(), data = data.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getThoiGianBieu(int?page, string search = "") { int pageSize = 50; int pageNumber = (page ?? 1); var data = db.DM_ThoiGianBieu.Where(p => p.Tuan.Contains(search) && p.MaTruong == MaTruong && p.NamHoc == NamHoc).ToList().OrderBy(x => x.Tuan); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", page = pageNumber, pageSize = pageSize, toltalSize = data.Count(), data = data.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getMinhChungDuKienAll(int?page) { int pageSize = 50; int pageNumber = (page ?? 1); var matruong = new SqlParameter("@MaTruong", MaTruong); var namhoc = new SqlParameter("@NamHoc", NamHoc); var data = db.Database.SqlQuery <MinhChungDuKien>("GET_MINHCHUNG_DUKIEN @MaTruong,@NamHoc", matruong, namhoc).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", page = pageNumber, pageSize = pageSize, toltalSize = data.Count(), data = data.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getChiSo(int?page, string idtieuchi) { int pageSize = 50; int pageNumber = (page ?? 1); var id = new SqlParameter("@idtieuchi", idtieuchi); var data = db.Database.SqlQuery <TieuChiChiSo>("GET_CHISO @idtieuchi", id).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", page = pageNumber, pageSize = pageSize, toltalSize = data.Count(), data = data.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getDanhGiaTieuChiAll(int?page) { int pageSize = 50; int pageNumber = (page ?? 1); var matruong = new SqlParameter("@MaTruong", MaTruong); var namhoc = new SqlParameter("@NamHoc", NamHoc); var data = db.Database.SqlQuery <DanhGiaTieuChi>("GET_TIEUCHI_DANHGIA @MaTruong,@NamHoc", matruong, namhoc).ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", page = pageNumber, pageSize = pageSize, toltalSize = data.Count(), data = data.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult getDonVi(int?page, string search = "") { int pageSize = 50; int pageNumber = (page ?? 1); var data = db.HT_DonVi.ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", page = pageNumber, pageSize = pageSize, toltalSize = data.Count(), data = data.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetDocument(int?page, string fromDate, string toDate, string customerId) { int pageSize = 50; int pageNumber = (page ?? 1); if (String.IsNullOrEmpty(fromDate) || String.IsNullOrEmpty(toDate)) { fromDate = DateTime.Now.ToString("dd/MM/yyyy"); toDate = DateTime.Now.ToString("dd/MM/yyyy"); } DateTime paserFromDate = DateTime.Now; DateTime paserToDate = DateTime.Now; try { paserFromDate = DateTime.ParseExact(fromDate, "dd/MM/yyyy", null); paserToDate = DateTime.ParseExact(toDate, "dd/MM/yyyy", null); } catch { paserFromDate = DateTime.Now; paserToDate = DateTime.Now; } var data = db.CUSTOMER_COD_DEBIT_GETDOCUMENTS(paserFromDate.ToString("yyyy-MM-dd"), paserToDate.ToString("yyyy-MM-dd"), "%" + customerId + "%").ToList(); ResultInfo result = new ResultWithPaging() { error = 0, msg = "", page = pageNumber, pageSize = pageSize, toltalSize = data.Count(), data = data.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }