public static int Insert(GPA_Grade s) { string statement = $"insert into gpa_grade columns(Grade_English,Grade_Arabic,OrderCode,Points,semesterID,Course_Points, Course_cr_points) values('{s.Grade_English}','{s.Grade_Arabic}',{s.OrderCode},{s.Points},{s.semesterID},{s.Course_Points},{s.Course_cr_points})"; var affected = DBManager.ExecuteNonQuery(statement); return(affected); }
public static int Update(GPA_Grade s) { string stataement = $"update gpa_grade set Grade_English='{s.Grade_English}',Grade_Arabic='{s.Grade_Arabic}',OrderCode={s.OrderCode},Points={s.Points},semesterID={s.semesterID},Course_Points='{s.Course_Points}',Course_cr_points='{s.Course_cr_points}' where ID={s.ID}"; int affected = DBManager.ExecuteNonQuery(stataement); return(affected); }
public static GPA_Grade GetById(int id) { string statement = $"select * from gpa_grade where id={id}"; var ds = DBManager.ExecuteQuery(statement); var item = ds.Tables[0].Rows[0]; var gp = new GPA_Grade { ID = int.Parse(item["ID"].ToString()), Grade_English = item["Grade_English"].ToString(), Grade_Arabic = item["Grade_Arabic"].ToString(), OrderCode = int.Parse(item["OrderCode"].ToString()), Points = (item["Points"].ToString()), semesterID = int.Parse(item["semesterID"].ToString()), Course_Points = (item["Course_Points"].ToString()), Course_cr_points = (item["Course_cr_points"].ToString()) }; return(gp); }