private void PopulateOrders()
{
if (InvokeRequired)
{
// Insure this is called in a GUI friendly thread.
Invoke((MethodInvoker) delegate { PopulateOrders(); });
return;
}
// Begin update.
marketBuyersList.BeginUpdate();
marketSellersList.BeginUpdate();
// Clear list.
marketBuyersList.Items.Clear();
marketSellersList.Items.Clear();
// Update region status.
ShowUpdatingRegions();
// Get type.
InvType type = marketTree.SelectedNode?.Tag as InvType;
// Get region.
RegionItem item = regionSelect.SelectedItem as RegionItem;
if (item != null && type != null && item.regionID != 0)
{
PopulateOrders(type.typeID, item.regionID);
}
// Complete update.
marketBuyersList.EndUpdate();
marketSellersList.EndUpdate();
}
/// <summary>
/// 折りたたみ範囲指定をセットする
/// </summary>
/// <param name="document">ドキュメント</param>
/// <param name="list">折りたたみ範囲指定オブジェクトリスト</param>
private List <FoldMarker> getRegionFoldMarker(IDocument document, RegionItem[] list)
{
List <FoldMarker> markerList = new List <FoldMarker>();
Stack <RegionItem> itemStack = new Stack <RegionItem>();
foreach (RegionItem item in list)
{
if (item.Position == RegionItem.Pos.Start) //開始位置
{
//開始位置を覚えておく
itemStack.Push(item);
}
else if (item.Position == RegionItem.Pos.End) //終了位置
{
if (itemStack.Count > 0)
{
//一番最近セットした開始位置を取得する
RegionItem startItem = itemStack.Pop();
if (startItem != null && item.LineNumber < document.TotalNumberOfLines)
{
//マークをセットする
markerList.Add(new FoldMarker(document, startItem.LineNumber - 1, 0
, item.LineNumber - 1, item.Text.Length - 1, FoldType.Region, startItem.Text));
}
}
}
}
return(markerList);
}
public void Inject(IModule module, object parameter)
{
var item = new RegionItem(owner.ViewModelLocator, owner.ViewLocator, owner.ViewModelStateSerializer, module, parameter);
items.Add(item);
DoForeachUIRegion(x => item.Inject(x, OnViewModelCreated));
TryNavigate();
}
public void Inject(IModule module, object parameter)
{
var item = new RegionItem(owner, module, parameter, LogicalState.Items.FirstOrDefault(x => x.Key == module.Key));
items.Add(item);
DoForeachUIRegion(x => item.Inject(x, OnViewModelCreated));
TryNavigate();
}
public void Inject(IModule module, object parameter)
{
var item = new RegionItem(viewModelLocator, viewLocator, stateSerializer, module, parameter);
items.Add(item);
DoForeachUIRegion(item.Inject);
TryNavigate();
}
public RegionDetailHomeVM(RegionItem regionItem)
{
regionAPI = new RegionAPI();
_region = regionItem;
ID = regionItem.tid;
//RegionName = regionItem.name;
RefreshCommand = new RelayCommand(Refresh);
LoadMoreCommand = new RelayCommand(LoadMore);
}
public int CompareTo(object obj)
{
RegionItem item = obj as RegionItem;
if (regionID <= 0 || item.regionID <= 0)
{
return(regionID.CompareTo(item.regionID));
}
return(name.CompareTo(item.name));
}
public override void Start()
{
base.Start();
try
{
SelectedCounty = Counties.FirstOrDefault(x => x.Id == 0);
SelectedSubCounty = SubCounties.FirstOrDefault(x => x.Id == 0);
SelectedWard = Wards.FirstOrDefault(x => x.Id == 0);
}
catch { }
}
public ClientContactViewModel(IDialogService dialogService, ISettings settings, IMetaService metaService) : base(dialogService, settings)
{
_metaService = metaService;
Step = 2;
Title = "Contacts";
MovePreviousLabel = "PREV";
MoveNextLabel = "NEXT";
Counties = RegionItem.Init("County");
SubCounties = RegionItem.Init("SubCounty");
Wards = RegionItem.Init("Ward");
}
public int Compare(RegionItem x, RegionItem y)
{
if (x.f > y.f)
{
return(1);
}
else if (x.f < y.f)
{
return(-1);
}
return(0);
}
private void GetWards()
{
Wards = RegionItem.Init("Ward");
try
{
if (null != SelectedSubCounty)
{
Wards = _metaService.GetWards(SelectedSubCounty.Id).ToList();
}
}
catch { }
}
public IEnumerable <RegionItem> GetWards(int subCountyId, bool addSelectOption = true)
{
var regions = new List <RegionItem>();
if (addSelectOption)
{
var initialSelected = RegionItem.CreateWardInitial();
regions.Add(initialSelected);
}
var wards = _regionRepository.GetWards(subCountyId).ToList();
if (wards.Any())
{
regions.AddRange(wards);
}
return(regions);
}
public IEnumerable <RegionItem> GetCounties(bool addSelectOption = true)
{
var regions = new List <RegionItem>();
if (addSelectOption)
{
var initialSelected = RegionItem.CreateCountyInitial();
regions.Add(initialSelected);
}
var counties = _regionRepository.GetCounties().ToList();
if (counties.Any())
{
regions.AddRange(counties);
}
return(regions);
}
private void UpdateSelectedRegion()
{
RegionItem item = regionSelect.SelectedItem as RegionItem;
if (item != null)
{
if (item.regionID > 0)
{
if (!updatingRegions.Contains(item.regionID))
{
updatingRegions.Add(item.regionID);
}
MarketRegionPage regionPage = Market.GetRegionPage(item.regionID, true);
if (regionPage != null)
{
regionPage.ScheduleRefresh();
}
}
PopulateOrders();
}
}
void SaveLogicalState(RegionItem item)
{
if (item == null)
{
return;
}
var info = LogicalState.Items.FirstOrDefault(x => x.Key == item.Key);
if (GetLogicalSerializationMode(item.Key) == LogicalSerializationMode.Disabled)
{
if (info != null)
{
LogicalState.Items.Remove(info);
}
return;
}
bool isInjected = items.Contains(item);
var actualInfo = item.GetLogicalInfo();
if (actualInfo == null)
{
if (info != null)
{
info.IsInjected = false;
}
return;
}
if (info == null)
{
LogicalState.Items.Add(actualInfo);
actualInfo.IsInjected = isInjected;
return;
}
info.IsInjected = isInjected;
info.ViewModelName = actualInfo.ViewModelName;
info.ViewModelState = actualInfo.ViewModelState;
info.ViewModelStateType = actualInfo.ViewModelStateType;
info.ViewName = actualInfo.ViewName;
}
private void Market_RegionUpdate(int regionID)
{
if (InvokeRequired)
{
// Insure this is called in a GUI friendly thread.
Invoke((MethodInvoker) delegate { Market_RegionUpdate(regionID); });
return;
}
if (updatingRegions.Contains(regionID))
{
// Remove region from updating status.
updatingRegions.RemoveAll(r => r == regionID);
}
// Get region.
RegionItem item = regionSelect.SelectedItem as RegionItem;
if (item?.regionID == regionID)
{
// Our current region updated... Refresh the list.
PopulateOrders();
}
}
public override void LoadFromStore(VMStore modelStore)
{
try
{
ContactAddress = JsonConvert.DeserializeObject <ClientContactAddressDTO>(modelStore.Store);
PersonId = ContactAddress.PersonId;
Downloaded = ContactAddress.Downloaded;
Telephone = ContactAddress.Phone;
Landmark = ContactAddress.Landmark;
ContactId = ContactAddress.ContactId;
AddressId = ContactAddress.AddressId;
SelectedCounty = Counties.FirstOrDefault(x => x.Id == 0);
SelectedSubCounty = SubCounties.FirstOrDefault(x => x.Id == 0);
SelectedWard = Wards.FirstOrDefault(x => x.Id == 0);
if (ContactAddress.CountyId.HasValue && ContactAddress.CountyId.Value > 0)
{
SelectedCounty = Counties.FirstOrDefault(x => x.Id == ContactAddress.CountyId);
GetSubCounties();
}
if (ContactAddress.SubCountyId.HasValue && ContactAddress.SubCountyId.Value > 0)
{
SelectedSubCounty = SubCounties.FirstOrDefault(x => x.Id == ContactAddress.SubCountyId);
GetWards();
}
if (ContactAddress.WardId.HasValue && ContactAddress.WardId.Value > 0)
{
SelectedWard = Wards.FirstOrDefault(x => x.Id == ContactAddress.WardId);
}
}
catch (Exception e)
{
Mvx.Error(e.Message);
}
}
private string getTrafficFromRegion(string distributor, string startDate, string endDate, string blog)
{
combineBlogDistributor(blog, distributor);
string strSQL;
try
{
string strClause = String.IsNullOrEmpty(startDate) ? "" : string.Format(" and convert(date, visit_time) >= '{0}'", startDate);
string strClause2 = String.IsNullOrEmpty(endDate) ? "" : string.Format(" and convert(date, visit_time) <= '{0}'", endDate);
//strSQL = string.Format("select top 10 city, COUNT(*) as visit, COUNT(*) * 1.0 / SUM(COUNT(*)) over() as percentage, SUM(COUNT(*)) over() as total, province, country from tb_page_visit_info_xango where distributor='{0}'{1}{2} group by city, province, country order by percentage desc", distributor, strClause, strClause2);
strSQL = string.Format("select top 10 f.city, COUNT(*) as visit, COUNT(*) * 1.0 / SUM(COUNT(*)) over() as percentage, SUM(COUNT(*)) over() as total, f.province, f.country from (select b.city, b.province, b.country from tb_page_visit_info_xango as a , tb_geolocation as b where a.ip = b.ip and a.distributor = '{0}'{1}{2}) as f group by f.city, f.province, f.country order by percentage desc", distributor, strClause, strClause2);
}
catch (Exception e)
{
AdssLogger.WriteLog("GetSampleAnalyticsInfo(getTrafficFromRegion) --- Exception: " + e.Message);
return "{}";
}
try
{
using (SqlConnection sc = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlserver"].ConnectionString))
{
if (sc != null)
{
DataSet ds = SqlHelper.ExecuteDataset(sc, CommandType.Text, strSQL);
if (ds != null && ds.Tables.Count > 0)
{
TopFiveStatRegion tfs = new TopFiveStatRegion();
tfs.list = new List<RegionItem>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow r = ds.Tables[0].Rows[i];
RegionItem pv = new RegionItem();
pv.page = Convert.ToString(r[0]);
pv.count = Convert.ToInt32(r[1]);
pv.percentage = string.Format("{0:P1}", Convert.ToSingle(r[2]));
pv.province = Convert.ToString(r[4]);
pv.country = Convert.ToString(r[5]);
tfs.list.Add(pv);
tfs.total = Convert.ToInt32(r[3]);
}
return new JavaScriptSerializer().Serialize(tfs);
}
}
}
}
catch (Exception e)
{
//Trace.WriteLine(e.Message);
AdssLogger.WriteLog("GetSampleAnalyticsInfo(getTrafficFromRegion) --- Exception: " + e.Message + " --- sql: " + strSQL);
}
return "{}";
}
public ActionResult RegionUpdate([DataSourceRequest] DataSourceRequest request, RegionItem regionItem)
{
if (regionItem != null && ModelState.IsValid)
{
service.UpdateRegion(regionItem);
}
return(Json(new[] { regionItem }.ToDataSourceResult(request, ModelState)));
}
public ActionResult RegionDelete([DataSourceRequest] DataSourceRequest request, RegionItem regionItem)
{
if (regionItem != null)
{
service.DeleteRegion(regionItem);
}
return(Json(new[] { regionItem }.ToDataSourceResult(request, ModelState)));
}
