public void Add(CreateNaklItemModel createNaklItemModel)
{
const string commandText = @"Insert Into chz_gtins(chz_nakl_id,count,const,vat_value,prod_sell_name)
Values(@chz_nakl_id,@count,@const,@vat_value,@prod_sell_name)";
var transaction = Transact <object> .Create(ConnectionString, commandText, parameter : createNaklItemModel);
transaction.ExecuteNonQuery();
}
public void SaveChanges(CreateNaklItemModel createNaklItemModel)
{
const string commandText = @"Update chz_gtins
Set chz_nakl_id = @chz_nakl_id, const=@const, vat_value=@vat_value,count=@count,prod_sell_name=@prod_sell_name
Where chz_gtin_id=@chz_gtin_id";
var transaction = Transact <object> .Create(ConnectionString, commandText, parameter : createNaklItemModel);
transaction.ExecuteNonQuery();
}
public void Update([FromBody] CreateNaklItemModel createNaklItemModel)
{
try
{
naklItemDataBase.SaveChanges(createNaklItemModel);
}
catch (Exception e)
{
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
}
public int Add([FromBody] CreateNaklItemModel createNaklItemModel)
{
try
{
naklItemDataBase.Add(createNaklItemModel);
return(naklItemDataBase.GetMaxId());
}
catch (Exception e)
{
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
}
