//Get Records
public static cs_recordcollection GetRecords()
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand cw = db.GetStoredProcCommand("sp_CANNED_getRecords");
using (System.Data.IDataReader dr = db.ExecuteReader(cw))
{
cs_recordcollection coll = new cs_recordcollection();
while (dr.Read())
{
cs_record k = new cs_record(
dr.GetInt32(dr.GetOrdinal("cannid")),
dr["recordid"].ToString(),
dr["headertext"].ToString(),
(dr["audience"] == DBNull.Value) ? "" : dr["audience"].ToString(),
(dr["cancertype"] == DBNull.Value) ? "" : dr["cancertype"].ToString(),
(dr["language"] == DBNull.Value) ? "" : dr["language"].ToString(),
(dr["prodformat"] == DBNull.Value) ? "" : dr["prodformat"].ToString(),
(dr["race"] == DBNull.Value) ? "" : dr["race"].ToString(),
(dr["series"] == DBNull.Value) ? "" : dr["series"].ToString(),
(dr["subject"] == DBNull.Value) ? "" : dr["subject"].ToString(),
dr.GetInt32(dr.GetOrdinal("active"))
);
coll.Add(k);
}
return(coll);
}
}
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 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;
}
}
}
/// <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 override DbQueryResult GetBalanceDrawRequestsNoPage(BalanceDrawRequestQuery query)
{
DbQueryResult result;
if (null == query)
{
result = new DbQueryResult();
}
else
{
DbQueryResult dbQueryResult = new DbQueryResult();
StringBuilder stringBuilder = new StringBuilder();
string arg = MemberData.BuildBalanceDrawRequestQuery(query);
stringBuilder.Append("select *");
stringBuilder.Append(" from Hishop_BalanceDrawRequest B where 0=0 ");
stringBuilder.AppendFormat("{0} ORDER BY RequestTime DESC", arg);
if (query.IsCount)
{
stringBuilder.AppendFormat(";select count(*) as Total from Hishop_BalanceDrawRequest where 0=0 {0}", arg);
}
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString());
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader);
if (query.IsCount && dataReader.NextResult())
{
dataReader.Read();
dbQueryResult.TotalRecords = dataReader.GetInt32(0);
}
}
result = dbQueryResult;
}
return(result);
}
public bool isActiveCache(string idAmministrazione)
{
bool result = false;
DocsPaUtils.Query queryDef = DocsPaUtils.InitQuery.getInstance().getQuery("S_CONFIG_CACHING");
queryDef.setParam("idAmministrazione", "'" + idAmministrazione + "'");
logger.Debug("isActiveCache - 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())
{
if (reader.GetInt32(reader.GetOrdinal("CACHING")) == 1)
{
result = true;
}
}
}
}
}
return(result);
}
public override decimal GetCostPrice(string skuId)
{
System.Data.Common.DbCommand storedProcCommand = this.database.GetStoredProcCommand("ss_distro_GetGroupBuyProductCostPrices");
this.database.AddInParameter(storedProcCommand, "DistributorUserId", System.Data.DbType.Int32, HiContext.Current.SiteSettings.UserId.Value);
this.database.AddInParameter(storedProcCommand, "SkuId", System.Data.DbType.String, skuId);
decimal result = 0m;
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(storedProcCommand))
{
int value = 100;
if (dataReader.Read())
{
value = dataReader.GetInt32(0);
}
if (dataReader.NextResult() && dataReader.Read())
{
if (dataReader["DistributorPurchasePrice"] != DBNull.Value)
{
result = (decimal)dataReader["DistributorPurchasePrice"];
}
else
{
result = Math.Round((decimal)dataReader["PurchasePrice"] * (value / 100m), 2);
}
}
}
return(result);
}
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);
}
public static DbQueryResult PagingByTopnotin(int pageIndex, int pageSize, string sortBy, SortAction sortOrder, bool isCount, string table, string key, string filter, string selectFields)
{
DbQueryResult result;
if (string.IsNullOrEmpty(table))
{
result = null;
}
else if (string.IsNullOrEmpty(key))
{
result = null;
}
else
{
if (string.IsNullOrEmpty(selectFields))
{
selectFields = "*";
}
string query = DataHelper.BuildNotinQuery(pageIndex, pageSize, sortBy, sortOrder, isCount, table, key, filter, selectFields);
DbQueryResult dbQueryResult = new DbQueryResult();
Database database = DatabaseFactory.CreateDatabase();
System.Data.Common.DbCommand sqlStringCommand = database.GetSqlStringCommand(query);
using (System.Data.IDataReader dataReader = database.ExecuteReader(sqlStringCommand))
{
dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader);
if (isCount && dataReader.NextResult())
{
dataReader.Read();
dbQueryResult.TotalRecords = dataReader.GetInt32(0);
}
}
result = dbQueryResult;
}
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 override DbQueryResult GetFavorites(int userId, string tags, Pagination page)
{
DbQueryResult dbQueryResult = new DbQueryResult();
System.Data.Common.DbCommand storedProcCommand = this.database.GetStoredProcCommand("ac_Underling_Favorites_Get");
this.database.AddInParameter(storedProcCommand, "PageIndex", System.Data.DbType.Int32, page.PageIndex);
this.database.AddInParameter(storedProcCommand, "PageSize", System.Data.DbType.Int32, page.PageSize);
this.database.AddInParameter(storedProcCommand, "IsCount", System.Data.DbType.Boolean, page.IsCount);
Member member = HiContext.Current.User as Member;
this.database.AddInParameter(storedProcCommand, "GradeId", System.Data.DbType.Int32, member.GradeId);
this.database.AddInParameter(storedProcCommand, "SqlPopulate", System.Data.DbType.String, CommentData.BuildFavoriteQuery(userId, tags));
this.database.AddOutParameter(storedProcCommand, "TotalFavorites", System.Data.DbType.Int32, 4);
this.database.AddInParameter(storedProcCommand, "DistributorUserId", System.Data.DbType.Int32, HiContext.Current.SiteSettings.UserId);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(storedProcCommand))
{
dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader);
if (page.IsCount && dataReader.NextResult())
{
dataReader.Read();
dbQueryResult.TotalRecords = dataReader.GetInt32(0);
}
}
return(dbQueryResult);
}
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);
}
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 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);
}
}
}
public int PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, int Atributo)
{
if ((lDataReader.IsDBNull(NumeroColuna) == true))
{
return(Int32.MinValue);
}
else
{
return(lDataReader.GetInt32(NumeroColuna));
}
}
public void Start(SP.ISPDatabase sharepointDatabase, SP.SPListDefinition list, UI.IProgressNotifier notifier)
{
notifier.Reset("Initializing...");
_Formatter.Initialize();
SP.SPFieldDefinitionCollection oFieldList = list.Fields;
notifier.SetProgress("Retrieving records from Sharepoint database...", 0);
System.Data.IDataReader oReader = sharepointDatabase.GetListItemsAsReader(list, true, false);
oReader.Read();
int nTotalRecords = oReader.GetInt32(0);
int nProcessedRecords = 0;
notifier.SetProgress(string.Format("{0} records retrieved. Now exporting...", nTotalRecords.ToString()), 10);
oReader.NextResult();
while (oReader.Read())
{
int nListItemID = Convert.ToInt32(oReader["ID"]);
_Formatter.BeginExportRow(nListItemID.ToString());
foreach (SP.SPFieldDefinition oField in oFieldList)
{
_Formatter.ExportField(oField.InternalName, sharepointDatabase.GetFieldText(oField, oReader));
}
if (_Formatter.SupportAttachments && oReader.GetBoolean(oReader.GetOrdinal("HasAttachments")))
{
DataTable oAttachmentList = sharepointDatabase.GetListItemAttachmentsList(list, nListItemID, true);
int nCounter = 1;
foreach (DataRow oAttachment in oAttachmentList.Rows)
{
_Formatter.ExportAttachment(nCounter, oAttachment["Folder"].ToString(), oAttachment["Filename"].ToString(), (byte[])oAttachment["Content"]);
nCounter++;
}
}
_Formatter.EndExportRow();
nProcessedRecords++;
if (nProcessedRecords % 100 == 0)
{
notifier.SetProgress(null, (short)(10 + (nProcessedRecords * 90 / nTotalRecords)));
}
}
_Formatter.Terminate();
notifier.SetComplete(null);
}
//Get Key, Value, Selected information for the lists
public static KVPairCollection GetKVPair(string procname, int mode, int cannid)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand cw = db.GetStoredProcCommand(procname);
db.AddInParameter(cw, "mode", DbType.Int32, mode);
db.AddInParameter(cw, "cannid", DbType.Int32, cannid);
using (System.Data.IDataReader dr = db.ExecuteReader(cw))
{
KVPairCollection coll = new KVPairCollection();
while (dr.Read())
{
KVPair k = new KVPair(
dr.GetInt32(0).ToString(),
(dr[1] == DBNull.Value) ? "" : dr[1].ToString(),
dr.GetInt32(2).ToString()
);
coll.Add(k);
}
return(coll);
}
}
public override DbQueryResult GetMemberBlanceList(MemberQuery query)
{
DbQueryResult result;
if (null == query)
{
result = new DbQueryResult();
}
else
{
DbQueryResult dbQueryResult = new DbQueryResult();
StringBuilder stringBuilder = new StringBuilder();
string text = string.Empty;
if (!string.IsNullOrEmpty(query.Username))
{
text = string.Format("AND UserId IN (SELECT UserId FROM vw_aspnet_Members WHERE UserName LIKE '%{0}%')", DataHelper.CleanSearchString(query.Username));
}
if (!string.IsNullOrEmpty(query.Realname))
{
text += string.Format(" AND RealName LIKE '%{0}%'", DataHelper.CleanSearchString(query.Realname));
}
stringBuilder.AppendFormat("SELECT TOP {0} *", query.PageSize);
stringBuilder.Append(" FROM vw_aspnet_Members WHERE 0=0");
if (query.PageIndex == 1)
{
stringBuilder.AppendFormat("{0} ORDER BY CreateDate DESC", text);
}
else
{
stringBuilder.AppendFormat("AND CreateDate < (select min(CreateDate) FROM (SELECT TOP {0} CreateDate FROM vw_aspnet_Members WHERE 0=0 {1} ORDER BY CreateDate DESC ) AS tbltemp) {1} ORDER BY CreateDate DESC", (query.PageIndex - 1) * query.PageSize, text);
}
if (query.IsCount)
{
stringBuilder.AppendFormat(";SELECT COUNT(CreateDate) AS Total FROM vw_aspnet_Members WHERE 0=0 {0}", text);
}
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString());
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader);
if (query.IsCount && dataReader.NextResult())
{
dataReader.Read();
dbQueryResult.TotalRecords = dataReader.GetInt32(0);
}
}
result = dbQueryResult;
}
return(result);
}
public bool BrandHvaeProducts(int brandId)
{
bool result = false;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT Count(ProductName) FROM Hishop_Products Where BrandId=@BrandId");
this.database.AddInParameter(sqlStringCommand, "BrandId", System.Data.DbType.Int32, brandId);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
result = (dataReader.GetInt32(0) > 0);
}
}
return(result);
}
public static int GetTimeout(int appID, int timeoutID)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand cw = db.GetStoredProcCommand("sp_KIOSK_GetTimeout");
db.AddInParameter(cw, "appID", DbType.Int32, appID);
db.AddInParameter(cw, "timeoutID", DbType.Int32, timeoutID);
using (System.Data.IDataReader dr = db.ExecuteReader(cw))
{
if (dr.Read())
{
return(dr.GetInt32(0));
}
}
throw (new ArgumentOutOfRangeException("Timeout", "Value is missing"));
}
//*********************************************************************
//
// 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);
}
}
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 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);
}
}
public override int DrToInt32(System.Data.IDataReader dr, int index)
{
Type t = dr.GetFieldType(index);
if (t.Equals(typeof(decimal)))
{
return(dr.IsDBNull(index) ? 0 : (int)dr.GetDecimal(index));
}
else if (t.Equals(typeof(Int32)))
{
return(dr.IsDBNull(index) ? 0 : (int)dr.GetInt32(index));
}
else
{
throw new NotImplementedException();
}
}
private static int LoadFromDbase(Shotgun.Database.IBaseDataClass2 dBase)
{
var sql = "SELECT cpls.id,cpls.cp_pool_id,tn.sp_trone_id,tod.trone_id,trone_order_id,priority,"
+ " ( cpls.status=1 and stn.status=1 and tn.status=1 and tod.disable=0 and stn.is_on_api=1) status"
+ " FROM daily_config.tbl_cp_pool_set cpls "
+ "left join tbl_cp_pool cpl on cpl.id= cpls.cp_pool_id "
+ "left join tbl_trone_order tod on cpls.trone_order_id= tod.id "
+ "left join tbl_trone tn on tn.id= tod.trone_id "
+ "left join tbl_sp_trone stn on stn.id= tn.sp_trone_id "
+ "where cpl.status=1 ";
var cmd = dBase.Command();
cmd.CommandText = sql;
System.Data.IDataReader rd = null;
int c = 0;
try
{
rd = dBase.ExecuteReader(cmd);
lock (cache.SyncRoot)
{
cache.ClearCache();
while (rd.Read())
{
PoolSetModel pm = new PoolSetModel();
pm.id = rd.GetInt32(0);
pm.cp_pool_id = rd.GetInt32(1);
pm.sp_trone_id = rd.GetInt32(2);
pm.trone_id = rd.GetInt32(3);
pm.trone_order_id = rd.GetInt32(4);
pm.priority = rd.GetInt32(5);
pm.status = rd.GetInt32(6);
cache.InsertItem(pm);
c++;
}
}
}
finally
{
if (rd != null)
{
rd.Dispose();
}
cmd.Dispose();
}
return(c);
}
public static DbQueryResult PagingByRownumber(int pageIndex, int pageSize, string sortBy, SortAction sortOrder, bool isCount, string table, string pk, string filter, string selectFields, int partitionSize, bool isAdmin)
{
DbQueryResult result;
if (string.IsNullOrEmpty(table))
{
result = null;
}
else
{
if (string.IsNullOrEmpty(sortBy) && string.IsNullOrEmpty(pk))
{
result = null;
}
else
{
if (string.IsNullOrEmpty(selectFields))
{
selectFields = "*";
}
string query = "";
query = DataHelper.BuildRownumberQuery(sortBy, sortOrder, isCount, table, pk, filter, selectFields, partitionSize, isAdmin);
int num = (pageIndex - 1) * pageSize + 1;
int num2 = num + pageSize - 1;
DbQueryResult dbQueryResult = new DbQueryResult();
Database database = DatabaseFactory.CreateDatabase();
System.Data.Common.DbCommand sqlStringCommand = database.GetSqlStringCommand(query);
database.AddInParameter(sqlStringCommand, "StartNumber", System.Data.DbType.Int32, num);
database.AddInParameter(sqlStringCommand, "EndNumber", System.Data.DbType.Int32, num2);
using (System.Data.IDataReader dataReader = database.ExecuteReader(sqlStringCommand))
{
dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader);
if (isCount && partitionSize == 0 && dataReader.NextResult())
{
dataReader.Read();
dbQueryResult.TotalRecords = dataReader.GetInt32(0);
}
}
result = dbQueryResult;
}
}
return(result);
}
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;
}
}
}
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;
}
}
}
