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;
}
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT508> resp = _reportsService.ChildGetAll <Model.Reports.RT508>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
string getLan = _systemService.SessionHelper.getLangauge();
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
PayrollLeavePaymentsReport h = new PayrollLeavePaymentsReport(parameters, getLan);
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;
// h.Parameters["Fitlers"].Value = texts.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
private void FillReport(bool throwException = true)
{
int count = 0;
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT802> resp = _reportsService.ChildGetAll <Model.Reports.RT802>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
resp.Items.ForEach(x => { x.TypeString = GetGlobalResourceObject("Common", "TrType" + x.type.ToString()).ToString(); x.ClassIdString = GetGlobalResourceObject("Classes", "Class" + x.classId.ToString()) != null ? GetGlobalResourceObject("Classes", "Class" + x.classId.ToString()).ToString() : "NA"; x.DateString = x.eventDt.ToString(_systemService.SessionHelper.GetDateformat() + " HH:mm", CultureInfo.CurrentCulture); });
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
AuditTrail h = new AuditTrail(parameters);
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.Parameters["User"].Value = _systemService.SessionHelper.GetCurrentUser();
// h.Parameters["Filters"].Value = texts.Text;
h.DataSource = resp.Items;
h.CreateDocument();
ASPxWebDocumentViewer1.OpenReport(h);
ASPxWebDocumentViewer1.DataBind();
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT401> resp = _reportsService.ChildGetAll <Model.Reports.RT401>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
resp.Items.ForEach(x => x.StatusString = GetLocalResourceObject("Status" + x.status.ToString()).ToString());
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
LoansReport h = new LoansReport(parameters);
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["User"].Value = user;
// h.Parameters["Filters"].Value = texts.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
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();
}
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 void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT602> resp = _reportsService.ChildGetAll <Model.Reports.RT602>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
resp.Items.ForEach(x =>
{
if (x.hireDate != null)
{
x.hireDateString = x.hireDate.Value.ToString(_systemService.SessionHelper.GetDateformat());
}
else
{
x.hireDateString = string.Empty;
}
if (x.lastReturnDate != null)
{
x.lastReturnDateString = x.lastReturnDate.Value.ToString(_systemService.SessionHelper.GetDateformat());
}
else
{
x.lastReturnDateString = string.Empty;
}
});
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
LeaveBalance h = new LeaveBalance(parameters);
h.DataSource = resp.Items;
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;
//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;
// h.Parameters["Fitlers"].Value = texts.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
List <XMLDictionary> statusList = Common.XMLDictionaryList(_systemService, "13");
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT601> resp = _reportsService.ChildGetAll <Model.Reports.RT601>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
errorMSG.Text = "";
string format = _systemService.SessionHelper.GetDateformat();
resp.Items.ForEach(s =>
{
s.endDateString = s.endDate.ToString(format, CultureInfo.CurrentCulture);
s.startDateString = s.startDate.ToString(format, CultureInfo.CurrentCulture);
if (s.returnDate.HasValue)
{
s.returnDateString = s.returnDate.Value.ToString(format, CultureInfo.CurrentCulture);
}
s.isPaidString = s.isPaid ? GetLocalResourceObject("Paid1").ToString() : GetLocalResourceObject("Paid0").ToString();
s.statusString = statusList.Where(y => y.key == s.status).Count() != 0 ? statusList.Where(y => y.key == s.status).First().value : "";
});
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
LeaveList h = new LeaveList(parameters);
h.DataSource = resp.Items;
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;
//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["User"].Value = user;
// h.Parameters["Fitlers"].Value = texts.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
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);
}
public void FillReport(bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT201> resp = _reportsService.ChildGetAll <Model.Reports.RT201>(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());
}
string getLang = _systemService.SessionHelper.getLangauge();
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
SalaryHistory h = new SalaryHistory(parameters, getLang);
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;
resp.Items.ForEach(x => {
x.PaymentFrequencyString = x.paymentFrequency.HasValue? GetGlobalResourceObject("Common", ((PaymentFrequency)x.paymentFrequency).ToString()).ToString():"";
x.SalaryTypeString = x.salaryType.HasValue ? GetGlobalResourceObject("Common", ((SalaryType)x.salaryType).ToString()).ToString() : "";
x.EffectiveDateString = x.effectiveDate.ToString(_systemService.SessionHelper.GetDateformat(), CultureInfo.CurrentCulture);
});
h.DataSource = resp.Items;
string user = _systemService.SessionHelper.GetCurrentUser();
h.Parameters["User"].Value = user;
h.CreateDocument();
//string format = "Pdf";
//string fileName = String.Format("Report.{0}", format);
//MemoryStream ms = new MemoryStream();
//h.ExportToPdf(ms,new DevExpress.XtraPrinting.PdfExportOptions() { ShowPrintDialogOnOpen = true });
//Response.Clear();
//Response.ContentType = "application/pdf";
//Response.AddHeader("Content-Disposition", String.Format("{0}; filename={1}", "inline", fileName));
//Response.BinaryWrite(ms.ToArray());
//Response.End();
ASPxWebDocumentViewer1.OpenReport(h);
ASPxWebDocumentViewer1.DataBind();
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT113> resp = _reportsService.ChildGetAll <Model.Reports.RT113>(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());
}
resp.Items.ForEach(x => {
x.licenseExpiryDateString = x.licenseExpiryDate == null ? " " : ((DateTime)x.licenseExpiryDate).ToString(_systemService.SessionHelper.GetDateformat());
x.licenseIssueDateString = x.licenseIssueDate == null ? " " : ((DateTime)x.licenseIssueDate).ToString(_systemService.SessionHelper.GetDateformat());
});
string getLang = _systemService.SessionHelper.getLangauge();
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
BranchWorkforce h = new BranchWorkforce(parameters, getLang);
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["Fitlers"].Value = texts.Text;
h.Parameters["User"].Value = user;
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 void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT111> resp = _reportsService.ChildGetAll <Model.Reports.RT111>(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());
return;
}
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
BankAccounts h = new BankAccounts(parameters);
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["PositionName"].Value = jobInfo1.GetPosition();
h.Parameters["User"].Value = user;
//h.Parameters["Status"].Value = statusCombo.SelectedItem.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT310> resp = _reportsService.ChildGetAll <Model.Reports.RT310>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
for (int i = resp.Items.Count - 1; i >= 0; i--)
{
DateTime parsed = DateTime.Now;
if (DateTime.TryParseExact(resp.Items[i].dayId, "yyyyMMdd", new CultureInfo("en"), DateTimeStyles.AdjustToUniversal, out parsed))
{
resp.Items[i].dayIdDateTime = parsed;
//x.dayIdString = parsed.ToString(_systemService.SessionHelper.GetDateformat());
// Use reformatted
}
else
{
resp.Items.RemoveAt(i);
}
}
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
AttendanceScheduleReport h = new AttendanceScheduleReport(resp.Items, _systemService.SessionHelper.CheckIfArabicSession(), _systemService.SessionHelper.GetDateformat(), parameters);
h.PrintingSystem.Document.AutoFitToPagesWidth = 1;
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;
//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"));
h.Parameters["User"].Value = string.IsNullOrEmpty(_systemService.SessionHelper.GetCurrentUser())?" ": _systemService.SessionHelper.GetCurrentUser();
// h.Parameters["Fitlers"].Value = texts.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.OpenReport(h);
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT503> resp = _reportsService.ChildGetAll <Model.Reports.RT503>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
string user = _systemService.SessionHelper.GetCurrentUser();
bool isArabic = _systemService.SessionHelper.CheckIfArabicSession();
int bulk = 1;
if (filterBy.Value != null)
{
int.TryParse(filterBy.Value.ToString(), out bulk);
}
string getLan = _systemService.SessionHelper.getLangauge();
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
GroupedPayrollCrossReport h = new GroupedPayrollCrossReport(resp.Items, isArabic, (GroupedPayrollCrossReport.GroupType)bulk, parameters, getLan);
h.PrintingSystem.Document.AutoFitToPagesWidth = 1;
h.Parameters["User"].Value = user;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT502> resp = _reportsService.ChildGetAll <Model.Reports.RT502>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
resp.Items.ForEach(x =>
{
x.cvOvertime = Math.Round(x.cvOvertime, 2);
x.cvLateness = Math.Round(x.cvLateness, 2);
x.cvAbsence = Math.Round(x.cvAbsence, 2);
x.cvDisappearance = Math.Round(x.cvDisappearance, 2);
x.cvMissedPunches = Math.Round(x.cvMissedPunches, 2);
});
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
PayrollPeriodTimeCodes h = new PayrollPeriodTimeCodes(parameters);
h.DataSource = resp.Items;
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;
string user = _systemService.SessionHelper.GetCurrentUser();
//h.Parameters["User"].Value = _systemService.SessionHelper.GetCurrentUser();
// h.Parameters["Filters"].Value = texts.Text;
h.DataSource = resp.Items;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
public void FillReport(bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT202> resp = _reportsService.ChildGetAll <Model.Reports.RT202>(req);
resp.Items.ForEach(x =>
{
if (x.prevBasicAmount == 0)
{
x.prevBasicAmount = null; x.prevCurrencyRef = ""; x.PrevSalaryTypeString = "";
}
});
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
//resp.Items.ForEach(x => { x.PaymentFrequencyString = GetGlobalResourceObject("Common", ((PaymentFrequency)x.paymentFrequency).ToString()).ToString(); });
resp.Items.ForEach(x =>
{
x.SalaryTypeString = x.salaryType.HasValue ? GetGlobalResourceObject("Common", ((SalaryType)x.salaryType).ToString()).ToString() : "";
x.PrevSalaryTypeString = x.prevSalaryType.HasValue ? GetGlobalResourceObject("Common", ((SalaryType)x.prevSalaryType).ToString()).ToString() : "";
x.DateString = x.effectiveDate != null ? ((DateTime)(x.effectiveDate)).ToString(_systemService.SessionHelper.GetDateformat(), CultureInfo.CurrentCulture) : "";
});
string getLan = _systemService.SessionHelper.getLangauge();
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
SalaryChanges h = new SalaryChanges(parameters, getLan);
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 user = _systemService.SessionHelper.GetCurrentUser();
h.Parameters["User"].Value = user;
h.CreateDocument();
ASPxWebDocumentViewer1.OpenReport(h);
ASPxWebDocumentViewer1.DataBind();
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT115> resp = _reportsService.ChildGetAll <Model.Reports.RT115>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
resp.Items.ForEach(x =>
{
if (x.hireDate != null)
{
x.hireDateString = ((DateTime)(x.hireDate)).ToString(_systemService.SessionHelper.GetDateformat(), System.Threading.Thread.CurrentThread.CurrentCulture);
}
if (x.terminationDate != null)
{
x.terminationDateString = ((DateTime)(x.terminationDate)).ToString(_systemService.SessionHelper.GetDateformat(), System.Threading.Thread.CurrentThread.CurrentCulture);
}
});
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
IndemnityReport h = new IndemnityReport(parameters);
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.Parameters["User"].Value = _systemService.SessionHelper.GetCurrentUser();
// h.Parameters["Filters"].Value = texts.Text;
h.DataSource = resp.Items;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
private void FillReport(bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT203> resp = _reportsService.ChildGetAll <Model.Reports.RT203>(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());
}
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
string getLan = _systemService.SessionHelper.getLangauge();
PointInTimeSalary h = new PointInTimeSalary(parameters, getLan);
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;
resp.Items.ForEach(x => { x.SalaryTypeString = x.salaryType.HasValue ? GetGlobalResourceObject("Common", ((SalaryType)x.salaryType).ToString()).ToString() : ""; });
h.DataSource = resp.Items;
//string from = DateTime.Parse(req.Parameters["_asOfDate"]).ToString(_systemService.SessionHelper.GetDateformat());
string user = _systemService.SessionHelper.GetCurrentUser();
h.Parameters["User"].Value = user;
// h.Parameters["Fitlers"].Value = texts.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.OpenReport(h);
ASPxWebDocumentViewer1.DataBind();
}
private void FillReport(bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT803> resp = _reportsService.ChildGetAll <Model.Reports.RT803>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
Dictionary <string, string> parameters = Common.FetchReportParameters(texts.Text);
UsersReport h = new UsersReport(parameters);
List <XMLDictionary> userTypeList = Common.XMLDictionaryList(_systemService, "7");
resp.Items.ForEach(x => x.userTypeName = userTypeList.Where(y => y.key == x.userType).Count() != 0 ? userTypeList.Where(y => y.key == x.userType).First().value : "");
// 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;
// h.Parameters["Filters"].Value = texts.Text;
//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();
}
private void FillReport(bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT104> resp = _reportsService.ChildGetAll <Model.Reports.RT104>(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());
}
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
YearsInService y = new YearsInService(parameters);
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;
List <Model.Reports.RT104> reordered = resp.Items.Where(x => x.hiredMonth >= DateTime.Now.Month).ToList();
reordered.AddRange(resp.Items.Where(x => x.hiredMonth < DateTime.Now.Month).OrderBy(h => h.hiredMonth).ToList());
reordered.ForEach(x => x.HiredMonthString = GetGlobalResourceObject("Common", new CultureInfo("en-US").DateTimeFormat.GetMonthName(x.hiredMonth)).ToString());
y.DataSource = reordered;
string user = _systemService.SessionHelper.GetCurrentUser();
y.Parameters["User"].Value = user;
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(y);
}
protected void firstStore_ReadData(object sender, StoreReadDataEventArgs e)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT103> resp = _reportsService.ChildGetAll <Model.Reports.RT103>(req);
resp.Items.ForEach(x =>
{
x.dateString = x.date.ToString(_systemService.SessionHelper.GetDateformat(), System.Threading.Thread.CurrentThread.CurrentUICulture);
});
if (!resp.Success)
{
X.MessageBox.ButtonText.Ok = Resources.Common.Ok;
Common.errorMessage(resp);
return;
}
firstStore.DataSource = resp.Items;
firstStore.DataBind();
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT506> resp = _reportsService.ChildGetAll <Model.Reports.RT506>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
PayrollPeriodSummary h = new PayrollPeriodSummary(parameters);
h.DataSource = resp.Items;
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;
string user = _systemService.SessionHelper.GetCurrentUser();
//if (resp.Items.Count != 0)
//{
// h.Parameters["startDate"].Value = resp.Items[0].startDate.ToString(_systemService.SessionHelper.GetDateformat());
// h.Parameters["endDate"].Value = resp.Items[0].endDate.ToString(_systemService.SessionHelper.GetDateformat());
//}
h.Parameters["User"].Value = user;
// h.Parameters["Fitlers"].Value = texts.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
public void FillReport(bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT105> resp = _reportsService.ChildGetAll <Model.Reports.RT105>(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());
}
resp.Items.ForEach(x => x.DateString = x.date.ToString(_systemService.SessionHelper.GetDateformat()));
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
JobHistory h = new JobHistory(parameters);
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.Parameters["User"].Value = _systemService.SessionHelper.GetCurrentUser();
h.DataSource = resp.Items;
h.CreateDocument();
ASPxWebDocumentViewer1.OpenReport(h);
ASPxWebDocumentViewer1.DataBind();
}
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();
}
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT507> resp = _reportsService.ChildGetAll <Model.Reports.RT507>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
List <Model.Reports.RT501> Items = new List <Model.Reports.RT501>();
Items.AddRange(resp.Items);
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
EmployeesPaySlip h = new EmployeesPaySlip(Items, _systemService.SessionHelper.CheckIfArabicSession(), parameters);
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;
string user = _systemService.SessionHelper.GetCurrentUser();
h.Parameters["user"].Value = user;
// h.Parameters["Fitlers"].Value = texts.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
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());
}
var monthlyGrouped = resp.Items.GroupBy(x => x.month);
MonthlyEmployeeAttendanceCollection monthlyAtts = new MonthlyEmployeeAttendanceCollection();
foreach (var item in monthlyGrouped)
{
MonthAttendance at = new MonthAttendance(item.Key, item.ToList());
monthlyAtts.Add(at);
}
//var grouped = resp.Items.GroupBy(x => x.name.fullName);
//EmployeeAttendanceCollection ats = new EmployeeAttendanceCollection();
//foreach (var item in grouped)
//{
// EmployeeAttendances at = new EmployeeAttendances();
// at.name = item.Key;
// var details = item.ToList();
// if (details.Count != 0)
// {
// at.departmentName = details[0].departmentName;
// at.branchName = details[0].branchName;
// at.positionName = details[0].positionName;
// }
// foreach (var subItem in item.ToList())
// {
// at.Add(new Attendance() { workingTime=subItem.workingTime, day = subItem.day, year=subItem.year, month = subItem.month, timeIn = subItem.checkIn, timeOut = subItem.checkOut });
// }
// ats.Add(at);
//}
TimeAttendanceSummary h = new TimeAttendanceSummary();
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 = monthlyAtts;
string user = _systemService.SessionHelper.GetCurrentUser();
DateTime date = DateTime.Parse(req.Parameters["_fromDate"]);
h.Parameters["User"].Value = user;
h.Parameters["Fitlers"].Value = texts.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT112> resp = _reportsService.ChildGetAll <Model.Reports.RT112>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
EmployeesNotes h = new EmployeesNotes(parameters);
//List<Model.Reports.RT112> EN = new List<Model.Reports.RT112>();
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;
// var d= resp.Items.GroupBy(x => x.employeeName);
resp.Items.ForEach(x => x.dateString = x.date.ToString(_systemService.SessionHelper.GetDateformat() + " HH:MM"));
// d.ToList().ForEach(x =>
// {
// //EN.Add(x.ToList()[0]);
// //x.ToList().RemoveAt(0);
// x.ToList()[0].dateString = x.ToList()[0].date.ToString(_systemService.SessionHelper.GetDateformat() + " HH:MM");
// EN.Add(x.ToList()[0]);
// foreach (var e in x.Skip(1))
// {
// e.employeeName = "";
// e.dateString = e.date.ToString(_systemService.SessionHelper.GetDateformat() + " HH:MM");
// EN.Add(e);
// }
// }
//);
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["PositionName"].Value = jobInfo1.GetPosition();
h.Parameters["User"].Value = user;
//h.Parameters["Status"].Value = statusCombo.SelectedItem.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT302> resp = _reportsService.ChildGetAll <Model.Reports.RT302>(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());
}
string getLan = _systemService.SessionHelper.getLangauge();
foreach (var item in resp.Items)
{
item.Absent = item.absentDays; // item.calendarDays - item.workingDays;
item.totLateness = item.NET_LATENESS; //item.LATE_CHECKIN + item.DURING_SHIFT_LEAVE + item.EARLY_LEAVE+item.SHIFT_LEAVE_WITHOUT_EXCUSE;
item.totOvertime = item.NET_OVERTIME; //item.OVERTIME + item.EARLY_CHECKIN;
item.Total_Absent += item.Absent;
//if (item.SHIFT_LEAVE_WITHOUT_EXCUSE >= 1)
//{
// item.SHIFT_LEAVE_WITHOUT_EXCUSE = item.SHIFT_LEAVE_WITHOUT_EXCUSE * 60;
//}
//if (item.LATE_CHECKIN >= 1)
//{
// item.LATE_CHECKIN = item.LATE_CHECKIN * 60;
//}
}
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
PeriodSummary h = new PeriodSummary(parameters, getLan);
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["Fitlers"].Value = texts.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
