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