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