protected void reportStore_ReadData(object sender, StoreReadDataEventArgs e) { ReportCompositeRequest req = new ReportCompositeRequest(); req.Size = "1000"; req.StartAt = "0"; req.SortBy = "departmentName"; ListResponse <Model.Reports.RT01> resp = _reportsService.ChildGetAll <Model.Reports.RT01>(req); if (!resp.Success) { X.MessageBox.ButtonText.Ok = Resources.Common.Ok; Common.errorMessage(resp); return; } List <object> l = new List <object>(); l.Add(new { id = GetLocalResourceObject("age00_18").ToString(), count = resp.Items.Sum(x => x.age00_18) }); l.Add(new { id = GetLocalResourceObject("age18_25").ToString(), count = resp.Items.Sum(x => x.age18_25) }); l.Add(new { id = GetLocalResourceObject("age26_30").ToString(), count = resp.Items.Sum(x => x.age26_30) }); l.Add(new { id = GetLocalResourceObject("age30_40").ToString(), count = resp.Items.Sum(x => x.age30_40) }); l.Add(new { id = GetLocalResourceObject("age40_50").ToString(), count = resp.Items.Sum(x => x.age40_50) }); l.Add(new { id = GetLocalResourceObject("age50_60").ToString(), count = resp.Items.Sum(x => x.age50_60) }); l.Add(new { id = GetLocalResourceObject("age60_99").ToString(), count = resp.Items.Sum(x => x.age60_99) }); summaryStore.DataSource = l; summaryStore.DataBind(); reportStore.DataSource = resp.Items; reportStore.DataBind(); }
protected void PoPuP(object sender, DirectEventArgs e) { int id = Convert.ToInt32(e.ExtraParams["id"]); string type = e.ExtraParams["type"]; switch (type) { case "imgAttach": //panelRecordDetails.ActiveIndex = 0; ReportCompositeRequest comp = new ReportCompositeRequest(); comp.Add(GetActivePreferance()); comp.Add(new MissingFieldParameterSet() { fieldId = id.ToString() }); ListResponse <RT107B> resp = _reportService.ChildGetAll <RT107B>(comp); if (!resp.Success) { Common.errorMessage(resp); return; } employeesStore.DataSource = resp.Items; employeesStore.DataBind(); Viewport1.ActiveIndex = 1; break; default: break; } }
/// <summary> /// Adding new record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Store1_RefreshData(object sender, StoreReadDataEventArgs e) { //GEtting the filter from the page string filter = string.Empty; int totalCount = 1; ReportCompositeRequest req = new ReportCompositeRequest(); req.Add(GetActivePreferance()); //Fetching the corresponding list //in this test will take a list of News ListResponse <Model.Reports.RT107> branches = _reportService.ChildGetAll <Model.Reports.RT107>(req); if (!branches.Success) { X.Msg.Alert(Resources.Common.Error, GetGlobalResourceObject("Errors", branches.ErrorCode) != null ? GetGlobalResourceObject("Errors", branches.ErrorCode).ToString() : branches.Summary).Show(); return; } this.Store1.DataSource = branches.Items; e.Total = branches.count; this.Store1.DataBind(); }
private void FillReport(bool throwException = true) { ReportCompositeRequest req = GetRequest(); ListResponse <Model.Reports.RT106> resp = _reportsService.ChildGetAll <Model.Reports.RT106>(req); //if (resp == null || string.IsNullOrEmpty(resp.Error)) //{ // throw new Exception(GetGlobalResourceObject("Errors", "Error_1").ToString()); //} //if (!resp.Success) //{ // throw new Exception(resp.Error + "<br>" + GetGlobalResourceObject("Errors", "ErrorLogId") + resp.LogId + "</br>"); //} if (!resp.Success) { Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString()); } TurnoverRate y = new TurnoverRate(); y.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No; y.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No; resp.Items.ForEach(x => { x.MonthString = CultureInfo.CurrentUICulture.DateTimeFormat.GetMonthName(x.month); x.month = x.month - 1; x.rate = x.rate / 100; }); y.DataSource = resp.Items; string user = _systemService.SessionHelper.GetCurrentUser(); y.Parameters["User"].Value = user; ASPxWebDocumentViewer1.DataBind(); ASPxWebDocumentViewer1.OpenReport(y); }
private ReportCompositeRequest GetRequest() { ReportCompositeRequest request = new ReportCompositeRequest(); request.Size = "1000"; request.StartAt = "0"; return(request); }
private ReportCompositeRequest GetRequest() { ReportCompositeRequest req = new ReportCompositeRequest(); req.Size = "1000"; req.StartAt = "0"; req.Add(jobInfo1.GetJobInfo()); return(req); }
private ReportCompositeRequest GetRequest() { ReportCompositeRequest req = new ReportCompositeRequest(); req.Size = "1000"; req.StartAt = "0"; req.Add(dateRange1.GetRange()); req.Add(employeeCombo1.GetEmployee()); return(req); }
private void FillReport(bool isInitial = false, bool throwException = true) { ReportCompositeRequest req = GetRequest(); ListResponse <Model.Reports.RT402> resp = _reportsService.ChildGetAll <Model.Reports.RT402>(req); if (!resp.Success) { Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString()); } for (int i = 0; i < resp.Items.Count; i++) { if (i == 0) { resp.Items[i].balance = resp.Items[i].amount; } else { resp.Items[i].balance = resp.Items[i - 1].balance + resp.Items[i].amount; } resp.Items[i].dateStringFormat = resp.Items[i].date.ToString(_systemService.SessionHelper.GetDateformat()); } LoanStatement h = new LoanStatement(); h.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No; h.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No; h.DataSource = resp.Items; // string from = DateTime.Parse(req.Parameters["_fromDate"]).ToString(_systemService.SessionHelper.GetDateformat(), new CultureInfo("en")); // string to = DateTime.Parse(req.Parameters["_toDate"]).ToString(_systemService.SessionHelper.GetDateformat(), new CultureInfo("en")); string user = _systemService.SessionHelper.GetCurrentUser(); h.Parameters["User"].Value = user; h.Parameters["EmployeeName"].Value = employeeFilter.SelectedItem.Text; h.Parameters["descriptionTrxType1"].Value = GetLocalResourceObject("descriptionTrxType1"); h.Parameters["descriptionTrxType2"].Value = GetLocalResourceObject("descriptionTrxType2"); h.CreateDocument(); ASPxWebDocumentViewer1.DataBind(); ASPxWebDocumentViewer1.OpenReport(h); }
protected void Page_Load(object sender, EventArgs e) { ReportCompositeRequest req = GetRequest(); ListResponse <Model.Reports.RT201> resp = _reportsService.ChildGetAll <Model.Reports.RT201>(req); SalaryHistory h = new SalaryHistory(new Dictionary <string, string> (), ""); h.DataSource = resp.Items; ASPxWebDocumentViewer1.OpenReport(h); }
private ReportCompositeRequest GetRequest() { ReportCompositeRequest req = new ReportCompositeRequest(); req.Size = "1000"; req.StartAt = "0"; req.SortBy = "eventDt"; req.Add(dateRange1.GetRange()); //req.Add(); return(req); }
private ReportCompositeRequest GetRequest() { ReportCompositeRequest req = new ReportCompositeRequest(); req.Size = "1000"; req.StartAt = "0"; req.SortBy = "firstName"; JobInfoParameterSet p = GetJobInfo(); req.Add(p); ActiveStatusParameterSet s = new ActiveStatusParameterSet(); s.active = DropDownList1.SelectedIndex; req.Add(s); return(req); }
private ReportCompositeRequest GetRequest() { ReportCompositeRequest request = new ReportCompositeRequest(); request.Size = "1000"; request.StartAt = "0"; request.SortBy = "hireDate"; request.Add(jobInfo1.GetJobInfo()); request.Add(activeControl.GetActiveStatus()); request.Add(GetCountryInfo()); request.Add(employeeFilter.GetEmployee()); request.Add(GetGenderFilter()); request.Add(GetSponserFilter()); request.Add(GetLocalsFilter()); return(request); }
private void FillReport(bool throwException = true) { ReportCompositeRequest req = GetRequest(); ListResponse <Model.Reports.RT801> resp = _reportsService.ChildGetAll <Model.Reports.RT801>(req); if (!resp.Success) { Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString()); } resp.Items.ForEach(x => x.DateString = x.eventDT.ToString(_systemService.SessionHelper.GetDateformat(), new CultureInfo("en"))); SignInTrail h = new SignInTrail(); h.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No; h.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No; h.DataSource = resp.Items; string from = DateTime.Parse(req.Parameters["_fromDate"]).ToString(_systemService.SessionHelper.GetDateformat()); string to = DateTime.Parse(req.Parameters["_toDate"]).ToString(_systemService.SessionHelper.GetDateformat()); string user = _systemService.SessionHelper.GetCurrentUser(); h.Parameters["From"].Value = from; h.Parameters["To"].Value = to; h.Parameters["User"].Value = user; if (resp.Items.Count > 0) { if (req.Parameters["_userId"] != "0") { h.Parameters["UserId"].Value = resp.Items[0].userName; } else { h.Parameters["UserId"].Value = GetGlobalResourceObject("Common", "All"); } } h.CreateDocument(); ASPxWebDocumentViewer1.OpenReport(h); ASPxWebDocumentViewer1.DataBind(); }
protected void Unnamed_Event(object sender, DirectEventArgs e) { ReportCompositeRequest request = GetRequest(); if (string.IsNullOrEmpty(e.ExtraParams["week"])) { return; } string week = e.ExtraParams["week"]; int year = Convert.ToInt32(week.Split('-')[0]); int weekNo = Convert.ToInt32(week.Split('-')[1]); DateTime d = FirstDateOfWeekISO8601(year, weekNo); DateTime dF = d.AddDays(6); DateRangeParameterSet r = new DateRangeParameterSet(); r.DateFrom = d; r.DateTo = dF; r.IsDayId = true; request.Add(r); ListResponse <Model.Reports.RT304> resp = _reportsService.ChildGetAll <Model.Reports.RT304>(request); if (!resp.Success) { X.MessageBox.ButtonText.Ok = Resources.Common.Ok; Common.errorMessage(resp); return; } if (resp.Items.Count > 0) { DisplayResult(resp.Items); } else { firstStore.DataSource = new List <departmentAvailability>(); firstStore.DataBind(); } }
protected void firstStore_ReadData(object sender, StoreReadDataEventArgs e) { ReportCompositeRequest requst = GetRequest(); }
private void FillReport(bool isInitial = false, bool throwException = true) { ReportCompositeRequest req = GetRequest(); ListResponse <AionHR.Model.Reports.RT306> resp = _reportsService.ChildGetAll <AionHR.Model.Reports.RT306>(req); if (!resp.Success) { if (throwException) { throw new Exception(resp.Error + "<br>" + GetGlobalResourceObject("Errors", "ErrorLogId") + resp.LogId + "</br>"); } else { X.MessageBox.ButtonText.Ok = Resources.Common.Ok; Common.errorMessage(resp); return; } } resp.Items.ForEach(x => { DateTime date = DateTime.ParseExact(x.dayId, "yyyyMMdd", new CultureInfo("en")); x.dateString = date.ToString(_systemService.SessionHelper.GetDateformat()); x.dowString = GetGlobalResourceObject("Common", date.DayOfWeek.ToString() + "Text").ToString(); x.specialTasks = x.jobTasks = "00:00"; x.specialTasks = x.unpaidLeaves; x.jobTasks = x.paidLeaves; x.dayStatusString = GetLocalResourceObject("status" + x.dayStatus.ToString()).ToString(); //if (x.workingHours != "00:00") //{ // x.unpaidLeaves = "00:00"; // x.jobTasks = x.paidLeaves; // x.paidLeaves = "00:00"; // x.specialTasks = x.unpaidLeaves; //} //else } ); DayStatus h = new DayStatus(); h.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No; h.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No; h.DataSource = resp.Items; string from = DateTime.ParseExact(req.Parameters["_fromDayId"], "yyyyMMdd", new CultureInfo("en")).ToString(_systemService.SessionHelper.GetDateformat(), new CultureInfo("en")); string to = DateTime.ParseExact(req.Parameters["_toDayId"], "yyyyMMdd", new CultureInfo("en")).ToString(_systemService.SessionHelper.GetDateformat(), new CultureInfo("en")); string user = _systemService.SessionHelper.GetCurrentUser(); h.Parameters["FromParameter"].Value = from; h.Parameters["ToParameter"].Value = to; h.Parameters["UserParameter"].Value = user; if (req.Parameters["_dayStatus"] != "0") { h.Parameters["dayStatusParameter"].Value = dayStatus.SelectedItem.Text; } else { h.Parameters["dayStatusParameter"].Value = GetGlobalResourceObject("Common", "All"); } if (req.Parameters["_punchStatus"] != "0") { h.Parameters["punchStatus"].Value = punchStatus.SelectedItem.Text; } else { h.Parameters["punchStatus"].Value = GetGlobalResourceObject("Common", "All"); } if (req.Parameters["_departmentId"] != "0") { h.Parameters["DepartmentName"].Value = jobInfo1.GetDepartment(); } else { h.Parameters["DepartmentName"].Value = GetGlobalResourceObject("Common", "All"); } //ListRequest def = new ListRequest(); //int lateness = 0; //ListResponse<KeyValuePair<string, string>> items = _systemService.ChildGetAll<KeyValuePair<string, string>>(def); //try //{ // lateness = Convert.ToInt32(items.Items.Where(s => s.Key == "allowedLateness").First().Value); //} //catch //{ //} //h.Parameters["AllowedLatenessParameter"].Value = lateness; h.PrintingSystem.Document.ScaleFactor = 4; h.CreateDocument(); ASPxWebDocumentViewer1.OpenReport(h); }
private void FillReport(bool isInitial = false, bool throwException = true) { ReportCompositeRequest req = GetRequest(); ListResponse <Model.Reports.RT301> resp = _reportsService.ChildGetAll <Model.Reports.RT301>(req); //if (!resp.Success) //{ // throw new Exception(resp.Error + "<br>" + GetGlobalResourceObject("Errors", "ErrorLogId") + resp.LogId + "</br>"); //} if (!resp.Success) { Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString()); } List <Model.Reports.DailyAttendance> atts = new List <Model.Reports.DailyAttendance>(); resp.Items.ForEach(x => atts.Add(new Model.Reports.DailyAttendance() { name = x.name, branchName = x.branchName, departmentName = x.departmentName, Date = DateTime.ParseExact(x.dayId, "yyyyMMdd", new CultureInfo("en")), lateness = x.OL_A_SIGN[0] == '-' ? (new TimeSpan(Convert.ToInt32(x.OL_A.Substring(1, 2)), -Convert.ToInt32(x.OL_A.Substring(4, 2)), 0)) : (new TimeSpan(Convert.ToInt32(x.OL_A.Substring(0, 2)), Convert.ToInt32(x.OL_A.Substring(3, 2)), 0)), early = x.OL_D_SIGN[0] == '-' ? (new TimeSpan(Convert.ToInt32(x.OL_D.Substring(1, 2)), Convert.ToInt32(x.OL_D.Substring(4, 2)), 0)) : (new TimeSpan(Convert.ToInt32(x.OL_D.Substring(0, 2)), Convert.ToInt32(x.OL_D.Substring(3, 2)), 0)), workingHours = new TimeSpan(Convert.ToInt32(x.workingTime.Substring(0, 2)), Convert.ToInt32(x.workingTime.Substring(3, 2)), 0), workingHoursString = x.workingTime, earlyString = x.OL_D, latenessString = x.OL_A })); atts.ForEach(x => { x.DOW = GetGlobalResourceObject("Common", x.Date.DayOfWeek.ToString() + "Text").ToString(); x.DateString = x.Date.ToString(_systemService.SessionHelper.GetDateformat(), CultureInfo.CurrentUICulture); }); DailyAttendance h = new DailyAttendance(); h.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No; h.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No; h.DataSource = atts; h.Parameters["From"].Value = DateTime.Parse(req.Parameters["_fromDate"]).ToString(_systemService.SessionHelper.GetDateformat()); h.Parameters["To"].Value = DateTime.Parse(req.Parameters["_toDate"]).ToString(_systemService.SessionHelper.GetDateformat()); h.Parameters["User"].Value = _systemService.SessionHelper.GetCurrentUser(); if (resp.Items.Count > 0) { if (req.Parameters["_employeeId"] != "0") { h.Parameters["Employee"].Value = resp.Items[0].name; } else { h.Parameters["Employee"].Value = GetGlobalResourceObject("Common", "All"); } } h.CreateDocument(); ASPxWebDocumentViewer1.DataBind(); ASPxWebDocumentViewer1.OpenReport(h); }