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