public string GetSetting(string settingName) { string settingValue = string.Empty; try { IDataParameter[] parameters = { GetParameter("@setting_name", settingName) }; using (IDbConnection conn = GetConnection()) { conn.Open(); using (var rdr = GetReader(conn, "sc_get_db_setting", parameters, CommandType.StoredProcedure)) { if (rdr.Read()) { settingValue = DataReaderExtensions.GetValue <string>(rdr, "db_setting_value"); } } } } catch (Exception ex) { throw ex; } return(settingValue); }
public Tuple <int, string> GetConnectionString(string smallFileName, string targetConnectionString) { IDataParameter[] parameters = { GetParameter("@file_name", smallFileName) }; using (IDbConnection conn = GetConnection()) { conn.Open(); using (var dr = GetReader(conn, "sc_get_user_dsn", parameters, CommandType.StoredProcedure)) { if (!dr.Read()) { throw new Exception("target database not found for this file"); } var databaseId = DataReaderExtensions.GetValue <int>(dr, "db_database_id"); var catalog = DataReaderExtensions.GetValue <string>(dr, "database_name"); var server = DataReaderExtensions.GetValue <string>(dr, "server_name"); var connStr = catalog + ";" + server; var items = server.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries); var dataSource = items.FirstOrDefault(x => x.Contains("Data Source=")); if (!string.IsNullOrEmpty(dataSource)) { connStr = string.Format(targetConnectionString, dataSource, catalog); } return(new Tuple <int, string>(databaseId, connStr)); } } }
public Config GetImportInformation(string connStr, string smallFileName, string fileName) { IDataParameter[] parameters = { GetParameter("@sys_file_name", smallFileName) }; using (IDbConnection conn = GetConnection()) { conn.Open(); using (IDataReader dr = GetReader(conn, "sc_get_ingredient_import", parameters, CommandType.StoredProcedure)) { if (dr.Read()) { int importId = DataReaderExtensions.GetValue <int>(dr, "ingredient_import_id"); int userId = dr.GetInt32(1); int uGroupId = dr.GetInt32(2); string displayFileName = dr.GetString(3); return(new Config(connStr, importId, userId, uGroupId, fileName, displayFileName)); } } } throw new Exception("import details not found for this file"); }
public IEnumerable <UpdatedEntityItem> GetUpdatedEntity(Tuple <int?, string> ids) { List <UpdatedEntityItem> resultList = new List <UpdatedEntityItem>(); IDataParameter[] parameters = { GetParameter("@product_id", ids.Item1), GetParameter("@supplier_code", ids.Item2), }; using (IDbConnection conn = GetConnection()) { conn.Open(); using (var dr = GetReader(conn, "sc_import_get_affected_products", parameters, CommandType.StoredProcedure)) // todo create store procedure { while (dr.Read()) { var entityId = DataReaderExtensions.IsDBNull(dr, "product_id") ? 0 : DataReaderExtensions.GetValue <int>(dr, "product_id"); var entityTypeId = DataReaderExtensions.IsDBNull(dr, "product_type_id") ? 0 : DataReaderExtensions.GetValue <int>(dr, "product_type_id"); var item = new UpdatedEntityItem { EntityId = entityId, EntityTypeId = entityTypeId == (int)Constants.ProductType.Ingredient ? Constants.EntityType.Ingredient : Constants.EntityType.Dish, MessageActionType = Constants.MessageActionType.StarChefEventsUpdated }; resultList.Add(item); } return(resultList); } } }
public bool IsOrchestrationEnabled(Constants.EntityType type) { bool result = false; IDataParameter[] parameters = { GetParameter("@entity_type_id", type) }; using (IDbConnection conn = GetConnection()) { conn.Open(); using (var dr = GetReader(conn, "sc_get_orchestration_lookup", parameters, CommandType.StoredProcedure)) { while (dr.Read()) { result = DataReaderExtensions.IsDBNull(dr, "is_publish") ? false : DataReaderExtensions.GetValue <bool>(dr, "is_publish"); } } } return(result); }