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