public List <Strand> Load()
{
try
{
using (MySqlConnection con = new MySqlConnection(GOCSystem2018.Config.GetConnectionString()))
{
con.Open();
string sql = "SELECT * FROM strand";
MySqlCommand cmd = new MySqlCommand(sql, con);
MySqlDataReader reader = cmd.ExecuteReader();
//loop while have record
while (reader.Read())
{
//instantiate model
Strand strand = new Strand();
//prepare properties
strand.id = Convert.ToInt32(reader["id"].ToString());
strand.strandName = reader["strand_name"].ToString();
strand.strandDesc = reader["strand_desc"].ToString();
strands.Add(strand);
}
}
}
catch (MySqlException ex)
{
MessageBox.Show("ERROR : " + ex.ToString(), "GOCINFOSYS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(strands);
}//End of Load
public void LoadAssesOtherFeesSTRAND_ICT()
{
//clear list
otherFees.Clear();
dgvOtherFees.Rows.Clear();
//pass value to list
otherFees = otherFee.Load();
//loop through load it to list view
if (Strand.Equals("TVL - ICT"))
{
Strand = "STEM";
}
foreach (var item in otherFees)
{
if (item.Strand.Equals(Strand))
{
dgvOtherFees.Rows.Add(item.OtherFeeName, item.OtherFeeAmount);
foreach (var item2 in otherFees)
{
if (item.Strand.Equals("Non-STEM"))
{
dgvOtherFees.Rows.Add(item2.OtherFeeName, item2.OtherFeeAmount);
}
}
}
if (item.Strand.Equals("Non-STEM"))
{
dgvOtherFees.Rows.Add(item.OtherFeeName, item.OtherFeeAmount);
}
}
double sum = 0;
for (int i = 0; i < dgvOtherFees.Rows.Count; i++)
{
sum += Convert.ToDouble(dgvOtherFees.Rows[i].Cells[1].Value);
}
lblOther.Text = sum.ToString("n");
Strand = "TVL - ICT";
}