public static void insert(mdatesheet t)
 {
     using (var data = new instDataContext())
     {
         data.mdatesheets.InsertOnSubmit(t);
         data.SubmitChanges();
     }
 }
 public static void insert(mdatesheet t)
 {
     using (var data = new instDataContext())
     {
         data.mdatesheets.InsertOnSubmit(t);
         data.SubmitChanges();
     }
 }
 public static void update(mdatesheet t)
 {
     using (var data = new instDataContext())
     {
         var obj = data.mdatesheets.Single(j => j.course == t.course);
         obj.sem = t.sem;
         obj.sub = t.sub;
         obj.subcode = t.subcode;
         obj.date = t.date;
         obj.examination = t.examination;
         obj.shift = t.shift;
         obj.timing = t.timing;
     }
 }
 public static void update(mdatesheet t)
 {
     using (var data = new instDataContext())
     {
         var obj = data.mdatesheets.Single(j => j.course == t.course);
         obj.sem         = t.sem;
         obj.sub         = t.sub;
         obj.subcode     = t.subcode;
         obj.date        = t.date;
         obj.examination = t.examination;
         obj.shift       = t.shift;
         obj.timing      = t.timing;
     }
 }
 partial void Deletemdatesheet(mdatesheet instance);
 partial void Updatemdatesheet(mdatesheet instance);
 partial void Insertmdatesheet(mdatesheet instance);