public StudentStatus GetStudentStatus(string studentID, int month, int year)
{
StudentStatus studentStatus = new StudentStatus();
try {
CreateIfNotExist(studentID, month, year);
DataTable dt = new DataTable();
using (SqlConnection conn = DBUtil.getConnection) {
string query = "select * from StudentStatus where studentID = @studentID and month = @month and year = @year";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@studentID", studentID);
cmd.Parameters.AddWithValue("@month", month);
cmd.Parameters.AddWithValue("@year", year);
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dt);
studentStatus.StudentID = studentID;
studentStatus.Month = month;
studentStatus.Year = year;
studentStatus.ElectricCost = double.Parse(dt.Rows[0][3].ToString());
studentStatus.WaterCost = double.Parse(dt.Rows[0][4].ToString());
studentStatus.ExtraFee = double.Parse(dt.Rows[0][5].ToString());
studentStatus.ExtraNote = dt.Rows[0][6].ToString();
Console.WriteLine("EEE" + dt.Rows[0][7].ToString());
studentStatus.Complete = dt.Rows[0][7].ToString() == "True" ? true : false;
studentStatus.Note = dt.Rows[0][8].ToString();
return(studentStatus);
}
} catch (Exception ex) {
Console.WriteLine(ex.Message);
return(null);
}
}
public int UpdateStudentStatus(StudentStatus studentStatus)
{
try {
string query = "update StudentStatus set electricCost = @electric, waterCost = @water, extraFee = @extra, extraFeeContent = @extraInfo, isCompleteFee = @complete, note = @info where studentID = @studentID and[month] = @month and[year] = @year";
using (SqlConnection conn = DBUtil.getConnection) {
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@electric", studentStatus.ElectricCost);
cmd.Parameters.AddWithValue("@water", studentStatus.WaterCost);
cmd.Parameters.AddWithValue("@extra", studentStatus.ExtraFee);
cmd.Parameters.AddWithValue("@extraInfo", studentStatus.ExtraNote);
cmd.Parameters.AddWithValue("@studentID", studentStatus.StudentID);
cmd.Parameters.AddWithValue("@month", studentStatus.Month);
cmd.Parameters.AddWithValue("@year", studentStatus.Year);
cmd.Parameters.AddWithValue("@complete", studentStatus.Complete);
cmd.Parameters.AddWithValue("@info", studentStatus.Note);
conn.Open();
return(cmd.ExecuteNonQuery());
}
} catch (Exception ex) {
Console.WriteLine(ex.Message);
return(0);
}
}
public static bool FillStatus(Control electric, Control water, Control extra, Control extrainfo, Control info, CheckBox complete, StudentStatus status)
{
if (status == null)
{
electric.Text = water.Text = extra.Text = extrainfo.Text = info.Text = "Not Found";
complete.Checked = false;
return(false);
}
electric.Text = status.ElectricCost.ToString();
water.Text = status.WaterCost.ToString();
extra.Text = status.ExtraFee.ToString();
extrainfo.Text = status.ExtraNote;
info.Text = status.Note;
complete.Checked = status.Complete;
return(true);
}
