public override List <NamePair> GetData(bool mandatory, bool onlyValidated, bool onlyActive, bool temporary)
{
List <NamePair> list = new List <NamePair>();
if (!mandatory)
{
list.Add(new KeyNamePair(-1, ""));
}
//
StringBuilder sql = new StringBuilder(
"SELECT M_ProductContainer_ID, Value || '_' || Name as valu from M_ProductContainer WHERE AD_Client_ID = @ClientId AND (AD_Org_ID = 0 OR @parameter = 0)");
if (onlyActive)
{
sql.Append(" AND IsActive='Y'");
}
sql.Append(" ORDER BY 1");
System.Data.IDataReader dr = null;
System.Data.SqlClient.SqlParameter[] param = null;
try
{
param = new System.Data.SqlClient.SqlParameter[2];
param[0] = new System.Data.SqlClient.SqlParameter("@ClientId", GetCtx().GetAD_Client_ID(_WindowNo));
param[1] = new System.Data.SqlClient.SqlParameter("@parameter", GetCtx().GetAD_Org_ID(_WindowNo));
dr = DataBase.DB.ExecuteReader(sql.ToString(), param);
while (dr.Read())
{
int key = Utility.Util.GetValueOfInt(dr[0]); //.getInt(1);
String desc = Utility.Util.GetValueOfString(dr[1]); //.getString(2);
if (desc == "")
{
desc = "{" + key + "}";
}
list.Add(new KeyNamePair(key, desc));
}
dr.Close();
dr = null;
param = null;
}
catch (Exception e)
{
if (dr != null)
{
dr.Close();
dr = null;
param = null;
}
log.Log(Level.SEVERE, sql.ToString(), e);
}
// Sort & return
return(list);
}
public void CloseReader()
{
reader.Close();
reader.Dispose();
ReCloseTimes++;
HdisCommon.Log.Logging("{0}", "CloseReader()" + " ReCloseTimes:" + ReCloseTimes);
}
public override RoleInfo GetRole(Guid roleId, string roleName)
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT RoleId, RoleName as [Name], r.Description FROM aspnet_Roles r WHERE 1=1");
if (roleId != Guid.Empty)
{
System.Data.Common.DbCommand expr_22 = sqlStringCommand;
expr_22.CommandText += " AND RoleId = @RoleId";
this.database.AddInParameter(sqlStringCommand, "RoleId", System.Data.DbType.Guid, roleId);
}
if (!string.IsNullOrEmpty(roleName))
{
System.Data.Common.DbCommand expr_59 = sqlStringCommand;
expr_59.CommandText += " AND RoleName = @RoleName";
this.database.AddInParameter(sqlStringCommand, "RoleName", System.Data.DbType.String, roleName);
}
RoleInfo result = null;
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
result = MemberRoleProvider.PopulateRoleFromIDataReader(dataReader);
}
dataReader.Close();
}
return(result);
}
public List <object> getSubCuentasByCliente(int xCodCliente)
{
List <IDataParameter> P = new List <IDataParameter>();
P.Add(new SqlParameter("@CODCLIENTE", xCodCliente));
DbCommand Command = new SqlCommand("SELECT CODCLIENTE AS TITULAR,CODSUBCTA AS CODIGO, NOMBRECLIENTE AS NOMBRE,DIRECCION,TELEFONO,DESCATALOGADO,TIPOCUENTA as TIPO,RUT,CELULAR FROM CLIENTESSUBCUENTAS WHERE CODCLIENTE = @CODCLIENTE", (SqlConnection)Connection);
System.Data.IDataReader rd = null;
List <object> SubCuentas = new List <object>();
SubCuenta Entity = null;
if (_Connection.State == System.Data.ConnectionState.Closed)
{
_Connection.Open();
}
rd = ExecuteReader(Command, P);
while (rd.Read())
{
Entity = (SubCuenta)getSubCuentaFromReader(rd);
SubCuentas.Add(Entity);
}
rd.Close();
CerrarConexion(_Connection);
return(SubCuentas);
}
/// <summary>
/// Gets the file list in a manner that is easy to serialize and send.
/// </summary>
/// <returns>
/// The file list.
/// </returns>
/// <param name='user'>
/// This account.
/// </param>
public List <List <string> > GetFileListSerializable(ServerUser user)
{
List <List <string> > fileList = new List <List <string> >();
int startPath = ("/" + user.id + "/files/").Length + 1;
DbCommand command = dbConnection.CreateCommand();
command.CommandText = "SELECT substr(path, " + startPath + ") as path, mtime as modtime, if(mimetype='httpd/unix-directory', 'd','f') as type, size, 0 as checksum FROM oc_fscache WHERE user='******' AND substr(path, " + startPath + ") != ''";
DbReader reader = command.ExecuteReader();
while (reader.Read())
{
List <string> fileInfo = new List <string>();
fileInfo.Add(reader["path"].ToString());
fileInfo.Add(reader["type"].ToString());
fileInfo.Add(reader["modtime"].ToString());
fileInfo.Add(reader["size"].ToString());
fileInfo.Add(reader["checksum"].ToString());
fileList.Add(fileInfo);
}
reader.Close();
return(fileList);
}
public List <object> getMovimientosPendiente(int xCliente)
{
List <IDataParameter> P = new List <IDataParameter>();
P.Add(new SqlParameter("@CLIENTE", xCliente));
DbCommand Command = new SqlCommand("SELECT V.VENCIMIENTOCONTADO AS PRECIOCONTADO,DBO.JL_TARIFABYFACTURA(T.SERIE,T.NUMERO) AS TARIFA,DBO.JL_TIPOBYCODCLIENTE(t.codigointerno) as tipocliente,T.SERIEDOC,t.NUMERODOC,t.codigointerno as CLIENTE,V.TIPODOC as NUMEROTIPO,T.MORA AS MORA,T.CAJASALDADO AS CAJASALDADO,T.ZSALDADO AS ZSALDADO,T.FACTORMONEDA AS FMONEDA,T.ORIGEN,T.GENAPUNTE AS APUNTE,T.CODTIPOPAGO AS TIPOPAGO,T.CODFORMAPAGO AS FORMAPAGO,MAX(T.POSICION) AS POSICION,MAX(D.DESCRIPCION) AS DESCRIPCION, MAX(T.FECHADOCUMENTO) AS 'FECHA DEL DOCUMENTO', MAX(T.SERIE) AS 'SERIE DE DOCUMENTO', MAX(T.NUMERO) AS 'NUMERO DE DOCUMENTO',CAST(SUM(T.IMPORTE) AS DECIMAL(16, 2)) AS IMPORTE,T.CODMONEDA AS MONEDA,T.ESTADO AS ESTADO,T.FECHAVENCIMIENTO AS VENCIMIENTO,T.NUMEROREMESA AS REMESA, T.TIPODOCUMENTO AS TIPODOC,T.FECHASALDADO AS SALDADO,SUBCTA FROM TESORERIA AS T LEFT OUTER JOIN FACTURASVENTA AS V ON T.SERIE = V.NUMSERIE AND T.NUMERO = V.NUMFACTURA AND T.N = V.N LEFT OUTER JOIN SERIES AS D ON V.NUMSERIE = D.SERIE WHERE (T.ORIGEN = 'C' AND (T.TIPODOCUMENTO='F' OR T.TIPODOCUMENTO ='L')) AND (T.CODIGOINTERNO = @CLIENTE) AND T.N='B' AND (T.ESTADO='P') GROUP BY V.VENCIMIENTOCONTADO,T.SERIEDOC,t.NUMERODOC,t.codigointerno,V.TIPODOC,T.MORA,T.CAJASALDADO,T.ZSALDADO,T.FACTORMONEDA,T.ORIGEN,T.GENAPUNTE,T.CODTIPOPAGO,T.CODFORMAPAGO,T.FECHADOCUMENTO,T.SERIE, T.NUMERO,T.CODMONEDA,T.ESTADO,T.FECHAVENCIMIENTO,T.NUMEROREMESA, T.TIPODOCUMENTO,T.FECHASALDADO,SUBCTA,T.POSICION ORDER BY T.FECHADOCUMENTO ASC ", (SqlConnection)Connection);
System.Data.IDataReader rd = null;
List <object> Movimientos = new List <object>();
MovimientoGeneral Entity = null;
if (Connection.State == System.Data.ConnectionState.Closed)
{
_Connection.Open();
}
rd = ExecuteReader(Command, P);
while (rd.Read())
{
Entity = (MovimientoGeneral)getMovimientoFromReader(rd, _ListaMonedas, false);
Movimientos.Add(Entity);
}
rd.Close();
CerrarConexion(Connection);
foreach (Movimiento M in Movimientos)
{
((Movimiento)M).CFE = (CFE)getCFEByFactura(M.Numero, M.Serie);
}
return(Movimientos);
}
public override HelpInfo GetFrontOrNextHelp(int helpId, int categoryId, string type)
{
string text = string.Empty;
if (type == "Next")
{
text = "SELECT TOP 1 * FROM distro_Helps WHERE HelpId< @HelpId AND CategoryId=@CategoryId AND DistributorUserId = @DistributorUserId ORDER BY HelpId DESC";
}
else
{
text = "SELECT TOP 1 * FROM distro_Helps WHERE HelpId> @HelpId AND CategoryId=@CategoryId AND DistributorUserId = @DistributorUserId ORDER BY HelpId ASC";
}
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(text);
this.database.AddInParameter(sqlStringCommand, "HelpId", System.Data.DbType.Int32, helpId);
this.database.AddInParameter(sqlStringCommand, "CategoryId", System.Data.DbType.Int32, categoryId);
this.database.AddInParameter(sqlStringCommand, "DistributorUserId", System.Data.DbType.Int32, HiContext.Current.SiteSettings.UserId.Value);
HelpInfo result = null;
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
result = DataMapper.PopulateHelp(dataReader);
}
dataReader.Close();
}
return(result);
}
public override PromotionInfo GetFrontOrNextPromoteInfo(PromotionInfo promote, string type)
{
string text = string.Empty;
if (type == "Next")
{
text = "SELECT TOP 1 * FROM distro_Promotions WHERE activityId<@activityId AND PromoteType=@PromoteType AND DistributorUserId=@DistributorUserId ORDER BY activityId DESC";
}
else
{
text = "SELECT TOP 1 * FROM distro_Promotions WHERE activityId>@activityId AND PromoteType=@PromoteType AND DistributorUserId=@DistributorUserId ORDER BY activityId ASC";
}
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(text);
this.database.AddInParameter(sqlStringCommand, "DistributorUserId", System.Data.DbType.Int32, HiContext.Current.SiteSettings.UserId.Value);
this.database.AddInParameter(sqlStringCommand, "activityId", System.Data.DbType.Int32, promote.ActivityId);
this.database.AddInParameter(sqlStringCommand, "PromoteType", System.Data.DbType.Int32, Convert.ToInt32(promote.PromoteType));
PromotionInfo result = null;
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
result = DataMapper.PopulatePromote(dataReader);
}
dataReader.Close();
}
return(result);
}
public override IList <int> GetPrivilegesForUser(string userName)
{
IList <int> result;
if (string.IsNullOrEmpty(userName))
{
result = new List <int>();
}
else
{
IList <int> list = new List <int>();
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT DISTINCT pr.Privilege FROM dbo.aspnet_Roles r INNER JOIN dbo.aspnet_UsersInRoles ur ON r.RoleId = ur.RoleId INNER JOIN dbo.Hishop_PrivilegeInRoles pr ON pr.RoleId = r.RoleId 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.GetInt32(0));
}
dataReader.Close();
}
result = list;
}
return(result);
}
public static string GetLastVersion(UpdateType ut)
{
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_updDescription", ut.ToString());
DbAccessLayer.MySqlDbAccess db = new DbAccessLayer.MySqlDbAccess(ConnectionString(), DbAccessLayer.ConnectionStringSourceType.MySetting);
System.Data.IDataReader reader = db.GetDataReaderFromProcedure("stpDad_updateSelLastVersion", param);
string result = string.Empty;
if (db.HasError)
{
throw db.ErrorException;
}
if (reader.Read())
{
result = DbAccessLayer.MySqlDataHelper.GetString(reader, "updVersionName");
}
reader.Close();
return(result);
}
public static Nullable <int> GetLastVersionDownloaded(UpdateType ut)
{
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_updDescription", ut.ToString());
DbAccessLayer.MySqlDbAccess db = new DbAccessLayer.MySqlDbAccess(ConnectionString(), DbAccessLayer.ConnectionStringSourceType.MySetting);
System.Data.IDataReader reader = db.GetDataReaderFromProcedure("stpDadupdateSelLastVerDownloaded", param);
Nullable <int> result = null;
if (db.HasError)
{
throw db.ErrorException;
}
if (reader.Read())
{
result = DbAccessLayer.MySqlDataHelper.GetNullableInt(reader, "updVersion");
}
reader.Close();
return(result);
}
public virtual object getmodel(object key, string alias)
{
OrmAnalysis ormAnalysis;
EFWCoreLib.CoreFrame.DbProvider.AbstractDatabase _oleDb = GetDb();
ICacheManager _cache = GetCache();
string _pluginName = GetPluginName();
ormAnalysis = OrmAnalysisFactory.CreateOrmAnalysisObject(_oleDb.DbType);
ormAnalysis.Alias = alias;
ormAnalysis.Db = _oleDb;
ormAnalysis.entityAttrList = (List <EntityAttributeInfo>)EntityManager.GetAttributeInfo(_cache, _pluginName);
object value = null;
object keyVal = key == null?ormAnalysis.GetEntityDataKeyValue(this) : key;
string strsql = ormAnalysis.GetEntitySQL(this.GetType(), keyVal);
System.Data.IDataReader result = _oleDb.GetDataReader(strsql);
if (result.Read())
{
value = ToObject(result, this, alias);
}
result.Close();
result.Dispose();
return(value);
}
public List <List <string> > GetFileListSerializable(ServerUser thisAccount)
{
List <List <string> > fileList = new List <List <string> >();
int startPath = ("/" + thisAccount.id + "/").Length + 1;
DbCommand command = dbConnection.CreateCommand();
command.CommandText = "SELECT substr(path, " + startPath + ") as path, type, modtime, size, checksum FROM files WHERE user='******' AND substr(path, " + startPath + ") != ''";
DbReader reader = command.ExecuteReader();
while (reader.Read())
{
List <string> fileInfo = new List <string>();
fileInfo.Add(reader["path"].ToString());
fileInfo.Add(reader["type"].ToString());
fileInfo.Add(reader["modtime"].ToString());
fileInfo.Add(reader["size"].ToString());
fileInfo.Add(reader["checksum"].ToString());
fileList.Add(fileInfo);
}
reader.Close();
return(fileList);
}
//open Copernicus DB connection By Veeresh
public List <CloseRequestBean> getData()
{
List <CloseRequestBean> ClosedRequestBeanList = new List <CloseRequestBean>();
SqlConnection cnn1 = null;
System.Data.IDataReader reader = null;
string connectionString1 = ConfigurationSettings.AppSettings["CONNECTION_STR1"];
try
{
using (SqlDataAdapter closeBean = new SqlDataAdapter())
{
cnn1 = new SqlConnection(connectionString1);
closeBean.SelectCommand = new SqlCommand("SP_GetRaskeeperPLCChangeRequests", cnn1);
closeBean.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet beanList = new DataSet();
closeBean.Fill(beanList, "CloseRequestBean");
DataTable dt = beanList.Tables["CloseRequestBean"];
}
//cnn1 = new SqlConnection(connectionString1);
//System.Data.IDbCommand dbcommand = new SqlCommand();
//dbcommand.Connection = cnn1;
//dbcommand.CommandType = CommandType.StoredProcedure;
//dbcommand.CommandText = "SPText";
//cnn1.Open();
//reader = dbcommand.ExecuteReader();
//while (reader.Read())
//{
// CloseRequestBean BeanList = new CloseRequestBean();
// BeanList.RequestID = (string)reader["ID"];
//BeanList.CreatedDate = (string)reader["CreatorDate"];
//BeanList.RequestorName = (string)reader["ReqstorName"];
//ClosedRequestBeanList.Add(BeanList);
//}
}
catch (SqlException e)
{
//PHWebException exMail = new PHWebException();
//exMail.popupMailOnIECrash(e);
}
finally
{
if (reader != null)
{
reader.Close();
}
cnn1.Close();
}
return(ClosedRequestBeanList);
}
public List <ImportProductCatalogueEntity> ImportDatatoCatalogue(int StoreId, int LoggedInUserId, int supplier_id, int language_id, int catalogue_id, DataTable XLS, bool IsConfirmToIgnore)
{
try
{
SqlConnection con = new SqlConnection();
con.ConnectionString = Convert.ToString(ConfigurationManager.ConnectionStrings["DefaultConnection"]);
con.Open();
SqlCommand cmd = new SqlCommand("ImportCatalogueDataToTable", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parameter = new SqlParameter();
parameter.ParameterName = "@importTypetbl";
parameter.SqlDbType = SqlDbType.Structured;
parameter.TypeName = "dbo.ImportCatalogType2";
parameter.Value = XLS;
cmd.Parameters.Add(parameter);
cmd.Parameters.AddWithValue("@Supplier_Id", supplier_id);
cmd.Parameters.AddWithValue("@Language_Id", language_id);
cmd.Parameters.AddWithValue("@Catalogue_Id", catalogue_id);
cmd.Parameters.AddWithValue("@CreatedBy", LoggedInUserId);
cmd.Parameters.AddWithValue("@IsConfirmToIgnore", IsConfirmToIgnore);
cmd.CommandTimeout = 120000000;
System.Data.IDataReader dr = cmd.ExecuteReader();
List <ImportProductCatalogueEntity> lstEntity = new List <ImportProductCatalogueEntity>();
while (dr.Read())
{
ImportProductCatalogueEntity objEntity = new ImportProductCatalogueEntity();
objEntity.code = Convert.ToString(dr.GetValue(0));
objEntity.name = Convert.ToString(dr.GetValue(1));
lstEntity.Add(objEntity);
//result = Convert.ToInt32(dr[0]);
}
dr.Close();
//tvpParam.TypeName = "dbo.ImportCatalogType";
// int result = 0;
//result = cmd.ExecuteNonQuery();
// result = Convert.ToInt32(cmd.ExecuteScalar());
//System.Data.IDataReader dr = cmd.ExecuteReader();
//while (dr.Read())
//{
// result = Convert.ToInt32(dr[0]);
//}
//dr.Close();
con.Close();
return(lstEntity);
}
catch (Exception ex)
{
throw;
}
}
public void ListDoldur900(ref ListView list, string sql)
{
CheckConnection();
System.Data.IDataReader rd = TSelect(sql);
int i;
while (rd != null && rd.Read())
{
if (rd.GetValue(1).ToString().Trim() == "HATA")
{
m mx = new m();
mx.tistex = "HATA!";
mx.label1.Text = rd.GetValue(0).ToString().Trim();
mx.ShowDialog();
break;
}
else
{
list.Items.Clear();
}
ListViewItem row = new ListViewItem();
if (rd.IsDBNull(0))
{
row.Text = "";
}
else
{
row.Text = rd.GetValue(0).ToString();
}
for (i = 1; i < rd.FieldCount; i++)
{
if (rd.IsDBNull(i))
{
row.SubItems.Add("");
}
else
{
row.SubItems.Add(rd.GetValue(i).ToString());
}
}
list.Items.Add(row);
}
if (rd != null)
{
rd.Close();
}
}
public bool HasDrawRequest(int serialid)
{
bool result = false;
string query = "select top 1 ID from vshop_SendRedpackRecord where BalanceDrawRequestID=" + serialid;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);
System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand);
if (dataReader.Read())
{
result = true;
}
dataReader.Close();
return(result);
}
public List <string> GetFuwuAdminUserMsgList(string MsgFieldName)
{
List <string> list = new List <string>();
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("select * from Hishop_MessageAdminUserMsgList WHERE isnull(" + MsgFieldName + ",0) = 1 and Type=1");
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
list.Add((string)dataReader["UserOpenId"]);
}
dataReader.Close();
}
return(list);
}
public IList <MessageTemplate> GetAliFuWuMessageTemplates()
{
IList <MessageTemplate> list = new List <MessageTemplate>();
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_AliFuWuMessageTemplates where IsValid=1 ORDER BY OrderIndex");
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
list.Add(this.PopulateEmailTempletFromIDataReader(dataReader));
}
dataReader.Close();
}
return(list);
}
public override IList <MessageTemplate> GetMessageTemplates()
{
IList <MessageTemplate> list = new List <MessageTemplate>();
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_MessageTemplates");
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
list.Add(MessageTemplateProvider.PopulateEmailTempletFromIDataReader(dataReader));
}
dataReader.Close();
}
return(list);
}
private Dictionary <string, string> LoadConfig(string configTable)
{
if (!Database.Instance.IsConfigured)
{
configureDatabase();
}
Dictionary <string, string> config = new Dictionary <string, string>();
System.Data.IDataReader rdr = Database.Instance.ExecuteReader(String.Format("select ConfigKey, ConfigValue from {0}", configTable));
while (rdr.Read())
{
config.Add(Db.DbValueConverter.ToString(rdr["ConfigKey"]), Db.DbValueConverter.ToString(rdr["ConfigValue"]));
}
rdr.Close();
return(config);
}
public MessageTemplate GetMessageTemplate(string messageType)
{
MessageTemplate result = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_MessageTemplates WHERE LOWER(MessageType) = LOWER(@MessageType)");
this.database.AddInParameter(sqlStringCommand, "MessageType", System.Data.DbType.String, messageType);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
result = this.PopulateEmailTempletFromIDataReader(dataReader);
}
dataReader.Close();
}
return(result);
}
public override IList <MessageTemplate> GetDistributorMessageTemplates()
{
IList <MessageTemplate> list = new List <MessageTemplate>();
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM distro_MessageTemplates 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(MessageTemplateProvider.PopulateEmailTempletFromIDataReader(dataReader));
}
dataReader.Close();
}
return(list);
}
public override ArrayList GetRoles()
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT RoleId, RoleName as [Name], Description FROM aspnet_Roles order by RoleId");
ArrayList arrayList = new ArrayList();
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
RoleInfo value = MemberRoleProvider.PopulateRoleFromIDataReader(dataReader);
arrayList.Add(value);
}
dataReader.Close();
}
return(arrayList);
}
public override SiteSettings GetDistributorSettings(string siteUrl)
{
SiteSettings result = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM distro_Settings WHERE LOWER(@SiteUrl) = LOWER(SiteUrl)");
this.database.AddInParameter(sqlStringCommand, "SiteUrl", System.Data.DbType.String, siteUrl);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
result = SiteSettingsProvider.PopulateDistributorSettings(dataReader);
}
dataReader.Close();
}
return(result);
}
public override SiteSettings GetDistributorSettings(int userId)
{
SiteSettings result = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM distro_Settings WHERE @UserId = UserId");
this.database.AddInParameter(sqlStringCommand, "UserId", System.Data.DbType.Int32, userId);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
result = SiteSettingsProvider.PopulateDistributorSettings(dataReader);
}
dataReader.Close();
}
return(result);
}
public override PromotionInfo GetPromote(int activityId)
{
PromotionInfo result = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_Promotions WHERE ActivityId=@ActivityId");
this.database.AddInParameter(sqlStringCommand, "ActivityId", System.Data.DbType.Int32, activityId);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
result = DataMapper.PopulatePromote(dataReader);
}
dataReader.Close();
}
return(result);
}
public override ArrayList GetRoles()
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT RoleId, RoleName as [Name], Description FROM aspnet_Roles where RoleId<>'625a27cc-7a55-41d6-8449-c6fe736003e5' and RoleId<>'5a26c830-b998-4569-bffc-c5ceae774a7a' order by RoleId");
ArrayList arrayList = new ArrayList();
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
RoleInfo value = MemberRoleProvider.PopulateRoleFromIDataReader(dataReader);
arrayList.Add(value);
}
dataReader.Close();
}
return(arrayList);
}
public MessageTemplate GetMessageTemplateByDetailType(string DetailType)
{
MessageTemplate result = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(" select a.DetailType, a.DetailName, a.AllowToAdmin,a.AllowToDistributor,a.AllowToMember, a.IsSelectedByDistributor,a.IsSelectedByMember,\r\n b.* from Hishop_MessageTemplatesDetail a \r\n left join Hishop_MessageTemplates b on a.MessageType= b.MessageType\r\n where b.MessageType is not null and isnull(b.IsValid,0)=1\r\n and LOWER(DetailType) = LOWER(@DetailType)");
this.database.AddInParameter(sqlStringCommand, "DetailType", System.Data.DbType.String, DetailType);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
result = this.PopulateEmailTempletFromIDataReader(dataReader);
}
dataReader.Close();
}
return(result);
}
/// <summary>
/// Returns all OPC Sample Group key and Name map
/// </summary>
/// <returns>Sample group key-Name map</returns>
public Dictionary <string, string> GetAllOPCGrpIdAndName(bool checkLoc)
{
string Function_Name = "GetAllOPCGrpIdAndName";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
Dictionary <string, string> opcGrpIDToNameDic = new Dictionary <string, string>();
string localSQL;
localSQL = "SELECT PKEY, NAME FROM DATALOG_DP_GROUP_TREND";
string LocationClauseStr = DAOHelper.CheckLocationAndAddSQL(COLUMN_LOCATION_KEY);
if (LocationClauseStr.Length != 0 && checkLoc)
{
localSQL += " WHERE" + LocationClauseStr;
}
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
try
{
while (drReader != null && drReader.Read())
{
string grpID = "", grpName = "";
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_PKEY)))
{
grpID = drReader[COLUMN_PKEY].ToString();
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_NAME)))
{
grpName = DAOHelper.convert8859P1ToGB2312(drReader[COLUMN_NAME].ToString());
}
opcGrpIDToNameDic.Add(grpID, grpName);
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
if (drReader != null)
{
drReader.Close();
drReader.Dispose();
//SimpleDatabase.GetInstance().CloseCurrentSession();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(opcGrpIDToNameDic);
}
