public async Task <int> Update(CollectionInventory inventory)
{
var cmd = QueriesCreatingHelper.CreateQueryUpdate(inventory);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs == 0 ? -1 : 0);
}
public async Task <int> UpdateItem(RetailerBuyingCalendarItem item)
{
var cmd = QueriesCreatingHelper.CreateQueryUpdate(item);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs == 0 ? -1 : 0);
}
public async Task <int> Add(FulfillmentFROrderViewModel fulFr)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(fulFr);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <bool> UpdateItemAsync(PurchaseOrderItem poItem)
{
var cmd = QueriesCreatingHelper.CreateQueryUpdate(poItem);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs != 0);
}
public async Task <int> Add(DistributionEmployee employee)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(employee);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <int> Update(DistributionEmployee employee)
{
var cmd = QueriesCreatingHelper.CreateQueryUpdate(employee);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs == 0 ? -1 : 0);
}
public async Task <int> Update(FarmerRetailerOrderItems item)
{
var cmd = QueriesCreatingHelper.CreateQueryUpdate(item);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs == 0 ? -1 : 0);
}
public async Task <int> Add(FarmerRetailerOrderItems item)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(item);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <int> AddAsync(UI.Captions.Models.Caption caption)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(caption);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <int> InsertDevice(UserAccountDevice userAccountDevice)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(userAccountDevice);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <int> CreateTripAudit(TripAudit audit)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(audit);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <int> Add(FarmerBuyingCalendar farmerBuyingCalendar)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(farmerBuyingCalendar);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <int> Add(FertilizerCategory fertilizerCategory)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(fertilizerCategory);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <int> Add(CollectionInventoryHistory history)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(history);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <int> UpdateItem(CFShippingItem shippingItem)
{
var cmd = QueriesCreatingHelper.CreateQueryUpdate(shippingItem);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs == 0 ? -1 : 0);
}
public async Task <int> UpdateAsync(Contact contact)
{
var cmd = QueriesCreatingHelper.CreateQueryUpdate(contact);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs == 0 ? -1 : 0);
}
public async Task <int> UpdateLocation(RetailerLocation retailerLocation)
{
var cmd = QueriesCreatingHelper.CreateQueryUpdate(retailerLocation);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs == 0 ? -1 : 0);
}
public async Task <int> AddItems(FulfillmentCollectionItem fulCoItem)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(fulCoItem);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <bool> UpdateAsync(Message msg, CancellationToken cancellationToken = default(CancellationToken))
{
string cmd = QueriesCreatingHelper.CreateQueryUpdate(msg);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs != 0);
}
public async Task <int> AddLocation(RetailerLocation retailerLocation)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(retailerLocation);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <int> AddItemAsync(PurchaseOrderItem poItem)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(poItem);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <int> UpdatePrice(ProductPrice price)
{
var cmd = QueriesCreatingHelper.CreateQueryUpdate(price);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs == 0 ? -1 : 0);
}
public async Task <int> AddAsync(GrowingMethod growingMethod)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(growingMethod);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <int> AddAsync(ProductLanguage productLanguage)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(productLanguage);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <bool> Update(FulfillmentCollection fulCol)
{
string cmd = QueriesCreatingHelper.CreateQueryUpdate(fulCol);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs != 0);
}
public async Task <int> AddAsync(Message msg, CancellationToken cancellationToken = default(CancellationToken))
{
msg.Code = await _storageQueries.GenarateCodeAsync(StorageKeys.MessageCode);
var cmd = QueriesCreatingHelper.CreateQueryInsert(msg);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <int> AddAsync(string key)
{
var storage = new Storage()
{
Key = key,
NumericLength = 3,
Prefix = "",
Value = 1,
HasDate = false,
};
var cmd = QueriesCreatingHelper.CreateQueryInsert(storage);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <int> AddOrUpdateContact(Contact contact)
{
var cmd = string.Empty;
if (contact.Id != 0)
{
cmd = QueriesCreatingHelper.CreateQueryUpdate(contact);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs == 0 ? -1 : contact.Id);
}
else
{
cmd = QueriesCreatingHelper.CreateQueryInsert(contact);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
}
public async Task <int> AddOrUpdateLanguage(CategoryLanguage language)
{
string cmd = QueriesCreatingHelper.CreateQuerySelect <CategoryLanguage>($"category_id = {language.CategoryId} AND language_id = {language.LanguageId}");
var lang = (await DALHelper.ExecuteQuery <CategoryLanguage>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).FirstOrDefault();
if (lang == null)
{
cmd = QueriesCreatingHelper.CreateQueryInsert(language);
cmd += ";SELECT LAST_INSERT_ID();";
return(await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection));
}
else
{
language.Id = lang.Id;
cmd = QueriesCreatingHelper.CreateQueryUpdate(language);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs == 0 ? -1 : language.Id);
}
}
public async Task <int> UpdateAsync(ProductLanguage productLanguage)
{
var cmd = QueriesCreatingHelper.CreateQueryUpdate(productLanguage);
return(await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection));
}
