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