public List <Class_Center> GetClassCenter(Guid?AgencyId, string queryCommand, long centerId = 0)
{
Class_Center center_Class = new Class_Center();
List <Class_Center> centersList = new List <Class_Center>();
try
{
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@Agencyid", AgencyId));
command.Parameters.Add(new SqlParameter("@Command", queryCommand));
command.Parameters.Add(new SqlParameter("@CenterId", centerId));
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "USP_GetCenters_Class";
DataAdapter = new SqlDataAdapter(command);
_dataset = new DataSet();
DataAdapter.Fill(_dataset);
if (_dataset.Tables[0] != null)
{
if (_dataset.Tables[0].Rows.Count > 0)
{
Class_Center class_center = null;
foreach (DataRow dr in _dataset.Tables[0].Rows)
{
class_center = new Class_Center();
class_center.CenterId = Convert.ToInt64(dr["CenterId"]);
class_center.ClassRoomName = dr["ClassroomName"].ToString();
class_center.ClassRoomId = Convert.ToInt64(dr["ClassRoomId"]);
class_center.CenterName = dr["CenterName"].ToString();
centersList.Add(class_center);
}
}
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
DataAdapter.Dispose();
command.Dispose();
}
return(centersList);
}
public List <ClientDetails> GetClientsForReview(out List <ClientReviewStatus> clientStatusList, Class_Center classCenter, string queryCommand)
{
List <ClientDetails> clientDetailsList = new List <ClientDetails>();
ClientDetails clientDetails = null;
ClientReviewStatus clientReviewStatus = null;
clientStatusList = new List <ClientReviewStatus>();
// List<ClientReviewStatus> clientStatusList = new List<ClientReviewStatus>();
try
{
StaffDetails details = new StaffDetails();
if (Connection.State == ConnectionState.Open)
{
Connection.Close();
}
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@Agencyid", classCenter.AgencyId));
command.Parameters.Add(new SqlParameter("@ClassRoomId", classCenter.ClassRoomId));
command.Parameters.Add(new SqlParameter("@CenterId", classCenter.CenterId));
command.Parameters.Add(new SqlParameter("@Command", queryCommand));
command.Parameters.Add(new SqlParameter("@UserId", details.UserId));
command.Parameters.Add(new SqlParameter("@RoleId", details.RoleId));
command.CommandText = "USP_GetClients_ForReview";
Connection.Open();
DataAdapter = new SqlDataAdapter(command);
_dataset = new DataSet();
DataAdapter.Fill(_dataset);
Connection.Close();
if ((_dataset.Tables[0] != null) && (_dataset.Tables[0].Rows.Count > 0))
{
foreach (DataRow dr in _dataset.Tables[0].Rows)
{
clientDetails = new ClientDetails();
clientDetails.ClientId = Convert.ToInt64(dr["ClientId"]);
clientDetails.ClientName = dr["ClientName"].ToString();
// clientDetails.ActiveProgramYear = dr["ActiveProgramYear"].ToString();
clientDetailsList.Add(clientDetails);
}
}
if ((_dataset.Tables[1] != null) && (_dataset.Tables[1].Rows.Count > 0))
{
foreach (DataRow dr in _dataset.Tables[1].Rows)
{
clientReviewStatus = new ClientReviewStatus();
clientReviewStatus.ClientId = Convert.ToInt64(dr["ClientId"]);
clientReviewStatus.AttendanceMonth = dr["AttendanceMonth"].ToString().ToLower();
clientReviewStatus.ActiveProgramYear = dr["ActiveProgramYear"].ToString();
clientReviewStatus.Status = (string.IsNullOrEmpty(dr["Status"].ToString())) ? "Empty" : (Convert.ToBoolean(dr["Status"])) ? "Open" : "Closed";
clientStatusList.Add(clientReviewStatus);
}
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
Connection.Close();
command.Dispose();
}
return(clientDetailsList);
}
