public List <CostDbModel> GetAll()
{
var costs = new List <CostDbModel>();
var sqlCommand = new SqlCommand();
string sqlQuery = @"
SELECT * FROM Cost
" ;
sqlCommand.CommandText = sqlQuery;
IEnumerable <CustomDataRow> dataRowCollection = _sqlServerDatabase.GetCustomDataRowCollection(sqlCommand);
foreach (var dataRow in dataRowCollection)
{
var cost = new CostDbModel();
cost.Id = ConversionHelper.ToInt(dataRow["IdCost"]);
cost.IsActive = ConversionHelper.ToBoolean(dataRow["IsActive"]);
cost.RefCriteriaValueCostType = ConversionHelper.ToInt(dataRow["RefCriteriaValueCostType"]);
cost.Amount = ConversionHelper.ToFloat(dataRow["Amount"]);
cost.DateTimeCreatedOn = ConversionHelper.ToDateTime(dataRow["DateTimeCreatedOn"]);
costs.Add(cost);
}
return(costs);
}
private void SaveCost(object parameter)
{
var values = (object[])parameter;
var cost = new CostDbModel {
IsActive = true,
RefCriteriaValueCostType = ConversionHelper.ToInt(values[0]),
Amount = ConversionHelper.ToFloat(values[1]),
DateTimeCreatedOn = ConversionHelper.ToDateTime(values[2])
};
_costRepository.Save(cost);
StatusMessage = "Cost saved succesfully!";
}
public bool Save(CostDbModel cost)
{
var sqlCommand = new SqlCommand();
string sqlQuery = @"
INSERT INTO Cost (IsActive, RefCriteriaValueCostType, Amount, DateTimeCreatedOn)
VALUES (@IsActive, @RefCriteriaValueCostType, @Amount, @DateTimeCreatedOn)
" ;
sqlCommand.CommandText = sqlQuery;
sqlCommand.Parameters.AddWithValue("@IsActive", 1);
sqlCommand.Parameters.AddWithValue("@RefCriteriaValueCostType", cost.RefCriteriaValueCostType);
sqlCommand.Parameters.AddWithValue("@Amount", cost.Amount);
sqlCommand.Parameters.AddWithValue("@DateTimeCreatedOn", cost.DateTimeCreatedOn);
_sqlServerDatabase.ExecuteNonQuery(sqlCommand);
return(false);
}
public CostDbModel Get(int id)
{
var sqlCommand = new SqlCommand();
string sqlQuery = @"
SELECT * FROM Cost WHERE IdCost = @IdCost
" ;
sqlCommand.CommandText = sqlQuery;
sqlCommand.Parameters.AddWithValue("@IdCost", id);
CustomDataRow dataRow = _sqlServerDatabase.GetCustomDataRow(sqlCommand);
var cost = new CostDbModel();
cost.Id = ConversionHelper.ToInt(dataRow["IdCost"]);
cost.IsActive = ConversionHelper.ToBoolean(dataRow["IsActive"]);
cost.RefCriteriaValueCostType = ConversionHelper.ToInt(dataRow["RefCriteriaValueCostType"]);
cost.Amount = ConversionHelper.ToFloat(dataRow["Amount"]);
cost.DateTimeCreatedOn = ConversionHelper.ToDateTime(dataRow["DateTimeCreatedOn"]);
return(cost);
}