private TrongSo TrongSoIDataReader(IDataReader Reader) { TrongSo obj = new TrongSo(); obj.MaDauDiem = (Reader["MaDauDiem"] is DBNull) ? int.MinValue : (int)Reader["MaDauDiem"]; obj.MaMonHoc = (Reader["MaMonHoc"] is DBNull) ? int.MinValue : (int)Reader["MaMonHoc"]; obj.TenDauDiem = (Reader["TenDauDiem"] is DBNull) ? string.Empty : (string)Reader["TenDauDiem"]; obj.GiaTriTrongSo = (Reader["TrongSo"] is DBNull) ? float.MinValue : (float)Reader["TrongSo"]; return(obj); }
public int SuaTrongSo(TrongSo obj) { using (SqlConnection conn = getConnect()) { try { conn.Open(); SqlCommand myCommand = new SqlCommand("Update TrongSo set TenDauDiem = '" + obj.TenDauDiem + "', TrongSo = '" + obj.GiaTriTrongSo + "' where MaMonHoc = '" + obj.MaMonHoc + "' and MaDauDiem = '" + obj.MaDauDiem + "' ", conn); myCommand.CommandType = CommandType.Text; myCommand.ExecuteNonQuery(); conn.Close(); return(1); } catch { return(0); } } }
public int ThemTrongSo(TrongSo obj) { using (SqlConnection conn = getConnect()) { try { conn.Open(); SqlCommand myCommand = new SqlCommand("Insert into TrongSo values('" + obj.MaMonHoc + "', '" + obj.MaDauDiem + "',N'" + obj.TenDauDiem + "','" + obj.GiaTriTrongSo + "')"); myCommand.CommandType = CommandType.Text; myCommand.ExecuteNonQuery(); return(1); } catch { return(0); } } }