public static List <ReportResponseModelWithContacts> GetAttendanceReportWithContacts(ReportRequestModel requestModel) { DataSet ds = new DataSet("TimeRanges"); var reportResponseModel = new ReportResponseModel(); var reportResponseModelWithContactsList = new List <ReportResponseModelWithContacts>(); //var reportResponseModelWithContacts = new ReportResponseModelWithContacts(); using (var con = new SqlConnection(ConnectionString)) { con.Open(); var sqlComm = new SqlCommand("GetAttendanceReportWithContacts", con) { CommandType = CommandType.StoredProcedure }; sqlComm.Parameters.AddWithValue("@name", requestModel.Name); sqlComm.Parameters.AddWithValue("@class", requestModel.StudentClass); sqlComm.Parameters.AddWithValue("@section", requestModel.Section); sqlComm.Parameters.AddWithValue("@fromDate", requestModel.DtFrom); sqlComm.Parameters.AddWithValue("@toDate", requestModel.DtTo); sqlComm.Parameters.AddWithValue("@category", requestModel.Category); SqlDataAdapter da = new SqlDataAdapter { SelectCommand = sqlComm }; da.Fill(ds); //sqlComm.ExecuteReader(); sqlComm.ExecuteNonQuery(); con.Close(); if (ds.Tables.Count > 0) { reportResponseModel.Rows = new List <Row>(); foreach (DataRow dataRow in ds.Tables[0].Rows) { var reportResponseModelWithContacts = new ReportResponseModelWithContacts { Name = dataRow[0].ToString(), Class = dataRow[1].ToString(), Section = dataRow[2].ToString(), Gender = dataRow[3].ToString(), RFID = dataRow[4].ToString(), AttendanceDate = dataRow[5].ToString(), InTime = dataRow[6].ToString(), OutTime = dataRow[7].ToString(), Duration = dataRow[8].ToString(), UserName = dataRow[9].ToString(), PhoneNumber = dataRow[10].ToString() }; reportResponseModelWithContactsList.Add(reportResponseModelWithContacts); } } } return(reportResponseModelWithContactsList); }
public static ReportResponseModel GetAttendanceReport(ReportRequestModel requestModel) { DataSet ds = new DataSet("TimeRanges"); var reportResponseModel = new ReportResponseModel(); using (var con = new SqlConnection(ConnectionString)) { con.Open(); var sqlComm = new SqlCommand("GetAttendanceReport", con) { CommandType = CommandType.StoredProcedure }; sqlComm.Parameters.AddWithValue("@name", requestModel.Name); sqlComm.Parameters.AddWithValue("@class", requestModel.StudentClass); sqlComm.Parameters.AddWithValue("@section", requestModel.Section); sqlComm.Parameters.AddWithValue("@fromDate", requestModel.DtFrom); sqlComm.Parameters.AddWithValue("@toDate", requestModel.DtTo); sqlComm.Parameters.AddWithValue("@category", requestModel.Category); SqlDataAdapter da = new SqlDataAdapter { SelectCommand = sqlComm }; da.Fill(ds); //sqlComm.ExecuteReader(); sqlComm.ExecuteNonQuery(); con.Close(); if (ds.Tables.Count > 0) { reportResponseModel.Columns = new List <string>(); foreach (DataColumn column in ds.Tables[0].Columns) { reportResponseModel.Columns.Add(column.ColumnName); } reportResponseModel.Rows = new List <Row>(); foreach (DataRow dataRow in ds.Tables[0].Rows) { var row = new Row(); row.RowCells = new List <string>(); foreach (var cells in dataRow.ItemArray) { row.RowCells.Add(cells.ToString()); } reportResponseModel.Rows.Add(row); } } } return(reportResponseModel); }
public ActionResult OrderReport(string startDate, string endDate) { var model = new ReportResponseModel(); int unixTimestamp = (Int32)(DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalSeconds; ReportRequest request = new ReportRequest(); request.merchant = "OPU_TEST"; request.startDate = startDate; request.endDate = endDate; request.timeStamp = unixTimestamp.ToString(); Options options = new Options(); options.Url = "https://secure.payu.com.tr/reports/orders"; options.SecretKey = "SECRET_KEY"; model.Response = ReportRequest.Execute(request, options); //api çağrısının başlatıldığı kısmı temsil eder. return(View(model)); }
public HomePage() { InitializeComponent(); NavigationPage.SetHasNavigationBar(this, false); _apiServices = new RestApi(); _baseUrl = Settings.Url + Domain.AppointmentApiConstant; _baseUrlPrescription = Settings.Url + Domain.PrescriptionApiConstant; _baseUrlReports = Settings.Url + Domain.ReportApiConstant; _objAppointmentResponseModel = new AppointmentResponseModel(); _objAppointmentRequestModel = new AppointmentRequestModel(); _objPrescriptionRequestModel = new PrescriptionRequestModel(); _objPrescriptionResponseModel = new PrescriptionResponseModel(); _objReportRequestModel = new ReportRequestModel(); _objReportResponseModel = new ReportResponseModel(); _objHeaderModel = new HeaderModel(); //App.DetailPage = this; _objHeaderModel.OTPToken = Settings.TokenCode; }
public async void LoadReportByFilter() { try { _objReportRequestModel.ClinicName = ""; _objReportRequestModel.DoctorName = ""; _objReportRequestModel.IsOrderByDate = true; _objReportRequestModel.OrderByName = false; _objReportRequestModel.Limit = 15; _objReportRequestModel.OffSet = 0; _objReportRequestModel.UserId = Settings.Id; // await Navigation.PushPopupAsync(new LoadingPopPage()); _objReportResponseModel = await _apiServices.GetReportListAsync(new Get_API_Url().ReportListApi(_baseUrlReports), true, _objHeaderModel, _objReportRequestModel); var Result = _objReportResponseModel.Response; if (Result.StatusCode == 200) { //listReportListByFilter.ItemsSource = Result.ReportListPatient; var result = Result.ReportListPatient.FirstOrDefault() as ReportListPatient; if (result != null) { LblReportdate.Text = result.ReportDateTime + ","; LblReporttime.Text = result.ReportTime; } // DependencyService.Get<IToast>().ShowToast(Result.Message); // await App.NavigationPage.Navigation.PushAsync(new OTPVerificationPage(Result)); await Navigation.PopAllPopupAsync(); } else { DependencyService.Get <IToast>().ShowToast(Result.Message); await Navigation.PopAllPopupAsync(); } } catch (Exception ex) { DependencyService.Get <IToast>().ShowToast("Something Went Wrong please try Again or check your Internet Connection!!"); await Navigation.PopAllPopupAsync(); var msg = ex.Message; } }
public async void LoadReportByFilter() { try { await Navigation.PushPopupAsync(new LoadingPopPage()); _objReportResponseModel = await _apiServices.GetReportListAsync(new Get_API_Url().ReportListApi(_baseUrl), true, _objHeaderModel, _objReportRequestModel); var Result = _objReportResponseModel.Response; if (Result.StatusCode == 200) { if (Result.ReportListPatient.Count > 0) { listReportListByFilter.ItemsSource = Result.ReportListPatient; // DependencyService.Get<IToast>().ShowToast(Result.Message); // await App.NavigationPage.Navigation.PushAsync(new OTPVerificationPage(Result)); await Navigation.PopAllPopupAsync(); } else { DependencyService.Get <IToast>().ShowToast("There is No Data To Display!"); await Navigation.PopAllPopupAsync(); } } else { DependencyService.Get <IToast>().ShowToast(Result.Message); await Navigation.PopAllPopupAsync(); } } catch (Exception ex) { DependencyService.Get <IToast>().ShowToast("Something Went Wrong please try Again or check your Internet Connection!!"); await Navigation.PopAllPopupAsync(); var msg = ex.Message; } }
public ReportsPage(ReportRequestModel objReportRequestModel) { InitializeComponent(); CrossDownloadManager.Current.CollectionChanged += (sender, e) => System.Diagnostics.Debug.WriteLine( "[DownloadManager] " + e.Action + " -> New items: " + (e.NewItems?.Count ?? 0) + " at " + e.NewStartingIndex + " || Old items: " + (e.OldItems?.Count ?? 0) + " at " + e.OldStartingIndex ); NavigationPage.SetHasNavigationBar(this, false); _apiServices = new RestApi(); _objReportListPatient = new ReportListPatient(); _baseUrl = Settings.Url + Domain.ReportApiConstant; _objReportRequestModel = new ReportRequestModel(); _objReportResponseModel = new ReportResponseModel(); _objHeaderModel = new HeaderModel(); _objHeaderModel.OTPToken = Settings.TokenCode; _objReportRequestModel = objReportRequestModel; App.DetailPage = this; LoadReportByFilter(); }
/// <summary> /// Tests the running of the controls text exported to word /// </summary> public ReportResponseModel RunReport(string astrOrgCode, int aintSequenceNumber) { ParameterValues parameter; ReportRequestModel reportRequestModel = new ReportRequestModel(); reportRequestModel.ExportType = USISDKConstants.ReportConstants.ExportType.PDF; parameter = new ParameterValues(); parameter.ParameterName = "Single Select Text Custom Values"; parameter.Values.Add("Value_2"); reportRequestModel.Parameters.Add(parameter); parameter = new ParameterValues(); parameter.ParameterName = "Single Select No Custom Values"; parameter.Values.Add("Value_1"); reportRequestModel.Parameters.Add(parameter); parameter = new ParameterValues(); parameter.ParameterName = "Multi Select No Custom Values"; parameter.Values.Add("Value_1"); parameter.Values.Add("Value_2"); reportRequestModel.Parameters.Add(parameter); parameter = new ParameterValues(); parameter.ParameterName = "Number Type"; parameter.Values.Add("8"); reportRequestModel.Parameters.Add(parameter); parameter = new ParameterValues(); parameter.ParameterName = "Single Date"; parameter.Values.Add(DateTime.Now.ToString(USISDKConstants.ReportConstants.ReportDateFormat)); reportRequestModel.Parameters.Add(parameter); parameter = new ParameterValues(); parameter.ParameterName = "Currency Type"; parameter.Values.Add("8.95"); reportRequestModel.Parameters.Add(parameter); parameter = new ParameterValues(); parameter.ParameterName = "Multi Select Text Box Custom Values"; parameter.Values.Add("Value_1"); parameter.Values.Add("I'm Custom"); reportRequestModel.Parameters.Add(parameter); parameter = new ParameterValues(); parameter.ParameterName = "Time Field"; parameter.Values.Add(DateTime.Now.ToString(USISDKConstants.ReportConstants.ReportDateFormat)); reportRequestModel.Parameters.Add(parameter); parameter = new ParameterValues(); parameter.ParameterName = "Date Time Field"; parameter.Values.Add(DateTime.Now.ToString(USISDKConstants.ReportConstants.ReportDateFormat)); reportRequestModel.Parameters.Add(parameter); parameter = new ParameterValues(); parameter.ParameterName = "Numeric Range Dropdown"; parameter.Values.Add("1"); parameter.Values.Add("2"); reportRequestModel.Parameters.Add(parameter); parameter = new ParameterValues(); parameter.ParameterName = "Numeric Range"; parameter.Values.Add("1"); parameter.Values.Add("2"); reportRequestModel.Parameters.Add(parameter); parameter = new ParameterValues(); parameter.ParameterName = "Date Range"; parameter.Values.Add(DateTime.Now.ToString(USISDKConstants.ReportConstants.ReportDateFormat)); parameter.Values.Add(DateTime.Now.AddDays(7).ToString(USISDKConstants.ReportConstants.ReportDateFormat)); reportRequestModel.Parameters.Add(parameter); parameter = new ParameterValues(); parameter.ParameterName = "Boolean Value with Text"; parameter.Values.Add(true.ToString()); reportRequestModel.Parameters.Add(parameter); parameter = new ParameterValues(); parameter.ParameterName = "Boolean Value No Text"; parameter.Values.Add("True"); reportRequestModel.Parameters.Add(parameter); ReportResponseModel reportResponseModelTest = APIUtil.RunReport(USISDKClient, astrOrgCode, aintSequenceNumber, reportRequestModel); return(reportResponseModelTest); }
/// <summary> /// Tests the running of the controls text exported to pdf /// </summary> public ReportResponseModel RunReport(string astrOrgCode, int aintSequenceNumber, ReportRequestModel reportRequestModel) { ReportResponseModel reportResponseModel = APIUtil.RunReport(USISDKClient, astrOrgCode, aintSequenceNumber, reportRequestModel); return(reportResponseModel); }