public dynamic GetDefaultInfo() { CompanyInfo model = new CompanyInfo(); try { model = _companyInfoService.GetQueryable().FirstOrDefault(); } catch (Exception ex) { LOG.Error("GetInfo", ex); Dictionary <string, string> Errors = new Dictionary <string, string>(); Errors.Add("Generic", "Error " + ex); return(Json(new { Errors }, JsonRequestBehavior.AllowGet)); } return(Json(new { model.Id, model.Name, model.Address, model.City, model.PostalCode, model.PhoneNumber, model.FaxNumber, model.Email, model.Website, model.NPWP, model.NPWPDate }, JsonRequestBehavior.AllowGet)); }
public ActionResult ReportSlipGajiDetail(Nullable <int> Id, DateTime monthYear) { var company = _companyInfoService.GetQueryable().FirstOrDefault(); var q = _slipGajiDetailService.GetQueryable().Include("SlipGajiDetail1s").Include("SlipGajiDetail2As").Where(x => (Id == null || Id.Value == 0 || x.EmployeeId == Id.Value) && x.MONTH.Month == monthYear.Month && x.MONTH.Year == monthYear.Year); //.ToList(); var q2 = _slipGajiDetail1Service.GetQueryable().Include("SlipGajiDetail").Where(x => (Id == null || Id.Value == 0 || x.SlipGajiDetail.EmployeeId == Id.Value) && x.SlipGajiDetail.MONTH.Month == monthYear.Month && x.SlipGajiDetail.MONTH.Year == monthYear.Year).ToList(); var q3 = _slipGajiDetail2AService.GetQueryable().Include("SlipGajiDetail").Where(x => (Id == null || Id.Value == 0 || x.SlipGajiDetail.EmployeeId == Id.Value) && x.SlipGajiDetail.MONTH.Month == monthYear.Month && x.SlipGajiDetail.MONTH.Year == monthYear.Year).ToList(); string user = AuthenticationModel.GetUserName(); CultureInfo ci = new CultureInfo("id-ID"); var query = (from model in q select new { model.MONTH, model.NoBadge, model.Name, model.Jabatan, model.TanggalPenerimaan, model.PeriodeAwal, model.PeriodeAkhir, model.GajiBasis, model.StatusMarriage, model.NoSlip, model.Rate, model.Lembur15, model.Lembur20, model.Lembur30, model.Lembur40, Disiapkan_oleh = "", Disetujui_oleh = "", Dikoreksi_oleh = "", company_code = company.Name, //CompanyAddress = company.Address, //User = user, model.SlipGajiDetail1s, model.SlipGajiDetail2As, }).ToList(); if (!query.Any()) { return(Content(Core.Constants.Constant.ErrorPage.RecordDetailNotFound)); } var rd = new ReportDocument(); //Loading Report rd.Load(Server.MapPath("~/") + "Reports/General/rpt_slip_gajiA.rpt"); // Setting report data source rd.SetDataSource(query); rd.Subreports["rpt_SlipGaji2.rpt"].SetDataSource(q2); rd.Subreports["rpt_SlipGaji3.rpt"].SetDataSource(q3); // Set parameters, need to be done after all data sources are set (to prevent reseting parameters) rd.SetParameterValue(0, "Periode " + monthYear.ToString("MMMM yyyy", ci).ToUpper()); // Set printer paper size //System.Drawing.Printing.PrintDocument doctoprint = new System.Drawing.Printing.PrintDocument(); //doctoprint.PrinterSettings.PrinterName = "Microsoft XPS Document Writer"; //int i = 0; //for (i = 0; i < doctoprint.PrinterSettings.PaperSizes.Count; i++) //{ // int rawKind = 0; // if (doctoprint.PrinterSettings.PaperSizes[i].PaperName.ToLower() == "Letter") // { // rawKind = Convert.ToInt32(doctoprint.PrinterSettings.PaperSizes[i].GetType().GetField("kind", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic).GetValue(doctoprint.PrinterSettings.PaperSizes[i])); // if (Enum.IsDefined(typeof(CrystalDecisions.Shared.PaperSize), rawKind)) // { // rd.PrintOptions.PaperSize = (CrystalDecisions.Shared.PaperSize)rawKind; // //rd.PrintOptions.PaperOrientation = PaperOrientation.Landscape; // } // break; // } //} var stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); return(File(stream, "application/pdf")); }
public dynamic GetList(string _search, long nd, int rows, int?page, string sidx, string sord, string filters = "") { // Construct where statement string strWhere = GeneralFunction.ConstructWhere(filters); string filter = null; GeneralFunction.ConstructWhereInLinq(strWhere, out filter); if (filter == "") { filter = "true"; } // Get Data var q = _companyInfoService.GetQueryable(); var query = (from model in q select new { model.Id, model.Name, model.Address, model.City, model.PostalCode, model.PhoneNumber, model.FaxNumber, model.Email, model.Website, model.NPWP, model.NPWPDate, model.CreatedAt, model.UpdatedAt, }).Where(filter).OrderBy(sidx + " " + sord); //.ToList(); var list = query.AsEnumerable(); var pageIndex = Convert.ToInt32(page) - 1; var pageSize = rows; var totalRecords = query.Count(); var totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize); // default last page if (totalPages > 0) { if (!page.HasValue) { pageIndex = totalPages - 1; page = totalPages; } } list = list.Skip(pageIndex * pageSize).Take(pageSize); return(Json(new { total = totalPages, page = page, records = totalRecords, rows = ( from model in list select new { id = model.Id, cell = new object[] { model.Id, model.Name, model.Address, model.City, model.PostalCode, model.PhoneNumber, model.FaxNumber, model.Email, model.Website, model.NPWP, model.NPWPDate, model.CreatedAt, model.UpdatedAt, } }).ToArray() }, JsonRequestBehavior.AllowGet)); }