public bool update(RangeDTO oRange) { bool bReturn = false; SqlConnection sqlCon = DBLibrary.OpenConnection(); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "sp_range_update"; sqlCmd.Parameters.AddWithValue("@IdRange", oRange.idRange.ToString()); sqlCmd.Parameters.AddWithValue("@FirstValue", oRange.firstValue.ToString()); sqlCmd.Parameters.AddWithValue("@LastValue", oRange.lastValue.ToString()); sqlCmd.ExecuteNonQuery(); bReturn = true; } catch (Exception ex) { throw ex; } finally { sqlCon.Close(); } return(bReturn); }
public int insert(RangeDTO oRange) { int iReturn = 0; SqlConnection sqlCon = DBLibrary.OpenConnection(); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "sp_range_insert"; sqlCmd.Parameters.AddWithValue("@FirstValue", oRange.firstValue.ToString()); sqlCmd.Parameters.AddWithValue("@LastValue", oRange.lastValue.ToString()); iReturn = sqlCmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { sqlCon.Close(); } return(iReturn); }
public ActionResult Edit(RangeDTO range) { try { _service.Update(range); return(RedirectToAction(nameof(Index))); } catch { ModelState.AddModelError(string.Empty, "Введены неправильные данные"); return(View(range)); } }
public override void WriteJson(JsonWriter writer, object value, JsonSerializer serializer) { var range = (RangeOrValue)value; if (range.IsRange) { var dto = new RangeDTO { Min = range.Min, Max = range.Max }; serializer.Serialize(writer, dto); } else { writer.WriteValue(range.Value); } }
public List <RangeDTO> getRangeByID(int pIdRange) { List <RangeDTO> oReturn = new List <RangeDTO>(); SqlConnection sqlCon = DBLibrary.OpenConnection(); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "sp_range_consultar"; sqlCmd.Parameters.AddWithValue("@IdRange", pIdRange); var oData = sqlCmd.ExecuteReader(); while (oData.Read() == true) { RangeDTO oRange = new RangeDTO(); oRange.idRange = pIdRange; oRange.firstValue = decimal.Parse(oData["firstValue"].ToString()); oRange.lastValue = decimal.Parse(oData["lastValue"].ToString()); oReturn.Add(oRange); } } catch (Exception ex) { throw ex; } finally { sqlCon.Close(); } return(oReturn); }
public void Update(RangeDTO item) { _database.Ranges.Update(Mapper.Map <Range>(item)); _database.Save(); }