public List <subGroupModel> getSubGroup()
{
List <subGroupModel> listStudent = new List <subGroupModel>();
try
{
string Query = "Select * from college_db.sub_group";
MySqlConnection con = new MySqlConnection(DBConnection.ConnectionString);
MySqlCommand cmd = new MySqlCommand(Query, con);
MySqlDataReader myReader;
con.Open();
myReader = cmd.ExecuteReader();
while (myReader.Read())
{
subGroupModel objStudent = new subGroupModel();
objStudent.GrouID = myReader["group_id"].ToString();
objStudent.SubGroupNo = myReader["sub_group_no"].ToString();
objStudent.SubGroupID = myReader["sub_group_id"].ToString();
listStudent.Add(objStudent);
}
}
catch (Exception ex)
{
}
return(listStudent);
}
private void btnSave_Click(object sender, EventArgs e)
{
subGroupModel objStudent = new subGroupModel();
objStudent.SubGroupNo = (textBox1.Text);
objStudent.GrouID = comboBox1.SelectedValue.ToString();
objStudent.SubGroupID = objStudent.GrouID + "." + objStudent.SubGroupNo;
objCore.insertSubGroup(objStudent);
//reset feilds
textBox1.Text = "";
loadData();
}
public void deleteSubGroup(subGroupModel objStudent)
{
int count = 0;
try
{
string Query = "Delete from sub_group where sub_group_id = '" + objStudent.SubGroupID + "'";
DBConnection.OpenConnection();
SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection);
count = cmd.ExecuteNonQuery();
DBConnection.CloseConnection();
}
catch (Exception ex)
{
}
}
public void updateSubGroup(subGroupModel objstudent, subGroupModel objPrevStd)
{
int count = 0;
try
{
string Query = "Update sub_group SET sub_group_id = '" + objstudent.SubGroupID + "' , group_id = '" + objstudent.GrouID + "', sub_group_no='" + objstudent.SubGroupNo + "' where sub_group_id = '" + objPrevStd.SubGroupID + "'";
DBConnection.OpenConnection();
SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection);
count = cmd.ExecuteNonQuery();
DBConnection.CloseConnection();
}
catch (Exception ex)
{
}
}
public void insertSubGroup(subGroupModel objstudent)
{
int count = 0;
try
{
string Query = "Insert into sub_group(sub_group_id,group_id,sub_group_no) values('" + objstudent.SubGroupID + "','" + objstudent.GrouID + "','" + objstudent.SubGroupNo + "' )";
DBConnection.OpenConnection();
SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection);
count = cmd.ExecuteNonQuery();
DBConnection.CloseConnection();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
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"))
{
subGroupModel objStudent = new subGroupModel();
objStudent.SubGroupNo = (textBox1.Text);
objStudent.GrouID = comboBox1.SelectedValue.ToString();
objStudent.SubGroupID = objStudent.GrouID + "." + objStudent.SubGroupNo;
objCore.updateSubGroup(objStudent, prevObject);
//reset feilds
textBox1.Text = "";
loadData();
}
}
public void deleteSubGroup(subGroupModel objStudent)
{
try
{
string Query = "Delete from college_db.sub_group where sub_group_id = '" + objStudent.SubGroupID + "'";
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 updateSubGroup(subGroupModel objstudent, subGroupModel objPrevStd)
{
try
{
string Query = "Update college_db.sub_group SET sub_group_id = '" + objstudent.SubGroupID + "' , group_id = '" + objstudent.GrouID + "', sub_group_no='" + objstudent.SubGroupNo + "' where sub_group_id = '" + objPrevStd.SubGroupID + "'";
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 insertSubGroup(subGroupModel objstudent)
{
try
{
string Query = "Insert into college_db.sub_group(sub_group_id,group_id,sub_group_no) values('" + objstudent.SubGroupID + "','" + objstudent.GrouID + "','" + objstudent.SubGroupNo + "' )";
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)
{
}
}
