public void insertYearSem(YearSemModel objstudent) { try { string Query = "Insert into college_db.year_sem(year,semester) values('" + objstudent.Year + "','" + objstudent.Semester + "')"; MySqlConnection con = new MySqlConnection(DBConnection.ConnectionString); MySqlCommand cmd = new MySqlCommand(Query, con); MySqlDataReader myReader; con.Open(); myReader = cmd.ExecuteReader(); while (myReader.Read()) { } con.Close(); }catch (Exception ex) { } }
public List <YearSemModel> getYearSem() { List <YearSemModel> listStudent = new List <YearSemModel>(); try { string Query = "Select year,semester from college_db.year_sem"; MySqlConnection con = new MySqlConnection(DBConnection.ConnectionString); MySqlCommand cmd = new MySqlCommand(Query, con); MySqlDataReader myReader; con.Open(); myReader = cmd.ExecuteReader(); while (myReader.Read()) { YearSemModel objStudent = new YearSemModel(); objStudent.Year = myReader["year"].ToString(); objStudent.Semester = myReader["semester"].ToString(); listStudent.Add(objStudent); } } catch (Exception ex) { } return(listStudent); }
public List <YearSemModel> getYearSem() { List <YearSemModel> listStudent = new List <YearSemModel>(); try { string Query = "Select year,semester from year_sem"; SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection); SqlDataReader myReader; DBConnection.OpenConnection(); myReader = cmd.ExecuteReader(); List <string> weekdayArray = new List <string>(); while (myReader.Read()) { YearSemModel objStudent = new YearSemModel(); objStudent.Year = myReader["year"].ToString(); objStudent.Semester = myReader["semester"].ToString(); listStudent.Add(objStudent); } DBConnection.CloseConnection(); } catch (Exception ex) { } return(listStudent); }
private void btnUpdate_Click(object sender, EventArgs e) { YearSemModel objStudent = new YearSemModel(); objStudent.Year = "Y" + txtYear.Text; objStudent.Semester = "S" + txtSem.Text; objStudCore.updateYearSem(objStudent, objCurrentStd); loadData(); //reset feilds txtYear.Text = ""; txtSem.Text = ""; }
private void btnSave_Click(object sender, EventArgs e) { YearSemModel objStudent = new YearSemModel(); objStudent.Year = "Y" + txtYear.Text; objStudent.Semester = "S" + txtSem.Text; objStudCore.insertYearSem(objStudent); //reset feilds txtYear.Text = ""; txtSem.Text = ""; loadData(); }
private void btnUpdate_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("Are you sure you want to Update?", "Confirm Update", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result.ToString().Equals("Yes")) { YearSemModel objStudent = new YearSemModel(); objStudent.Year = "Y" + txtYear.Text; objStudent.Semester = "S" + txtSem.Text; objStudCore.updateYearSem(objStudent, objCurrentStd); loadData(); //reset feilds txtYear.Text = ""; txtSem.Text = ""; } }
public void updateYearSem(YearSemModel objstudent, YearSemModel objPrevStd) { int count = 0; try { string Query = "Update year_sem SET year = '" + objstudent.Year + "' , semester = '" + objstudent.Semester + "' where year = '" + objPrevStd.Year + "' and semester = '" + objPrevStd.Semester + "'"; DBConnection.OpenConnection(); SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection); count = cmd.ExecuteNonQuery(); DBConnection.CloseConnection(); } catch (Exception ex) { } }
public void insertYearSem(YearSemModel objstudent) { int count = 0; try { string Query = "Insert into year_sem(year,semester) values('" + objstudent.Year + "','" + objstudent.Semester + "')"; DBConnection.OpenConnection(); SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection); count = cmd.ExecuteNonQuery(); DBConnection.CloseConnection(); } catch (Exception ex) { } }
public void deleteYearSem(YearSemModel objStudent) { int count = 0; try { string Query = "Delete from year_sem where year = '" + objStudent.Year + "' and semester = '" + objStudent.Semester + "'"; DBConnection.OpenConnection(); SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection); count = cmd.ExecuteNonQuery(); DBConnection.CloseConnection(); } catch (Exception ex) { } }
public void deleteYearSem(YearSemModel objStudent) { try { string Query = "Delete from college_db.year_sem where year = '" + objStudent.Year + "' and semester = '" + objStudent.Semester + "'"; MySqlConnection con = new MySqlConnection(DBConnection.ConnectionString); MySqlCommand cmd = new MySqlCommand(Query, con); MySqlDataReader myReader; con.Open(); myReader = cmd.ExecuteReader(); while (myReader.Read()) { } con.Close(); } catch (Exception ex) { } }
public void updateYearSem(YearSemModel objstudent, YearSemModel objPrevStd) { try { string Query = "Update college_db.year_sem SET year = '" + objstudent.Year + "' , semester = '" + objstudent.Semester + "' where year = '" + objPrevStd.Year + "' and semester = '" + objPrevStd.Semester + "'"; MySqlConnection con = new MySqlConnection(DBConnection.ConnectionString); MySqlCommand cmd = new MySqlCommand(Query, con); MySqlDataReader myReader; con.Open(); myReader = cmd.ExecuteReader(); while (myReader.Read()) { } con.Close(); } catch (Exception ex) { } }