public static tblClinicMaintenance AddMaintenance(tblClinicMaintenance m) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { if (m.maintenanceId == 0) { //add tblClinicMaintenance newM = new tblClinicMaintenance(); newM.name = m.name; newM.permissionToExpand = m.permissionToExpand; newM.accessibilityOfInvalids = m.accessibilityOfInvalids; context.tblClinicMaintenances.Add(newM); context.SaveChanges(); m.maintenanceId = newM.maintenanceId; return(m); } else { tblClinicMaintenance mToEdit = (from x in context.tblClinicMaintenances where x.maintenanceId == m.maintenanceId select x).FirstOrDefault(); mToEdit.name = m.name; mToEdit.accessibilityOfInvalids = m.accessibilityOfInvalids; mToEdit.permissionToExpand = m.permissionToExpand; context.SaveChanges(); return(m); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }
public static void DeleteMaintenance(tblClinicMaintenance maintenance) { try { using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4()) { tblClinicMaintenance toDelete = (from u in context.tblClinicMaintenances where u.maintenanceId == maintenance.maintenanceId select u).First(); context.tblClinicMaintenances.Remove(toDelete); context.SaveChanges(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); } }