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