public static IList <FindUserWarehousesResult> TranslateResultSet(IDataReader reader)
{
IList <FindUserWarehousesResult> resultList = new List <FindUserWarehousesResult>();
object data;
while (reader.Read())
{
FindUserWarehousesResult result = new FindUserWarehousesResult();
data = reader["WHID"];
if (data != DBNull.Value)
{
result.WarehouseIdentity = DbTypeConvertor.Convert <string>(data);
}
data = reader["WHNAME"];
if (data != DBNull.Value)
{
result.WarehouseName = DbTypeConvertor.Convert <string>(data);
}
resultList.Add(result);
}
return(resultList);
}
public static void MarksNewsAsRead(List <OrderedItemInfo> newItems)
{
for (int i = 0; i < newItems.Count; i++)
{
NewsDb item = DbTypeConvertor.FromNewsData(newItems[i]);
DatabaseManager.AddNewsItems(item);
}
}
public static void TranslateParameters(IDataParameterCollection parameterList, string outputManagerID)
{
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "OMID";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = outputManagerID;
parameterList.Add(dbParameter);
}
public static PictureData ToPictureData(PictureDb p)
{
FillAlgorithm fillType = DbTypeConvertor.FillAlgFromDb(p.FillType);
return(new PictureData(PictureType.Local, p.PackId, p.PicId, fillType)
{
HasSave = (p.HasSave == 1),
Solved = (p.Solved == 1),
PicClass = DbTypeConvertor.PicClassFromDb(p.PicClass)
});
}
public static PictureDb FromPictureData(PictureData pd)
{
return(new PictureDb
{
PicId = pd.Id,
PackId = pd.PackId,
FillType = DbTypeConvertor.FillAlgToDb(pd.FillType),
HasSave = ((!pd.HasSave) ? 0 : 1),
Solved = ((!pd.Solved) ? 0 : 1),
PicClass = DbTypeConvertor.PicClassToDb(pd.PicClass)
});
}
public static void UpdateSave(PictureSaveData pictureSaveData)
{
try
{
SaveDb obj = DbTypeConvertor.FromPictureSaveData(pictureSaveData);
DatabaseManager.db.UpdateTable(obj);
}
catch (Exception ex)
{
FMLogger.Log("upd saveData fail. " + ex.Message);
}
}
public static void UpdatePicture(PictureData pd)
{
try
{
PictureDb obj = DbTypeConvertor.FromPictureData(pd);
DatabaseManager.db.UpdateTable(obj);
}
catch (Exception ex)
{
FMLogger.Log("upd pic error. " + ex.Message);
AnalyticsManager.DbTransactionError("picDb", "UpdatePicture: " + ex.Message);
}
}
public static void AddPicture(PictureData pd)
{
try
{
PictureDb obj = DbTypeConvertor.FromPictureData(pd);
DatabaseManager.db.Insert(obj);
}
catch (Exception ex)
{
FMLogger.Log("error adding picture. " + ex.Message);
AnalyticsManager.DbTransactionError("picDb", "AddPicture: " + ex.Message);
}
}
public static LogonResult TranslateResult(IDataParameterCollection resultParameters)
{
LogonResult result = new LogonResult();
object data;
data = ((IDbDataParameter)resultParameters["ALMID_O"]).Value;
if (data != DBNull.Value)
{
result.AlarmId = DbTypeConvertor.Convert <string>(data);
}
return(result);
}
public static IList <IDbDataParameter> TranslateParameters(FindUserNodesParameters parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "EMPID";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.UserIdentity;
parameterList.Add(dbParameter);
return(parameterList);
}
public static FindRowIdentityResult TranslateResult(IDataParameterCollection resultParameters)
{
FindRowIdentityResult result = new FindRowIdentityResult();
object data;
data = ((IDbDataParameter)resultParameters["ROWIDENTITY_I"]).Value;
if (data != DBNull.Value)
{
result.RowIdentity = DbTypeConvertor.Convert <string>(data);
}
return(result);
}
public static IList <FindUserLogonDetailsResult> TranslateResultSet(IDataReader reader)
{
IList <FindUserLogonDetailsResult> resultList = new List <FindUserLogonDetailsResult>();
object data;
while (reader.Read())
{
FindUserLogonDetailsResult result = new FindUserLogonDetailsResult();
data = reader["EMPID"];
if (data != DBNull.Value)
{
result.UserIdentity = DbTypeConvertor.Convert <string>(data);
}
data = reader["EMPNAME"];
if (data != DBNull.Value)
{
result.UserName = DbTypeConvertor.Convert <string>(data);
}
data = reader["WHID"];
if (data != DBNull.Value)
{
result.RecentWarehouseIdentity = DbTypeConvertor.Convert <string>(data);
}
data = reader["COMPANY_ID"];
if (data != DBNull.Value)
{
result.RecentCompanyIdentity = DbTypeConvertor.Convert <string>(data);
}
data = reader["LASTLOGONDTM"];
if (data != DBNull.Value)
{
result.LastLogonTime = DbTypeConvertor.Convert <DateTime>(data);
}
resultList.Add(result);
}
return(resultList);
}
public static IList <IDbDataParameter> TranslateParameters(LogonParameters parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "EMPID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.UserIdentity;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "WHID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.WarehouseIdentity;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "COMPANY_ID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.CompanyIdentity;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "TERID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.TerminalIdentity;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "PRODUCT_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.ApplicationIdentity;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "ALMID_O";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Output;
dbParameter.Size = 35;
parameterList.Add(dbParameter);
return(parameterList);
}
public static PictureSaveData GetSave(PictureData pd)
{
PictureSaveData result;
try
{
SaveDb s = DatabaseManager.db.Get <SaveDb>(pd.Id);
PictureSaveData pictureSaveData = DbTypeConvertor.ToPictureSaveData(s);
result = pictureSaveData;
}
catch
{
result = null;
}
return(result);
}
public static PictureData GetPicture(int id)
{
PictureData result;
try
{
PictureDb p = DatabaseManager.db.Get <PictureDb>(id);
PictureData pictureData = DbTypeConvertor.ToPictureData(p);
result = pictureData;
}
catch
{
result = null;
}
return(result);
}
public static void DeletePicture(PictureData pd)
{
if (pd.HasSave)
{
DatabaseManager.DeleteSave(pd.Id, false);
}
try
{
PictureDb obj = DbTypeConvertor.FromPictureData(pd);
DatabaseManager.db.Delete <PictureDb>(obj);
}
catch (Exception ex)
{
FMLogger.Log("error del pic. " + ex.Message);
AnalyticsManager.DbTransactionError("picDb", "DeletePicture: " + ex.Message);
}
}
public static bool AddBonusCode(BonusCodeData bonusCode)
{
bool result;
try
{
GiftDb obj = DbTypeConvertor.FromGiftData(bonusCode);
DatabaseManager.db.Insert(obj);
result = true;
}
catch (Exception ex)
{
FMLogger.Log("add gift fail. " + ex.Message);
result = false;
}
return(result);
}
public static IList <FindUserCompaniesResult> TranslateResultSet(IDataReader reader)
{
IList <FindUserCompaniesResult> resultList = new List <FindUserCompaniesResult>();
object data;
while (reader.Read())
{
FindUserCompaniesResult result = new FindUserCompaniesResult();
data = reader["COMPANY_ID"];
if (data != DBNull.Value)
{
result.CompanyIdentity = DbTypeConvertor.Convert <string>(data);
}
data = reader["COMPANY_NAME"];
if (data != DBNull.Value)
{
result.CompanyName = DbTypeConvertor.Convert <string>(data);
}
data = reader["HOSTINTFACETYPE"];
if (data != DBNull.Value)
{
string hostIntFaceType = DbTypeConvertor.Convert <string>(data);
result.IsClientInterfaceHAPI = hostIntFaceType.Equals("H");
result.IsClientInterfaceWebServices = hostIntFaceType.Equals("W");
result.IsClientInterfaceEDI = hostIntFaceType.Equals("E");
}
data = reader["WHID"];
if (data != DBNull.Value)
{
result.WarehouseIdentity = DbTypeConvertor.Convert <string>(data);
}
resultList.Add(result);
}
return(resultList);
}
public static IList <IDbDataParameter> TranslateParameters(GetInformationXMLParameters parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
OracleParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "NLANGCOD_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.LanguageCode;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter("XML_O", OracleDbType.Clob);
dbParameter.Direction = ParameterDirection.ReturnValue;
parameterList.Add(dbParameter);
return(parameterList);
}
public static IList <IDbDataParameter> TranslateParameters(StartDatabaseTracingParameters parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "EMPID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.UserId;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "TERID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.TerminalId;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "THREAD_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = "0";
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "WriteHeader_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
if (parameters.WriteHeader)
{
dbParameter.Value = "1";
}
else
{
dbParameter.Value = "0";
}
parameterList.Add(dbParameter);
return(parameterList);
}
public static void TranslateParameters(IDataParameterCollection parameterList, string outputManagerID, string errorMessage)
{
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "OMID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = outputManagerID;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "ERROR_MSG_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
((OracleParameter)dbParameter).OracleDbType = OracleDbType.Clob;
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = errorMessage;
parameterList.Add(dbParameter);
}
public DateTime?FindConfigUpdateTime(string outputManagerID)
{
using (TransactionScope scope = new TransactionScope())
{
DateTime?result = null;
using (IDbConnection connection = new DbConnection(ConnectionString))
{
connection.Open();
using (IDbCommand command = connection.CreateCommand())
{
command.CommandText = StatementCache.Instance.GetCachedStatement("Imi.SupplyChain.OM.OutputHandler.ConfigDataAccess.Queries.FindUpdateTime.sql");
((OracleCommand)command).BindByName = true;
IDataParameter dbParameter = new OracleParameter();
dbParameter.ParameterName = "OMID";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = outputManagerID;
command.Parameters.Add(dbParameter);
//LogDbCommand(command);
command.Prepare();
object upddtm = command.ExecuteScalar();
if (upddtm != null && upddtm != DBNull.Value)
{
result = DbTypeConvertor.Convert <DateTime>(upddtm);
}
}
}
scope.Complete();
return(result);
}
}
public static IDictionary <string, Printer> TranslateResultSet(IDataReader reader)
{
IDictionary <string, Printer> resultList = new Dictionary <string, Printer>();
object data;
while (reader.Read())
{
Printer result = new Printer();
data = reader["PRTID"];
if (data != DBNull.Value)
{
result.PrinterID = DbTypeConvertor.Convert <string>(data);
}
data = reader["PRT_DEVICE"];
if (data != DBNull.Value)
{
result.PrinterDevice = DbTypeConvertor.Convert <string>(data);
}
data = reader["PRT_TYPE"];
if (data != DBNull.Value)
{
result.PrinterType = DbTypeConvertor.Convert <string>(data);
}
data = reader["UPDDTM"];
if (data != DBNull.Value)
{
result.LatestUpdate = DbTypeConvertor.Convert <DateTime>(data);
}
if (!resultList.ContainsKey(result.PrinterID))
{
resultList.Add(result.PrinterID, result);
}
}
return(resultList);
}
public static IList <IDbDataParameter> TranslateParameters(ModifyInterfaceTracingParameters parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "LOGG_ON_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.LoggOn ? "1" : "0";
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "LOGG_INTVL_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(int));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.LoggInterval;
parameterList.Add(dbParameter);
return(parameterList);
}
public static IList <IDbDataParameter> TranslateParameters(FindRowIdentityParameters parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "ID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.Id;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "ROWIDENTITY_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Output;
dbParameter.Size = 255;
parameterList.Add(dbParameter);
return(parameterList);
}
public static IList <FindAlarmTextResult> TranslateResultSet(IDataReader reader)
{
IList <FindAlarmTextResult> resultList = new List <FindAlarmTextResult>();
object data;
while (reader.Read())
{
FindAlarmTextResult result = new FindAlarmTextResult();
data = reader["ALMTXT"];
if (data != DBNull.Value)
{
result.AlarmText = DbTypeConvertor.Convert <string>(data);
}
resultList.Add(result);
}
return(resultList);
}
public static IList <IDbDataParameter> TranslateParameters(FindAlarmTextParams parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "ALMID";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.AlarmId;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "NLANGCOD";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.LanguageCode;
parameterList.Add(dbParameter);
return(parameterList);
}
public static IList <DocumentType> TranslateResultSet(IDataReader reader)
{
IList <DocumentType> resultList = new List <DocumentType>();
object data;
while (reader.Read())
{
DocumentType result = new DocumentType();
data = reader["DOCTYPID"];
if (data != DBNull.Value)
{
result.DocumentTypeID = DbTypeConvertor.Convert <string>(data);
}
data = reader["DOCSUBTYPID"];
if (data != DBNull.Value)
{
result.SubDocmentTypeID = DbTypeConvertor.Convert <string>(data);
}
data = reader["RPTID"];
if (data != DBNull.Value)
{
result.ReportID = DbTypeConvertor.Convert <string>(data);
}
data = reader["UPDDTM"];
if (data != DBNull.Value)
{
result.LatestUpdate = DbTypeConvertor.Convert <DateTime>(data);
}
resultList.Add(result);
}
return(resultList);
}
public static IList <PrinterAssociation> TranslateResultSet(IDataReader reader)
{
IList <PrinterAssociation> resultList = new List <PrinterAssociation>();
object data;
while (reader.Read())
{
PrinterAssociation result = new PrinterAssociation();
data = reader["PRTID"];
if (data != DBNull.Value)
{
result.PrinterID = DbTypeConvertor.Convert <string>(data);
}
data = reader["TERGRPID"];
if (data != DBNull.Value)
{
result.TerminalGroupID = DbTypeConvertor.Convert <string>(data);
}
data = reader["RPTGRPID"];
if (data != DBNull.Value)
{
result.ReportGroupID = DbTypeConvertor.Convert <string>(data);
}
data = reader["UPDDTM"];
if (data != DBNull.Value)
{
result.LatestUpdate = DbTypeConvertor.Convert <DateTime>(data);
}
resultList.Add(result);
}
return(resultList);
}
public static List <BonusCodeData> GetClaimedGifts()
{
List <BonusCodeData> list = new List <BonusCodeData>();
try
{
string query = "SELECT * FROM GiftDb ORDER BY TimeStamp DESC";
List <GiftDb> list2 = DatabaseManager.db.Query <GiftDb>(query, new object[0]);
if (list2 != null)
{
for (int i = 0; i < list2.Count; i++)
{
list.Add(DbTypeConvertor.ToGiftData(list2[i]));
}
}
}
catch (Exception ex)
{
FMLogger.Log("failed to get saves. " + ex.Message);
AnalyticsManager.DbTransactionError("giftDb", "GetClaimedGifts: " + ex.Message);
}
return(list);
}
