public bool Edit(NewspaperName name) { if (validation.Validate(name).Count > 0) { foreach (var res in validation.Validate(name)) { if (res.IsValidate) { logger.Error(res.ValidationMessage.ToString()); } } } return(nameDao.Edit(name)); }
public List <ValidationResult> Validate(NewspaperName newspaperName) { List <ValidationResult> results = new List <ValidationResult>(); if (newspaperName == null) { results.Add(new ValidationResult(true, new ArgumentNullException(nameof(newspaperName)).Message.ToString())); } if (string.IsNullOrWhiteSpace(newspaperName.Name)) { results.Add(new ValidationResult(true, new ArgumentException("Name").Message.ToString())); } return(results); }
public bool Edit(NewspaperName newspaper) { try { using (var con = new SqlConnection(config.ConnectionString)) { using (var cmnd = new SqlCommand("newspaper_name_edite", con)) { cmnd.CommandType = CommandType.StoredProcedure; cmnd.Parameters.AddWithValue("@name", newspaper.Name); cmnd.Parameters.AddWithValue("@id", newspaper.Id); con.Open(); cmnd.ExecuteNonQuery(); return true; } } } catch { return false; } }
public bool Add(NewspaperName newspaper) { if (newspaper == null) { throw new ArgumentNullException(); } if (newspaper.Name == null || newspaper.Name.Length > 300) { throw new ArgumentException("NewspaperName Name"); } try { using (var con = new SqlConnection(config.ConnectionString)) { using (var cmnd = new SqlCommand("newspaper_name_add", con)) { cmnd.CommandType = CommandType.StoredProcedure; cmnd.Parameters.AddWithValue("@name", newspaper.Name); cmnd.Parameters.Add("@id", SqlDbType.Int, 4); cmnd.Parameters["@id"].Direction = ParameterDirection.Output; con.Open(); cmnd.ExecuteNonQuery(); int? id = cmnd.Parameters["@id"].Value as int?; if (id != null) { newspaper.Id = (int)cmnd.Parameters["@id"].Value; } return true; } } } catch { return false; } }
public ICollection<NewspaperName> GetAll() { using (var con = new SqlConnection(config.ConnectionString)) { using (var cmnd = new SqlCommand("newspapers_names_get_all", con)) { cmnd.CommandType = CommandType.StoredProcedure; con.Open(); using (var reader = cmnd.ExecuteReader()) { var newspapersNames = new List<NewspaperName>(); while (reader.Read()) { var newspaper = new NewspaperName(); newspaper.Id = (int)reader["id"]; newspaper.Name = (string)reader["name"]; newspapersNames.Add(newspaper); } return newspapersNames; } } } }