public static SubjectDTO GetSubjectById(string id) { try { SqlCommand get = new SqlCommand("select * from [Subject] where subjId = @subjId", con); get.Parameters.AddWithValue("@subjId", id); con.Open(); SqlDataReader r = get.ExecuteReader(); SubjectDTO obj = null; while (r.Read()) { obj = new SubjectDTO(); obj.SubjId = r["subjId"].ToString(); obj.SubjName = r["subjName"].ToString(); } return(obj); } catch (Exception ex) { Console.WriteLine(ex.Message); return(null); } }
public static bool AddSubject(SubjectDTO obj) { try { SqlCommand insert = new SqlCommand("insert into [Subject] values(@subjId,@subjName)", con); insert.Parameters.AddWithValue("@subjId", obj.SubjId); insert.Parameters.AddWithValue("@subjName", obj.SubjName); con.Open(); int res = insert.ExecuteNonQuery(); if (res == 1) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } }