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));
}
