public async Task <int> SaveSingleDefault(StickerSimpleDefaultValueViewModel defaultValues, int garageId)
{
var defaultValueModel = new GarageDefaultModel()
{
GarageId = garageId,
Screen = "SINGLE",
DefaultValues = JsonConvert.SerializeObject(defaultValues)
};
var exist = await _garageFactory.GetSingleDefault(garageId, "SINGLE");
if (exist != null)
{
defaultValueModel.Id = exist.Id;
}
return(exist == null
? await _garageFactory.CreateSingleDefault(defaultValueModel)
: await _garageFactory.UpdateSingleDefault(defaultValueModel));
}
public async Task <int> SavePrinterConfiguration(PrinterConfigurationViewModel configuration, int garageId)
{
var defaultValueModel = new GarageDefaultModel()
{
GarageId = garageId,
Screen = "PRINTERCONFIGURATION",
DefaultValues = JsonConvert.SerializeObject(configuration)
};
var exist = await _garageFactory.GetSingleDefault(garageId, "PRINTERCONFIGURATION");
if (exist != null)
{
defaultValueModel.Id = exist.Id;
}
return(exist == null
? await _garageFactory.CreateSingleDefault(defaultValueModel)
: await _garageFactory.UpdateSingleDefault(defaultValueModel));
}
public async Task <int> UpdateSingleDefault(GarageDefaultModel defaultValues)
{
var sql = @"UPDATE [dbo].[Garage_Defaults]
SET DefaultValues = @DefaultValues
WHERE Id = @Id";
using (var connection = new SqlConnection(_configuration.GetConnectionString("DefaultConnection")))
{
connection.Open();
var result = await connection.ExecuteAsync(sql,
new
{
Id = defaultValues.Id,
DefaultValues = defaultValues.DefaultValues
},
commandType : CommandType.Text);
return(result);
}
}
public async Task <int> CreateSingleDefault(GarageDefaultModel defaultValues)
{
var sql = @"INSERT INTO [dbo].[Garage_Defaults]
VALUES(
@GarageId,
@Screen,
@DefaultValues)";
using (var connection = new SqlConnection(_configuration.GetConnectionString("DefaultConnection")))
{
connection.Open();
var result = await connection.ExecuteAsync(sql,
new
{
GarageId = defaultValues.GarageId,
Screen = defaultValues.Screen,
DefaultValues = defaultValues.DefaultValues
},
commandType : CommandType.Text);
return(result);
}
}
