public bool Return_true_if_name_not_repeted_in_db(Visit_type visit_type_to_check) { Visit_type visit_type = new Visit_type(); try { using (Visit_manager_dbEntities db = new Visit_manager_dbEntities()) { visit_type = db.Visit_type .Where(a => a.is_removed == false && a.id != visit_type_to_check.id && a.name == visit_type_to_check.name) .FirstOrDefault(); } } catch (Exception ex) { NLog_logger.Loger.Error(ex); } if (visit_type == null) { return(true); } else { return(false); } }
public void Add(Visit_type visit_type) { try { using (Visit_manager_dbEntities db = new Visit_manager_dbEntities()) { db.Visit_type.Add(visit_type); db.SaveChanges(); } } catch (Exception ex) { NLog_logger.Loger.Error(ex); } }
public void Remove(long id) { try { using (Visit_manager_dbEntities db = new Visit_manager_dbEntities()) { Visit_type visit_type = db.Visit_type.Find(id); visit_type.is_removed = true; db.SaveChanges(); } } catch (Exception ex) { NLog_logger.Loger.Error(ex); } }
public Visit_type Get_by_id(long id) { Visit_type visit_type = new Visit_type(); try { using (Visit_manager_dbEntities db = new Visit_manager_dbEntities()) { visit_type = db.Visit_type.Find(id); } } catch (Exception ex) { NLog_logger.Loger.Error(ex); } return(visit_type); }
public Visit_type Get_by_name(string name) { Visit_type visit_type = new Visit_type(); try { using (Visit_manager_dbEntities db = new Visit_manager_dbEntities()) { visit_type = db.Visit_type .Where(a => a.is_removed == false && a.name == name) .FirstOrDefault(); } } catch (Exception ex) { NLog_logger.Loger.Error(ex); } return(visit_type); }
public void Update(Visit_type visit_type) { try { using (Visit_manager_dbEntities db = new Visit_manager_dbEntities()) { Visit_type visit_type_from_db = db.Visit_type.Find(visit_type.id); if (visit_type_from_db != null) { visit_type_from_db.name = visit_type.name; db.SaveChanges(); } } } catch (Exception ex) { NLog_logger.Loger.Error(ex); } }