public List <Bill> GetWorkshopBills(int workshop_id)
{
StatQuery statQuery = new StatQuery();
System.Data.DataTable dataTable = new System.Data.DataTable();
dataTable = conn_db.ReadTable(statQuery.GetWorkshopBills(workshop_id));
if (dataTable.Rows.Count == 0)
{
throw new EmptyViewException(language);
}
Bill bill = new Bill();
List <Bill> bills = new List <Bill>();
foreach (System.Data.DataRow row in dataTable.Rows)
{
bill = new Bill();
bill.OFFER_ID = Convert.ToInt32(row["OFFER_ID"]);
bill.WORKSHOP_ID = Convert.ToInt32(row["WORKSHOP_ID"]);
bill.PLATENUMBER = row["PLATENUMBER"].ToString();
bill.PRICE = Convert.ToDouble(row["PRICE"]);
bill.WORKDAYS = Convert.ToInt32(row["WORKDAYS"]);
bill.ACTUALWORKDAYS = Convert.ToInt32(row["ACTUALWORKDAYS"]);
bill.PAYMENT = Convert.ToDouble(row["PAYMENT"]);
bills.Add(bill);
}
return(bills);
}
public override void Query(object source, StatQuery sq)
{
if (ReferenceEquals(source, this))
{
switch (sq.Statistic)
{
case Statistic.Attack:
sq.Result += baseAttack;
break;
case Statistic.Defense:
sq.Result += baseDefense;
break;
default:
throw new ArgumentOutOfRangeException();
}
}
else
{
if (sq.Statistic == Statistic.Defense)
{
sq.Result++;
}
}
}
public MiningStatsJob(NexusQuery nexusQuery, RedisCommand redisCommand, StatQuery statQuery, ILogger <MiningStatsJob> logger)
: base(10, logger)
{
_nexusQuery = nexusQuery;
_redisCommand = redisCommand;
_statQuery = statQuery;
}
public void Max_date()
{
var query = new StatQuery();
var data = query.Load(DateTime.Today, DateTime.Today);
Assert.That(data.ToKeyValuePairs().Count(), Is.GreaterThan(0));
}
public HomeController(BlockQuery blockQuery, TransactionQuery txQuery, RedisCommand redisCommand, StatQuery statQuery)
{
_blockQuery = blockQuery;
_txQuery = txQuery;
_redisCommand = redisCommand;
_statQuery = statQuery;
}
public NexplorerApiController(IMapper mapper, RedisCommand redis, ExchangeQuery exchangeQuery, StatQuery statQuery, AddressQuery addressQuery)
{
_mapper = mapper;
_redis = redis;
_exchangeQuery = exchangeQuery;
_statQuery = statQuery;
_addressQuery = addressQuery;
}
public ActionResult GetStatDetail(StatQuery query)
{
IAuthorFacadeService service = ServiceContainer.Instance.Container.Resolve <IAuthorFacadeService>();
query.JournalID = JournalID;
int pageIndex = TypeParse.ToInt(Request.Params["page"], 1);
IList <StatDealContributionDetailEntity> listStatDetail = service.GetDealContributionDetail(query);
return(Json(new { Rows = listStatDetail.Skip((pageIndex - 1) * 10).Take(10), Total = listStatDetail.Count }));
}
public override void Query(object source, StatQuery sq)
{
if (!ReferenceEquals(source, this) && sq.Statistic == Statistic.Attack)
{
sq.Result++; // every goblin gets +1 attack
}
else
{
base.Query(source, sq);
}
}
private void GetStatistics(DateTime fromDate, DateTime toDate, bool full)
{
var query = new StatQuery();
query.Full = full;
BindObjectInstance(query, "query");
var data = query.Load(fromDate, toDate);
foreach (var pair in data.ToKeyValuePairs())
{
var column = pair.Key;
var value = pair.Value;
if (column.ToString() != "LastDown" && column.ToString() != "LastForm")
{
value = TryToFixBrokenDateTimeValue(value);
if (value != DBNull.Value && column.DataType == typeof(DateTime))
{
var dateTimeValue = (DateTime)value;
value = dateTimeValue.ToLongTimeString();
}
}
PropertyBag[column.ColumnName] = value;
}
PropertyBag["WarningUpdateTime"] = false;
if (PropertyBag["LastForm"] != DBNull.Value && PropertyBag["LastDown"] != DBNull.Value)
{
var lastForm = DateTime.Parse(PropertyBag["LastForm"].ToString());
var lastDown = DateTime.Parse(PropertyBag["LastDown"].ToString());
PropertyBag["WarningUpdateTime"] = CheckFormalizeTime(lastDown, lastForm);
if (lastForm.ToLongDateString() == DateTime.Today.ToLongDateString())
{
PropertyBag["LastDown"] = lastDown.ToLongTimeString();
PropertyBag["LastForm"] = lastForm.ToLongTimeString();
}
}
Size("MaxMailSize");
Size("AvgMailSize");
Size("DownloadDataSize");
Size("DownloadDocumentSize");
InPercentOf("TotalNotSendCertificates", "TotalCertificates");
InPercentOf("TotalSendCertificates", "TotalCertificates");
DoConvert <double>("OrderSum", s => s.ToString("C"));
PropertyBag["FromDate"] = fromDate;
PropertyBag["ToDate"] = toDate;
PropertyBag["query"] = query;
}
public abstract void Query(object source, StatQuery sq);
