/// <summary> /// Instanciates a Admin1 object from the database via the admin1ID /// </summary> public Admin1(int admin1ID) { db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("AG_GetAdmin1Byadmin1ID"); db.AddInParameter(dbCommand, "admin1ID", DbType.Int32, admin1ID); //execute the stored procedure using (IDataReader dr = db.ExecuteReader(dbCommand)) { ColumnFieldList list = new ColumnFieldList(dr); if (dr.Read()) { if (list.IsColumnPresent("admin1ID")) { this._admin1ID = (int)dr["admin1ID"]; } if (list.IsColumnPresent("CountryID")) { this._countryID = (int)dr["CountryID"]; } if (list.IsColumnPresent("admin1CD")) { this._admin1CD = (string)dr["admin1CD"]; } if (list.IsColumnPresent("Name")) { this._name = (string)dr["Name"]; } } else { throw new Exception("There is no Admin1 in the database with the ID " + admin1ID); } dr.Close(); } }
/// <summary> /// Retrieve all files for a category and group /// </summary> /// <param name="category"></param> /// <returns></returns> /// <remarks></remarks> public List <Datafile> RetrieveDataFiles(string category, string group) { List <Datafile> files = new List <Datafile>(); DbCommand cmd = store.GetStoredProcCommand("RetrieveDatafiles"); store.AddInParameter(cmd, "category", DbType.String, category); store.AddInParameter(cmd, "group", DbType.String, group); using (IDataReader reader = store.ExecuteReader(cmd)) { while (reader.Read()) { Datafile newfile = new Datafile(); newfile.ID = reader.GetInt32(reader.GetOrdinal("id")); newfile.Category = category; newfile.Group = System.Convert.ToString(reader.SafeGetString(reader.GetOrdinal("group"))); newfile.Filename = System.Convert.ToString(reader.SafeGetString(reader.GetOrdinal("filename"))); newfile.Extension = System.Convert.ToString(reader.SafeGetString(reader.GetOrdinal("extension"))); newfile.Content = (byte[])(reader.GetValue(reader.GetOrdinal("content"))); files.Add(newfile); } } return(default(List <Datafile>)); }
public Usuario GetUsuario(int IdUsuario) { //stringBuilder = new StringBuilder(); //stringBuilder.Append(" SELECT IdUsuario,NumeroDeEmpleado,Usuario,Descripcion ,PasswordHash,PasswordSalt FROM TBLSECUSUARIOS WHERE IdUsuario = @IdUsuario"); //DbCommand commad = Database.GetSqlStringCommand(stringBuilder.ToString()); //Database.AddInParameter(commad, "USUARIO", System.Data.DbType.String, IdUsuario); //var usuario = Database.ExecuteSprocAccessor<Usuario>("UPSUsuarioByID", IdUsuario); //return usuario.SingleOrDefault(); List <Usuario> usuarios = new List <Usuario>(); stringBuilder = new StringBuilder(); stringBuilder.AppendLine("SELECT IdUsuario,NumeroDeEmpleado,Usuario UsuarioAcceso,Descripcion ,PasswordHash ,PasswordSalt FROM DbSistemas.dbo.TBLSECUSUARIOS WHERE IdUsuario = @PIdUsuario "); DbCommand dbCommand = Database.GetSqlStringCommand(stringBuilder.ToString()); Database.AddInParameter(dbCommand, "PIdUsuario", DbType.Int64, IdUsuario); using (IDataReader reader = Database.ExecuteReader(dbCommand)) { while (reader.Read()) { Usuario usuario = new Usuario(); usuario.IdUsuario = (int)reader["IdUsuario"]; usuario.NumeroDeEmpleado = reader["NumeroDeEmpleado"].ToString(); usuario.UsuarioAcceso = reader["UsuarioAcceso"].ToString(); usuario.Descripcion = reader["Descripcion"].ToString(); usuario.PasswordHash = (byte[])reader["PasswordHash"]; usuario.PasswordSalt = (byte[])reader["PasswordSalt"]; usuarios.Add(usuario); } } return(usuarios.FirstOrDefault()); }
ICollection <PersonalTiemposDeAlimentacion> IPersonalTiemposDeAlimentacionRepository.GetPersonalTiempos() { List <PersonalTiemposDeAlimentacion> personalTiempos = new List <PersonalTiemposDeAlimentacion>(); //DatabaseProviderFactory databaseProviderFactory = new DatabaseProviderFactory(); //Microsoft.Practices.EnterpriseLibrary.Data.Database database = databaseProviderFactory.Create("DefaultConnection"); stringBuilder = new StringBuilder(); stringBuilder.AppendLine("SELECT A.PersonalTiemposDeAlimentacionID,ltrim(rtrim(A.NumeroDeEmpleado))NumeroDeEmpleado,CAST(A.Fecha AS DATE)Fecha,A.TiemposDeAlimentacionID, "); stringBuilder.AppendLine("A.ModuloHabitacional FROM TblPersonalTiemposDeAlimentacion A"); using (IDataReader reader = Database.ExecuteReader(CommandType.Text, stringBuilder.ToString())) { while (reader.Read()) { PersonalTiemposDeAlimentacion personal = new PersonalTiemposDeAlimentacion(); personal.PersonalTiemposDeAlimentacionID = (int)reader["PersonalTiemposDeAlimentacionID"]; personal.NumeroDeEmpleado = reader["NumeroDeEmpleado"].ToString(); personal.Fecha = (DateTime)reader["Fecha"]; personal.TiemposDeAlimentacionID = (int)reader["TiemposDeAlimentacionID"]; TiemposDeAlimentacion tiemposDeAlimentacion = new TiemposDeAlimentacion(personal.TiemposDeAlimentacionID); personal.TiemposDeAlimentacion = tiemposDeAlimentacion; personal.ModuloHabitacional = reader["ModuloHabitacional"].ToString(); ModulosHabitacionales modulosHabitacionales = new ModulosHabitacionales(personal.ModuloHabitacional); personal.ModulosHabitacionales = modulosHabitacionales; personalTiempos.Add(personal); } } return(personalTiempos); }
//private Database db = DatabaseSettings.GetDatabaseSettings(); internal static IDataReader ExecuteReader(string CommandName, Int32 tipo, DbParameter[] param = null, DbTransaction transaction = null) { try { db = SetEnviroment(tipo); using (DbCommand cmd = db.GetStoredProcCommand(CommandName)) { if (param != null) { cmd.Parameters.AddRange(param); } //db.AddInParameter(cmd, "dni", DbType.String,"41856906"); IDataReader dr = null; if (transaction != null) { dr = db.ExecuteReader(cmd, transaction); } else { dr = db.ExecuteReader(cmd); } cmd.Dispose(); return(dr); } } catch (Exception ex) { throw new Exception("Error Inesperado=>" + ex.Message, ex); } }
public static IDataReader ExecuteReader(DbCommand command, DongABaseDAL dal) { // Kiểm tra, xử lý khi có transaction và không có transaction var result = dal.Transaction == null ? Instance.ExecuteReader(command) : Instance.ExecuteReader(command, dal.Transaction); return(result); }
/// <summary> /// Takes a command object and returns a sqldatareader object /// </summary> /// <param name="sqlCommand">SQLCommand</param> /// <returns>SqlDataReader</returns> public IDataReader ExecuteReader(SqlCommand command) { if (command == null) { throw new ArgumentNullException("command"); } int timeout = CommandTimeOut; if (timeout > 0) { command.CommandTimeout = timeout; } //Microsoft.Practices.EnterpriseLibrary.Data.Database db = GetDatabase(); return(db.ExecuteReader((DbCommand)command)); }
public DetalleTarjetaLugarList GetDetalleTarjetaLugarPaginacion(int IdProyecto, Paginacion oPaginacion, out int RowCount) { DetalleTarjetaLugarList olista = new DetalleTarjetaLugarList(); DbCommand oDbCommand = oDatabase.GetStoredProcCommand(DetalleTarjetaLugar.Proc.Paginacion.Str()); oDatabase.AddInParameter(oDbCommand, "@IdProyecto", DbType.Int32, IdProyecto); oDatabase = Pagination.DefaultParams(oDatabase, oDbCommand, oPaginacion); using (IDataReader oIDataReader = oDatabase.ExecuteReader(oDbCommand)) { int i1 = oIDataReader.GetOrdinal("IdDetTarjetaLugar"); int i2 = oIDataReader.GetOrdinal("IdProyecto"); int i3 = oIDataReader.GetOrdinal("SubRackId"); int i4 = oIDataReader.GetOrdinal("Slot"); int i5 = oIDataReader.GetOrdinal("BoardType"); while (oIDataReader.Read()) { DetalleTarjetaLugar obj = new DetalleTarjetaLugar(); obj.IdDetalleTarjetaLugar = DataUtil.DbValueToDefault<Int32>(oIDataReader[i1]); obj.IdProyecto = DataUtil.DbValueToDefault<Int32>(oIDataReader[i2]); obj.SubRackId = DataUtil.DbValueToDefault<String>(oIDataReader[i3]); obj.Slot = DataUtil.DbValueToDefault<String>(oIDataReader[i4]); obj.BoardType = DataUtil.DbValueToDefault<String>(oIDataReader[i5]); olista.Add(obj); } } RowCount = Convert.ToInt32(oDatabase.GetParameterValue(oDbCommand, "@RowCount")); return olista; }
public ProyectosList GetBandejaPaginacion(Proyectos oPersona, int IdEmpleado,Paginacion oPaginacion, out int RowCount) { ProyectosList olista = new ProyectosList(); DbCommand oDbCommand = oDatabase.GetStoredProcCommand(Proyectos.Proc.Bandeja.Str()); oDatabase.AddInParameter(oDbCommand, "@Codigo", DbType.String, oPersona.Codigo.nullEmpty()); oDatabase.AddInParameter(oDbCommand, "@IdEmpleado", DbType.Int32, IdEmpleado); oDatabase = Pagination.DefaultParams(oDatabase, oDbCommand, oPaginacion); using (IDataReader oIDataReader = oDatabase.ExecuteReader(oDbCommand)) { Proyectos obj = new Proyectos(); int i1 = oIDataReader.GetOrdinal("IdProyecto"); int i2 = oIDataReader.GetOrdinal("CodProyecto"); int i3 = oIDataReader.GetOrdinal("DescripProyecto"); int i4 = oIDataReader.GetOrdinal("NombreEstacion"); int i5 = oIDataReader.GetOrdinal("TipoEquipo"); int i6 = oIDataReader.GetOrdinal("NombreEquipo"); while (oIDataReader.Read()) { obj = new Proyectos(); obj.IdProyecto = DataUtil.DbValueToDefault<Int32>(oIDataReader[i1]); obj.Codigo = DataUtil.DbValueToDefault<String>(oIDataReader[i2]); obj.Descripcion = DataUtil.DbValueToDefault<String>(oIDataReader[i3]); obj.NombreEstacion = DataUtil.DbValueToDefault<String>(oIDataReader[i4]); obj.TipoEquipo = DataUtil.DbValueToDefault<String>(oIDataReader[i5]); obj.NombreEquipo = DataUtil.DbValueToDefault<String>(oIDataReader[i6]); olista.Add(obj); } } RowCount = Convert.ToInt32(oDatabase.GetParameterValue(oDbCommand, "@RowCount")); return olista; }
/*********************************************************************************************/ /// <summary> /// Lists Chinese language specific assets /// </summary> public static void ListAssets_Chi() { string strAssetServer, strFilePath; StreamWriter oListWriter; int intSiteId; strAssetServer = System.Configuration.ConfigurationSettings.AppSettings["AssetServer"]; intSiteId = Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings["SiteCodeID"]); strFilePath = System.Configuration.ConfigurationSettings.AppSettings["FilePath"]; DataLibrary.Database oSiteWideDB = null; oSiteWideDB = DataLibrary.DatabaseFactory.CreateDatabase("FlukeSitewide"); SqlDataReader sqlReader; sqlReader = (SqlDataReader)oSiteWideDB.ExecuteReader(System.Data.CommandType.Text, "RTK_Asset_Sel 'chi'," + intSiteId + ""); oListWriter = File.CreateText(strFilePath + "AssetList_zh.htm"); oListWriter.WriteLine("<html>"); oListWriter.WriteLine("<body>"); while (sqlReader.Read()) { oListWriter.WriteLine("<a href='" + strAssetServer + "/" + sqlReader["Site_Code"] + "/" + sqlReader["File_Name"] + "'>" + strAssetServer + "/" + sqlReader["Site_Code"] + "/" + sqlReader["File_Name"] + "</a><br>"); } oListWriter.WriteLine("</body>"); oListWriter.WriteLine("</html>"); oListWriter.Close(); sqlReader.Close(); }
/// <summary> /// GetItem SAS_ExportData Data... /// <summary> /// <param name=sender></param> /// <param name= e></param> public ExportDataEN GetItem(ExportDataEN argEn) { ExportDataEN loItem = new ExportDataEN(); string sqlCmd = "Select * FROM SAS_ExportData WHERE InterfaceID = @InterfaceID"; Microsoft.Practices.EnterpriseLibrary.Data.Database coDb = DatabaseFactory.CreateDatabase(csConnectionStr); try { using (DbCommand cmd = coDb.GetSqlStringCommand(sqlCmd)) { coDb.AddInParameter(cmd, "@InterfaceID", DbType.String, argEn.InterfaceID); using (IDataReader loReader = coDb.ExecuteReader(cmd)) { if (loReader != null) { loReader.Read(); loItem = LoadObject(loReader); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loItem); }
/// <summary> /// Getlist SAS_ExportData Data... /// <summary> /// <param name=sender></param> /// <param name= e></param> public List <ExportDataEN> GetList(ExportDataEN argEn) { List <ExportDataEN> loEnList = new List <ExportDataEN>(); argEn.InterfaceID = argEn.InterfaceID.Replace("*", "%"); string sqlCmd = "select * from SAS_ExportData where Interfaceid <> '0'"; if (argEn.InterfaceID.Length != 0) { sqlCmd = sqlCmd + " and Interfaceid like '" + argEn.InterfaceID + "'"; } Microsoft.Practices.EnterpriseLibrary.Data.Database coDb = DatabaseFactory.CreateDatabase(csConnectionStr); try { using (DbCommand cmd = coDb.GetSqlStringCommand(sqlCmd)) { using (IDataReader loReader = coDb.ExecuteReader(cmd)) { while (loReader.Read()) { ExportDataEN loItem = LoadObject(loReader); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
public void btnReader_Click(System.Object sender, System.EventArgs e) { //ExecuteReader using (IDataReader reader = db.ExecuteReader("GetSampleData")) { StringBuilder sb = new StringBuilder(); while (reader.Read() == true) { sb.AppendLine("--- New Row ---"); sb.AppendLine("ID: " + System.Convert.ToString(reader.GetInt32(0))); sb.AppendLine("Name: " + reader.GetString(1)); sb.AppendLine("Value: " + reader.GetString(2)); } txtResults.Text = sb.ToString(); } }
public IDataReader GetAllReader(string OrderBy, Database db) { orderBy = ""; if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy; sqlText="Select ID,UZMANLIK_ADI from UZMANLIK_ALANLARI "+orderBy; dbComm = db.GetSqlStringCommand(sqlText); return db.ExecuteReader(dbComm); }
public IDataReader GetAllReader(string OrderBy, Database db) { orderBy = ""; if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy; sqlText="Select ID,ACIKLAMA from SECENEK_TIP "+orderBy; dbComm = db.GetSqlStringCommand(sqlText); return db.ExecuteReader(dbComm); }
//public DbRulesManager() //{ // dbRules = DatabaseFactory.CreateDatabase(); //} /// <summary> /// Retrieves a rule from the database /// </summary> /// <param name="Name">The name of the rule</param> /// <returns>An AuthorizationRuleData object</returns> public AuthorizationRuleData GetRule(string name) { AuthorizationRuleData rule = null; DbCommand cmd = dbRules.GetStoredProcCommand("dbo.GetRuleByName"); dbRules.AddInParameter(cmd, "Name", DbType.String, name); using (IDataReader reader = dbRules.ExecuteReader(cmd)) { if (reader.Read()) { rule = GetRuleFromReader(reader); } } return(rule); }
/// <summary> /// Method to Get AutoNumber /// </summary> /// <param name="Description">Description as Input</param> /// <returns>Returns AutoNumber</returns> public string GetAutoNumber(string Description) { string AutoNo = ""; int CurNo = 0; int NoDigit = 0; int AutoCode = 0; int i = 0; string SqlStr; SqlStr = "select * from SAS_AutoNumber where SAAN_Des='" + Description + "'"; try { Microsoft.Practices.EnterpriseLibrary.Data.Database loDbAut = DatabaseFactory.CreateDatabase(csConnectionStr); DbCommand cmd = loDbAut.GetSqlStringCommand(SqlStr); IDataReader loReader = loDbAut.ExecuteReader(cmd); if (loReader.Read()) { AutoCode = Convert.ToInt32(loReader["SAAN_Code"]); CurNo = Convert.ToInt32(loReader["SAAN_CurNo"]) + 1; NoDigit = Convert.ToInt32(loReader["SAAN_NoDigit"]); AutoNo = Convert.ToString(loReader["SAAN_Prefix"]); if (CurNo.ToString().Length < NoDigit) { while (i < NoDigit - CurNo.ToString().Length) { AutoNo = AutoNo + "0"; i = i + 1; } AutoNo = AutoNo + CurNo; } loReader.Close(); } AutoNumberEn loItem = new AutoNumberEn(); loItem.SAAN_Code = AutoCode; AutoNumberDAL cods = new AutoNumberDAL(); cods.GetItem(loItem); loItem.SAAN_Code = Convert.ToInt32(AutoCode); loItem.SAAN_CurNo = CurNo; loItem.SAAN_AutoNo = AutoNo; cods.Update(loItem); return(AutoNo); } catch (Exception ex) { Console.Write("Error in connection : " + ex.Message); return(ex.ToString()); } }
public static IDataReader ExecuteReader(EntLib.Database db, DbCommand cmd) { var f = new Func <IDataReader>(() => { return(db.ExecuteReader(cmd)); }); return(RetryIt(f, cmd)); }
protected IDataReader ExecuteReader(SqlCommand command) { try { return(_db.ExecuteReader(command)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Executes the <paramref name="dbCommand"/> and returns an <see cref="IDataReader"/> through which the result can be read. /// It is the responsibility of the caller to close the connection and reader when finished. /// </summary> /// <param name="database">The database to execute the command within.</param> /// <param name="dbCommand">The command that contains the query to execute.</param> /// <returns>An <see cref="IDataReader"/> object.</returns> /// <exception cref="System.Exception">The command could not be executed.</exception> /// <exception cref="System.Data.Common.DbException">The command could not be executed.</exception> public static IDataReader ExecuteReader(Enterprise.Database database, DbCommand dbCommand) { IDataReader results = null; try { results = database.ExecuteReader(dbCommand); } catch (Exception ex) { throw new BusinessException(ex); } return(results); }
public List<Kulup> GetAllList(string OrderBy,Database db) { orderBy = ""; if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy; sqlText="Select ID,AD,SIFRE from KULUP "+orderBy; dbComm = db.GetSqlStringCommand(sqlText); using (IDataReader reader = db.ExecuteReader(dbComm)){ List<Kulup> kulupList = new List<Kulup>(); while(reader.Read()){ Kulup kulup = FillKulup(reader); kulupList.Add( kulup); } return kulupList; } }
public List<Katilimci> GetAllList(string OrderBy,Database db) { orderBy = ""; if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy; sqlText="Select ID,AD,SOYAD,TELEFON,EMAIL,UNVAN_ID from KATILIMCI "+orderBy; dbComm = db.GetSqlStringCommand(sqlText); using (IDataReader reader = db.ExecuteReader(dbComm)){ List<Katilimci> katilimciList = new List<Katilimci>(); while(reader.Read()){ Katilimci katilimci = FillKatilimci(reader); katilimciList.Add( katilimci); } return katilimciList; } }
public static List<EntityDTO> ExecuteReaderReturnDTO(Database db, string sql) { IDataReader reader = db.ExecuteReader(CommandType.Text, sql); List<EntityDTO> relatedProcess = new List<EntityDTO>(); while (reader.Read()) { EntityDTO dto = ReaderToEntityDTO(reader); relatedProcess.Add(dto); } reader.Close(); reader.Dispose(); return relatedProcess; }
public List<UzmanlikAlanlari> GetAllList(string OrderBy,Database db) { orderBy = ""; if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy; sqlText="Select ID,UZMANLIK_ADI from UZMANLIK_ALANLARI "+orderBy; dbComm = db.GetSqlStringCommand(sqlText); using (IDataReader reader = db.ExecuteReader(dbComm)){ List<UzmanlikAlanlari> uzmanlikalanlariList = new List<UzmanlikAlanlari>(); while(reader.Read()){ UzmanlikAlanlari uzmanlikalanlari = FillUzmanlikAlanlari(reader); uzmanlikalanlariList.Add( uzmanlikalanlari); } return uzmanlikalanlariList; } }
public List<OrganizasyonTip> GetAllList(string OrderBy,Database db) { orderBy = ""; if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy; sqlText="Select ID,ACIKLAMA from ORGANIZASYON_TIP "+orderBy; dbComm = db.GetSqlStringCommand(sqlText); using (IDataReader reader = db.ExecuteReader(dbComm)){ List<OrganizasyonTip> organizasyontipList = new List<OrganizasyonTip>(); while(reader.Read()){ OrganizasyonTip organizasyontip = FillOrganizasyonTip(reader); organizasyontipList.Add( organizasyontip); } return organizasyontipList; } }
public List<Unvan> GetAllList(string OrderBy,Database db) { orderBy = ""; if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy; sqlText="Select ID,ACIKLAMA from UNVAN "+orderBy; dbComm = db.GetSqlStringCommand(sqlText); using (IDataReader reader = db.ExecuteReader(dbComm)){ List<Unvan> unvanList = new List<Unvan>(); while(reader.Read()){ Unvan unvan = FillUnvan(reader); unvanList.Add( unvan); } return unvanList; } }
public List<Anket> GetAllList(string OrderBy,Database db) { orderBy = ""; if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy; sqlText="Select ID,ORGANIZASYON_ID,ACIKLAMA from ANKET "+orderBy; dbComm = db.GetSqlStringCommand(sqlText); using (IDataReader reader = db.ExecuteReader(dbComm)){ List<Anket> anketList = new List<Anket>(); while(reader.Read()){ Anket anket = FillAnket(reader); anketList.Add( anket); } return anketList; } }
public List<DuyuruTip> GetAllList(string OrderBy,Database db) { orderBy = ""; if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy; sqlText="Select ID,ACIKLAMA from DUYURU_TIP "+orderBy; dbComm = db.GetSqlStringCommand(sqlText); using (IDataReader reader = db.ExecuteReader(dbComm)){ List<DuyuruTip> duyurutipList = new List<DuyuruTip>(); while(reader.Read()){ DuyuruTip duyurutip = FillDuyuruTip(reader); duyurutipList.Add( duyurutip); } return duyurutipList; } }
public List<Soru> GetAllList(string OrderBy,Database db) { orderBy = ""; if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy; sqlText="Select ID,SORU_METNI,SECENEK_TIP from SORU "+orderBy; dbComm = db.GetSqlStringCommand(sqlText); using (IDataReader reader = db.ExecuteReader(dbComm)){ List<Soru> soruList = new List<Soru>(); while(reader.Read()){ Soru soru = FillSoru(reader); soruList.Add( soru); } return soruList; } }
public List<SecenekTip> GetAllList(string OrderBy,Database db) { orderBy = ""; if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy; sqlText="Select ID,ACIKLAMA from SECENEK_TIP "+orderBy; dbComm = db.GetSqlStringCommand(sqlText); using (IDataReader reader = db.ExecuteReader(dbComm)){ List<SecenekTip> secenektipList = new List<SecenekTip>(); while(reader.Read()){ SecenekTip secenektip = FillSecenekTip(reader); secenektipList.Add( secenektip); } return secenektipList; } }
public Domain.Order GetByID(int id) { // string sql = String.Format("select * from Blogs where BlogId={0}", id); string sql = String.Format("select * from Posts"); IDataReader rdr = database.ExecuteReader(CommandType.Text, sql); if (rdr.Read()) { IRowMapper <Domain.Order> mapper = MapBuilder <Domain.Order> .BuildAllProperties(); Domain.Order order = mapper.MapRow(rdr); return(order); } return(null); }
/// <summary> /// 执行查询语句,返回IDataReader /// </summary> /// <param name="dc">查询语句</param> /// <param name="db">操作目标数据库</param> /// <returns>IDataReader</returns> public static IDataReader ExecuteReader(DbCommand dc, Database db) { IDataReader myReader = null; try { PrepareCommand(ref dc, db); myReader = db.ExecuteReader(dc); return myReader; } catch (System.Exception e) { if (myReader != null) myReader.Close(); throw new Exception(e.Message); } }
public IDataReader ExecuteReader(string query, CommandType commandType, List <IDbDataParameter> parameters) { DbConnection _connection; _connection = _database.CreateConnection(); var cmd = commandType == CommandType.StoredProcedure ? _database.GetStoredProcCommand(query) : _database.GetSqlStringCommand(query); cmd.CommandTimeout = 300; cmd.Connection = _connection; _connection.Open(); if (parameters != null && parameters.Count > 0) { cmd.Parameters.AddRange(parameters.ToArray()); } return(_database.ExecuteReader(cmd)); }
ICollection <ModulosHabitacionales> IModuloHabitacionalRepository.GetModulosHabitacionales() { List <ModulosHabitacionales> clsModuloHabitacionals = new List <ModulosHabitacionales>(); DatabaseProviderFactory databaseProviderFactory = new DatabaseProviderFactory(); Microsoft.Practices.EnterpriseLibrary.Data.Database database = databaseProviderFactory.Create("DefaultConnection"); using (IDataReader reader = database.ExecuteReader(CommandType.Text, "SELECT ModuloHabitacional,Nombre FROM TblModulosHabitacionales WHERE ModuloHabitacional>0")) { while (reader.Read()) { ModulosHabitacionales ModuloHabitacional = new ModulosHabitacionales(); ModuloHabitacional.ModuloHabitacional = reader["ModuloHabitacional"].ToString(); ModuloHabitacional.Nombre = reader["Nombre"].ToString(); clsModuloHabitacionals.Add(ModuloHabitacional); } } return(clsModuloHabitacionals); }
//public ICollection<TiemposDeAlimentacion> GetTiempos() ICollection <TiemposDeAlimentacion> ITiemposDeAlimentacionRepository.GetTiempos() { //throw new NotImplementedException(); List <TiemposDeAlimentacion> tiemposDeAlimentacions = new List <TiemposDeAlimentacion>(); DatabaseProviderFactory databaseProviderFactory = new DatabaseProviderFactory(); Microsoft.Practices.EnterpriseLibrary.Data.Database database = databaseProviderFactory.Create("DefaultConnection"); using (IDataReader reader = database.ExecuteReader(CommandType.Text, "SELECT TiemposDeAlimentacionID,Nombre FROM TblTiemposDeAlimentacion --WHERE CAST(GETDATE() AS TIME) BETWEEN HoraInicial AND HoraFinal ")) { while (reader.Read()) { TiemposDeAlimentacion tiempos = new TiemposDeAlimentacion(); tiempos.TiempoDeAlimentacionID = (int)reader["TiemposDeAlimentacionID"]; tiempos.Nombre = reader["Nombre"].ToString(); tiemposDeAlimentacions.Add(tiempos); } } return(tiemposDeAlimentacions); }
/// <summary> /// Instanciates a FavouriteGroup object from the database via the FavouriteGroupID /// </summary> public FavouriteGroup(int FavouriteGroupID) { db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("AG_GetFavouriteGroupByFavouriteGroupID"); db.AddInParameter(dbCommand, "FavouriteGroupID", DbType.Int32, FavouriteGroupID); //execute the stored procedure using (IDataReader dr = db.ExecuteReader(dbCommand)) { ColumnFieldList list = new ColumnFieldList(dr); if (dr.Read()) { if (list.IsColumnPresent("FavouriteGroupID")) { this._favouriteGroupID = (int)dr["FavouriteGroupID"]; } if (list.IsColumnPresent("MemberID")) { this._memberID = (int)dr["MemberID"]; } if (list.IsColumnPresent("TheFavouriteGroupID")) { this._theFavouriteGroupID = (int)dr["TheFavouriteGroupID"]; } if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; } } else { throw new Exception("There is no FavouriteGroup in the database with the ID " + FavouriteGroupID); } dr.Close(); } }
public void Save(Database db) { DbCommand dbCommand = db.GetStoredProcCommand("AG_SaveEmailReferral"); db.AddInParameter(dbCommand, "EmailReferralID", DbType.Int32, EmailReferralID); db.AddInParameter(dbCommand, "NewMemberID", DbType.Int32, NewMemberID); db.AddInParameter(dbCommand, "Email", DbType.String, Email); db.AddInParameter(dbCommand, "DTCreated", DbType.DateTime, DTCreated); using (IDataReader dr = db.ExecuteReader(dbCommand)) { // get the returned ID if (dr.Read()) { int ID = Int32.Parse(dr[0].ToString()); //if the ID is NOT zero then the query was an insert if (ID != 0) this.EmailReferralID = ID; } dr.Close(); } }
public void Save(Database db) { DbCommand dbCommand = db.GetStoredProcCommand("AG_SaveFavourite"); db.AddInParameter(dbCommand, "FavouriteID", DbType.Int32, FavouriteID); db.AddInParameter(dbCommand, "MemberID", DbType.Int32, MemberID); db.AddInParameter(dbCommand, "TheFavouriteObjectID", DbType.Int32, TheFavouriteObjectID); db.AddInParameter(dbCommand, "ObjectType", DbType.Int32, ObjectType); db.AddInParameter(dbCommand, "DTCreated", DbType.DateTime, DTCreated); using (IDataReader dr = db.ExecuteReader(dbCommand)) { // get the returned ID if (dr.Read()) { int ID = Int32.Parse(dr[0].ToString()); //if the ID is NOT zero then the query was an insert if (ID != 0) this.FavouriteID = ID; } dr.Close(); } }
/// <summary> /// Instanciates a EmailReferral object from the database via the EmailReferralID /// </summary> public EmailReferral(int EmailReferralID) { db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("AG_GetEmailReferralByEmailReferralID"); db.AddInParameter(dbCommand, "EmailReferralID", DbType.Int32, EmailReferralID); //execute the stored procedure using (IDataReader dr = db.ExecuteReader(dbCommand)) { ColumnFieldList list = new ColumnFieldList(dr); if (dr.Read()) { if (list.IsColumnPresent("EmailReferralID")) { this._emailReferralID = (int)dr["EmailReferralID"]; } if (list.IsColumnPresent("NewMemberID")) { this._newMemberID = (int)dr["NewMemberID"]; } if (list.IsColumnPresent("Email")) { this._email = (string)dr["Email"]; } if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; } } else { throw new Exception("There is no EmailReferral in the database with the ID " + EmailReferralID); } dr.Close(); } }
/// <summary> /// Instanciates a Abuse object from the database via the AbuseID /// </summary> public Abuse(int AbuseID) { db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("AG_GetAbuseByAbuseID"); db.AddInParameter(dbCommand, "AbuseID", DbType.Int32, AbuseID); //execute the stored procedure using (IDataReader dr = db.ExecuteReader(dbCommand)) { ColumnFieldList list = new ColumnFieldList(dr); if (dr.Read()) { if (list.IsColumnPresent("AbuseID")) { this._abuseID = (int)dr["AbuseID"]; } if (list.IsColumnPresent("MemberID")) { this._memberID = (int)dr["MemberID"]; } if (list.IsColumnPresent("ResourceFileID")) { this._resourceFileID = (string)dr["ResourceFileID"]; } if (list.IsColumnPresent("URL")) { this._uRL = (string)dr["URL"]; } if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; } } else { throw new Exception("There is no Abuse in the database with the ID " + AbuseID); } dr.Close(); } }
/// <summary> /// Instanciates a AdminStatus object from the database via the AdminStatusID /// </summary> public AdminStatus(int AdminStatusID) { db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("AG_GetAdminStatusByAdminStatusID"); db.AddInParameter(dbCommand, "AdminStatusID", DbType.Int32, AdminStatusID); //execute the stored procedure using (IDataReader dr = db.ExecuteReader(dbCommand)) { ColumnFieldList list = new ColumnFieldList(dr); if (dr.Read()) { if (list.IsColumnPresent("AdminStatusID")) { this._adminStatusID = (int)dr["AdminStatusID"]; } if (list.IsColumnPresent("Description")) { this._description = (string)dr["Description"]; } } else { throw new Exception("There is no AdminStatus in the database with the ID " + AdminStatusID); } dr.Close(); } }
public void Save(Database db) { DbCommand dbCommand = db.GetStoredProcCommand("AG_SaveEmailMessage"); db.AddInParameter(dbCommand, "EmailMessageID", DbType.Int32, EmailMessageID); db.AddInParameter(dbCommand, "WebEmailMessageID", DbType.String, WebEmailMessageID); db.AddInParameter(dbCommand, "ResourceFileID", DbType.Int32, ResourceFileID); db.AddInParameter(dbCommand, "MemberID", DbType.Int32, MemberID); db.AddInParameter(dbCommand, "EmailAddress", DbType.String, EmailAddress); db.AddInParameter(dbCommand, "Text", DbType.String, Text); db.AddInParameter(dbCommand, "IsRead", DbType.Boolean, IsRead); db.AddInParameter(dbCommand, "DTCreated", DbType.DateTime, DTCreated); using (IDataReader dr = db.ExecuteReader(dbCommand)) { // get the returned ID if (dr.Read()) { int ID = Int32.Parse(dr[0].ToString()); //if the ID is NOT zero then the query was an insert if (ID != 0) this.EmailMessageID = ID; } dr.Close(); } }
public void AddUpdateAsset() //**********AddUpdateAsset********** //NAME : AddUpdateAsset //PURPOSE : This function is used to Add or update asset info. //PARAMETERS : //RETURN VALUE : void //USAGE : //CREATED ON : 16-04-2007 //CHANGE HISTORY :Auth Date Description //*********************************************************************** { try { XmlHttpHandler AssetDocs = new XmlHttpHandler(); string strproducts; string splitcharater; splitcharater = ","; string[] ProductArray; string PID; //string calendarSql; string strIncludeExclude; DataLibrary.Database oSiteWideDB = null; SqlDataReader assetDataReader = null; strproducts = Request.Form["products"]; ProductArray = strproducts.Split(splitcharater.ToCharArray()[0]); PID = AssetDocs.CreateModifyAsset(Convert.ToBoolean(Request.Form["isclone"]), Request.Form["assetpid"], Request.Form["title"], Request.Form["description"], Request.Form["Filename"], Request.Form["FileSize"], Convert.ToDateTime(Request.Form["begindate"]), ProductArray, Request.Form["language"], Request.Form["operation"], Request.Form["Category_Type"], Request.Form["oraclenumber"], Request.Form["access"], Request.Form["industry"], Request.Form["IncludeExclude"], Convert.ToBoolean(Request.Form["status"]), Request.Form["oldLanguage"], Request.Form["oldItemNumber"], Convert.ToInt64(Request.Form["AssetId"])); try { oSiteWideDB = DataLibrary.DatabaseFactory.CreateDatabase("FlukeSitewide"); assetDataReader = (SqlDataReader)oSiteWideDB.ExecuteReader(System.Data.CommandType.Text, "PCAT_FNET_ASSETCLONES_SEL " + Site_Id + "," + Request.Form["calendarId"].ToString()); } catch (Exception connectionEx) { if (ExceptionPolicy.HandleException(DanaherTM.Framework.ExceptionHandling.ExceptionInstance.FlukeNetworks.WebPages, connectionEx)) { //throw; } } if (assetDataReader != null) { while (assetDataReader.Read()) { if (assetDataReader.GetValue(16).ToString().StartsWith("0") == true) { strIncludeExclude = assetDataReader.GetValue(16).ToString(); } else if (assetDataReader.GetValue(16).ToString() == "none") { strIncludeExclude = "none"; } else { strIncludeExclude = "1" + assetDataReader.GetValue(16).ToString(); } XmlDocument xmlDomDocument = new XmlDocument(); string productId; xmlDomDocument.LoadXml(PID); productId = xmlDomDocument.DocumentElement.InnerText.ToString(); xmlDomDocument = null; string strFilePathName = ""; if (Convert.ToInt32(assetDataReader.GetValue(17)) <= 0) { strFilePathName = assetDataReader.GetValue(6).ToString(); if (strFilePathName.LastIndexOf(@"\") > 1) { strFilePathName = strFilePathName.Substring(strFilePathName.LastIndexOf(@"\") + 1); } if (strFilePathName.LastIndexOf("/") > 1) { strFilePathName = strFilePathName.Substring(strFilePathName.LastIndexOf("/") + 1); } PID = AssetDocs.CreateModifyAsset(Convert.ToBoolean(assetDataReader.GetValue(11)), productId, assetDataReader.GetValue(0).ToString(), assetDataReader.GetValue(4).ToString(), strFilePathName, assetDataReader.GetValue(7).ToString(), Convert.ToDateTime(assetDataReader.GetValue(8).ToString()), ProductArray, assetDataReader.GetValue(5).ToString(), "U", assetDataReader.GetValue(1).ToString(), assetDataReader.GetValue(14).ToString(), assetDataReader.GetValue(2).ToString(), Request.Form["industry"], strIncludeExclude, Convert.ToBoolean(Request.Form["status"]) , assetDataReader.GetValue(5).ToString(), assetDataReader.GetValue(14).ToString() , Convert.ToInt64(assetDataReader.GetValue(15))); } strIncludeExclude = ""; } } Response.ContentType = "text/xml"; Response.Charset = "utf-16"; Response.BinaryWrite(StringToBytes(PID)); AssetDocs = null; } catch (Exception ex) { if (ExceptionPolicy.HandleException(DanaherTM.Framework.ExceptionHandling.ExceptionInstance.FlukeNetworks.WebPages, ex)) { //throw; } } }
/// <summary> /// Instanciates a EmailMessage object from the database via the EmailMessageID /// </summary> public EmailMessage(int EmailMessageID) { db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("AG_GetEmailMessageByEmailMessageID"); db.AddInParameter(dbCommand, "EmailMessageID", DbType.Int32, EmailMessageID); //execute the stored procedure using (IDataReader dr = db.ExecuteReader(dbCommand)) { ColumnFieldList list = new ColumnFieldList(dr); if (dr.Read()) { if (list.IsColumnPresent("EmailMessageID")) { this._emailMessageID = (int)dr["EmailMessageID"]; } if (list.IsColumnPresent("WebEmailMessageID")) { this._webEmailMessageID = (string)dr["WebEmailMessageID"]; } if (list.IsColumnPresent("ResourceFileID")) { this._resourceFileID = (int)dr["ResourceFileID"]; } if (list.IsColumnPresent("MemberID")) { this._memberID = (int)dr["MemberID"]; } if (list.IsColumnPresent("EmailAddress")) { this._emailAddress = (string)dr["EmailAddress"]; } if (list.IsColumnPresent("Text")) { this._text = (string)dr["Text"]; } if (list.IsColumnPresent("IsRead")) { this._isRead = (bool)dr["IsRead"]; } if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; } } else { throw new Exception("There is no EmailMessage in the database with the ID " + EmailMessageID); } dr.Close(); } }
/*********************************************************************************************/ /// <summary> /// Generates XML file listing assets /// </summary> public static void GenerateXmlForAll() { string strAssetServer, strCategory, strFindItPath, strFilePath, strSecured; StreamWriter oListWriter; int intSiteId; strAssetServer = System.Configuration.ConfigurationSettings.AppSettings["AssetServer"]; strFindItPath = System.Configuration.ConfigurationSettings.AppSettings["FindItUrl"].Replace("&", "&"); intSiteId = Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings["SiteCodeID"]); strFilePath = System.Configuration.ConfigurationSettings.AppSettings["FilePath"]; DataLibrary.Database oSiteWideDB = null; oSiteWideDB = DataLibrary.DatabaseFactory.CreateDatabase("FlukeSitewide"); SqlDataReader sqlReader; //sqlReader =(SqlDataReader)oSiteWideDB.ExecuteReader(System.Data.CommandType.StoredProcedure, "FNET_AllAssets_Sel"); sqlReader = (SqlDataReader)oSiteWideDB.ExecuteReader(System.Data.CommandType.Text, "RTK_AllAssets_Sel " + intSiteId + ""); oListWriter = File.CreateText(strFilePath + "AssetDetails.xml"); oListWriter.WriteLine("<?xml version='1.0' encoding='UTF-8'?>"); oListWriter.WriteLine("<Assets>"); while (sqlReader.Read()) { //if(sqlReader["PCAT_ID"].ToString()!="-1") if (Convert.ToInt32(sqlReader["PCAT_ID"]) > 0) { try { //objProd = new Product(Convert.ToInt32(sqlReader["PCAT_ID"])); oListWriter.WriteLine(" <Asset"); oListWriter.WriteLine(" URI='" + strAssetServer + "/" + sqlReader["Site_Code"] + "/" + sqlReader["File_Name"] + "'>"); oListWriter.WriteLine(" <Title>"); oListWriter.WriteLine(sqlReader["Title"].ToString().Replace("&", "&")); oListWriter.WriteLine(" </Title>"); oListWriter.WriteLine(" <CrawlURI>"); oListWriter.WriteLine(strAssetServer + "/" + sqlReader["Site_Code"] + "/" + sqlReader["File_Name"]); oListWriter.WriteLine(" </CrawlURI>"); oListWriter.WriteLine(" <UserURI>"); oListWriter.WriteLine(strFindItPath + sqlReader["Item_Number"]); oListWriter.WriteLine(" </UserURI>"); oListWriter.WriteLine(" </Asset>"); } catch (Exception ex) { if (ExceptionPolicy.HandleException(DanaherTM.Framework.ExceptionHandling.ExceptionInstance.FlukeNetworks.WebPages, ex)) { //throw; Console.WriteLine("Unable to write files" + ex.Message); } } } } oListWriter.WriteLine("</Assets>"); oListWriter.Close(); sqlReader.Close(); }
/// <summary> /// Instanciates a FeaturedMember object from the database via the FeaturedMemberID /// </summary> public FeaturedMember(int FeaturedMemberID) { db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("AG_GetFeaturedMemberByFeaturedMemberID"); db.AddInParameter(dbCommand, "FeaturedMemberID", DbType.Int32, FeaturedMemberID); //execute the stored procedure using (IDataReader dr = db.ExecuteReader(dbCommand)) { ColumnFieldList list = new ColumnFieldList(dr); if (dr.Read()) { if (list.IsColumnPresent("FeaturedMemberID")) { this._featuredMemberID = (int)dr["FeaturedMemberID"]; } if (list.IsColumnPresent("MemberID")) { this._memberID = (int)dr["MemberID"]; } if (list.IsColumnPresent("Position")) { this._position = (int)dr["Position"]; } if (list.IsColumnPresent("IsDisplayed")) { this._isDisplayed = (bool)dr["IsDisplayed"]; } if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; } } else { throw new Exception("There is no FeaturedMember in the database with the ID " + FeaturedMemberID); } dr.Close(); } }
public void Save(Database db) { DbCommand dbCommand = db.GetStoredProcCommand("AG_SaveAdminStatus"); db.AddInParameter(dbCommand, "AdminStatusID", DbType.Int32, AdminStatusID); db.AddInParameter(dbCommand, "Description", DbType.String, Description); using (IDataReader dr = db.ExecuteReader(dbCommand)) { // get the returned ID if (dr.Read()) { int ID = Int32.Parse(dr[0].ToString()); //if the ID is NOT zero then the query was an insert if (ID != 0) this.AdminStatusID = ID; } dr.Close(); } }
public static void GenerateXmlForAll() { string sAssetServer, sCategory, sFindItPath, sFilePath, sSecured; StreamWriter oListWriter; int iSiteId; sAssetServer = System.Configuration.ConfigurationSettings.AppSettings["AssetServer"]; sFindItPath = System.Configuration.ConfigurationSettings.AppSettings["FindItUrl"].Replace("&", "&"); iSiteId = Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings["SiteCodeID"]); sFilePath = System.Configuration.ConfigurationSettings.AppSettings["FilePath"]; DataLibrary.Database oSiteWideDB = null; oSiteWideDB = DataLibrary.DatabaseFactory.CreateDatabase("FlukeSitewide"); SqlDataReader sqlReader; //sqlReader =(SqlDataReader)oSiteWideDB.ExecuteReader(System.Data.CommandType.StoredProcedure, "FNET_AllAssets_Sel"); sqlReader = (SqlDataReader)oSiteWideDB.ExecuteReader(System.Data.CommandType.Text, "FNET_AllAssets_Sel " + iSiteId + ""); oListWriter = File.CreateText(sFilePath + "AssetDetails.xml"); oListWriter.WriteLine("<?xml version='1.0' encoding='UTF-8'?>"); oListWriter.WriteLine("<Assets>"); while (sqlReader.Read()) { //if(sqlReader["PCAT_ID"].ToString()!="-1") if (Convert.ToInt32(sqlReader["PCAT_ID"]) > 0) { Product objProd; try { objProd = new Product(Convert.ToInt32(sqlReader["PCAT_ID"])); oListWriter.WriteLine(" <Asset"); oListWriter.WriteLine(" URI='" + sAssetServer + "/" + sqlReader["Site_Code"] + "/" + sqlReader["File_Name"] + "'>"); oListWriter.WriteLine(" <Title>"); oListWriter.WriteLine(sqlReader["Title"].ToString().Replace("&", "&")); oListWriter.WriteLine(" </Title>"); oListWriter.WriteLine(" <CrawlURI>"); oListWriter.WriteLine(sAssetServer + "/" + sqlReader["Site_Code"] + "/" + sqlReader["File_Name"]); oListWriter.WriteLine(" </CrawlURI>"); oListWriter.WriteLine(" <UserURI>"); oListWriter.WriteLine(sFindItPath + sqlReader["Item_Number"]); oListWriter.WriteLine(" </UserURI>"); if (objProd.ProductSubType == DanaherTM.ProductEngine.DBUtils.DataStructures.ProductSubTypes.Manual || objProd.ProductSubType == DanaherTM.ProductEngine.DBUtils.DataStructures.ProductSubTypes.AppNote || objProd.ProductSubType == DanaherTM.ProductEngine.DBUtils.DataStructures.ProductSubTypes.DataSheet || objProd.ProductSubType == DanaherTM.ProductEngine.DBUtils.DataStructures.ProductSubTypes.WhitePaper) { sCategory = "Technical"; } else if (objProd.ProductSubType == DanaherTM.ProductEngine.DBUtils.DataStructures.ProductSubTypes.Software) { sCategory = "Support"; } else if (objProd.ProductSubType == DanaherTM.ProductEngine.DBUtils.DataStructures.ProductSubTypes.VirtualDemo) { sCategory = "Products"; } else { sCategory = "Asset"; } oListWriter.WriteLine(" <MainCategory>"); oListWriter.WriteLine(sCategory); oListWriter.WriteLine(" </MainCategory>"); if (Convert.ToInt32(sqlReader["SubGroups"].ToString().IndexOf("nfre")) == -1) { sSecured = "yes"; } else { sSecured = "no"; } // oListWriter.WriteLine(" <Secured>"); oListWriter.WriteLine(sSecured); oListWriter.WriteLine(" </Secured>"); oListWriter.WriteLine(" </Asset>"); } catch (ProductEngineException ex) { if (ExceptionPolicy.HandleException(DanaherTM.Framework.ExceptionHandling.ExceptionInstance.FlukeNetworks.ProductEngine, ex)) { //throw; // Console.WriteLine("Unable to write files"); } } } } oListWriter.WriteLine("</Assets>"); oListWriter.Close(); sqlReader.Close(); }
//**********UploadExcelFile************************************************** //NAME : UploadExcelFile //PURPOSE : Uploading the data from calendar table and excel sheet into product catalog //PARAMETERS : IncludeExclude,Locale //RETURN VALUE : boolean //USAGE : //CREATED ON : 11-02-2006 //CHANGE HISTORY :Auth Date Description //*********************************************************************** public bool UploadExcelFile() { string sConnectionOleString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.AppDomain.CurrentDomain.BaseDirectory + "AssetData.xls;Extended Properties=Excel 8.0;"; OleDbDataReader assetOleDataReader = null; SqlDataReader assetDataReader = null; string strProducts = ""; string splitCharater; splitCharater = ","; string strMode = "A"; string sql = ""; string PID = ""; int iResult; DataLibrary.Database oSiteWideDB = null; OleDbConnection objOleConn = new OleDbConnection(sConnectionOleString); try { objOleConn.Open(); } catch (Exception Ex) { Console.WriteLine(Ex.Message); return(false); } sql = "select distinct Title,Category_ID,SubGroups,'' as Industry,calendar.Description,iso2,[File_Name]," + " File_Size,BDate,calendar.Code,'' ProductIds,Clone,File_Name_POD,Revision_Code,item_number,calendar.Id" + " from calendar,Language where site_id=82 and file_name is not null " + " and calendar.language=language.code " + " order by calendar.id"; try { //Create database object using enterprise library i.e(Dataconfig.config) oSiteWideDB = DataLibrary.DatabaseFactory.CreateDatabase("FlukeSitewide"); //Get the data reader for assets assetDataReader = (SqlDataReader)oSiteWideDB.ExecuteReader(System.Data.CommandType.Text, sql); } catch (Exception ex) { Console.Write("Unable to execute the reader"); } string[] productArray = null; string assetFilename; string assetPODName; string strcategory = ""; long lngpid = 0; string clonePID = ""; string strupdatequery = ""; while (assetDataReader.Read()) { assetFilename = assetDataReader.GetValue(6).ToString(); assetPODName = assetDataReader.GetValue(12).ToString(); fnWriteLog("Id = " + assetDataReader.GetValue(15).ToString() + "*******" + "\n", false); sql = "SELECT IndustryID,ProductID FROM [Sheet1$]" + " where Revision_Code='" + assetDataReader.GetValue(13).ToString() + "' and item_number=" + assetDataReader.GetValue(14).ToString(); OleDbCommand objCmdOleSelect = new OleDbCommand(sql, objOleConn); OleDbDataAdapter objOleAdapter = new OleDbDataAdapter(); objOleAdapter.SelectCommand = objCmdOleSelect; try { assetOleDataReader = objCmdOleSelect.ExecuteReader(); } catch (Exception ex) { //Console.Write("Row not found in excel sheet " + ex.Message + "\n"); fnWriteLog("Row not found in excel sheet " + "\n", false); } try { assetOleDataReader.Read(); try { strProducts = assetOleDataReader.GetValue(1).ToString(); if (strProducts.Length > 5) { //Console.WriteLine("Stop"); strProducts = strProducts.Substring(1, 0); } productArray = strProducts.Split(splitCharater.ToCharArray()[0]); if (assetOleDataReader.GetValue(0).ToString() == "1") { strcategory = "DCCA"; } else if (assetOleDataReader.GetValue(0).ToString() == "2") { strcategory = "INET"; } else if (assetOleDataReader.GetValue(0).ToString() == "3") { strcategory = "TELE"; } } catch (Exception Ex) { fnWriteLog("Product or Industry Id value not present for this row" + "\n", false); } clonePID = "0"; strMode = "A"; if (Convert.ToBoolean(assetDataReader.GetValue(11)) == true) { sql = "SELECT PID FROM calendar" + " where id=" + assetDataReader.GetValue(11).ToString(); SqlDataReader Clonedatareader = null; Clonedatareader = (SqlDataReader)oSiteWideDB.ExecuteReader(System.Data.CommandType.Text, sql); strMode = "U"; try { clonePID = Convert.ToString(Clonedatareader.GetValue(0)); Clonedatareader.Close(); Clonedatareader = null; } catch (Exception ex) { fnWriteLog("Parent Row not found for this asset " + "\n", false); } } PID = CreateModifyAsset(Convert.ToBoolean(assetDataReader.GetValue(11)), clonePID, assetDataReader.GetValue(0).ToString(), assetDataReader.GetValue(4).ToString(), assetFilename, assetDataReader.GetValue(7).ToString(), Convert.ToDateTime(assetDataReader.GetValue(8).ToString()), productArray, assetDataReader.GetValue(5).ToString(), strMode, assetDataReader.GetValue(1).ToString(), assetDataReader.GetValue(14).ToString(), assetDataReader.GetValue(2).ToString(), strcategory, "none"); assetOleDataReader.Close(); Console.Write("Id and PID = " + assetDataReader.GetValue(15).ToString() + " - " + PID + "\n"); fnWriteLog("Id and PID = " + assetDataReader.GetValue(15).ToString() + " - " + PID + "\n", false); XmlDocument objxml = new XmlDocument(); XmlNode objcol; objxml.LoadXml(PID); if (objxml != null) { objcol = objxml.SelectSingleNode("ProductId"); PID = objcol.InnerText; } try { lngpid = Convert.ToInt32(PID); PID = Convert.ToString(lngpid); } catch (Exception ex) { PID = "0"; fnWriteLog("Relationship no set " + "\n", false); } if (PID != "0") { strupdatequery = "update calendar set PID=" + PID + " where id=" + assetDataReader.GetValue(15).ToString(); iResult = (int)oSiteWideDB.ExecuteNonQuery(System.Data.CommandType.Text, strupdatequery); fnWriteLog(assetDataReader.GetValue(15).ToString() + "," + PID + "\n", false); } fnWriteLog("*******************" + "\n", false); } catch (Exception ex) { Console.WriteLine(ex.Message); } objCmdOleSelect = null; objOleAdapter = null; assetOleDataReader.Close(); } assetDataReader = null; return(true); }
public void Save(Database db) { DbCommand dbCommand = db.GetStoredProcCommand("AG_SaveFeaturedChannel"); db.AddInParameter(dbCommand, "FeaturedChannelID", DbType.Int32, FeaturedChannelID); db.AddInParameter(dbCommand, "Position", DbType.Int32, Position); db.AddInParameter(dbCommand, "ChannelID", DbType.Int32, ChannelID); using (IDataReader dr = db.ExecuteReader(dbCommand)) { // get the returned ID if (dr.Read()) { int ID = Int32.Parse(dr[0].ToString()); //if the ID is NOT zero then the query was an insert if (ID != 0) this.FeaturedChannelID = ID; } dr.Close(); } }
public void updateLocalizedtable() { SqlDataReader assetDataReader = null; DataLibrary.Database oSiteWideDB = null; StringBuilder strResult = new StringBuilder(""); string smtpServer = ""; string mailRecepients = ""; string fromUser = ""; string strProductId = ""; bool boolMailYn = true; smtpServer = System.Configuration.ConfigurationSettings.AppSettings.Get("SmtpServer"); mailRecepients = System.Configuration.ConfigurationSettings.AppSettings.Get("Recepients"); fromUser = System.Configuration.ConfigurationSettings.AppSettings.Get("From"); boolMailYn = Convert.ToBoolean(System.Configuration.ConfigurationSettings.AppSettings.Get("MailYN")); //Get the assets from sitewide DB try { //Create database object using enterprise library i.e(Dataconfig.config) oSiteWideDB = DataLibrary.DatabaseFactory.CreateDatabase("FlukeSitewide"); //Get the data reader for assets assetDataReader = (SqlDataReader)oSiteWideDB.ExecuteReader(System.Data.CommandType.StoredProcedure, "PCAT_FNET_SYNCASSETS"); //Update the products in product engine ArrayList localArray; while (assetDataReader.Read()) { localArray = GetLocales(assetDataReader.GetValue(0).ToString().Substring(0, 2)); try { Product ModifiedProduct = new Product(Convert.ToInt32(assetDataReader.GetValue(2).ToString())); strProductId = ModifiedProduct.ID.ToString(); foreach (string LangLocale in localArray) { try { ProductLocalized ModifiedLocalProduct = new ProductLocalized(ModifiedProduct, LangLocale); if (assetDataReader.GetValue(3).ToString() == "1") { ModifiedLocalProduct.StartDate = Convert.ToDateTime(assetDataReader.GetValue(4).ToString()); } else { ModifiedLocalProduct.StartDate = DanaherTM.ProductEngine.DBUtils.DataStructures.EndDate_Never; } ModifiedLocalProduct.Save(); strResult.Append("Asset Item Number=" + ModifiedLocalProduct.OraclePartNum + ":StartDate=" + ModifiedLocalProduct.StartDate + "\n"); } catch (ProductEngineException ex) { if (ExceptionPolicy.HandleException(DanaherTM.Framework.ExceptionHandling.ExceptionInstance.FlukeNetworks.ProductEngine, ex)) { strResult.Append("Product Id=" + ModifiedProduct.ID + ":Error occurred" + "\n"); } } catch (Exception ex) { if (ExceptionPolicy.HandleException(DanaherTM.Framework.ExceptionHandling.ExceptionInstance.FlukeNetworks.WebPages, ex)) { strResult.Append("Product Id=" + ModifiedProduct.ID + ":Error occurred" + "\n"); } } } } catch (ProductEngineException ex) { if (ExceptionPolicy.HandleException(DanaherTM.Framework.ExceptionHandling.ExceptionInstance.FlukeNetworks.ProductEngine, ex)) { strResult.Append("Product Id=" + strProductId + ":Error occurred" + "\n"); } } catch (Exception ex) { if (ExceptionPolicy.HandleException(DanaherTM.Framework.ExceptionHandling.ExceptionInstance.FlukeNetworks.WebPages, ex)) { strResult.Append("Product Id=" + strProductId + ":Error occurred" + "\n"); } } } //Dispose the unused objects assetDataReader.Close(); assetDataReader = null; oSiteWideDB = null; if (boolMailYn == true) { SendEmail(mailRecepients, "Synchronization:Process completed successfully-" + DateTime.Now.ToString(), strResult.ToString(), smtpServer, fromUser, ""); } } catch (Exception ex) { try { if (ExceptionPolicy.HandleException(DanaherTM.Framework.ExceptionHandling.ExceptionInstance.FlukeNetworks.WebPages, ex)) { SendEmail(mailRecepients, "Synchronization:Error occurred while processing.-" + ex.Message + DateTime.Now.ToString(), strResult.ToString(), smtpServer, fromUser, ""); } } catch (Exception LoggingException) { SendEmail(mailRecepients, "Synchronization:Error occurred while processing.-" + LoggingException.Message + DateTime.Now.ToString(), strResult.ToString(), smtpServer, fromUser, ""); } } }
public void Save(Database db) { DbCommand dbCommand = db.GetStoredProcCommand("AG_SaveFeaturedMember"); db.AddInParameter(dbCommand, "FeaturedMemberID", DbType.Int32, FeaturedMemberID); db.AddInParameter(dbCommand, "MemberID", DbType.Int32, MemberID); db.AddInParameter(dbCommand, "Position", DbType.Int32, Position); db.AddInParameter(dbCommand, "IsDisplayed", DbType.Boolean, IsDisplayed); db.AddInParameter(dbCommand, "DTCreated", DbType.DateTime, DTCreated); using (IDataReader dr = db.ExecuteReader(dbCommand)) { // get the returned ID if (dr.Read()) { int ID = Int32.Parse(dr[0].ToString()); //if the ID is NOT zero then the query was an insert if (ID != 0) this.FeaturedMemberID = ID; } dr.Close(); } }
/// <summary> /// Calls the database and gets all the CommunityView objects for this AdminStatus /// </summary> private List<CommunityView> GetCommunityViewByAdminStatusID() { db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("AG_GetCommunityViewByAdminStatusID"); db.AddInParameter(dbCommand, "AdminStatusID", DbType.Int32, AdminStatusID); List<CommunityView> arr = null; // Populate the datareader using (IDataReader dr = db.ExecuteReader(dbCommand)) { // Call the PopulateObject method passing the datareader to return the object array arr = Next2Friends.Data.CommunityView.PopulateObject(dr); dr.Close(); } return arr; }
/// <summary> /// Instanciates a Feedback object from the database via the FeedbackID /// </summary> public Feedback(int FeedbackID) { db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("AG_GetFeedbackByFeedbackID"); db.AddInParameter(dbCommand, "FeedbackID", DbType.Int32, FeedbackID); //execute the stored procedure using (IDataReader dr = db.ExecuteReader(dbCommand)) { ColumnFieldList list = new ColumnFieldList(dr); if (dr.Read()) { if (list.IsColumnPresent("FeedbackID")) { this._feedbackID = (int)dr["FeedbackID"]; } if (list.IsColumnPresent("MemberID")) { this._memberID = (int)dr["MemberID"]; } if (list.IsColumnPresent("Name")) { this._name = (string)dr["Name"]; } if (list.IsColumnPresent("EmailAddress")) { this._emailAddress = (string)dr["EmailAddress"]; } if (list.IsColumnPresent("Text")) { this._text = (string)dr["Text"]; } if (list.IsColumnPresent("DTCreated")) { this._dTCreated = (DateTime)dr["DTCreated"]; } } else { throw new Exception("There is no Feedback in the database with the ID " + FeedbackID); } dr.Close(); } }
/// <summary> /// Update SAS_ExportData Data... /// <summary> /// <param name=sender></param> /// <param name= e></param> public bool Update(ExportDataEN argEn) { bool lbRes = false; int iOut = 0; string sqlCmd = "Select count(*) as cnt From SAS_ExportData WHERE InterfaceID = '" + argEn.InterfaceID + "'"; try { Microsoft.Practices.EnterpriseLibrary.Data.Database loDbSel = DatabaseFactory.CreateDatabase(csConnectionStr); using (DbCommand cmdSel = loDbSel.GetSqlStringCommand(sqlCmd)) { using (IDataReader dr = loDbSel.ExecuteReader(cmdSel)) { if (dr.Read()) { iOut = GetValue <int>(dr, "cnt"); } if (iOut < 0) { throw new Exception("Update Failed! No Record Exist!"); } } if (iOut != 0) { sqlCmd = "UPDATE SAS_ExportData SET InterfaceID = @InterfaceID, FileFormat = @FileFormat, Interface = @Interface, Frequency = @Frequency, TimeofExport = @TimeofExport, Filepath = @Filepath, PreviousData = @PreviousData,DateRange = @DateRange, DateFrom = @DateFrom, DateTo = @DateTo, LastUpdatedBy = @LastUpdatedBy, LastUpdatedDateTime = @LastUpdatedDateTime WHERE InterfaceID = @InterfaceID"; Microsoft.Practices.EnterpriseLibrary.Data.Database loDbUpd = DatabaseFactory.CreateDatabase(csConnectionStr); using (DbCommand cmd = loDbUpd.GetSqlStringCommand(sqlCmd)) { loDbUpd.AddInParameter(cmd, "@InterfaceID", DbType.String, argEn.InterfaceID); loDbUpd.AddInParameter(cmd, "@FileFormat", DbType.String, argEn.FileFormat); loDbUpd.AddInParameter(cmd, "@Interface", DbType.String, argEn.Interface); loDbUpd.AddInParameter(cmd, "@Frequency", DbType.String, argEn.Frequency); loDbUpd.AddInParameter(cmd, "@TimeofExport", DbType.String, argEn.TimeofExport); loDbUpd.AddInParameter(cmd, "@Filepath", DbType.String, argEn.Filepath); loDbUpd.AddInParameter(cmd, "@PreviousData", DbType.Boolean, argEn.PreviousData); loDbUpd.AddInParameter(cmd, "@DateRange", DbType.Boolean, argEn.DateRange); loDbUpd.AddInParameter(cmd, "@DateFrom", DbType.DateTime, argEn.DateFrom); loDbUpd.AddInParameter(cmd, "@DateTo", DbType.DateTime, argEn.DateTo); loDbUpd.AddInParameter(cmd, "@LastUpdatedBy", DbType.String, argEn.LastUpdatedBy); loDbUpd.AddInParameter(cmd, "@LastUpdatedDateTime", DbType.DateTime, argEn.LastUpdatedDateTime); int liRowAffected = loDbUpd.ExecuteNonQuery(cmd); if (liRowAffected > -1) { System.Messaging.Message mm = new System.Messaging.Message(argEn, new System.Messaging.XmlMessageFormatter(new Type[] { typeof(ExportDataEN), typeof(string) })); mm.Label = argEn.InterfaceID; MessageQueueTransaction Transaction = new MessageQueueTransaction(); Transaction.Begin(); mq.Send(mm, Transaction); Transaction.Commit(); lbRes = true; } else { throw new Exception("Update Failed! No Row has been updated..."); } } } } } catch (Exception ex) { throw ex; } return(lbRes); }