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