public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, _SurveyRequest.ExportToExcel(searchText));
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _jobOrderHeader.GetAll().AsQueryable().Where(j => j.ParentJobOrderId == null);
records = searchText != "" ? records.Where(p => p.JobOrderNo.ToUpper().Contains(searchText.ToUpper()) ||
p.UltimateClient.ToUpper().Contains(searchText.ToUpper()) ||
p.ReceivingClient.ToUpper().Contains(searchText.ToUpper())) : records;
var jobOrders = records.Select(record => new
{
record.Id,
record.JobOrderNo,
ReceivingClient = record.ReceivingClient,
record.PreparedDate,
IsChecked = record.CheckedById == null ? false : true,
IsApproved = record.ApprovedById == null ? false : true
}).ToList().Select(record => new
{
record.Id,
record.JobOrderNo,
record.ReceivingClient,
Date = string.Format("{0:MMMM dd, yyyy}", record.PreparedDate),
record.IsChecked,
record.IsApproved
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, jobOrders);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _serviceAgreement.GetAll();
records = searchText != "" ? records.Where(p => p.iffsCustomer.Name.ToUpper().Contains(searchText.ToUpper()) ||
(p.iffsQuotationHeader == null ? false : p.iffsQuotationHeader.QuotationNo.ToUpper().Contains(searchText.ToUpper())) ||
p.AgreementFile.ToUpper().Contains(searchText.ToUpper()) ||
p.Remark.ToUpper().Contains(searchText.ToUpper())) : records;
var serviceAgreements = records.Select(item => new
{
item.Id,
Date = String.Format("{0:MMMM dd, yyyy}", item.Date),
item.CustomerId,
Customer = item.iffsCustomer.Name,
item.QuotationId,
Quotation = item.iffsQuotationHeader == null ? "" : item.iffsQuotationHeader.QuotationNo,
item.AgreementFile,
item.Remark
}).Cast <object>().ToList();
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, serviceAgreements);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var records = _PackingMaterialConsumption.GetAll().AsQueryable();
records = searchText != "" ? records.Where(p => p.iffsPackingMaterialDetail.Description.ToUpper().Contains(searchText.ToUpper())) : records;
var PackingMaterialConsumptions = records.Select(record => new
{
record.iffsPackingMaterialDetail.Description,
record.Date,
record.Requested,
record.Consumed,
record.Returned,
record.Remarks,
MeasurmentUnit = record.iffsPackingMaterialDetail.lupMeasurementUnit.Name
}).ToList().Select(record => new
{
record.Description,
record.Date,
record.Requested,
record.Consumed,
record.Returned,
record.Remarks,
record.MeasurmentUnit
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, PackingMaterialConsumptions);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var records = _ShipmentType.GetAll().AsQueryable();
records = searchText != "" ? records.Where(p => p.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.Code.ToUpper().Contains(searchText.ToUpper()) ||
p.Type.ToUpper().Contains(searchText.ToUpper())) : records;
var ShipmentTypes = records.Select(record => new
{
record.Id,
record.Name,
record.Code,
record.Type
}).ToList().Select(record => new
{
record.Id,
record.Name,
record.Code,
record.Type
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, ShipmentTypes);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _ReceivingClient.GetAll();
records = searchText != "" ? records.Where(p => p.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.ContactPerson.ToUpper().Contains(searchText.ToUpper()) ||
p.Address.ToUpper().Contains(searchText.ToUpper()) ||
p.Telephone.ToUpper().Contains(searchText.ToUpper())) : records;
var ReceivingClients = records.Select(obj => new
{
obj.Id,
obj.Name,
obj.ContactPerson,
obj.Telephone,
obj.Mobile,
obj.Email,
obj.AlternativeEmail,
obj.Address
}).Cast <object>().ToList();
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, ReceivingClients);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _customer.GetAll();
records = searchText != "" ? records.Where(p => p.iffsLupCustomerGroup.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.Code.ToUpper().Contains(searchText.ToUpper()) ||
(p.TinNo == null ? false : p.TinNo.ToUpper().Contains(searchText.ToUpper())) ||
p.Email.ToUpper().Contains(searchText.ToUpper()) ||
p.Telephone.ToUpper().Contains(searchText.ToUpper()) ||
p.Address.ToUpper().Contains(searchText.ToUpper())) : records;
var customers = records.Select(record => new
{
record.Id,
record.CustomerGroupId,
CustomerGroup = record.iffsLupCustomerGroup.Name,
record.Name,
record.Code,
record.TinNo,
record.Address,
record.Email,
record.Telephone
}).Cast <object>().ToList();
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, customers);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _quotationHeader.GetAll();
records = searchText != "" ? records.Where(p => p.iffsServiceRequest.iffsCustomer.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.QuotationNo.ToUpper().Contains(searchText.ToUpper())) : records;
var customers = records.Select(record => new
{
record.Id,
record.QuotationNo,
Customer = record.iffsServiceRequest.iffsCustomer.Name,
record.Date,
PreparedBy = record.hrmsEmployee.corePerson.FirstName + " " + record.hrmsEmployee.corePerson.FatherName,
record.Remark,
// record.TermsAndConditions,
record.ValidityDate,
record.IsAccepted,
ApprovedBy = record.ApprovedById.HasValue? record.hrmsEmployee2.corePerson.FirstName + " " + record.hrmsEmployee2.corePerson.FatherName:"",
record.ApprovalDate,
CheckedBy = record.CheckedById.HasValue? record.hrmsEmployee1.corePerson.FirstName + " " + record.hrmsEmployee1.corePerson.FatherName:"",
record.CheckedDate,
IsChecked = record.CheckedById == null ? false : true,
IsApproved = record.ApprovedById == null ? false : true,
}).Cast <object>().ToList();
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, customers);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _invoiceHeader.GetAll().AsQueryable().OrderByDescending(o => o.Date).AsQueryable();
records = searchText != "" ? records.
Where(p =>
p.InvoiceNo.ToUpper().Contains(searchText.ToUpper()) ||
p.iffsCustomer.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.OperationNo.ToUpper().Contains(searchText.ToUpper()) ||
p.iffsLupOperationType.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.FsNo.ToUpper().Contains(searchText.ToUpper()) ||
(p.hrmsEmployee.corePerson.FirstName + " " + p.hrmsEmployee.corePerson.FatherName).ToUpper().Contains(searchText.ToUpper())
) : records;
var customers = records.Select(record => new
{
record.Id,
OperationType = record.iffsLupOperationType.Name,
record.InvoiceNo,
record.Date,
Customer = record.iffsCustomer.Name,
record.FsNo,
record.CustomerReferenceNo,
record.BL_AWB,
record.Carrier,
record.Remark,
record.Container,
record.ExchangeRate,
record.HBL,
record.OperationNo,
PreparedBy = record.CheckedById.HasValue ? record.hrmsEmployee.corePerson.FirstName + " " + record.hrmsEmployee.corePerson.FatherName : "",
record.PreparedDate,
IsChecked = record.CheckedById == null ? false : true,
IsApproved = record.ApprovedById == null ? false : true
}).ToList();
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, customers);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _operation.GetAll().AsQueryable();
records = searchText != "" ? records.Where(p => p.OperationNo.ToUpper().Contains(searchText.ToUpper())) : records;
var jobOrders = records.Select(record => new
{
record.Id,
record.OperationNo,
record.Date,
IsChecked = record.CheckedById == null ? false : true,
IsApproved = record.ApprovedById == null ? false : true,
PreparedByFirst = record.hrmsEmployee.corePerson.FirstName,
PreparedByFather = record.hrmsEmployee.corePerson.FatherName,
CheckedByFirst = record.CheckedById != null ? record.hrmsEmployee1.corePerson.FirstName : "",
CheckedByFather = record.CheckedById != null ? record.hrmsEmployee1.corePerson.FatherName : "",
ApprovedByFirst = record.ApprovedById != null ? record.hrmsEmployee2.corePerson.FirstName : "",
ApprovedByFather = record.ApprovedById != null ? record.hrmsEmployee2.corePerson.FatherName : "",
record.PreparedDate,
record.CheckedDate,
record.ApprovalDate
}).ToList().Select(record => new
{
record.Id,
record.OperationNo,
Date = string.Format("{0:MMMM dd, yyyy}", record.Date),
record.IsChecked,
record.IsApproved,
PreparedBy = record.PreparedByFirst + " " + record.PreparedByFather,
CheckedBy = record.CheckedByFirst + " " + record.CheckedByFather,
ApprovedBy = record.ApprovedByFirst + " " + record.ApprovedByFather,
PreparedDate = string.Format("{0:MMMM dd, yyyy}", record.PreparedDate),
CheckedDate = string.Format("{0:MMMM dd, yyyy}", record.CheckedDate),
ApprovalDate = string.Format("{0:MMMM dd, yyyy}", record.ApprovalDate)
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, jobOrders);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var records = _PackingMaterialHeader.GetAll().AsQueryable();
records = searchText != "" ? records.Where(p => p.Number.ToUpper().Contains(searchText.ToUpper()) ||
p.ToDept.ToUpper().Contains(searchText.ToUpper()) ||
p.RequestedDept.ToUpper().Contains(searchText.ToUpper())) : records;
var PackingMaterials = records.Select(record => new
{
record.Number,
PreparedBy = GetFullName(record.PreparedById),
CheckedBy = record.CheckedById.HasValue ? GetFullName(record.CheckedById.Value) : "",
ApprovedBy = record.ApprovedById.HasValue ? GetFullName(record.ApprovedById.Value) : "",
record.ApprovalDate,
record.CheckedDate,
record.PreparedDate,
record.ToDept,
record.RequestedDept,
record.RequestedDate,
}).ToList().Select(record => new
{
record.Number,
record.ToDept,
record.RequestedDept,
record.RequestedDate,
record.PreparedBy,
record.CheckedBy,
record.ApprovedBy,
record.ApprovalDate,
record.CheckedDate,
record.PreparedDate,
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, PackingMaterials);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var records = _CrateAndBoxRequestHeader.GetAll().AsQueryable();
records = searchText != "" ? records.Where(p => p.OrderNumber.ToUpper().Contains(searchText.ToUpper()) ||
p.hrmsEmployeeApprovedBy.corePerson.FatherName.ToUpper().Contains(searchText.ToUpper()) ||
p.hrmsEmployeePreparedBy.corePerson.GrandFatherName.ToUpper().Contains(searchText.ToUpper())) : records;
var PackingCrateAndBoxRequests = records.Select(record => new
{
record.Id,
record.OperationId,
record.OrderNumber,
record.PrevOrderNumber,
record.PreparedDate,
record.RequestedDate,
record.PreparedBy,
record.IsIronSheetCover,
record.Remark
}).ToList().Select(record => new
{
record.Id,
record.OperationId,
record.OrderNumber,
record.PrevOrderNumber,
record.PreparedDate,
record.RequestedDate,
record.PreparedBy,
record.IsIronSheetCover,
record.Remark
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, PackingCrateAndBoxRequests);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var Type = int.Parse(Request.QueryString["Type"].ToString());
MaterialType materialType = Type == 1 ? MaterialType.Standard : MaterialType.CrateAndBox;
var records = _PackingMaterialSetting.FindAllQueryable(p => p.MaterialType == materialType);
records = searchText != "" ? records.Where(p => p.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.Description.ToUpper().Contains(searchText.ToUpper())) : records;
var PackingMaterialSettings = records.Select(record => new
{
record.Name,
record.Description,
record.MeasurmentUnit,
record.Length,
record.Width,
record.Height,
record.SizeCMB,
record.MaterialType,
record.Remark
}).ToList().Select(record => new
{
record.Name,
record.Description,
record.MeasurmentUnit,
record.Length,
record.Width,
record.Height,
record.SizeCMB,
record.MaterialType,
record.Remark
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, PackingMaterialSettings);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _service.GetAll();
records = searchText != "" ? records.Where(p => p.Name.ToUpper().Contains(searchText.ToUpper()) ||
(p.Description == null ? false : p.Description.ToUpper().Contains(searchText.ToUpper())) ||
p.Code.ToUpper().Contains(searchText.ToUpper())) : records;
var services = records.Select(record => new
{
record.Id,
record.Name,
record.Description,
record.Code,
record.IsTaxable
}).Cast <object>().ToList();
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, services);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var records = _PackingDamageReport.GetAll().AsQueryable();
//records = searchText != "" ? records.Where(p => p.Number.ToUpper().Contains(searchText.ToUpper()) ||
// p.iffsCustomer.Name.ToUpper().Contains(searchText.ToUpper()) ||
// p.iffsReceivingClient.Name.ToUpper().Contains(searchText.ToUpper())) : records;
var PackingDamageReports = records.Select(record => new
{
record.Id,
record.Remarks,
}).ToList().Select(record => new
{
record.Id,
record.Remarks,
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, PackingDamageReports);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var records = _PackingHeader.GetAll().AsQueryable();
records = searchText != "" ? records.Where(p => p.ActivityType.ToUpper().Contains(searchText.ToUpper()) ||
p.hrmsEmployee.corePerson.FatherName.ToUpper().Contains(searchText.ToUpper()) ||
p.hrmsEmployee.corePerson.FatherName.ToUpper().Contains(searchText.ToUpper()) ||
p.hrmsEmployee.corePerson.GrandFatherName.ToUpper().Contains(searchText.ToUpper())) : records;
var Packings = records.Select(record => new
{
record.ActivityType,
Supervisor = GetFullName(record.SupervisorId),
PreparedBy = GetFullName(record.PreparedBy),
record.ActualVolume,
record.ActualWeight,
record.StartDate,
record.EndDate,
Date = record.PreparedDate
}).ToList().Select(record => new
{
record.ActivityType,
record.Supervisor,
record.PreparedBy,
record.ActualVolume,
record.ActualWeight,
record.StartDate,
record.EndDate,
record.Date
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, Packings);
}
