public DataSourceResult CustomerReportsInView(KendoFilterRequestDto Request)
{
using (EAharaDB context = new EAharaDB())
{
var rep = context.Customers.Where(x => x.IsActive &&
((DbFunctions.TruncateTime(x.CreatedDate)) >= (DbFunctions.TruncateTime(Request.FromDate))
&& (DbFunctions.TruncateTime(x.CreatedDate)) <= (DbFunctions.TruncateTime(Request.ToDate))));
var dataSourceResult = rep.Select(x => new CustomerDto
{
Id = x.Id,
Name = x.Name,
IsActive = x.IsActive,
Email = x.Email,
MobileNo = x.MobileNo,
TelephoneNo = x.TelephoneNo,
Address = x.Address,
Location = x.Location,
CreatedDate = x.CreatedDate,
RefNo = x.RefNo,
Points = x.Points,
BLCount = x.BLCount,
InstRefNo = x.InstRefNo,
Photo = x.Photo,
TOrders = context.Bookings.Where(y=>y.IsActive && y.CustomerId == x.Id).Count(),
}).OrderByDescending(x => x.Id).ToDataSourceResult(Request);
DataSourceResult kendoResponseDto = new DataSourceResult();
kendoResponseDto.Data = dataSourceResult.Data;
kendoResponseDto.Aggregates = dataSourceResult.Aggregates;
kendoResponseDto.Total = dataSourceResult.Total;
return kendoResponseDto;
}
}
public DataSourceResult CompanyexpenseInView(KendoFilterRequestDto Request)
{
using (EAharaDB context = new EAharaDB())
{
var expenses = context.CompanyExpenses.Where(x => x.IsActive);
if (Request.FromDate != null && Request.ToDate != null)
{
expenses = expenses.Where(x => (DbFunctions.TruncateTime(x.Date)) >= (DbFunctions.TruncateTime(Request.FromDate)) && (DbFunctions.TruncateTime(x.Date)) <= (DbFunctions.TruncateTime(Request.ToDate)));
}
var dataSourceResult = expenses
.Select(x => new CompanyExpenseDto
{
Id = x.Id,
Description = x.Description,
Date = x.Date,
Total = x.Total,
TotalVAT = x.TotalVAT,
GrandTotal = x.GrandTotal,
IsActive = x.IsActive,
PaymentModeId = x.PaymentModeId,
PaymentMode = new PaymentModeDto
{
Id = x.PaymentMode.Id,
Name = x.PaymentMode.Name,
},
CompanyExpenseDetails = x.CompanyExpenseDetails.Where(y => y.IsActive)
.Select(y => new CompanyExpenseDetailsDto
{
Id = y.Id,
Description = y.Description,
Quantity = y.Quantity,
Price = y.Price,
Total = y.Total,
SubTotal = y.SubTotal,
VATPrice = y.VATPrice,
GrandTotal = y.GrandTotal,
CompanyExpenseId = y.CompanyExpenseId,
}).ToList(),
}).OrderByDescending(x => x.Id).ToDataSourceResult(Request);
DataSourceResult kendoResponseDto = new DataSourceResult();
kendoResponseDto.Data = dataSourceResult.Data;
kendoResponseDto.Aggregates = dataSourceResult.Aggregates;
kendoResponseDto.Total = dataSourceResult.Total;
return(kendoResponseDto);
}
}
public string PrintDyncReport(KendoFilterRequestDto Request)
{
using (EAharaDB context = new EAharaDB())
{
ReportDocument rd = new ReportDocument();
DateReport dreport = new DateReport();
dreport.From = Request.FromDate.Value;
dreport.To = Request.ToDate.Value;
context.DateReports.Add(dreport);
context.SaveChanges();
Guid id1 = Guid.NewGuid();
var pdfName = Request.RPTName + id1 + ".pdf";
string strRptPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Reports\\" + Request.RPTName + ".rpt";
string strPdfPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Reports\\" + pdfName;
rd.Load(strRptPath);
rd.Refresh();
string connectionString =
ConfigurationManager.ConnectionStrings["EAharaDB"].ConnectionString;
SqlConnectionStringBuilder SConn = new SqlConnectionStringBuilder(connectionString);
rd.DataSourceConnections[0].SetConnection(
SConn.DataSource, SConn.InitialCatalog, SConn.UserID, SConn.Password);
foreach (ReportDocument srd in rd.Subreports)
{
srd.DataSourceConnections[0].SetConnection(SConn.DataSource, SConn.InitialCatalog, SConn.UserID, SConn.Password);
}
//rd.SetParameterValue(0, dreport.Id);
rd.SetParameterValue("FromDate", Request.FromDate);
rd.SetParameterValue("ToDate", Request.ToDate);
System.IO.File.Delete(strPdfPath);
//rd.PrintOptions.PaperSize = PaperSize.PaperA5;
rd.ExportToDisk(ExportFormatType.PortableDocFormat, strPdfPath);
return(pdfName);
}
}
public string PrintClientReportList(KendoFilterRequestDto Request)
{
using (EAharaDB context = new EAharaDB())
{
var rep = context.Customers.Where(x => x.IsActive &&
((DbFunctions.TruncateTime(x.CreatedDate)) >= (DbFunctions.TruncateTime(Request.FromDate)) &&
(DbFunctions.TruncateTime(x.CreatedDate)) <= (DbFunctions.TruncateTime(Request.ToDate))));
long[] items = rep.Select(x => x.Id).ToArray();
ReportDocument rd = new ReportDocument();
Guid id1 = Guid.NewGuid();
var pdfName = "CustomerReport" + id1 + ".pdf";
string strRptPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Reports\\" + "CustomerReport" + ".rpt";
string strPdfPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Reports\\" + pdfName;
rd.Load(strRptPath);
rd.Refresh();
string connectionString =
ConfigurationManager.ConnectionStrings["EAharaDB"].ConnectionString;
SqlConnectionStringBuilder SConn = new SqlConnectionStringBuilder(connectionString);
rd.DataSourceConnections[0].SetConnection(
SConn.DataSource, SConn.InitialCatalog, SConn.UserID, SConn.Password);
foreach (ReportDocument srd in rd.Subreports)
{
srd.DataSourceConnections[0].SetConnection(SConn.DataSource, SConn.InitialCatalog, SConn.UserID, SConn.Password);
}
rd.SetParameterValue(0, items);
System.IO.File.Delete(strPdfPath);
rd.PrintOptions.PaperSize = PaperSize.PaperA4;
rd.ExportToDisk(ExportFormatType.PortableDocFormat, strPdfPath);
return(pdfName);
}
}
public string PrintShopDyncReport(KendoFilterRequestDto Request)
{
using (EAharaDB context = new EAharaDB())
{
BasicAuthenticationIdentity identity = (BasicAuthenticationIdentity)User.Identity;
var user = context.Users.FirstOrDefault(x => x.Id == identity.Id);
var shops = context.Shops.Where(x => x.IsActive);
if (user.Role == "Employee")
{
if (user.Employee != null)
{
shops = shops.Where(x => x.LocationId == user.Employee.LocationId);
}
}
long[] items = shops.Select(x => x.Id).ToArray();
if (Request.Shops.Count > 0)
{
items = Request.Shops.ToArray();
}
//foreach (var det in Request.Shops)
//{
//}
ReportDocument rd = new ReportDocument();
DateReport dreport = new DateReport();
dreport.From = Request.FromDate.Value;
dreport.To = Request.ToDate.Value;
context.DateReports.Add(dreport);
context.SaveChanges();
Guid id1 = Guid.NewGuid();
var pdfName = Request.RPTName + id1 + ".pdf";
string strRptPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Reports\\" + Request.RPTName + ".rpt";
string strPdfPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Reports\\" + pdfName;
rd.Load(strRptPath);
rd.Refresh();
string connectionString =
ConfigurationManager.ConnectionStrings["EAharaDB"].ConnectionString;
SqlConnectionStringBuilder SConn = new SqlConnectionStringBuilder(connectionString);
rd.DataSourceConnections[0].SetConnection(
SConn.DataSource, SConn.InitialCatalog, SConn.UserID, SConn.Password);
foreach (ReportDocument srd in rd.Subreports)
{
srd.DataSourceConnections[0].SetConnection(SConn.DataSource, SConn.InitialCatalog, SConn.UserID, SConn.Password);
}
rd.SetParameterValue(0, items);
rd.SetParameterValue("FromDate", Request.FromDate);
rd.SetParameterValue("ToDate", Request.ToDate);
System.IO.File.Delete(strPdfPath);
//rd.PrintOptions.PaperSize = PaperSize.PaperA5;
rd.ExportToDisk(ExportFormatType.PortableDocFormat, strPdfPath);
return(pdfName);
}
}
public string PrintBookingReportList(KendoFilterRequestDto Request)
{
using (EAharaDB context = new EAharaDB())
{
BasicAuthenticationIdentity identity = (BasicAuthenticationIdentity)User.Identity;
var user = context.Users.FirstOrDefault(x => x.Id == identity.Id);
var query = context.Bookings.Where(x => x.IsActive &&
((DbFunctions.TruncateTime(x.OrderDate)) >= (DbFunctions.TruncateTime(Request.FromDate)) &&
(DbFunctions.TruncateTime(x.OrderDate)) <= (DbFunctions.TruncateTime(Request.ToDate))));
if (user.Role == "Employee")
{
if (user.Employee != null)
{
query = query.Where(x => x.LocationId == user.Employee.LocationId);
}
}
var rep = query;
if (Request.ShopId > 0)
{
rep = rep.Where(x => x.ShopId == Request.ShopId);
}
if (Request.Paid == "Paid")
{
rep = rep.Where(x => x.IsPaid);
}
if (Request.Paid == "Not Paid")
{
rep = rep.Where(x => !x.IsPaid);
}
long[] items = rep.Select(x => x.Id).ToArray();
ReportDocument rd = new ReportDocument();
Guid id1 = Guid.NewGuid();
var pdfName = "BookingReport" + id1 + ".pdf";
string strRptPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Reports\\" + "BookingReport" + ".rpt";
string strPdfPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Reports\\" + pdfName;
rd.Load(strRptPath);
rd.Refresh();
string connectionString =
ConfigurationManager.ConnectionStrings["EAharaDB"].ConnectionString;
SqlConnectionStringBuilder SConn = new SqlConnectionStringBuilder(connectionString);
rd.DataSourceConnections[0].SetConnection(
SConn.DataSource, SConn.InitialCatalog, SConn.UserID, SConn.Password);
foreach (ReportDocument srd in rd.Subreports)
{
srd.DataSourceConnections[0].SetConnection(SConn.DataSource, SConn.InitialCatalog, SConn.UserID, SConn.Password);
}
rd.SetParameterValue(0, items);
System.IO.File.Delete(strPdfPath);
rd.PrintOptions.PaperSize = PaperSize.PaperA4;
rd.ExportToDisk(ExportFormatType.PortableDocFormat, strPdfPath);
return(pdfName);
}
}
