public InfoFileCaching[] ricercaDocumemtoInCache(string aggiornato, string idAmministrazione)
{
System.Collections.Generic.List <InfoFileCaching> list = new System.Collections.Generic.List <InfoFileCaching>();
DocsPaUtils.Query queryDef = DocsPaUtils.InitQuery.getInstance().getQuery("S_CACHE");
queryDef.setParam("idAmministrazione", "'" + idAmministrazione + "'");
queryDef.setParam("aggiornato", aggiornato);
logger.Debug("ricercaDocumemtoInCache - query: " + queryDef.getSQL());
string commandText = queryDef.getSQL();
using (DocsPaDB.DBProvider dbProvider = new DocsPaDB.DBProvider())
{
using (System.Data.IDataReader reader = dbProvider.ExecuteReader(commandText))
{
if (reader != null)
{
while (reader.Read())
{
InfoFileCaching info = new InfoFileCaching();
info.Aggiornato = reader.GetInt32(reader.GetOrdinal("AGGIORNATO"));
info.CacheFilePath = reader.GetString(reader.GetOrdinal("PATHCACHE"));
info.DocNumber = reader.GetInt32(reader.GetOrdinal("DOCNUMBER"));
info.file_size = reader.GetInt32(reader.GetOrdinal("FILE_SIZE"));
info.idAmministrazione = reader.GetString(reader.GetOrdinal("idAmministrazione"));
info.Version_id = reader.GetInt32(reader.GetOrdinal("VERSION_ID"));
list.Add(info);
}
}
}
}
return(list.ToArray());
}
private void GetPasswordWithFormat(string username, bool updateLastLoginActivityDate, out int status, out string password, out int passwordFormat, out string passwordSalt, out int failedPasswordAttemptCount, out int failedPasswordAnswerAttemptCount, out bool isApproved, out DateTime lastLoginDate, out DateTime lastActivityDate)
{
password = null;
passwordFormat = 0;
passwordSalt = null;
failedPasswordAttemptCount = 0;
failedPasswordAnswerAttemptCount = 0;
isApproved = false;
lastLoginDate = DateTime.Now;
lastActivityDate = DateTime.Now;
status = -1;
System.Data.Common.DbCommand storedProcCommand = this.database.GetStoredProcCommand("aspnet_Membership_GetPasswordWithFormat");
this.database.AddInParameter(storedProcCommand, "UserName", System.Data.DbType.String, username);
this.database.AddInParameter(storedProcCommand, "UpdateLastLoginActivityDate", System.Data.DbType.Boolean, updateLastLoginActivityDate);
this.database.AddInParameter(storedProcCommand, "CurrentTime", System.Data.DbType.DateTime, DateTime.Now);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(storedProcCommand))
{
if (dataReader.Read())
{
password = dataReader.GetString(0);
passwordFormat = dataReader.GetInt32(1);
passwordSalt = dataReader.GetString(2);
failedPasswordAttemptCount = dataReader.GetInt32(3);
failedPasswordAnswerAttemptCount = dataReader.GetInt32(4);
isApproved = dataReader.GetBoolean(5);
lastLoginDate = dataReader.GetDateTime(6);
lastActivityDate = dataReader.GetDateTime(7);
status = 0;
}
}
}
public DocsPaVO.Caching.InfoFileCaching massimaVersioneDelDocumentoComponents(string docnumber)
{
DocsPaVO.Caching.InfoFileCaching info = null;
DocsPaUtils.Query sql = DocsPaUtils.InitQuery.getInstance().getQuery("S_CACHE_MAX_VESIONE_COMPONENTS");
sql.setParam("docnumber", docnumber.ToString());
logger.Debug("massimaVersioneDelDocumentoComponents - query:" + sql.getSQL());
using (DocsPaDB.DBProvider dbProvider = new DocsPaDB.DBProvider())
{
using (System.Data.IDataReader reader = dbProvider.ExecuteReader(sql.getSQL()))
{
if (reader != null)
{
while (reader.Read())
{
info = new InfoFileCaching();
info.CacheFilePath = reader.GetString(reader.GetOrdinal("pathcache"));
info.ext = reader.GetString(reader.GetOrdinal("ext"));
info.Version_id = reader.GetInt32(reader.GetOrdinal("version_id"));
}
}
}
}
return(info);
}
public static IEnumerable <ZipCountyView> GetZipCodesAndCountyFIPSForState(string StateFIPS)
{
List <ZipCountyView> ZipCodesAndCounties = new List <ZipCountyView>();
System.Data.IDataReader reader = LookupDAL.GetZipCodeForStateFips(StateFIPS);
//string CountyFIPS = string.Empty;
while (reader.Read())
{
ZipCodesAndCounties.Add(new ZipCountyView(reader.GetString(0), reader.GetString(1), reader.GetString(2)));
}
return(ZipCodesAndCounties);
}
/// <summary>
///
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public DocsPaVO.utente.InfoUtente ricercaInfoutente(string userId)
{
DocsPaVO.utente.InfoUtente utente = null;
DocsPaUtils.Query q = DocsPaUtils.InitQuery.getInstance().getQuery("S_INFOUTENTE");
q.setParam("user_id", "'" + userId + "'");
logger.Debug("ricercaInfoutente - query: " + q.getSQL());
using (DocsPaDB.DBProvider dbProvider = new DocsPaDB.DBProvider())
{
using (System.Data.IDataReader reader = dbProvider.ExecuteReader(q.getSQL()))
{
if (reader != null)
{
while (reader.Read())
{
utente = new DocsPaVO.utente.InfoUtente();
utente.idGruppo = reader.GetInt32(reader.GetOrdinal("GROUPS_SYSTEM_ID")).ToString();
utente.idPeople = reader.GetInt32(reader.GetOrdinal("system_id")).ToString();
utente.userId = reader.GetString(reader.GetOrdinal("user_id"));
utente.idAmministrazione = reader.GetInt32(reader.GetOrdinal("ID_AMM")).ToString();
}
}
}
}
return(utente);
}
public string recuperaPathComponents(string docnumber, string version_id)
{
string path = null;//string.Empty;
DocsPaUtils.Query sql = DocsPaUtils.InitQuery.getInstance().getQuery("S_COMPONENTS_FILE");
sql.setParam("docnumber", docnumber);
sql.setParam("version_id", version_id);
logger.Debug("recuperaPathComponents - query: " + sql.getSQL());
using (DocsPaDB.DBProvider dbProvider = new DocsPaDB.DBProvider())
{
using (System.Data.IDataReader reader = dbProvider.ExecuteReader(sql.getSQL()))
{
if (reader != null)
{
while (reader.Read())
{
path = reader.GetString(reader.GetOrdinal("PATH")).ToString();
}
}
}
}
if (path == null)
{
path = string.Empty;
}
return(path);
}
public override IList <string> GetPrivilegesForUser(string userName)
{
IList <string> result;
if (string.IsNullOrEmpty(userName))
{
result = new List <string>();
}
else
{
IList <string> list = new List <string>();
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT DISTINCT pm.PrivilegeENName FROM dbo.aspnet_Roles r INNER JOIN dbo.aspnet_UsersInRoles ur ON r.RoleId = ur.RoleId INNER JOIN dbo.Ecshop_PrivilegeInRoles pr ON pr.RoleId = r.RoleId JOIN dbo.Ecshop_PrivilegeMenu pm ON pr.Privilege=pm.PrivilegeId WHERE ur.UserId = (SELECT UserId FROM dbo.aspnet_Users WHERE LoweredUserName = LOWER(@UserName))");
this.database.AddInParameter(sqlStringCommand, "UserName", System.Data.DbType.String, userName);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
list.Add(dataReader.GetString(0));
}
dataReader.Close();
}
result = list;
}
return(result);
}
public static KVPairCollection GetAllShippingMethods()
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand cw = db.GetStoredProcCommand("sp_NCIPL_GetAllShippingMethods");
using (System.Data.IDataReader dr = db.ExecuteReader(cw))
{
KVPairCollection coll = new KVPairCollection();
while (dr.Read())
{
KVPair k = new KVPair((string)dr.GetString(0), (string)dr.GetString(1));
coll.Add(k);
}
return(coll);
}
}
public void GetImpronta(out string impronta, string versionId, string docNumber, string idAmministrazione)
{
impronta = "";
try
{
DocsPaUtils.Query q = DocsPaUtils.InitQuery.getInstance().getQuery("S_CACHE_ALL");
q.setParam("docnumber", docNumber);
q.setParam("idAmministrazione", "'" + idAmministrazione + "'");
q.setParam("version_id", versionId);
string queryString = q.getSQL();
logger.Debug("GetImpronta - query :" + queryString);
using (DocsPaDB.DBProvider dbProvider = new DocsPaDB.DBProvider())
{
using (System.Data.IDataReader reader = dbProvider.ExecuteReader(queryString))
{
if (reader != null)
{
while (reader.Read())
{
impronta = reader.GetString(reader.GetOrdinal("VAR_IMPRONTA"));
}
}
}
}
}
catch (Exception e)
{
logger.Debug("GetImpronta - errore: " + e.Message);
}
finally
{
this.CloseConnection();
}
}
private Model.hierarchy3a GetInstance(System.Data.IDataReader result, System.Collections.Generic.IDictionary <string, int> ordinals)
{
var obj = new Model.hierarchy3a()
{
pid = result.IsDBNull(ordinals["pid"]) ? new Guid() : result.GetGuid(ordinals["pid"]),
fid = result.IsDBNull(ordinals["fid"]) ? 0 : result.GetInt64(ordinals["fid"]),
uid = result.IsDBNull(ordinals["uid"]) ? new Guid() : result.GetGuid(ordinals["uid"]),
numfield1 = result.IsDBNull(ordinals["numfield1"]) ? 0 : result.GetInt32(ordinals["numfield1"]),
numfield2 = result.IsDBNull(ordinals["numfield2"]) ? 0 : result.GetInt32(ordinals["numfield2"]),
numfield3 = result.IsDBNull(ordinals["numfield3"]) ? 0 : result.GetInt32(ordinals["numfield3"]),
textfield1 = result.IsDBNull(ordinals["textfield1"]) ? null : result.GetString(ordinals["textfield1"]),
textfield2 = result.IsDBNull(ordinals["textfield2"]) ? null : result.GetString(ordinals["textfield2"]),
textfield3 = result.IsDBNull(ordinals["textfield3"]) ? null : result.GetString(ordinals["textfield3"])
};
return(obj);
}
public CacheConfig getConfigurazioneCache(string idAmministrazione)
{
CacheConfig info = null;
DocsPaUtils.Query queryDef = DocsPaUtils.InitQuery.getInstance().getQuery("S_CONFIG_CACHE");
queryDef.setParam("idAmministrazione", "'" + idAmministrazione + "'");
logger.Debug("getConfigurazioneCache - query :" + queryDef.getSQL());
string commandText = queryDef.getSQL();
using (DocsPaDB.DBProvider dbProvider = new DocsPaDB.DBProvider())
{
using (System.Data.IDataReader reader = dbProvider.ExecuteReader(commandText))
{
if (reader != null)
{
while (reader.Read())
{
info = new CacheConfig();
info.caching = reader.GetInt32(reader.GetOrdinal("CACHING")) == 1 ? true : false;
info.doc_root_server = reader.GetString(reader.GetOrdinal("DOC_ROOT_SERVER"));
info.massima_dimensione_caching = reader.GetDouble(reader.GetOrdinal("MASSIMA_DIMENSIONE_CACHING"));
info.massima_dimensione_file = reader.GetDouble(reader.GetOrdinal("MASSIMA_DIMENSIONE_FILE"));
info.idAmministrazione = reader.GetString(reader.GetOrdinal("idAmministrazione"));
info.ora_fine_cache = reader.GetString(reader.GetOrdinal("ORA_FINE_CACHE"));
info.ora_inizio_cache = reader.GetString(reader.GetOrdinal("ORA_INIZIO_CACHE"));
info.urlwscaching = reader.GetString(reader.GetOrdinal("urlwscaching"));
info.url_ws_caching_locale = reader.GetString(reader.GetOrdinal("url_ws_caching_locale"));
info.doc_root_server_locale = reader.GetString(reader.GetOrdinal("doc_root_server_locale"));
}
}
}
}
return(info);
}
///*******************************************************************************
///NOMBRE DE LA FUNCIÓN : Consultar_Detalles_Menu
///DESCRIPCIÓN : Regresa un objeto con los datos de un Menu.
///PARAMETROS : Parametros: Contiene los criterios para la busqueda.
///CREO : Salvador Vázquez Camacho
///FECHA_CREO : 12/Enero/2013
///MODIFICO :
///FECHA_MODIFICO :
///CAUSA_MODIFICACIÓN :
///*******************************************************************************
public static Cls_Cat_Menus_Negocio Consultar_Detalles_Menu(Cls_Cat_Menus_Negocio Parametros)
{
StringBuilder Mi_SQL;
Cls_Cat_Menus_Negocio Contrato = new Cls_Cat_Menus_Negocio();
Conexion.Iniciar_Helper();
Conexion.HelperGenerico.Conexion_y_Apertura();
Mi_SQL = new StringBuilder();
Mi_SQL.Append("SELECT * FROM " + Cat_Menus.Tabla_Cat_Menus);
Mi_SQL.Append(" WHERE " + Cat_Menus.Campo_Menu_Id + " = '" + Parametros.P_Menu_Id + "'");
System.Data.IDataReader Dr_Menu = (System.Data.IDataReader)Conexion.HelperGenerico.Obtener_Data_Reader(Mi_SQL.ToString());
while (Dr_Menu.Read())
{
Contrato.P_Menu_Id = Dr_Menu.IsDBNull(0) ? "" : Dr_Menu.GetString(0);
Contrato.P_Parent_Id = Dr_Menu.IsDBNull(1) ? "" : Dr_Menu.GetString(1);
Contrato.P_Menu_Descripcion = Dr_Menu.IsDBNull(2) ? "" : Dr_Menu.GetString(2);
Contrato.P_Url_Link = Dr_Menu.IsDBNull(3) ? "" : Dr_Menu.GetString(3);
Contrato.P_Nombre_Menu = Dr_Menu.IsDBNull(4) ? "" : Dr_Menu.GetString(4);
Contrato.P_Orden = Dr_Menu.IsDBNull(5) ? "" : Dr_Menu.GetString(5);
Contrato.P_Estatus = Dr_Menu.IsDBNull(6) ? "" : Dr_Menu.GetString(6);
}
Conexion.HelperGenerico.Cerrar_Conexion();
return(Contrato);
}
public static void Main()
{
SQLRelayConnection sqlrcon = new SQLRelayConnection("Data Source=sqlrserver:9000;User ID=user;Password=password;Retry Time=0;Tries=1;Debug=false");
sqlrcon.Open();
SQLRelayCommand sqlrcom = (SQLRelayComand)sqlrcon.CreateCommand();
sqlrcom.CommandText = "select col1,col2 from exampletable";
try
{
System.Data.IDataReader datareader = sqlrcom.ExecuteReader();
// read row...
datareader.Read();
// get the raw data of the first field in a variety of ways
Object o1 = datareader.GetValue(0);
o1 = datareader[0];
o1 = datareader.GetValue(datareader.GetOrdinal("col1"));
o1 = datareader["col1"];
Object[] os1 = datareader.GetValues();
o1 = os1[0];
// get the first field as a string
String s1 = datareader.GetString(0);
// get the raw data of the second field in a variety of ways
Object o2 = datareader.GetValue(1);
o2 = datareader[1];
o2 = datareader.GetValue(datareader.GetOrdinal("col2"));
o2 = datareader["col2"];
Object[] os2 = datareader.GetValues();
o2 = os2[1];
// get the second field as a string
String s2 = datareader.GetString(1);
// read another row...
datareader.Read();
... do something with this row ...
... fetch more rows ...
}
public static EMS.Entities.MyProfileMDL GetProfileDetails(int UserId, int BusinessId)
{
EMS.Entities.MyProfileMDL user = new EMS.Entities.MyProfileMDL();
using (DBSqlCommand cmd = new DBSqlCommand())
{
try
{
cmd.AddParameters(UserId, CommonConstants.UserId, System.Data.SqlDbType.Int);
cmd.AddParameters(BusinessId, CommonConstants.BusinessID, System.Data.SqlDbType.Int);
System.Data.IDataReader ireader = cmd.ExecuteDataReader(SqlProcedures.Get_MyAccountDetails);
while (ireader.Read())
{
var userDet = new EMS.Entities.MyProfileMDL
{
UserFirstName = ireader.GetString(CommonColumns.FirstName),
UserLastName = ireader.GetString(CommonColumns.LastName),
Email = ireader.GetString(CommonColumns.UserEmail),
Fax = ireader.GetString(CommonColumns.BusinessFax),
AddressLine1 = ireader.GetString(CommonColumns.UserAddressLine1),
City = ireader.GetString(CommonColumns.City),
State = ireader.GetString(CommonColumns.State),
Country = ireader.GetString(CommonColumns.Country),
//RenewalDate = ireader.GetDateTime(CommonColumns.UserAccountExpiryDate),
Licences = ireader.GetInt16(CommonColumns.Licences),
BusinessName = ireader.GetString(CommonColumns.BusinessName),
LogMeOutId = ireader.GetInt32(CommonColumns.LogMeOutId),
EndDate = ireader.GetNullLocalDateTime(CommonColumns.UserAccountExpiryDate),
CityId = ireader.GetInt32(CommonColumns.CityId),
StateId = ireader.GetInt32(CommonColumns.StateId),
CountryId = ireader.GetInt16(CommonColumns.CountryId),
ImagePath = ireader.GetString(CommonColumns.ImagePath)
};
user = userDet;
}
return(user);
}
catch (Exception ex)
{
return(null);
}
}
}
private void GetPasswordWithFormat(string tableName, string username, out bool success, out int passwordFormat, out string passwordSalt, out string passwordFromDb)
{
passwordFormat = 0;
passwordSalt = null;
passwordFromDb = null;
success = false;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT biz.TradePasswordFormat, biz.TradePasswordSalt, biz.TradePassword FROM " + tableName + " AS biz INNER JOIN aspnet_Users AS u ON biz.UserId = u.UserId WHERE u.LoweredUserName = LOWER(@Username)");
this.database.AddInParameter(sqlStringCommand, "Username", System.Data.DbType.String, username);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
passwordFormat = dataReader.GetInt32(0);
passwordSalt = dataReader.GetString(1);
passwordFromDb = dataReader.GetString(2);
success = true;
}
}
}
public string PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, string Atributo)
{
if ((lDataReader.IsDBNull(NumeroColuna) == true))
{
return(null);
}
else
{
return(lDataReader.GetString(NumeroColuna));
}
}
public char PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, char Atributo)
{
if ((lDataReader.IsDBNull(NumeroColuna) == true))
{
return(char.MinValue);
}
else
{
return(Convert.ToChar(lDataReader.GetString(NumeroColuna)));
}
}
public InfoFileCaching getFileComponents(string docnumber, string version_id, string idAmministrazione)
{
InfoFileCaching info = null;
DocsPaUtils.Query q = DocsPaUtils.InitQuery.getInstance().getQuery("S_COMPONENTS_FILE");
q.setParam("docnumber", docnumber);
q.setParam("idAmministrazione", "'" + idAmministrazione + "'");
q.setParam("version_id", version_id);
string queryString = q.getSQL();
logger.Debug("getFileComponents - query: " + queryString);
using (DocsPaDB.DBProvider dbProvider = new DocsPaDB.DBProvider())
{
using (System.Data.IDataReader reader = dbProvider.ExecuteReader(queryString))
{
if (reader != null)
{
while (reader.Read())
{
info = new InfoFileCaching();
info.alternate_path = reader.GetString(reader.GetOrdinal("ALTERNATE_PATH"));
info.CacheFilePath = reader.GetString(reader.GetOrdinal("PATH"));
info.comptype = reader.GetString(reader.GetOrdinal("COMPTYPE"));
info.DocNumber = reader.GetInt32(reader.GetOrdinal("DOCNUMBER"));
info.ext = reader.GetString(reader.GetOrdinal("EXT"));
info.var_impronta = reader.GetString(reader.GetOrdinal("VAR_IMPRONTA"));
info.file_size = reader.GetInt32(reader.GetOrdinal("FILE_SIZE"));
info.locked = int.Parse(reader.GetString(reader.GetOrdinal("LOCKED")));
info.Version_id = reader.GetInt32(reader.GetOrdinal("VERSION_ID"));
}
}
}
}
return(info);
}
public static void Main()
{
SQLRelayConnection sqlrcon = new SQLRelayConnection("Data Source=sqlrserver:9000;User ID=user;Password=password;Retry Time=0;Tries=1;Debug=false");
sqlrcon.Open();
SQLRelayCommand sqlrcom1 = (SQLRelayComand)sqlrcon.CreateCommand();
sqlrcom1.CommandText = "select * from my_first_table";
SQLRelayCommand sqlrcom2 = (SQLRelayComand)sqlrcon.CreateCommand();
sqlrcom2.CommandText = "insert into my_second_table values (:col1, :col2, :col3)";
try
{
System.Data.IDataReader datareader = sqlrcom1.ExecuteReader();
while (datareader.Read())
{
sqlrcom2.Parameters.Clear();
sqlrcom2.Parameters.Add("col1", datareader.GetString(0));
sqlrcom2.Parameters.Add("col2", datareader.GetString(1));
sqlrcom2.Parameters.Add("col3", datareader.GetString(2));
try
{
sqlrcom2.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public override IList <string> GetConfigedTypes()
{
IList <string> list = new List <string>();
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT OpenIdType FROM aspnet_OpenIdSettings");
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
list.Add(dataReader.GetString(0));
}
}
return(list);
}
public override IList <string> GetConfigedTypes()
{
IList <string> list = new List <string>();
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT OpenIdType FROM distro_OpenIdSettings WHERE UserId=@UserId");
this.database.AddInParameter(sqlStringCommand, "UserId", System.Data.DbType.Int32, HiContext.Current.User.UserId);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
list.Add(dataReader.GetString(0).ToLower());
}
}
return(list);
}
///*******************************************************************************
///NOMBRE DE LA FUNCIÓN : Consultar_Detalles_Rol
///DESCRIPCIÓN : Regresa un objeto con los datos de un Rol.
///PARAMETROS : Parametros: Contiene los criterios para la busqueda.
///CREO : Salvador Vázquez Camacho
///FECHA_CREO : 12/Enero/2013
///MODIFICO :
///FECHA_MODIFICO :
///CAUSA_MODIFICACIÓN :
///*******************************************************************************
public static Cls_Apl_Roles_Negocio Consultar_Detalles_Rol(Cls_Apl_Roles_Negocio Parametros)
{
StringBuilder Mi_SQL;
Cls_Apl_Roles_Negocio Contrato = new Cls_Apl_Roles_Negocio();
Conexion.Iniciar_Helper();
Conexion.HelperGenerico.Conexion_y_Apertura();
Mi_SQL = new StringBuilder();
Mi_SQL.Append("SELECT * FROM " + Apl_Roles.Tabla_Apl_Roles);
Mi_SQL.Append(" WHERE " + Apl_Roles.Campo_Rol_Id + " = '" + Parametros.P_Rol_Id + "'");
System.Data.IDataReader Dr_Rol = (System.Data.IDataReader)Conexion.HelperGenerico.Obtener_Data_Reader(Mi_SQL.ToString());
while (Dr_Rol.Read())
{
Contrato.P_Rol_Id = Dr_Rol.IsDBNull(0) ? "" : Dr_Rol.GetString(0);
Contrato.P_Nombre = Dr_Rol.IsDBNull(1) ? "" : Dr_Rol.GetString(1);
Contrato.P_Descripcion = Dr_Rol.IsDBNull(2) ? "" : Dr_Rol.GetString(2);
Contrato.P_Estatus = Dr_Rol.IsDBNull(3) ? "" : Dr_Rol.GetString(3);
}
Conexion.HelperGenerico.Cerrar_Conexion();
return(Contrato);
}
//*********************************************************************
//
// Generate Collection Methods
//
// The following methods are used to generate collections of objects
//[]
//*********************************************************************
public static KVPairCollection GetKVPair(string s)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand cw = db.GetStoredProcCommand(s);
using (System.Data.IDataReader dr = db.ExecuteReader(cw))
{
KVPairCollection coll = new KVPairCollection();
while (dr.Read())
{
KVPair k = new KVPair(dr.GetInt32(0).ToString(), (string)dr.GetString(1));
coll.Add(k);
}
return(coll);
}
}
public static void Main(String[] args)
{
SQLRelayConnection sqlrcon = new SQLRelayConnection("Data Source=sqlrelay:9000:/tmp/test.socket;User ID=test;Password=test;Retry Time=0;Tries=1;Debug=false");
sqlrcon.Open();
SQLRelayCommand sqlrcom = (SQLRelayCommand)sqlrcon.CreateCommand();
Console.WriteLine("UNICODE:");
sqlrcom.CommandText = "select unistr('abc\\00e5\\00f1\\00f6') from dual";
System.Data.IDataReader datareader = ExecuteReader(sqlrcom);
checkSuccess(datareader != null, true);
checkSuccess(datareader.Read(), true);
checkSuccess(datareader.GetString(0), "abcåñö");
Console.WriteLine("\n");
sqlrcon.Close();
}
public override string GetUsernameWithOpenId(string openId, string openIdType)
{
string result = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT UserName FROM aspnet_Users WHERE LOWER(OpenId)=LOWER(@OpenId) AND LOWER(OpenIdType)=LOWER(@OpenIdType)");
this.database.AddInParameter(sqlStringCommand, "OpenId", System.Data.DbType.String, openId);
this.database.AddInParameter(sqlStringCommand, "OpenIdType", System.Data.DbType.String, openIdType);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
result = dataReader.GetString(0);
}
}
return(result);
}
public static KVPairCollection GetOrderMedia(string role)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand cw = db.GetStoredProcCommand("sp_NCIPLCC_getOrderMedia");
db.AddInParameter(cw, "role", DbType.String, role);
using (System.Data.IDataReader dr = db.ExecuteReader(cw))
{
KVPairCollection coll = new KVPairCollection();
while (dr.Read())
{
KVPair k = new KVPair(dr.GetInt32(0).ToString(), (string)dr.GetString(1));
coll.Add(k);
}
return(coll);
}
}
private static void GetTradePassword(string username, out int passwordFormat, out string passwordSalt)
{
passwordFormat = 0;
passwordSalt = null;
Database database = DatabaseFactory.CreateDatabase();
System.Data.Common.DbCommand sqlStringCommand = database.GetSqlStringCommand("SELECT TradePasswordFormat, TradePasswordSalt FROM aspnet_Members WHERE UserId = (SELECT UserId FROM aspnet_Users WHERE LOWER(@Username) = LoweredUserName)");
database.AddInParameter(sqlStringCommand, "Username", System.Data.DbType.String, username);
using (System.Data.IDataReader dataReader = database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
passwordFormat = dataReader.GetInt32(0);
passwordSalt = dataReader.GetString(1);
}
}
}
private static void smethod_1(string string_0, out int int_0, out string string_1)
{
int_0 = 0;
string_1 = string.Empty;
Database database = DatabaseFactory.CreateDatabase();
System.Data.Common.DbCommand sqlStringCommand = database.GetSqlStringCommand("SELECT TradePasswordFormat, TradePasswordSalt FROM aspnet_Distributors WHERE UserId = (SELECT UserId FROM aspnet_Users WHERE LOWER(@Username) = LoweredUserName)");
database.AddInParameter(sqlStringCommand, "Username", System.Data.DbType.String, string_0);
using (System.Data.IDataReader dataReader = database.ExecuteReader(sqlStringCommand))
{
if (dataReader != null && dataReader.Read())
{
int_0 = dataReader.GetInt32(0);
string_1 = dataReader.GetString(1);
}
}
}
//---------------------------------------------------------------------------------------------------------------------
public void LoadRegistrationInfo()
{
string sql = String.Format("SELECT reg_origin, reg_date FROM usrreg WHERE id_usr={0};", this.Id);
System.Data.IDbConnection dbConnection = context.GetDbConnection();
System.Data.IDataReader reader = context.GetQueryResult(sql, dbConnection);
if (reader.Read())
{
if (reader.GetValue(0) != DBNull.Value)
{
RegistrationOrigin = reader.GetString(0);
}
if (reader.GetValue(1) != DBNull.Value)
{
RegistrationDate = reader.GetDateTime(1);
}
}
context.CloseQueryResult(reader, dbConnection);
}
private void GetPasswordWithFormat(string username, bool updateLastLoginActivityDate, out int status, out int passwordFormat, out string passwordSalt)
{
passwordFormat = 0;
passwordSalt = null;
status = -1;
System.Data.Common.DbCommand storedProcCommand = this.database.GetStoredProcCommand("aspnet_Membership_GetPasswordWithFormat");
this.database.AddInParameter(storedProcCommand, "UserName", System.Data.DbType.String, username);
this.database.AddInParameter(storedProcCommand, "UpdateLastLoginActivityDate", System.Data.DbType.Boolean, updateLastLoginActivityDate);
this.database.AddInParameter(storedProcCommand, "CurrentTime", System.Data.DbType.DateTime, DateTime.Now);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(storedProcCommand))
{
if (dataReader.Read())
{
passwordFormat = dataReader.GetInt32(1);
passwordSalt = dataReader.GetString(2);
status = 0;
}
}
}
