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