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> 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> 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> 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> 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> 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> 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 <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> 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> 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 <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 <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> 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(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> Write(UserSession userLogin, T value, IDbConnection conn = null, IDbTransaction trans = null) { Assembly assembly = null; if (!string.IsNullOrEmpty(GlobalConfiguration.IntegrationTemplate.ModelAssembly)) { var path = Path.Combine(Directory.GetCurrentDirectory(), "ExtensionFolder", GlobalConfiguration.IntegrationTemplate.ModelAssembly); assembly = Assembly.Load(File.ReadAllBytes(path)); } EventResultModel eventResultModel = null; if (conn != null && trans != null) { try { var model = GlobalConfiguration.IntegrationTemplate.ModelTemplates.FirstOrDefault(m => m.Name == typeof(T).Name); // run berore record event eventResultModel = CommonHelper.RunEvent(assembly, model.Insert.BeforeRowEvent, typeof(BaseEvent <T>), new object[] { this, value, conn, trans, userLogin }); if (!eventResultModel.Result) { throw new Exception(eventResultModel.ErrorMessage); } if (!eventResultModel.IsBubble) { return(0); } string cmd = QueriesCreatingHelper.CreateQueryInsert(value); var rs = await DALHelper.Execute(cmd, dbTransaction : trans, connection : conn); // run after record event eventResultModel = CommonHelper.RunEvent(assembly, model.Insert.AfterRowEvent, typeof(BaseEvent <T>), new object[] { this, value, conn, trans, userLogin }); if (!eventResultModel.Result) { throw new Exception(eventResultModel.ErrorMessage); } if (!eventResultModel.IsBubble) { return(0); } return(rs == 1 ? 0 : -1); } catch (Exception ex) { LogHelper.GetLogger().Error(ex.Message); return(-1); } } else { try { var model = GlobalConfiguration.IntegrationTemplate.ModelTemplates.FirstOrDefault(m => m.Name == typeof(T).Name); // run berore record event eventResultModel = CommonHelper.RunEvent(assembly, model.Insert.BeforeRowEvent, typeof(BaseEvent <T>), new object[] { this, value, conn, trans, userLogin }); if (!eventResultModel.Result) { throw new Exception(eventResultModel.ErrorMessage); } if (!eventResultModel.IsBubble) { return(0); } string cmd = QueriesCreatingHelper.CreateQueryInsert(value); var rs = await DALHelper.Execute(cmd); // run after record event eventResultModel = CommonHelper.RunEvent(assembly, model.Insert.AfterRowEvent, typeof(BaseEvent <T>), new object[] { this, value, conn, trans, userLogin }); if (!eventResultModel.Result) { throw new Exception(eventResultModel.ErrorMessage); } if (!eventResultModel.IsBubble) { return(0); } return(rs == 1 ? 0 : -1); } catch (Exception ex) { LogHelper.GetLogger().Error(ex.Message); return(-1); } } }
public async Task <int> WriteArray(UserSession user, IEnumerable <T> value, IDbConnection conn = null, IDbTransaction trans = null) { Assembly assembly = null; if (!string.IsNullOrEmpty(GlobalConfiguration.IntegrationTemplate.ModelAssembly)) { var path = Path.Combine(Directory.GetCurrentDirectory(), "ExtensionFolder", GlobalConfiguration.IntegrationTemplate.ModelAssembly); assembly = Assembly.Load(File.ReadAllBytes(path)); } EventResultModel eventResultModel = null; if (conn != null && trans != null) { try { var model = GlobalConfiguration.IntegrationTemplate.ModelTemplates.FirstOrDefault(m => m.Name == typeof(T).Name); // run berore event eventResultModel = CommonHelper.RunEvent(assembly, model.Insert.BeforeEvent, typeof(BaseEvent <T>), new object[] { this, value, conn, trans, user }); if (!eventResultModel.Result) { throw new Exception(eventResultModel.ErrorMessage); } if (!eventResultModel.IsBubble) { return(0); } foreach (var item in value) { // run berore record event eventResultModel = CommonHelper.RunEvent(assembly, model.Insert.BeforeRowEvent, typeof(BaseEvent <T>), new object[] { this, item, conn, trans, user }); if (!eventResultModel.Result) { throw new Exception(eventResultModel.ErrorMessage); } if (!eventResultModel.IsBubble) { continue; } string cmd = QueriesCreatingHelper.CreateQueryInsert(value); var rs = await DALHelper.Execute(cmd, dbTransaction : trans, connection : conn); // run after record event eventResultModel = CommonHelper.RunEvent(assembly, model.Insert.AfterRowEvent, typeof(BaseEvent <T>), new object[] { this, item, conn, trans, user }); if (!eventResultModel.Result) { throw new Exception(eventResultModel.ErrorMessage); } if (!eventResultModel.IsBubble) { continue; } } // run after event eventResultModel = CommonHelper.RunEvent(assembly, model.Insert.AfterEvent, typeof(BaseEvent <T>), new object[] { this, value, conn, trans, user }); if (!eventResultModel.Result) { throw new Exception(eventResultModel.ErrorMessage); } if (!eventResultModel.IsBubble) { return(0); } return(0); } catch (Exception ex) { LogHelper.GetLogger().Error(ex.Message); return(-1); } } else { using (conn = DALHelper.GetConnection()) { conn.Open(); using (trans = conn.BeginTransaction()) { try { var model = GlobalConfiguration.IntegrationTemplate.ModelTemplates.FirstOrDefault(m => m.Name == typeof(T).Name); // run berore event eventResultModel = CommonHelper.RunEvent(assembly, model.Insert.BeforeEvent, typeof(BaseEvent <T>), new object[] { this, value, conn, trans, user }); if (!eventResultModel.Result) { throw new Exception(eventResultModel.ErrorMessage); } if (!eventResultModel.IsBubble) { return(0); } foreach (var item in value) { // run berore record event eventResultModel = CommonHelper.RunEvent(assembly, model.Insert.BeforeRowEvent, typeof(BaseEvent <T>), new object[] { this, item, conn, trans, user }); if (!eventResultModel.Result) { throw new Exception(eventResultModel.ErrorMessage); } if (!eventResultModel.IsBubble) { continue; } string cmd = QueriesCreatingHelper.CreateQueryInsert(value); var rs = await DALHelper.Execute(cmd, dbTransaction : trans, connection : conn); // run after record event eventResultModel = CommonHelper.RunEvent(assembly, model.Insert.AfterRowEvent, typeof(BaseEvent <T>), new object[] { this, item, conn, trans, user }); if (!eventResultModel.Result) { throw new Exception(eventResultModel.ErrorMessage); } if (!eventResultModel.IsBubble) { continue; } } // run after event eventResultModel = CommonHelper.RunEvent(assembly, model.Insert.AfterEvent, typeof(BaseEvent <T>), new object[] { this, value, conn, trans, user }); if (!eventResultModel.Result) { throw new Exception(eventResultModel.ErrorMessage); } if (!eventResultModel.IsBubble) { return(0); } trans.Commit(); return(0); } catch (Exception ex) { LogHelper.GetLogger().Error(ex.Message); try { trans.Rollback(); } catch { } return(-1); } finally { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } } } } }