///<summary>
///EXAMINATIONS
/// </summary>
public static void insert2examination(EXAMINATIONS newExamination)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Add new EXAMINATIONS to database
db.EXAMINATIONS.InsertOnSubmit(newExamination);
//Save changes to Database.
db.SubmitChanges();
}
public static void updateexamination(string str_id, EXAMINATIONS newExamination)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get EXAMINATIONS for update
EXAMINATIONS oldExamination = db.EXAMINATIONS.FirstOrDefault(e => e.id.Equals(str_id));
oldExamination = newExamination;
//Save changes to Database.
db.SubmitChanges();
}
public static void deleteexamination(string str_id)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get EXAMINATIONS to Delete
EXAMINATIONS deleteEXAMINATIONS = db.EXAMINATIONS.FirstOrDefault(e => e.id.Equals(str_id));
//Delete EXAMINATIONS
db.EXAMINATIONS.DeleteOnSubmit(deleteEXAMINATIONS);
//Save changes to Database.
db.SubmitChanges();
}
