public async Task <bool> UpdateReestrSetting(ReestrSetting reestr)
{
using (var connection = _applicationContextFactory.CreateConnection())
{
return(await connection.UpdateAsync(reestr));
}
}
public async Task <ReestrSetting> CreateReestrSetting(ReestrSetting reestr)
{
using (var connection = _applicationContextFactory.CreateConnection())
{
await connection.InsertAsync(reestr);
return(reestr);
}
}
public async Task <bool> UpdateReestrSettingBarrelColumn(ReestrSetting reestrSetting)
{
using (var connection = _applicationContextFactory.CreateConnection())
{
string query = "UPDATE ReestrSettings SET InitialBarrelNumber =@ibn where id=@id";
var rowAffected = await connection.ExecuteAsync(query, new { ibn = reestrSetting.InitialBarrelNumber, id = reestrSetting.Id });
return(rowAffected == 1);
}
}
private Reestr CreateReestr(double net)
{
var reestr = new Reestr
{
BatchNumber = ReestrSetting.BatchNumber,
Customer = ReestrSetting.Customer,
CustomerId = ReestrSetting.CustomerId,
RecipeId = ReestrSetting.CurrentRecipe.Id,
Recipe = ReestrSetting.CurrentRecipe,
TareBarrel = ReestrSetting.TaraBarrel,
TareBarrelWithLid = ReestrSetting.TaraBarrelWithLid,
PackingDate = DateTime.Now,
ReestrState = true,
Net = net,
};
reestr.BarrelNumber = ReestrSetting.GetBarrelNumberAndClearIt();
return(reestr);
}
