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();
}
