public List <NotAvailableModel> getNotAvailableStudent() { List <NotAvailableModel> listStudent = new List <NotAvailableModel>(); try { string Query = "Select * from NotAvailableStudent"; SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection); SqlDataReader myReader; DBConnection.OpenConnection(); myReader = cmd.ExecuteReader(); while (myReader.Read()) { NotAvailableModel objStudent = new NotAvailableModel(); objStudent.groupID = myReader["group_id"].ToString(); objStudent.sub_group_id = myReader["sub_grou_id"].ToString(); objStudent.day = myReader["day"].ToString(); objStudent.startTime = myReader["start_time"].ToString(); objStudent.endTime = myReader["end_time"].ToString(); listStudent.Add(objStudent); } } catch (Exception ex) { } return(listStudent); }
private void btnDelete_Click(object sender, EventArgs e) { NotAvailableModel objStudent = new NotAvailableModel(); objNotAvailableCore.DeleteNotAvailableLec(objCurr); loadData(); }
private void btnUpdate_Click(object sender, EventArgs e) { NotAvailableModel objStudent = new NotAvailableModel(); objStudent.lecturerID = ddlLec.SelectedValue.ToString(); objStudent.day = ddlDay.SelectedItem.ToString(); objStudent.startTime = ddlFrom.SelectedItem.ToString(); objStudent.endTime = ddlTo.SelectedItem.ToString(); objStudent.startSlot = convertToSlot(objStudent.startTime); objStudent.endSlot = convertToSlot(objStudent.endTime); objNotAvailableCore.UpdateNotAvailableLec(objStudent, objCurr); loadData(); }
private void btnSave_Click(object sender, EventArgs e) { NotAvailableModel obj = new NotAvailableModel(); obj.lecturerID = ddlLec.SelectedValue.ToString(); obj.day = ddlDay.SelectedItem.ToString(); obj.startTime = ddlFrom.SelectedItem.ToString(); obj.endTime = ddlTo.SelectedItem.ToString(); obj.startSlot = convertToSlot(obj.startTime); obj.endSlot = convertToSlot(obj.endTime); objNotAvailableCore.insertNotAvailableLecturer(obj); loadData(); }
private void iconButton1_Click(object sender, EventArgs e) { NotAvailableModel obj = new NotAvailableModel(); obj.groupID = ddlGroup.SelectedValue.ToString(); obj.sub_group_id = ddlSubGroup.SelectedValue.ToString(); obj.day = ddlDay.SelectedItem.ToString(); obj.startTime = ddlFrom.SelectedItem.ToString(); obj.endTime = ddlTo.SelectedItem.ToString(); obj.startSlot = convertToSlot(obj.startTime); obj.endSlot = convertToSlot(obj.endTime); objNotAvailableCore.insertNotAvailableStudent(obj); loadData(); }
public void insertNotAvailableStudent(NotAvailableModel objstudent) { int count = 0; try { string Query = "Insert into NotAvailableStudent (group_id,sub_grou_id,day,start_time,end_time,start_slot,end_slot) values('" + objstudent.groupID + "','" + objstudent.sub_group_id + "','" + objstudent.day + "','" + objstudent.startTime + "','" + objstudent.endTime + "'," + objstudent.startSlot + "," + objstudent.endSlot + ")"; DBConnection.OpenConnection(); SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection); count = cmd.ExecuteNonQuery(); DBConnection.CloseConnection(); } catch (Exception ex) { } }
public void UpdateNotAvailableStudent(NotAvailableModel objstudent, NotAvailableModel objstudentCurr) { int count = 0; try { //Insert into NotAvailableStudent (group_id,sub_grou_id,day,start_time,end_time,start_slot,end_slot) values('" + objstudent.groupID + "','" + objstudent.sub_group_id + "','" + objstudent.day + "','" + objstudent.startTime + "','" + objstudent.endTime + "'," + objstudent.startSlot + "," + objstudent.endSlot + ")"; string Query = "UPDATE NotAvailableStudent SET day='" + objstudent.day + "', start_time = '" + objstudent.startTime + "', end_time = '" + objstudent.endTime + "', start_slot = " + objstudent.startSlot + ",end_slot = " + objstudent.endSlot + " WHERE group_id = '" + objstudentCurr.groupID + "' and sub_grou_id = '" + objstudentCurr.sub_group_id + "' and start_slot = " + objstudentCurr.startSlot + " and end_slot = " + objstudentCurr.endSlot + ""; DBConnection.OpenConnection(); SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection); count = cmd.ExecuteNonQuery(); DBConnection.CloseConnection(); } catch (Exception ex) { } }