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