public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
var data = new List <PRequestHeader>();
if (accessDetail.xem)
{
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "a.");
data = dbConn.Select <PRequestHeader>(@"Select distinct a.* From PRequestHeader a
Inner Join UsersBranch b on b.ma_chi_nhanh = a.ma_chi_nhanh
Where b.ma_nguoi_dung = '" + currentUser.ma_nguoi_dung + "' and " + where);
}
else
{
data = dbConn.Select <PRequestHeader>(@"Select distinct a.* From PRequestHeader a
Inner Join UsersBranch b on b.ma_chi_nhanh = a.ma_chi_nhanh
Where b.ma_nguoi_dung = '" + currentUser.ma_nguoi_dung + "'");
}
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
return(Json(data.ToDataSourceResult(request)));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn())
{
var data = new DataSourceResult();
var query = @"SELECT
Detail.*,
P.nha_cung_cap_id,
V.ten_nha_cung_Cap,
V.dien_thoai,
P.so_hop_dong,
V.email,
P.ghi_chu
FROM ProductPriceHeader P LEFT JOIN Vendor V ON P.nha_cung_cap_id = V.nha_cung_cap_id
LEFT JOIN dbo.ProductPriceDetail Detail ON Detail.ma_chinh_sach_gia = P.ma_chinh_sach_gia
";
if (accessDetail.xem)
{
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0]);
data = KendoApplyFilter.KendoDataByQuery <ProductPriceReport>(request, query, where);
}
else
{
data = KendoApplyFilter.KendoDataByQuery <ProductPriceReport>(request, query, "");
}
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
public ActionResult ExportData([DataSourceRequest] DataSourceRequest request)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
//using (ExcelPackage excelPkg = new ExcelPackage())
FileInfo fileInfo = new FileInfo(Server.MapPath(@"~\ExportExcelFile\NCC.xlsx"));
var excelPkg = new ExcelPackage(fileInfo);
string fileName = "NCC_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
var data = new List <Vendor>();
if (accessDetail.xuat)
{
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
data = dbConn.Select <Vendor>(where).ToList();
}
else
{
data = dbConn.Select <Vendor>().ToList();
}
}
ExcelWorksheet Sheet = excelPkg.Workbook.Worksheets["data"];
int rowData = 7;
int stt = 0;
foreach (var item in data)
{
var contact = dbConn.SingleOrDefault <ContactInfor>("nha_cung_cap_id={0} and nguoi_lien_he_chinh = 1", item.nha_cung_cap_id);
int i = 1;
stt++;
rowData++;
Sheet.Cells[rowData, i++].Value = stt;
Sheet.Cells[rowData, i++].Value = item.ten_nha_cung_cap;
Sheet.Cells[rowData, i++].Value = item.ten_thuong_goi;
Sheet.Cells[rowData, i++].Value = item.ma_so_thue;
Sheet.Cells[rowData, i++].Value = item.dia_chi;
Sheet.Cells[rowData, i++].Value = item.von_dieu_le;
Sheet.Cells[rowData, i++].Value = item.quy_mo;
Sheet.Cells[rowData, i++].Value = item.pham_vi_cung_ung;
//Mat hang kinh doanh
Sheet.Cells[rowData, i++].Value = "";
Sheet.Cells[rowData, i++].Value = item.thoi_gian_cung_ung;
Sheet.Cells[rowData, i++].Value = item.khach_hang_cung_cap;
Sheet.Cells[rowData, i++].Value = item.nha_cung_cap_cua_hdbank;
Sheet.Cells[rowData, i++].Value = contact != null ? contact.ten_nguoi_lien_he : "";
Sheet.Cells[rowData, i++].Value = contact != null ? contact.so_dien_thoai : "";
Sheet.Cells[rowData, i++].Value = contact != null ? contact.email : "";
Sheet.Cells[rowData, i++].Value = item.file_dinh_kem;
Sheet.Cells[rowData, i++].Value = item.ghi_chu;
}
MemoryStream output = new MemoryStream();
excelPkg.SaveAs(output);
output.Position = 0;
return(File(output.ToArray(), contentType, fileName));
}
}
public ActionResult ExportData([DataSourceRequest] DataSourceRequest request)
{
if (asset.Export)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
//using (ExcelPackage excelPkg = new ExcelPackage())
FileInfo fileInfo = new FileInfo(Server.MapPath(@"~\ExportExcelFile\Deca_Telesales_Agent_KPI.xlsx"));
var excelPkg = new ExcelPackage(fileInfo);
string fileName = "Deca_Telesales_Agent_KPI" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
var data = new List <Deca_Telesales_Agent_KPI>();
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
data = dbConn.Select <Deca_Telesales_Agent_KPI>(where).ToList();
}
else
{
data = dbConn.Select <Deca_Telesales_Agent_KPI>().ToList();
}
ExcelWorksheet dataSheet = excelPkg.Workbook.Worksheets["TelesalesAgentKPI"];
int rowData = 1;
foreach (var item in data)
{
int i = 1;
rowData++;
dataSheet.Cells[rowData, i++].Value = item.Agent;
dataSheet.Cells[rowData, i++].Value = item.Revenue;
dataSheet.Cells[rowData, i++].Value = item.Order;
dataSheet.Cells[rowData, i++].Value = item.Call;
dataSheet.Cells[rowData, i++].Value = item.TalkTime;
dataSheet.Cells[rowData, i++].Value = item.CreatedAt;
dataSheet.Cells[rowData, i++].Value = item.CreatedBy;
dataSheet.Cells[rowData, i++].Value = item.UpdatedAt;
dataSheet.Cells[rowData, i++].Value = item.UpdatedBy;
}
MemoryStream output = new MemoryStream();
excelPkg.SaveAs(output);
output.Position = 0;
return(File(output.ToArray(), contentType, fileName));
}
}
else
{
return(Json(new { success = false }));
}
}
//CanhLV
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
var data = new List <User>();
if (accessDetail.xem)
{
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0]);
data = dbConn.Select <User>(@" Select * From
(
Select *
,ISNULL(STUFF ((
Select DISTINCT ',' + a.ma_chi_nhanh
From UsersBranch a
Inner Join Branch b ON a.ma_chi_nhanh = b.ma_chi_nhanh
Where a.ma_nguoi_dung = usr.ma_nguoi_dung
For XML Path('')
), 1, 1, ''),'') AS ma_chi_nhanh
,ISNULL(STUFF ((
Select DISTINCT ',' + b.ten_chi_nhanh
From UsersBranch a
Inner Join Branch b ON a.ma_chi_nhanh = b.ma_chi_nhanh
Where a.ma_nguoi_dung = usr.ma_nguoi_dung
For XML Path('')
), 1, 1, ''),'') AS ten_chi_nhanh
From [User] usr
) data Where " + where
);
}
else
{
data = dbConn.Select <User>(@"Select *
,ISNULL(STUFF ((
Select DISTINCT ',' + a.ma_chi_nhanh
From UsersBranch a
Inner Join Branch b ON a.ma_chi_nhanh = b.ma_chi_nhanh
Where a.ma_nguoi_dung = usr.ma_nguoi_dung
For XML Path('')
), 1, 1, ''),'') AS ma_chi_nhanh
,ISNULL(STUFF ((
Select DISTINCT ',' + b.ten_chi_nhanh
From UsersBranch a
Inner Join Branch b ON a.ma_chi_nhanh = b.ma_chi_nhanh
Where a.ma_nguoi_dung = usr.ma_nguoi_dung
For XML Path('')
), 1, 1, ''),'') AS ten_chi_nhanh
From [User] usr"
);
}
}
return(Json(data.ToDataSourceResult(request)));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
var dbConn = Helpers.OrmliteConnection.openConn();
string whereCondition = "";
if (request.Filters.Count > 0)
{
whereCondition = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
}
var data = dbConn.Select <Parameters>(whereCondition);
return(Json(data.ToDataSourceResult(request)));
}
public ActionResult ExportData([DataSourceRequest] DataSourceRequest request)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
//using (ExcelPackage excelPkg = new ExcelPackage())
FileInfo fileInfo = new FileInfo(Server.MapPath(@"~\ExportExcelFile\User_Template.xlsx"));
var excelPkg = new ExcelPackage(fileInfo);
string fileName = "User_Template_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
var data = new List <tw_User>();
if (accessDetail != null && (accessDetail.access["all"] || accessDetail.access["export"]))
{
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
data = dbConn.Select <tw_User>(where).ToList();
}
else
{
data = dbConn.Select <tw_User>().ToList();
}
}
ExcelWorksheet Sheet = excelPkg.Workbook.Worksheets["Data"];
int rowData = 1;
var territory = dbConn.Select <Territory>();
foreach (var item in data)
{
int i = 1;
rowData++;
Sheet.Cells[rowData, i++].Value = item.name;
Sheet.Cells[rowData, i++].Value = item.fullName;
Sheet.Cells[rowData, i++].Value = item.gender;
Sheet.Cells[rowData, i++].Value = item.birthday;
Sheet.Cells[rowData, i++].Value = item.phone;
Sheet.Cells[rowData, i++].Value = item.email;
Sheet.Cells[rowData, i++].Value = item.address;
Sheet.Cells[rowData, i++].Value = territory.SingleOrDefault(s => s.Id == item.country) != null?territory.SingleOrDefault(s => s.Id == item.country).Name : "";
Sheet.Cells[rowData, i++].Value = territory.SingleOrDefault(s => s.Id == item.city) != null?territory.SingleOrDefault(s => s.Id == item.city).Name : "";
Sheet.Cells[rowData, i++].Value = territory.SingleOrDefault(s => s.Id == item.district) != null?territory.SingleOrDefault(s => s.Id == item.district).Name : "";
}
MemoryStream output = new MemoryStream();
excelPkg.SaveAs(output);
output.Position = 0;
return(File(output.ToArray(), contentType, fileName));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (IDbConnection dbConn = OrmliteConnection.openConn())
{
var data = new DataSourceResult();
string whereCondition = "";
if (request.Filters.Count > 0)
{
whereCondition = " AND " + KendoApplyFilter.ApplyFilter(request.Filters[0], "");
}
data = new CRM_Adv().GetPage(request, whereCondition);
return(Json(data));
}
}
public ActionResult City_Read([DataSourceRequest] DataSourceRequest request)
{
var data = new List <CRM_Location_City>();
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "data.");
data = CRM_Location_City.GetCRM_Location_Citys(where, "CityID DESC");
}
else
{
data = CRM_Location_City.GetCRM_Location_Citys("1=1", "CityID DESC");
}
return(Json(data.ToDataSourceResult(request)));
}
public ActionResult Country_Read([DataSourceRequest] DataSourceRequest request)
{
var data = new List <DC_Location_Countries>();
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "data.");
data = DC_Location_Countries.GetDC_Location_Countries(where, "CountryID DESC");
}
else
{
data = DC_Location_Countries.GetDC_Location_Countries("1=1", "CountryID DESC");
}
return(Json(data.ToDataSourceResult(request)));
}
public ActionResult Alias_Read([DataSourceRequest] DataSourceRequest request)
{
var data = new List <khu_vuc>();
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
data = khu_vuc.GetCRM_Location_Alias(where, "ma_khu_vuc DESC");
}
else
{
data = khu_vuc.GetCRM_Location_Alias("1=1", "ma_khu_vuc DESC");
}
return(Json(data.ToDataSourceResult(request)));
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn())
{
var data = new List <DC_Telesales_ResultList>();
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
data = dbConn.Select <DC_Telesales_ResultList>("SELECT * FROM DC_Telesales_ResultList WHERE " + where).OrderBy(p => p.SubId).ToList();
}
else
{
data = dbConn.Select <DC_Telesales_ResultList>().OrderBy(p => p.Id).ToList();
}
return(Json(data.ToDataSourceResult(request)));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn())
{
var data = new List <DC_Telesales_QuestionList>();
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
data = dbConn.Select <DC_Telesales_QuestionList>(where);
}
else
{
data = dbConn.Select <DC_Telesales_QuestionList>();
}
return(Json(data.ToDataSourceResult(request)));
}
}
public ActionResult TeleSale_Announcement_Read([DataSourceRequest] DataSourceRequest request, string UserName)
{
using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn())
{
var data = new List <DC_TeleSale_AnnouncementByCS>();
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
data = dbConn.Select <DC_TeleSale_AnnouncementByCS>("SELECT * FROM DC_TeleSale_AnnouncementByCS");
}
else
{
data = dbConn.Select <DC_TeleSale_AnnouncementByCS>("SELECT * FROM DC_TeleSale_AnnouncementByCS");
}
return(Json(data.ToDataSourceResult(request)));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
if (asset.View)
{
var dbConn = Helpers.OrmliteConnection.openConn();
string whereCondition = "";
if (request.Filters.Count > 0)
{
whereCondition = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
}
var data = dbConn.Select <CRM_Debit_Management>(whereCondition);
return(Json(data.ToDataSourceResult(request)));
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
if (asset.View)
{
var dbConn = Helpers.OrmliteConnection.openConn();
var data = new List <CRM_CategoryHierarchy>();
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
data = dbConn.Select <CRM_CategoryHierarchy>(where + " Order by ID DESC");
}
data = dbConn.Select <CRM_CategoryHierarchy>();
return(Json(data.ToDataSourceResult(request)));
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult ReadStatement([DataSourceRequest] DataSourceRequest request)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
if (accessDetail.xem)
{
var data = new DataSourceResult();
var strsql = @" SELECT * FROM (SELECT d.*, d.don_gia_vat * d.so_luong AS thanh_tien, b.dia_chi as dia_chi_don_vi
FROM StatementHeader h
INNER JOIN StatementDetail d
ON h.ma_phieu = d.ma_phieu_header
LEFT JOIN dbo.Vendor v
ON d.ma_nha_cung_cap = v.nha_cung_cap_id
INNER JOIN Branch b
on d.ma_chi_nhanh=b.ma_chi_nhanh
and d.ma_don_vi=b.ma_don_vi
WHERE ISNULL(d.ma_don_dat_hang,'') = ''
) data ";
string whereCondition = "";
if (request.Filters != null)
{
if (request.Filters.Count != 0)
{
whereCondition = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
}
else
{
whereCondition = " 1 = 0 ";
}
}
else
{
whereCondition = " 1 = 0 ";
}
data = KendoApplyFilter.KendoDataByQuery <StatementDetail>(request, strsql, whereCondition);
return(Json(data));
}
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn())
{
var data = new List <Group>();
if (accessDetail.xem)
{
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
data = dbConn.Query <Group>(where).ToList();
}
else
{
data = dbConn.Select <Group>().ToList();
}
}
return(Json(data.ToDataSourceResult(request)));
}
}
public ActionResult District_Read([DataSourceRequest] DataSourceRequest request)
{
using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn())
{
var data = new List <CRM_Location_District>();
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "data.");
data = CRM_Location_District.GetCRM_Location_Districts(where, "DistrictID DESC");
}
else
{
data = CRM_Location_District.GetCRM_Location_Districts("1=1", "DistrictID DESC");
}
var a = new DataSourceResult();
a.Data = data;
a.Total = data.Count();
return(Json(a));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
if (accessDetail.xem)
{
var WhereCondition = "";
if (request.Filters != null)
{
if (request.Filters.Count > 0)
{
WhereCondition = " AND " + KendoApplyFilter.ApplyFilter(request.Filters[0], "");
}
}
var data = dbConn.SqlList <ReportQualityService>("EXEC p_Get_ReportQualityService '1','200',@WhereCondition", new { WhereCondition = WhereCondition });
return(Json(data.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn())
{
var data = new List <Users>();
if (asset.View)
{
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
data = dbConn.Query <Users>(where + " AND IsAppUser = 1").ToList();
}
else
{
data = dbConn.Select <Users>("IsAppUser = 1").ToList();
}
}
return(Json(data.ToDataSourceResult(request)));
}
}
public ActionResult ReadPYC([DataSourceRequest] DataSourceRequest request)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
if (accessDetail.xem)
{
var data = new DataSourceResult();
var strsql = @" SELECT * FROM (SELECT pod.*, h.ma_don_vi, h.ma_chi_nhanh, pod.so_luong_duyet*pod.don_gia_vat as thanh_tien
FROM PRequestHeader h
INNER JOIN PRequestDetail pod
ON h.ma_phieu = pod.ma_phieu
LEFT JOIN dbo.Branch d
ON h.ma_chi_nhanh = d.ma_chi_nhanh
WHERE ISNULL(pod.ma_to_trinh,'') = ''
AND h.trang_thai={0}
) data WHERE 1 = 1 ".Params(AllConstant.TRANGTHAI_DA_DUYET);
string whereCondition = "";
if (request.Filters != null)
{
if (request.Filters.Count != 0)
{
whereCondition = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
}
}
//data = KendoApplyFilter.KendoDataByQuery<PRequestDetail>(request, strsql, whereCondition);
//var data = dbConn.SqlList<PORequestDetail>("EXEC p_get_PO_CreateStatement @WhereCondition", new { WhereCondition = whereCondition });
var lstResult = dbConn.SqlList <PRequestDetail>(strsql + whereCondition);
lstResult.ForEach(s => {
if (!string.IsNullOrEmpty(s.ma_san_pham_thay_the))
{
s.ma_san_pham = s.ma_san_pham_thay_the;
}
});
return(Json(lstResult.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
if (accessDetail.xem)
{
//var data = new List<User>();
var WhereCondition = "";
if (request.Filters != null)
{
if (request.Filters.Count > 0)
{
WhereCondition = " AND " + KendoApplyFilter.ApplyFilter(request.Filters[0], "");
}
}
var data = dbConn.SqlList <UserProductCategory>("EXEC p_Get_UserProductCategory 1,200,@WhereCondition", new { WhereCondition = WhereCondition });
return(Json(data.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
if (accessDetail.xem)
{
var query = @"SELECT S.*, B.ten_chi_nhanh AS ten_don_vi FROM InvoiceHeader S LEFT JOIN Branch B ON S.ma_don_vi=B.ma_chi_nhanh";
var data = new DataSourceResult();
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0]);
data = KendoApplyFilter.KendoDataByQuery <InvoiceHeader>(request, query, where);
}
else
{
data = KendoApplyFilter.KendoDataByQuery <InvoiceHeader>(request, query, "");
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (IDbConnection dbConn = OrmliteConnection.openConn())
{
if (asset.View)
{
//string whereCondition = "";
//if (request.Filters.Count > 0)
//{
// whereCondition = " AND " + KendoApplyFilter.ApplyFilter(request.Filters[0], "");
//}
//var data = new CRM_Contract().GetPage(request, whereCondition);
//var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
//jsonResult.MaxJsonLength = int.MaxValue;
//return jsonResult;
string where = "";
if (request.Filters.Count > 0)
{
where = " and " + KendoApplyFilter.ApplyFilter(request.Filters[0], "");
}
//Debug.Write(DateTime.Now);
var data = CRM_Contract.GetPage(request.Page, request.PageSize, where);
//Debug.Write(DateTime.Now);
request.Page = 1;
request.Filters = null;
var result = data.ToDataSourceResult(request);
if (data.Rows.Count > 0)
{
result.Total = Convert.ToInt32(data.Rows[0]["RowCount"]);
}
var jsonResult = Json(result);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult Read_DetailAvoidCallingTimeFrame([DataSourceRequest] DataSourceRequest request, string HeaderID)
{
if (asset.View)
{
using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn())
{
var data = new List <DC_DetailAvoidCallingTimeFrame>();
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
data = dbConn.Select <DC_DetailAvoidCallingTimeFrame>("SELECT * FROM DC_DetailAvoidCallingTimeFrame Where " + where);
}
else
{
data = dbConn.Select <DC_DetailAvoidCallingTimeFrame>("SELECT * FROM DC_DetailAvoidCallingTimeFrame WHERE HeaderID = '" + HeaderID + "'");
}
return(Json(data.ToDataSourceResult(request)));
}
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn())
{
var data = new DataSourceResult();
var query = @"SELECT P.id, P.ma_to_trinh_ncc, P.ten_to_trinh_ncc, P.nha_cung_cap_id, V.ten_nha_cung_Cap, V.dien_thoai, P.so_hop_dong,
V.email, V.dia_chi, V.website, P.ngay_ap_dung, P.ngay_ket_thuc, P.trang_thai, P.ghi_chu, P.ngay_bao_gia
, p.file_hop_dong, p.file_bao_gia, p.nguoi_tao, p.ngay_tao, p.nguoi_cap_nhat, p.ngay_cap_nhat
FROM StatementVendorHeader P LEFT JOIN Vendor V ON P.nha_cung_cap_id = V.nha_cung_cap_id";
if (accessDetail.xem)
{
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0]);
data = KendoApplyFilter.KendoDataByQuery <StatementVendorHeader>(request, query, where);
}
else
{
data = KendoApplyFilter.KendoDataByQuery <StatementVendorHeader>(request, query, "");
}
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
public ActionResult ReadData([DataSourceRequest] DataSourceRequest request)
{
if (asset.View)
{
string where = "";
if (request.Filters.Any())
{
where = " where " + KendoApplyFilter.ApplyFilter(request.Filters[0], "");
}
var data = CRM_Customer_Debt.ReadData(request.Page, request.PageSize, where);
request.Page = 1;
request.Filters = null;
var result = data.ToDataSourceResult(request);
if (data.Rows.Count > 0)
{
result.Total = Convert.ToInt32(data.Rows[0]["RowCount"]);
}
return(Json(result));
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult CSDailyNewView_ReadHot([DataSourceRequest] DataSourceRequest request)
{
if (asset.View)
{
using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn())
{
var data = new List <CRM_CS_Daily_New>();
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
data = dbConn.Select <CRM_CS_Daily_New>("SELECT * FROM CRM_CS_Daily_New Where " + where + " AND Hot = 1 AND [Status] = 1 order by Id DESC");
}
else
{
data = dbConn.Select <CRM_CS_Daily_New>("SELECT * FROM CRM_CS_Daily_New where Hot = 1 AND [Status] = 1 order by Id DESC ");
}
return(Json(data.ToDataSourceResult(request)));
}
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult ReadUserInGroup([DataSourceRequest] DataSourceRequest request, int ma_nhom)
{
using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn())
{
if (accessDetail.xem)
{
var data = new List <UserInGroup>();
if (request.Filters.Any())
{
var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "") + " and ma_nhom =" + ma_nhom;
data = dbConn.Select <UserInGroup>(@"
select * from(
select
u.id,
u.ma_nguoi_dung,
u.ten_nguoi_dung, " +
ma_nhom + @" as ma_nhom,
case when uig.id_nhom_nguoi_dung is null then 0 else 1 end as thuoc_nhom,
u.email,
ISNULL(STUFF ((
Select DISTINCT ',' + a.ma_chi_nhanh
From UsersBranch a
Inner Join Branch b ON a.ma_chi_nhanh = b.ma_chi_nhanh
Where a.ma_nguoi_dung = u.ma_nguoi_dung
For XML Path('')
), 1, 1, ''),'') AS ma_chi_nhanh,
ISNULL(STUFF ((
Select DISTINCT ',' + b.ten_chi_nhanh
From UsersBranch a
Inner Join Branch b ON a.ma_chi_nhanh = b.ma_chi_nhanh
Where a.ma_nguoi_dung = u.ma_nguoi_dung
For XML Path('')
), 1, 1, ''),'') AS ten_chi_nhanh
from [User] u
left join ( Select * From UserInGroup where id_nhom_nguoi_dung = " + ma_nhom + @") uig on uig.ma_nguoi_dung = u.ma_nguoi_dung
) data where " + where);
}
else
{
data = dbConn.Select <UserInGroup>(@" select * from(
select
u.id,
u.ma_nguoi_dung,
u.ten_nguoi_dung, " +
ma_nhom + @" as ma_nhom,
case when uig.id_nhom_nguoi_dung is null then 0 else 1 end as thuoc_nhom,
u.email,
ISNULL(STUFF ((
Select DISTINCT ',' + a.ma_chi_nhanh
From UsersBranch a
Inner Join Branch b ON a.ma_chi_nhanh = b.ma_chi_nhanh
Where a.ma_nguoi_dung = u.ma_nguoi_dung
For XML Path('')
), 1, 1, ''),'') AS ma_chi_nhanh,
ISNULL(STUFF ((
Select DISTINCT ',' + b.ten_chi_nhanh
From UsersBranch a
Inner Join Branch b ON a.ma_chi_nhanh = b.ma_chi_nhanh
Where a.ma_nguoi_dung = u.ma_nguoi_dung
For XML Path('')
), 1, 1, ''),'') AS ten_chi_nhanh
from [User] u
left join ( Select * From UserInGroup where id_nhom_nguoi_dung = " + ma_nhom + @") uig on uig.ma_nguoi_dung = u.ma_nguoi_dung
) data where ma_nhom = " + ma_nhom);
}
return(Json(data.ToDataSourceResult(request)));
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
}