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