private void RespondeWithFile(DataSourceRequest request, string filename)
{
string mimeType = string.Empty;
string ext = Path.GetExtension(filename);
if (ext == ".html") mimeType = "text/html";
if (ext == ".png") mimeType = "image/png";
if (ext == ".gif") mimeType = "image/gif";
if (ext == ".js") mimeType = "application/javascript";
if (ext == ".css") mimeType = "text/css";
//if (ext == ".webm") mimeType = "video/webm";
if (mimeType.Length > 0)
{
byte[] buffer = File.ReadAllBytes(filename);
IntPtr tmpPtr = Marshal.AllocHGlobal(buffer.Length);
Marshal.Copy(buffer, 0, tmpPtr, buffer.Length);
DataSourceResponse response = new DataSourceResponse() { Buffer = tmpPtr, Size = (uint)buffer.Length, MimeType = mimeType };
SendResponse(request, response);
Marshal.FreeHGlobal(tmpPtr);
}
else
{
SendRequestFailed(request);
}
}
protected override void OnRequest(DataSourceRequest request)
{
var path = request.Path.ToLower();
if (!(_dataPak.ContainsKey(path)))
{
SendResponse(request, new DataSourceResponse { Buffer = IntPtr.Zero, MimeType = request.MimeType, Size = 0 });
return;
}
var fileInfo = _dataPak[path];
var ms = new MemoryStream();
using (var source = new MemoryStream())
{
byte[] buffer = new byte[4096];
using (var fs = OpenFile())
{
fs.Seek(fileInfo.Position, SeekOrigin.Begin);
int count, max = fileInfo.Length;
while ((count = fs.Read(buffer, 0, Math.Min(4096, max))) > 0)
{
source.Write(buffer, 0, count);
max -= count;
if (max == 0)
{
break;
}
}
}
source.Seek(0, SeekOrigin.Begin);
using (var gzip = fileInfo.IsGziped ? (Stream)new GZipStream(source, CompressionMode.Decompress) : new BufferedStream(source))
{
int count;
while ((count = gzip.Read(buffer, 0, 4096)) > 0)
{
ms.Write(buffer, 0, count);
}
ms.Flush();
}
}
var data = ms.ToArray();
ms.Dispose();
unsafe
{
fixed (byte* pdata = data)
{
IntPtr ptr = new IntPtr(pdata);
DataSourceResponse response = new DataSourceResponse
{
Buffer = ptr,
Size = (uint)data.Length,
MimeType = request.MimeType
};
SendResponse(request, response);
}
}
}
protected override void OnRequest(DataSourceRequest request)
{
//Console.WriteLine("DataSource: {0}\tHost: {1}\tPathAndQuery: {2}\tLocalPath: {3}", request.Url, request.Url.Host, request.Url.PathAndQuery, request.Url.LocalPath);
string path = request.Url.LocalPath.Trim('/','\\');
string[] pathParts = path.Split('/', '\\');
NameValueCollection QS = HttpUtility.ParseQueryString(request.Url.Query);
if (pathParts.Length > 0)
{
if (pathParts[0] == "home")
{
RespondeWithFile(request, ".\\core\\home.html");
}
else if (pathParts[0] == "about")
{
RespondeWithFile(request, ".\\core\\about.html");
}
else if (pathParts[0] == "options")
{
RespondeWithFile(request, ".\\core\\options.html");
}
else if (pathParts[0] == "images")
{
string palletName = QS["pallet"];
if(palletName != null)
{
PalletCache tmpCache = PalletCache.GetInstance();
Image returnImage = tmpCache.ColorizeImage(palletName, Image.FromFile(".\\core\\images\\" + string.Join("\\", pathParts.Skip(1))));
RespondeWithPng(request, returnImage);
}
else
{
RespondeWithFile(request, ".\\core\\images\\" + string.Join("\\", pathParts.Skip(1)));
}
}
else if (pathParts[0] == "scripts")
{
RespondeWithFile(request, ".\\core\\scripts\\" + string.Join("\\", pathParts.Skip(1)));
}
else if (pathParts[0] == "styles")
{
RespondeWithFile(request, ".\\core\\styles\\" + string.Join("\\", pathParts.Skip(1)));
}
}
else
{
SendRequestFailed(request);
}
/*if (request.Path == "index.html")
{
//SendResponse(request, DataSourceResponse
}*/
}
public bool HandleRequest(DataSourceRequest request, Action<DataSourceResponse> respond)
{
var handled = first.HandleRequest(request, respond);
if (handled || next == null)
{
return handled;
}
else
{
return next.HandleRequest(request, respond);
}
}
protected override void OnRequest(DataSourceRequest request)
{
try
{
var handled = HandleRequest(request, (response) => SendResponse(request, response));
if (!handled)
{
SendRequestFailed(request);
}
}
catch
{
SendRequestFailed(request);
}
}
public bool HandleRequest(DataSourceRequest request, Action<DataSourceResponse> respond)
{
try
{
Uri uri;
if (!request.Path.StartsWith("urimap/"))
{
return false;
}
else
{
string path = request.Path.Substring("urimap/".Length);
lock (o)
{
uri = map[path];
}
if (!uri.IsFile)
throw new NotImplementedException("Mapping to non-local URIs not yet implemented.");
using (var stream = File.OpenRead(uri.LocalPath))
{
byte[] bytes = new byte[stream.Length];
stream.Read(bytes, 0, (int)stream.Length);
GCHandle pinnedBuffer = GCHandle.Alloc(bytes, GCHandleType.Pinned);
IntPtr pointer = pinnedBuffer.AddrOfPinnedObject();
respond(new DataSourceResponse
{
Buffer = pointer,
Size = (uint)bytes.Length
});
pinnedBuffer.Free();
}
}
return true;
}
catch
{
return false;
}
}
public bool HandleRequest(DataSourceRequest request, Action<DataSourceResponse> respond)
{
try
{
var bg = DataManager.Backgrounds.GetFile("/" + request.Path);
using (WebClient client = new WebClient())
{
var bytes = client.DownloadData(bg.Uri);
// TODO: is this buffer ever freed again?
GCHandle pinnedBuffer = GCHandle.Alloc(bytes, GCHandleType.Pinned);
IntPtr pointer = pinnedBuffer.AddrOfPinnedObject();
respond(new DataSourceResponse
{
Buffer = pointer,
Size = (uint)bytes.Length
});
}
return true;
}
catch
{
return false;
}
}
public bool HandleRequest(DataSourceRequest request, Action<DataSourceResponse> respond)
{
try
{
using (var stream = assembly.GetResourceStream(request.Path))
{
byte[] buffer = new byte[stream.Length];
stream.Read(buffer, 0, (int)stream.Length);
GCHandle pinnedBuffer = GCHandle.Alloc(buffer, GCHandleType.Pinned);
IntPtr pointer = pinnedBuffer.AddrOfPinnedObject();
respond(new DataSourceResponse
{
Buffer = pointer,
Size = (uint)stream.Length
});
pinnedBuffer.Free();
return true;
}
}
catch
{
return false;
}
}
public ActionResult HierarchyBinding_Orders(int employeeID, [DataSourceRequest] DataSourceRequest request)
{
return(Json(GetOrders()
.Where(order => order.EmployeeID == employeeID)
.ToDataSourceResult(request)));
}
public ActionResult GetPersons([DataSourceRequest] DataSourceRequest dsRequest)
{
var result = people.ToDataSourceResult(dsRequest);
return(Json(result));
}
public ActionResult List([DataSourceRequest] DataSourceRequest request)
{
var list = customerVisitCategoryProvider.ListCustomerVisitCategories();
return(Json(list.ToDataSourceResult(request)));
}
private void RespondeWithPng(DataSourceRequest request, Image image)
{
byte[] buffer = new byte[0];
using (MemoryStream stream = new MemoryStream())
{
image.Save(stream, System.Drawing.Imaging.ImageFormat.Png);
stream.Close();
buffer = stream.ToArray();
}
IntPtr tmpPtr = Marshal.AllocHGlobal(buffer.Length);
Marshal.Copy(buffer, 0, tmpPtr, buffer.Length);
DataSourceResponse response = new DataSourceResponse() { Buffer = tmpPtr, Size = (uint)buffer.Length, MimeType = "image/png" };
SendResponse(request, response);
Marshal.FreeHGlobal(tmpPtr);
}
public DataSourceResult GetAllUsers(DataSourceRequest request)
{
return(UserBiz.Read(u => true, true).Include(u => u.Membership)
.MapTo <UserInfoPm>()
.ToDataSourceResult(request));
}
public ActionResult Update([DataSourceRequest] DataSourceRequest request, ModelType model)
{
return(this.BaseUpdate(request, model));
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
return(Json(db.Contacts.ToDataSourceResult(request)));
}
public ActionResult Brands_Read([DataSourceRequest] DataSourceRequest request)
{
var resultBrands = brands.GetAll().ProjectTo <BrandViewModel>();
return(Json(resultBrands.ToDataSourceResult(request)));
}
public IEnumerable <Lookup> Get(string Type, string SearchText, DataSourceRequest dataSourceRequest, Dictionary <string, object> args, object[] ids = null)
{
args = args ?? new Dictionary <string, object>();
IEnumerable <Lookup> result = null;
switch (Type.ToLower())
{
case "categories":
result = _unitOfWork.Repository <Category>().GetAll()
//.Where(x => string.IsNullOrEmpty(SearchText) || x.CategoryNameAr.Contains(SearchText) || x.CategoryNameEn.Contains(SearchText) || x.CategoryCode.Contains(SearchText))
//.Where(x => ids == null || ids.Select(id => Convert.ToInt32(id)).Contains(x.PermissionId))
.ToDataSourceResult(dataSourceRequest, true).Data
.Select(x => new Lookup
{
Id = x.CategoryId,
TextAr = x.CategoryNameAr,
TextEn = x.CategoryNameEn
}).OrderBy(x => x.Id);
break;
case "subcategories":
result = _unitOfWork.Repository <SubCategory>().GetAll()
//.Where(x => string.IsNullOrEmpty(SearchText) || x.CategoryNameAr.Contains(SearchText) || x.CategoryNameEn.Contains(SearchText) || x.CategoryCode.Contains(SearchText))
//.Where(x => ids == null || ids.Select(id => Convert.ToInt32(id)).Contains(x.PermissionId))
.ToDataSourceResult(dataSourceRequest, true).Data
.Select(x => new Lookup
{
Id = x.SubCategoryId,
TextAr = x.SubCategoryNameAr,
TextEn = x.SubCategoryNameEn,
Additional = new LookupAdditional {
Data = x.CategoryId
}
}).OrderBy(x => x.Id);
break;
// case "permissions":
// result = _unitOfWork.Repository<Permission>().GetAllAsync().Result
// .Where(x => string.IsNullOrEmpty(SearchText) || x.PermissionNameAr.Contains(SearchText) || x.PermissionNameEn.Contains(SearchText) || x.PermissionCode.Contains(SearchText))
// .Where(x => ids == null || ids.Select(id => Convert.ToInt32(id)).Contains(x.PermissionId))
// .ToDataSourceResult(dataSourceRequest, true).Data
// .Select(x => new Lookup
// {
// Id = x.PermissionId,
// Text = CultureInfo.CurrentCulture.TwoLetterISOLanguageName.ToString().StartsWith("ar") ? (string.IsNullOrEmpty(x.PermissionNameAr) ? x.PermissionNameEn : x.PermissionNameAr) : (string.IsNullOrEmpty(x.PermissionNameEn) ? x.PermissionNameAr : x.PermissionNameEn),
// }).OrderBy(x => x.Text);
// break;
// case "genders":
// result = _unitOfWork.Repository<Gender>().GetAllAsync().Result
// .Where(x => string.IsNullOrEmpty(SearchText) || x.GenderNameAr.Contains(SearchText) || x.GenderNameEn.Contains(SearchText))
// .Where(x => ids == null || ids.Select(id => Convert.ToInt32(id)).Contains(x.GenderId))
// .ToDataSourceResult(dataSourceRequest, true).Data
// .Select(x => new Lookup
// {
// Id = x.GenderId,
// Text = CultureInfo.CurrentCulture.TwoLetterISOLanguageName.ToString().StartsWith("ar") ? (string.IsNullOrEmpty(x.GenderNameAr) ? x.GenderNameEn : x.GenderNameAr) : (string.IsNullOrEmpty(x.GenderNameEn) ? x.GenderNameAr : x.GenderNameEn)
// }).OrderBy(x => x.Text);
// break;
// case "jobtitles":
// result = _unitOfWork.Repository<JobTitle>().GetAllAsync().Result
// .Where(x => string.IsNullOrEmpty(SearchText) || x.JobTitleNameAr.Contains(SearchText) || x.JobTitleNameEn.Contains(SearchText))
// .Where(x => ids == null || ids.Select(id => Convert.ToInt32(id)).Contains(x.JobTitleId))
// .ToDataSourceResult(dataSourceRequest, true).Data
// .Select(x => new Lookup
// {
// Id = x.JobTitleId,
// Text = CultureInfo.CurrentCulture.TwoLetterISOLanguageName.ToString().StartsWith("ar") ? (string.IsNullOrEmpty(x.JobTitleNameAr) ? x.JobTitleNameEn : x.JobTitleNameAr) : (string.IsNullOrEmpty(x.JobTitleNameEn) ? x.JobTitleNameAr : x.JobTitleNameEn)
// }).OrderBy(x => x.Text);
// break;
// case "nationalities":
// result = _unitOfWork.Repository<Nationality>().GetAllAsync().Result
// .Where(x => string.IsNullOrEmpty(SearchText) || x.NationalityNameAr.Contains(SearchText) || x.NationalityNameEn.Contains(SearchText))
// .Where(x => ids == null || ids.Select(id => Convert.ToInt32(id)).Contains(x.NationalityId))
// .ToDataSourceResult(dataSourceRequest, true).Data
// .Select(x => new Lookup
// {
// Id = x.NationalityId,
// Text = CultureInfo.CurrentCulture.TwoLetterISOLanguageName.ToString().StartsWith("ar") ? (string.IsNullOrEmpty(x.NationalityNameAr) ? x.NationalityNameEn : x.NationalityNameAr) : (string.IsNullOrEmpty(x.NationalityNameEn) ? x.NationalityNameAr : x.NationalityNameEn)
// }).OrderBy(x => x.Text);
// break;
// case "organizations":
// result = _unitOfWork.Repository<Organization>().GetAllAsync().Result
// .Where(x => x.IsActive)
// .Where(x => string.IsNullOrEmpty(SearchText) || x.OrganizationNameAr.Contains(SearchText) || x.OrganizationNameEn.Contains(SearchText) || x.Code.ToString().Contains(SearchText))
// .Where(x => ids == null || ids.Select(id => Convert.ToInt32(id)).Contains(x.OrganizationId))
// .ToDataSourceResult(dataSourceRequest, true).Data
// .Select(x => new Lookup
// {
// Id = x.OrganizationId,
// Text = x.Code.ToString() + " - " + (CultureInfo.CurrentCulture.TwoLetterISOLanguageName.ToString().StartsWith("ar") ? (string.IsNullOrEmpty(x.OrganizationNameAr) ? x.OrganizationNameEn : x.OrganizationNameAr) : (string.IsNullOrEmpty(x.OrganizationNameEn) ? x.OrganizationNameAr : x.OrganizationNameEn)),
// Additional = new LookupAdditional
// {
// Description = x.FullPath
// }
// }).OrderBy(x => x.Text);
// break;
// case "roles":
// result = _unitOfWork.Repository<Role>().GetAllAsync().Result
// .Where(x => string.IsNullOrEmpty(SearchText) || x.RoleNameAr.Contains(SearchText) || x.RoleNameEn.Contains(SearchText))
// .Where(x => ids == null || ids.Select(id => Convert.ToInt32(id)).Contains(x.RoleId))
// .ToDataSourceResult(dataSourceRequest, true).Data
// .Select(x => new Lookup
// {
// Id = x.RoleId,
// Text = x.RoleName,
// }).OrderBy(x => x.Text);
// break;
// case "notificationtypes":
// result = _unitOfWork.Repository<NotificationType>().GetAllAsync().Result
// .Where(x => string.IsNullOrEmpty(SearchText) || x.NotificationTypeNameAr.Contains(SearchText) || x.NotificationTypeNameEn.Contains(SearchText))
// .Where(x => ids == null || ids.Select(id => Convert.ToInt32(id)).Contains(x.NotificationTypeId))
// .ToDataSourceResult(dataSourceRequest, true).Data
// .Select(x => new Lookup
// {
// Id = x.NotificationTypeId,
// Text = CultureInfo.CurrentCulture.TwoLetterISOLanguageName.ToString().StartsWith("ar") ? (string.IsNullOrEmpty(x.NotificationTypeNameAr) ? x.NotificationTypeNameEn : x.NotificationTypeNameAr) : (string.IsNullOrEmpty(x.NotificationTypeNameEn) ? x.NotificationTypeNameAr : x.NotificationTypeNameEn)
// });
// break;
// case "users":
// OrganizationId = args.GetValue<int?>("OrganizationId");
// result = _unitOfWork.Repository<User>().GetAllAsync().Result
// .Where(x => !OrganizationId.HasValue || x.UserRoles.Any(ur => ur.OrganizationId == OrganizationId))
// .Where(x => string.IsNullOrEmpty(SearchText) || x.FullNameAr.Contains(SearchText) || x.FullNameEn.Contains(SearchText) || x.Email.StartsWith(SearchText))
// .Where(x => ids == null || ids.Select(id => Convert.ToInt32(id)).Contains(x.UserId))
// .ToDataSourceResult(dataSourceRequest, true).Data
// .Select(x => new Lookup
// {
// Id = x.UserId,
// Text = CultureInfo.CurrentCulture.TwoLetterISOLanguageName.ToString().StartsWith("ar") ? (string.IsNullOrEmpty(x.FullNameAr) ? x.FullNameEn : x.FullNameAr) : (string.IsNullOrEmpty(x.FullNameEn) ? x.FullNameAr : x.FullNameEn)
// //Additional = new LookupAdditional { ImageId = x.ProfileImageFileId, Data = new { CanReceiveNotification = x.NotificationByMail || x.NotificationBySMS } }
// }).OrderBy(x => x.Text);
// break;
// case "permissioncategories":
// result = _unitOfWork.Repository<PermissionCategory>().GetAllAsync().Result.ToDataSourceResult(dataSourceRequest, true).Data
// .Select(x => new Lookup
// {
// Id = x.PermissionCategoryId,
// Text = CultureInfo.CurrentCulture.TwoLetterISOLanguageName.ToString().StartsWith("ar") ? (string.IsNullOrEmpty(x.PermissionCategoryNameAr) ? x.PermissionCategoryNameEn : x.PermissionCategoryNameAr) : (string.IsNullOrEmpty(x.PermissionCategoryNameEn) ? x.PermissionCategoryNameAr : x.PermissionCategoryNameEn)
// }).OrderBy(x => x.Text);
// break;
default:
throw new BusinessException("No lookup defined for this type");
}
return(result);
}
public ActionResult ExportWHL([DataSourceRequest] DataSourceRequest request)
{
if (userAsset["Export"])
{
using (var dbConn = new OrmliteConnection().openConn())
{
//using (ExcelPackage excelPkg = new ExcelPackage())
FileInfo fileInfo = new FileInfo(Server.MapPath(@"~\ExportTemplate\ViTriKho.xlsx"));
var excelPkg = new ExcelPackage(fileInfo);
string fileName = "ViTriKho_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
var data = new List <WareHouseLocation>();
if (request.Filters.Any())
{
var where = new KendoApplyFilter().ApplyFilter(request.Filters[0], "data.");
data = data = dbConn.Query <WareHouseLocation>("p_SelectWareHouseLocation_Export", new { WhereCondition = where }, commandType: System.Data.CommandType.StoredProcedure).ToList();
}
else
{
data = data = dbConn.Query <WareHouseLocation>("p_SelectWareHouseLocation_Export", new { WhereCondition = "1=1" }, commandType: System.Data.CommandType.StoredProcedure).ToList();
}
ExcelWorksheet expenseSheet = excelPkg.Workbook.Worksheets["Data"];
int rowData = 1;
foreach (var item in data)
{
int i = 1;
rowData++;
expenseSheet.Cells[rowData, i++].Value = item.WHLID;
expenseSheet.Cells[rowData, i++].Value = item.WHLName;
expenseSheet.Cells[rowData, i++].Value = item.WHName + "/" + item.WHID;
expenseSheet.Cells[rowData, i++].Value = item.Note;
if (item.Status == true)
{
expenseSheet.Cells[rowData, i++].Value = "Đang hoạt động";
}
else
{
expenseSheet.Cells[rowData, i++].Value = "Ngưng hoạt động";
}
expenseSheet.Cells[rowData, i++].Value = item.CreatedBy;
expenseSheet.Cells[rowData, i++].Value = item.CreatedAt;
expenseSheet.Cells[rowData, i++].Value = item.UpdatedBy;
if (item.UpdatedAt != DateTime.Parse("1900-01-01"))
{
expenseSheet.Cells[rowData, i++].Value = item.UpdatedAt;
}
else
{
expenseSheet.Cells[rowData, i++].Value = "";
}
}
expenseSheet = excelPkg.Workbook.Worksheets["Kho"];
var listWH = dbConn.Select <WareHouse>("SELECT * FROM WareHouse WHERE Status = 1");
rowData = 1;
foreach (var item in listWH)
{
int i = 1;
rowData++;
expenseSheet.Cells[rowData, i++].Value = item.WHName + "/" + item.WHID;
}
MemoryStream output = new MemoryStream();
excelPkg.SaveAs(output);
output.Position = 0;
return(File(output.ToArray(), contentType, fileName));
}
}
else
{
return(Json(new { success = false }));
}
}
public async Task <IActionResult> GetItems([DataSourceRequest] DataSourceRequest request)
{
var items = await _context.Items.ToListAsync();
return(Json(items.ToDataSourceResult(request)));
}
public ActionResult MJobs_Read([DataSourceRequest] DataSourceRequest request)
{
return(Json(GetMJobs().ToDataSourceResult(request)));
}
public static IEnumerable <T> PagedForCommand <T>(this IEnumerable <T> current, DataSourceRequest command)
{
return(current.Skip((command.Page - 1) * command.PageSize).Take(command.PageSize));
}
public async Task <ActionResult> GetAllBuildings([DataSourceRequest] DataSourceRequest request)
{
var objects = await RestQuery.ExecuteAsync <List <BuildingDto> >("http://localhost:57770/", "GetAllBuildings", Method.GET);
return(Json(objects.Data.ToDataSourceResult(request)));
}
public ActionResult ExportUnit([DataSourceRequest] DataSourceRequest request)
{
if (userAsset["Export"])
{
using (var dbConn = new OrmliteConnection().openConn())
{
//using (ExcelPackage excelPkg = new ExcelPackage())
FileInfo fileInfo = new FileInfo(Server.MapPath(@"~\ExportTemplate\DonViTinh.xlsx"));
var excelPkg = new ExcelPackage(fileInfo);
string fileName = "DonViTinh_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
var data = new List <DC_AD_Unit>();
if (request.Filters.Any())
{
var where = new KendoApplyFilter().ApplyFilter(request.Filters[0]);
data = dbConn.Select <DC_AD_Unit>(where);
}
else
{
data = dbConn.Select <DC_AD_Unit>();
}
ExcelWorksheet expenseSheet = excelPkg.Workbook.Worksheets["Data"];
int rowData = 1;
foreach (var item in data)
{
int i = 1;
rowData++;
expenseSheet.Cells[rowData, i++].Value = item.UnitID;
expenseSheet.Cells[rowData, i++].Value = item.UnitName;
//expenseSheet.Cells[rowData, i++].Value = item.WHID;
expenseSheet.Cells[rowData, i++].Value = item.Note;
if (item.Status == true)
{
expenseSheet.Cells[rowData, i++].Value = "Đang hoạt động";
}
else
{
expenseSheet.Cells[rowData, i++].Value = "Ngưng hoạt động";
}
expenseSheet.Cells[rowData, i++].Value = item.CreatedBy;
expenseSheet.Cells[rowData, i++].Value = item.CreatedAt;
expenseSheet.Cells[rowData, i++].Value = item.UpdatedBy;
if (item.UpdatedAt != DateTime.Parse("1900-01-01"))
{
expenseSheet.Cells[rowData, i++].Value = item.UpdatedAt;
}
else
{
expenseSheet.Cells[rowData, i++].Value = "";
}
}
MemoryStream output = new MemoryStream();
excelPkg.SaveAs(output);
output.Position = 0;
return(File(output.ToArray(), contentType, fileName));
}
}
else
{
return(Json(new { success = false }));
}
}
public JsonResult GetList([DataSourceRequest] DataSourceRequest request)
{
var employeeList = _emplyeeService.GetAllEmployees();
return(Json(employeeList.ToDataSourceResult(request)));
}
public ActionResult IssueCategorySelect([DataSourceRequest] DataSourceRequest request)
{
return(Json(service.GetIssueCategorys().ToDataSourceResult(request)));
}
public RetrieveResult <WildfireAssessmentMitigationRequirementsViewModel> RetrieveView(DataSourceRequest request, Guid mitigationRequirementId)
{
var dbSet = context.Set <InspectionOrderWildfireAssessmentMitigationRequirements>()
.Include(a => a.Image)
.Where(a => a.InspectionOrderWildfireAssessmentMitigation.Id == mitigationRequirementId)
.OrderBy(a => a.Image.CreatedAt);
var resultList = Retrieve(dbSet, request);
var mitigationList = new RetrieveResult <WildfireAssessmentMitigationRequirementsViewModel>();
mitigationList.PageNo = resultList.PageNo;
mitigationList.SortBy = resultList.SortBy;
mitigationList.RecordPage = resultList.RecordPage;
mitigationList.TotalRecords = resultList.TotalRecords;
mitigationList.Results = resultList.Results.Select(mitigation => new WildfireAssessmentMitigationRequirementsViewModel
{
InspectionOrderWildfireAssessmentMitigationId = mitigation.InspectionOrderWildfireAssessmentMitigationId,
InspectionOrderWildfireAssessmentMitigation = mitigation.InspectionOrderWildfireAssessmentMitigation,
Id = mitigation.Id,
Description = mitigation.Description,
ImageId = mitigation.ImageId,
Image = mitigation.Image,
ChildMitigation = mitigation.ChildMitigation,
ChildMitigationCount = _inspectionOrderWildfireAssessmentChildMitigationRequirementsRepository.childMitigationCount(mitigation.Id),
Status = mitigation.Status
}).ToList();
return(mitigationList);
}
public async Task <ActionResult> GetBiddings([DataSourceRequest] DataSourceRequest request, int typeId)
{
var biddings = await _biddingProvider.GetGovBiddings();
return(Json(biddings.ToDataSourceResult(request)));
}
public ActionResult ColumnSettings_Read([DataSourceRequest] DataSourceRequest request)
{
return(Json(productService.Read().ToDataSourceResult(request)));
}
public JsonResult GetAllTypeMeasureForView(DataSourceRequest command)
{
var data = MeasureType.IP.EnumToList().Select(x => new { Id = x.Key, Name = x.Value }).ToList();
return Json(data, JsonRequestBehavior.AllowGet);
}
public IActionResult PredefinedProductAttributeValueList(string productAttributeId, DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageAttributes))
{
return(AccessDeniedView());
}
var values = _productAttributeService.GetProductAttributeById(productAttributeId).PredefinedProductAttributeValues;
var gridModel = new DataSourceResult
{
Data = values.Select(x =>
{
return(new PredefinedProductAttributeValueModel
{
Id = x.Id,
ProductAttributeId = x.ProductAttributeId,
Name = x.Name,
PriceAdjustment = x.PriceAdjustment,
PriceAdjustmentStr = x.PriceAdjustment.ToString("G29"),
WeightAdjustment = x.WeightAdjustment,
WeightAdjustmentStr = x.WeightAdjustment.ToString("G29"),
Cost = x.Cost,
IsPreSelected = x.IsPreSelected,
DisplayOrder = x.DisplayOrder
});
}),
Total = values.Count()
};
return(Json(gridModel));
}
public async Task <IActionResult> SeNames(DataSourceRequest command, UrlEntityListModel model)
{
bool?active = null;
switch (model.SearchActiveId)
{
case 1:
active = true;
break;
case 2:
active = false;
break;
default:
break;
}
var entityUrls = await _slugService.GetAllEntityUrl(model.SeName, active, command.Page - 1, command.PageSize);
var items = new List <UrlEntityModel>();
foreach (var x in entityUrls)
{
//language
string languageName;
if (String.IsNullOrEmpty(x.LanguageId))
{
languageName = _translationService.GetResource("admin.configuration.senames.Language.Standard");
}
else
{
var language = await _languageService.GetLanguageById(x.LanguageId);
languageName = language != null ? language.Name : "Unknown";
}
//details URL
string detailsUrl = "";
var entityName = x.EntityName != null?x.EntityName.ToLowerInvariant() : "";
switch (entityName)
{
case "blogpost":
detailsUrl = Url.Action("Edit", "Blog", new { id = x.EntityId, area = Constants.AreaAdmin });
break;
case "category":
detailsUrl = Url.Action("Edit", "Category", new { id = x.EntityId, area = Constants.AreaAdmin });
break;
case "collection":
detailsUrl = Url.Action("Edit", "Collection", new { id = x.EntityId, area = Constants.AreaAdmin });
break;
case "product":
detailsUrl = Url.Action("Edit", "Product", new { id = x.EntityId, area = Constants.AreaAdmin });
break;
case "newsitem":
detailsUrl = Url.Action("Edit", "News", new { id = x.EntityId, area = Constants.AreaAdmin });
break;
case "page":
detailsUrl = Url.Action("Edit", "Page", new { id = x.EntityId, area = Constants.AreaAdmin });
break;
case "vendor":
detailsUrl = Url.Action("Edit", "Vendor", new { id = x.EntityId, area = Constants.AreaAdmin });
break;
case "course":
detailsUrl = Url.Action("Edit", "Course", new { id = x.EntityId, area = Constants.AreaAdmin });
break;
case "knowledgebasecategory":
detailsUrl = Url.Action("EditCategory", "Knowledgebase", new { id = x.EntityId, area = Constants.AreaAdmin });
break;
case "knowledgebasearticle":
detailsUrl = Url.Action("EditArticle", "Knowledgebase", new { id = x.EntityId, area = Constants.AreaAdmin });
break;
default:
break;
}
items.Add(new UrlEntityModel
{
Id = x.Id,
Name = x.Slug,
EntityId = x.EntityId,
EntityName = x.EntityName,
IsActive = x.IsActive,
Language = languageName,
DetailsUrl = detailsUrl
});
}
var gridModel = new DataSourceResult
{
Data = items,
Total = entityUrls.TotalCount
};
return(Json(gridModel));
}
public ActionResult Destroy([DataSourceRequest] DataSourceRequest request, ModelType model)
{
return(this.BaseDestroy(request, model));
}
public ActionResult k_jRead([DataSourceRequest] DataSourceRequest request)
{
return(Json(repository.GetAll().ToDataSourceResult(request)));
}
protected override void OnRequest(DataSourceRequest request)
{
var encoding = new UTF8Encoding();
var bytes = encoding.GetBytes(Render);
IntPtr unmanagedPointer = Marshal.AllocHGlobal(bytes.Length);
Marshal.Copy(bytes, 0, unmanagedPointer, bytes.Length);
try
{
SendResponse(request, new DataSourceResponse
{
MimeType = "text/html",
Size = (uint)bytes.Length,
Buffer = unmanagedPointer
});
}
finally
{
// Call unmanaged code
Marshal.FreeHGlobal(unmanagedPointer);
}
}
protected override void OnRequest(DataSourceRequest request)
{
DataSourceResponse response
SendResponse(request, response);
}
public DataSourceResult _departmentcomparativeanalysisOppExcel([DataSourceRequest] DataSourceRequest request, Search search)
{
DataSourceResult result = new DataSourceResult();
try
{
SearchFormat searchoutput = new SearchFormat();
searchoutput.CheckInputs(search);
List <DepartmentComparativeAnalysisOPP> DepartmentComparativeAnalysis = new List <DepartmentComparativeAnalysisOPP>();
DataTable dt = new DataTable();
dt = ReportDepartmentComparativeAnalysisOpportunities(search).Tables[0];
//convert datatable to list
DepartmentComparativeAnalysis = dt.ToList <DepartmentComparativeAnalysisOPP>();
result = DepartmentComparativeAnalysis.ToDataSourceResult(request, dca => new DepartmentComparativeAnalysisOPP
{
OrgName_Rank3 = dca.OrgName_Rank3,
OrgName_Rank2 = dca.OrgName_Rank2,
OrgName_Rank1_Dept = dca.OrgName_Rank1_Dept,
QuestionText = dca.QuestionText.ReplaceNewline(),
StandardEPs = dca.StandardEPs.ReplaceNewline(),
TracerCustomName = dca.TracerCustomName,
TracerResponseTitle = dca.TracerResponseTitle,
ObservationDate = dca.ObservationDate,
Numerator = dca.Numerator,
Denominator = dca.Denominator,
CompliancePercent = dca.CompliancePercent,
TracerQuestionNote = dca.TracerQuestionNote.ReplaceNewline(),
});
}
catch (Exception ex)
{
if (ex.Message.ToString() == "No Data")
{
result.Errors = WebConstants.NO_DATA_FOUND_EXCEL_VIEW;
}
else if (ex.Message.ToString() == "Limit")
{
result.Errors = "Maximum limit of " + ConfigurationManager.AppSettings["ReportOutputLimit"].ToString() + " records reached. Refine your criteria to narrow the result.";
}
if (ex.Message.ToString() != "No Data" && ex.Message.ToString() != "Limit")
{
ExceptionLog exceptionLog = new ExceptionLog
{
ExceptionText = "Reports: " + ex.Message,
PageName = "DepartmentComparativeAnalysis",
MethodName = "_departmentcomparativeanalysisOppExcel",
UserID = Convert.ToInt32(AppSession.UserID),
SiteId = Convert.ToInt32(AppSession.SelectedSiteId),
TransSQL = "",
HttpReferrer = null
};
_exceptionService.LogException(exceptionLog);
}
}
return(result);
}
public JsonResult List2([DataSourceRequest] DataSourceRequest request, int Id, int Tarih = 0)
{
return(Json(db.GetTaskList(Id, vUser.DepoId ?? 0, Tarih).ToList().ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
public async Task <string> PdfOnly([FromBody] DataSourceRequest gridRequest)
{
string base64File = await GenerateFile(false, gridRequest);
return(await Task.FromResult(base64File));
}
public async Task <string> FromExcel([FromBody] DataSourceRequest gridRequest)
{
string base64File = await GenerateFile(true, gridRequest);
return(await Task.FromResult(base64File));
}
public ActionResult List([DataSourceRequest] DataSourceRequest request)
{
var weekendCategoryList = _weekendCategoryService.GetAll().Where(w => !w.IsDeleted).ToList();
return(Json(weekendCategoryList.ToDataSourceResult(request)));
}
public ActionResult List([DataSourceRequest] DataSourceRequest request, long employeeId)
{
var employeeEmploymentHistoryList = _employeeEmploymentHistoryService.GetAll().Where(e => e.EmployeeId == employeeId).ToList();
return(Json(employeeEmploymentHistoryList.ToDataSourceResult(request)));
}
