public List <ExamTimeTable> getExamTimeTable(int classId)
{
List <ExamTimeTable> lstExamTimeTable = null;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(Helper.sp_GetExamTimeTable, connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@ClassId", classId);
objReader = command.ExecuteReader();
if (objReader.HasRows)
{
lstExamTimeTable = new List <ExamTimeTable>();
while (objReader.Read())
{
ExamTimeTable objExamTimeTable = new ExamTimeTable();
objExamTimeTable.ExamTimeTableID = (int)(objReader["ExamTimeTableID"]);
objExamTimeTable.ClassId = (int)objReader["ClassId"];
objExamTimeTable.Subject = objReader["Subject"].ToString();
objExamTimeTable.FromDate = objReader["FromDate"].ToString();
objExamTimeTable.FromTime = objReader["FromTime"].ToString();
objExamTimeTable.ToTime = objReader["ToTime"].ToString();
objExamTimeTable.Location = objReader["Location"].ToString();
objExamTimeTable.Batch = objReader["Batch"].ToString();
lstExamTimeTable.Add(objExamTimeTable);
}
}
}
return(lstExamTimeTable);
}
public Message createUpdateExamTimeTable(ExamTimeTable timeTable)
{
Message msg = null;
using (SqlConnection connection = new SqlConnection(connectionString))
{
msg = new Message();
connection.Open();
SqlCommand command = new SqlCommand(Helper.sp_CreateUpdateExamTimeTables, connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@ExamTimeTableID", timeTable.ExamTimeTableID);
command.Parameters.AddWithValue("@ClassId", timeTable.ClassId);
command.Parameters.AddWithValue("@Subject", timeTable.Subject);
command.Parameters.AddWithValue("@FromDate", timeTable.FromDate);
command.Parameters.AddWithValue("@FromTime", timeTable.FromTime);
command.Parameters.AddWithValue("@ToTime", timeTable.ToTime);
command.Parameters.AddWithValue("@Location", timeTable.Location);
command.Parameters.AddWithValue("@Batch", timeTable.Batch);
command.Parameters.AddWithValue("@CreateBy", timeTable.CreateBy);
command.Parameters.AddWithValue("@UpdatedBy", timeTable.UpdatedBy);
command.Parameters.AddWithValue("@CreatedDate", timeTable.CreatedDate);
command.Parameters.AddWithValue("@UpdatedDate", timeTable.UpdatedDate);
msg.status = command.ExecuteNonQuery();
msg.message = msg.status == 1 ? Constants.savedSuccessfully : Constants.saveUnuccessfull;
}
return(msg);
}
public MessageDTO addUpdateExamTimeTable(ExamTimeTableDto examTimeTable)
{
ExamTimeTable examTimeT = Mapper.Map <ExamTimeTableDto, ExamTimeTable>(examTimeTable);
Message msg = _class.addUpdateExamTimeTable(examTimeT);
var result = Mapper.Map <Message, MessageDTO>(msg);
return(result);
}
public Message editExamTimeTable(ExamTimeTable timeTable)
{
throw new NotImplementedException();
}
public Message uploadTimeTableByStandard(ExamTimeTable timeTable)
{
throw new NotImplementedException();
}
public Message addUpdateExamTimeTable(ExamTimeTable examTimeTable)
{
return(_classSetupRepository.createUpdateExamTimeTable(examTimeTable));
}
