//Add To ProgramLanguage Table
 public bool AddProgramLanguage(programLanguage pl)
 {
     try
     {
         db.programLanguages.InsertOnSubmit(pl);
         db.SubmitChanges();
         return true;
     }
     catch (Exception error)
     {
         return false;
     }
 }
 //Edit ProgramLanguage Table
 public int EditProgramLanguage(programLanguage pl)
 {
     try
     {
         var v = from i in db.programLanguages
                 where i.programLangCode == pl.programLangCode
                 select i;
         programLanguage newprogram = v.FirstOrDefault();
         if(newprogram!= null)
         {
             newprogram = pl;
             db.SubmitChanges();
             return 1;
         }
         return 0;//not found
      }
     catch (Exception error)
     {
         return -1;
     }
 }
 partial void UpdateprogramLanguage(programLanguage instance);
 partial void DeleteprogramLanguage(programLanguage instance);
 partial void InsertprogramLanguage(programLanguage instance);