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);
}
