public void TransactionTest1()
{
var seller = new SellerEntity
{
AccountID = 1,
AreaCode = "10001",
UserRole = 3,
OperatorID = 2,
OperatorTime = DateTime.Now,
CreatorID = 2,
CreateTime = DateTime.Now,
UserName = "******"
};
var police = new PoliceEnity
{
AccountID = 1,
AreaCode = "10001",
UserRole = 3,
OperatorID = 2,
OperateTime = DateTime.Now,
CreatorID = 2,
CreateTime = DateTime.Now,
UserName = "******"
};
((ISellerRepository)this.uw.GetRepository(typeof(ISellerRepository))).Insert(seller, false);
((IPoliceRepository)this.uw.GetRepository(typeof(IPoliceRepository))).Insert(police, false);
this.uw.Save();
}
public async Task RemoveSeller(SellerEntity seller)
{
using (var connection = new SqliteConnection(_setting.ConnectionString))
{
const string command =
"DELETE FROM Sellers WHERE Id = @Id";
var result = await connection.ExecuteAsync(command, seller);
}
}
private void CreateInitialSeller(long productId, SellerEntity seller)
{
using (var connection = new SqliteConnection(_setting.ConnectionString))
{
var command = $@"INSERT INTO Sellers (Id, ProductId, Name, Quantity, Price) VALUES
({seller.Id}, {productId}, '{seller.Name}', {seller.Quantity}, {seller.Price} )";
connection.Execute(command);
}
}
public async Task <SellerEntity> Add(SellerEntity item)
{
string query = @"INSERT INTO
seller
(
firstname
,lastname
,shopname
,shoplocation
,genderid
,shopdescription
,isactive
,isdeleted
,createdate
,updatedate
,createdby
,updatedby
,sellerimg
)
VALUES
(
@firstname
,@lastname
,@shopname
,@shoplocation
,@genderid
,@shopdescription
,@isactive
,@isdeleted
,@createdate
,@updatedate
,@createdby
,@updatedby
,@sellerimg
);";
var param = new
{
@firstname = item.FirstName,
@lastname = item.LastName,
@shopname = item.ShopName,
@shoplocation = item.ShopLocation,
@genderid = item.GenderId,
@shopdescription = item.ShopDescription,
@isactive = item.IsActive,
@isdeleted = item.IsDeleted,
@createdate = item.CreateDate,
@updatedate = item.UpdateDate,
@createdby = item.CreatedBy,
@updatedby = item.UpdatedBy,
@sellerimg = item.SellerIMG,
};
var result = await DbExecuteAsync <SellerEntity>(query, param);
return(result ? await GetById(item.Id) : new SellerEntity());
}
public async Task UpdateSeller(SellerEntity seller)
{
using (var connection = new SqliteConnection(_setting.ConnectionString))
{
const string command =
"UPDATE Sellers SET Name = @Name, Quantity = @Quantity, Price = @Price " +
"WHERE ID = @Id";
var result = await connection.ExecuteAsync(command, seller);
}
}
public async Task <SellerEntity> Update(long id, SellerEntity item)
{
string query = @"UPDATE seller
SET
query_status = @query_status
, modified_date = @modified_date
, start_time = @start_time
, end_time = @end_time
, modified_by = @modified_by
WHERE id = @id;";
var param = new
{
@id = id,
@modified_date = DateTime.Now.ToEpoch(),
};
var result = await DbExecuteAsync <SellerEntity>(query, param);
return(result ? await GetById(item.Id) : new SellerEntity());
}
public async Task CreateSeller(long productId, SellerEntity seller)
{
using (var connection = new SqliteConnection(_setting.ConnectionString))
{
string command;
if (seller.Id <= 0)
{
command = "INSERT INTO Sellers(ID, ProductID, Name, Quantity, Price) " +
$"VALUES (NULL, {productId}, @Name, @Quantity, @Price); " +
"SELECT LAST_INSERT_ROWID() AS id";
}
else
{
command = "INSERT INTO Sellers(ID, ProductID, Name, Quantity, Price) " +
$"VALUES ({seller.Id}, {productId}, @Name, @Quantity, @Price); " +
"SELECT LAST_INSERT_ROWID() AS id";
}
seller.Id = await connection.ExecuteScalarAsync <int>(command, seller);
}
}
public void TransactionTest2()
{
var seller = new SellerEntity
{
AccountID = 1,
AreaCode = "10001",
UserRole = 3,
OperatorID = 2,
OperatorTime = DateTime.Now,
CreatorID = 2,
CreateTime = DateTime.Now,
UserName = "******",
};
var sellerBrand = new SellerBrandEntity
{
BrandID = 1,
Seller = seller
};
((ISellerBrandRepository)this.uw.GetRepository(typeof(ISellerBrandRepository))).Insert(sellerBrand);
}
public async Task <SellerEntity> Update(long id, SellerEntity item)
{
item.Id = id;
return(await _SellerRepository.Update(id, item));
}
public async Task <SellerEntity> Add(SellerEntity item) => await _SellerRepository.Add(item);
