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