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