private void LoadSalesData()
{
CD_DomainContext context = new CD_DomainContext();
string cdIds = DBUtils.Get_CD_ProductIDs(Utils.GetBrandCode(_productBrand));
if (GetDosageSaCodes() != "")
cdIds = DBUtils.GetCdProductIds(GetDosageSaCodes());
if (this._regionType == SanofiRegionTypes.Province)
context.Load(context.GetProvince_PerCustomer_PerDistributor_PerChannelQuery(cdIds, _startDate, _endDate, DBUtils.Get_CD_ProvinceIds(_groupRegionMapId, _productBrand), _selectedDistributorsIds), ProvincePerCustomerPerDistributorPerChannel_Callback, null);
else if (this._regionType == SanofiRegionTypes.TotalIR)
context.Load(context.GetTotal_PerCustomer_PerDistributor_PerChannelQuery(cdIds, _startDate, _endDate, _selectedDistributorsIds), TotalPerCustomerPerDistributorPerChannel_Callback, null);
}
private void LoadActualSales_Async()
{
CD_DomainContext context = new CD_DomainContext();
DateTime start = new DateTime(_endYear - 2,1,1);
DateTime end = new DateTime(_endYear, _endMonth, 1).AddMonths(1).AddSeconds(-1);
LoadOperation<AccountsPerMonth> loadOp = context.Load(context.GetAccounts_PerMonthQuery(DBUtils.Get_CD_ProductIDs(Utils.GetBrandCode(_productBrand)), start,end, Utils.GetStringSeperated(_dsIds, "-")), Accounts_PerMonth_ResultCallBack, null);
}
private void LoadActualSales_Async()
{
CD_DomainContext context = new CD_DomainContext();
string cdIds = DBUtils.Get_CD_ProductIDs(Utils.GetBrandCode(_productBrand));
if (GetDosageSaCodes() != "")
cdIds = DBUtils.GetCdProductIds(GetDosageSaCodes());
LoadOperation<TotalActualPerProvincePerMonth> loadOp = context.Load(context.GetTotalActual_PerProvince_PerMonthQuery(cdIds, new DateTime(_startYear - 1,_startMonth,1),new DateTime(_endYear,_endMonth,1).AddMonths(1).AddMinutes(-1)),TotalActualPerProvincePerMonth_ResultCallBack,null);
}
private void LoadActualSales_Async()
{
if (this._regionType == SanofiRegionTypes.Province)
{
CD_DomainContext context = new CD_DomainContext();
string cdIds = DBUtils.Get_CD_ProductIDs(Utils.GetBrandCode(_productBrand));
if (GetDosageSaCodes() != "")
cdIds = DBUtils.GetCdProductIds(GetDosageSaCodes());
context.Load(context.GetProvinceActual_PerMonthQuery(cdIds, new DateTime(_endYear - 1, 1, 1), new DateTime(_endYear, _endMonth, 1).AddMonths(1).AddSeconds(-1), DBUtils.Get_CD_ProvinceIds(_groupRegionMapId, _productBrand)), ProvinceActualPerMonth_ResultCallBack, null);
}
else if (this._regionType == SanofiRegionTypes.TotalIR)
_DAT_DomainContext.Load(_DAT_DomainContext.GetTotalActual_PerMonthQuery(Utils.GetBrandCode(_productBrand), 1, _endYear - 1, _endMonth, _endYear, GetDosageSaCodes()), TotalActual_PerMonth_ResultCallBack, null);
}
private void LoadNumberOfClientsFromCdDatabase()
{
string cdIds = DBUtils.Get_CD_ProductIDs(Utils.GetBrandCode(_productBrand));
if (GetDosageSaCodes() != "")
cdIds = DBUtils.GetCdProductIds(GetDosageSaCodes());
if (_regionType == SanofiRegionTypes.TotalIR)
{
CD_DomainContext context = new CD_DomainContext();
context.Load(context.GetTotal_Clients_PerDist_PerQuarterQuery(cdIds, _startDate, _endDate), TotalClientsPerDistPerQuarter_ResultCallBack, null);
}
else if (_regionType == SanofiRegionTypes.Province)
{
CD_DomainContext context = new CD_DomainContext();
context.Load(context.GetProvince_Clients_PerDist_PerQuarterQuery(cdIds, _startDate, _endDate, DBUtils.Get_CD_ProvinceIds(_groupRegionMapId, _productBrand)), ProvinceClientsPerDistPerQuarter_ResultCallBack, null);
}
}
private void LoadActual_Async()
{
_provinceActualQty = new Dictionary<int, double>();
_provinceActualVal = new Dictionary<int, double>();
_provinceLastYearActualQty = new Dictionary<int, double>();
_provinceLastYearActualVal = new Dictionary<int, double>();
CD_DomainContext context = new CD_DomainContext();
string cdIds = DBUtils.Get_CD_ProductIDs(Utils.GetBrandCode(_productBrand));
if (GetDosageSaCodes() != "")
cdIds = DBUtils.GetCdProductIds(GetDosageSaCodes());
context.Load<TotalActualPerProvincePerMonth>(context.GetTotalActual_PerProvince_PerMonthQuery(cdIds, _startDate, _endDate), TotalActualPerProvincePerMonth_ThisYear_ResultCallBack, null);
}
private void LoadDate()
{
CD_DomainContext context = new CD_DomainContext();
string cdIds = DBUtils.Get_CD_ProductIDs(Utils.GetBrandCode(_productBrand));
if (GetDosageSaCodes() != "")
cdIds = DBUtils.GetCdProductIds(GetDosageSaCodes());
if (_regionType == SanofiRegionTypes.TotalIR)
{
context.Load<TotalSalesPerDSDaily>(context.GetTotalSales_PerDS_DailyQuery(cdIds, _startDate, _endDate), TotalSalesPerDSDaily_ResultCallBack, null);
}
else if (_regionType == SanofiRegionTypes.Province)
{
context.Load<ProvinceSalesPerDSDaily>(context.GetProvinceSales_PerDS_DailyQuery(cdIds, _startDate, _endDate, DBUtils.Get_CD_ProvinceIds(_groupRegionMapId, _productBrand)), ProvinceSalesPerDSDaily_ResultCallBack, null);
}
}
public static void Load_CD_DataRange()
{
try
{
CD_DomainContext context = new CD_DomainContext();
LoadOperation<CDDataRange> loadOp = context.Load(context.GetDataRangeQuery(), CD_DataRange_Loaded, null);
}
catch (Exception ex)
{
string msg = ex.Message;
if (ex.InnerException != null)
msg += ("Inner: \n" + ex.InnerException.Message);
System.IO.File.WriteAllText(@"C:\inetpub\wwwroot\snfgis\loadcd_datarange1_error.txt", msg);
}
}
public void TotalActualPerProvincePerMonth_ThisYear_ResultCallBack(LoadOperation<TotalActualPerProvincePerMonth> result)
{
if (Utils.LoadOperation_Error_Handled(result.Error, "CD"))
{
_loadedDataThisYear = new List<TotalActualPerProvincePerMonth>();
foreach (TotalActualPerProvincePerMonth dataItem in result.Entities)
{
_loadedDataThisYear.Add(dataItem);
if (!DBUtils.Null_Handled(dataItem))
continue;
Add_to_Province_ThisYear_Actual_Dictionaries((int)dataItem.QTY, (int)dataItem.ProductID, new DateTime((int)dataItem.YearT,(int)dataItem.MonthT,1).AddMonths(1).AddSeconds(-1), (int)dataItem.ProvinceID);
Add_to_Provinces_With_Actual((int)dataItem.ProvinceID);
}
CD_DomainContext context = new CD_DomainContext();
context.Load<TotalActualPerProvincePerMonth>(context.GetTotalActual_PerProvince_PerMonthQuery(DBUtils.Get_CD_ProductIDs(Utils.GetBrandCode(_productBrand)), _startDate.AddYears(-1), _endDate.AddYears(-1)), TotalActualPerProvincePerMonth_LastYear_ResultCallBack, null);
}
}
/*
private void AfterDraw(string position)
{
Snf.Silver.Main.GisService.Polygon region = new Snf.Silver.Main.GisService.Polygon
{
Caption = "",
Description = ""
};
region.Points = new System.Collections.ObjectModel.ObservableCollection<GisService.Point>();
string[] splits = position.Split(new char[] { ',' });
foreach (string split in splits)
{
string[] coords = split.Split(new char[] { ' ' });
region.Points.Add(new Snf.Silver.Main.GisService.Point { X = Convert.ToDouble(coords[0]), Y = Convert.ToDouble(coords[1]) });
}
//_gisService.CreateRegionAsync(1, region);
}*/
void MapPolygon_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
ChangeDeselectedPolygonsColorToOriginalColor();
var selectedPolygon = (sender as BIT.AVL.Silver.Map.Geometry.Polygon);
_selectedRegoinOrginalColor = selectedPolygon.FillColor;
_selectedRegionsOpacity = new Dictionary<int, double>();
_selectedRegionMapId = GetRegionMapId(selectedPolygon.TempID);
foreach (BIT.AVL.Silver.Map.Geometry.Polygon p in DrawControl.DrawLayer.Children)
{
if (GetRegionGroupId(p.TempID) == GetRegionGroupId(selectedPolygon.TempID))
{
_selectedRegionsOpacity.Add(GetRegionMapId(p.TempID), p.Opacity);
ChangeSelectedPolygonsColorToOrange(p);
}
}
SetMenusButton(DBUtils.GetGroupRegionName(_selectedRegionMapId, (SanofiProductBrands) _selected_Product));
if (_selected_RegionType == SanofiRegionTypes.Tehran)
{
ShowShowLocations();
if (DistrictDSIDs.ContainsKey(DBUtils.GetDistrictId(_selectedRegionMapId)))
{
EnableShowLocations();
}
else
{
DisableShowLocations();
CD_DomainContext context = new CD_DomainContext();
context.Load(context.GetDSID_PerDistrictQuery(DBUtils.GetDistrictId(_selectedRegionMapId) + ""), DSID_PerDistrict_ResultCallback, null);
}
}
}
public void DSID_PerDistrict_ResultCallback(LoadOperation<DSID_PerDistrict> result)
{
if (result.Error == null)
{
foreach (DSID_PerDistrict dataItem in result.Entities)
{
if (dataItem.DistrictID == null)
continue;
if (DistrictDSIDs.ContainsKey((int)dataItem.DistrictID))
{
if (DistrictDSIDs[(int)dataItem.DistrictID].Where<DSID_PerDistrict>(d => d.DSID == dataItem.DSID ).Count<DSID_PerDistrict>() < 1)
DistrictDSIDs[(int)dataItem.DistrictID].Add(dataItem);
}
else
{
DistrictDSIDs.Add((int)dataItem.DistrictID, new List<DSID_PerDistrict>() { dataItem });
}
}
if (DistrictDSIDs != null && DistrictDSIDs.ContainsKey(DBUtils.GetDistrictId(_selectedRegionMapId)) && DistrictDSIDs[DBUtils.GetDistrictId(_selectedRegionMapId)].Count > 0)
EnableShowLocations();
}
if (result.UserState != null)
{
object[] state = (object[])result.UserState;
if (!IsLoading("GetTotalActual_PerDistrict_PerMonthQuery", state))
{
SanofiProductBrands product = (SanofiProductBrands)state[0];
int startM = (int)state[1];
int startY = (int)state[2];
int endM = (int)state[3];
int endY = (int)state[4];
CD_DomainContext context = new CD_DomainContext();
AddtoLoadingList("GetTotalActual_PerDistrict_PerMonthQuery", state);
DateTime start = new DateTime(startY, startM, 1);
DateTime end = new DateTime(endY, endM, 1).AddMonths(1).AddSeconds(-1);
// context.Load(context.GetTotalActual_PerDistrict_PerMonthQuery(DBUtils.Get_CD_ProductIDs(Utils.GetBrandCode(product)), start, end, "6-2-3-5-21", "28348-85784*65561-28079*29549-33865*83023*32929"), TotalActualPerDistrictPerMonth_ResultCallback, state);
string pids = DBUtils.Get_CD_ProductIDs(Utils.GetBrandCode(product));
string distids =GetListStringDistrictIds();
// string dsids = GetListOfDSIDs();
context.Load(context.GetTotalActual_PerDistrict_PerMonthQuery(pids, start, end,distids), TotalActualPerDistrictPerMonth_ResultCallback, state);
}
}
}
private void LoadTehranResult(SanofiProductBrands product, int startM, int startY, int endM, int endY)
{
object[] state = { product, startM, startY, endM, endY };
CD_DomainContext context = new CD_DomainContext();
context.Load(context.GetDSID_PerDistrictQuery(""), DSID_PerDistrict_ResultCallback, state);
}
private void LoadProvinceResult(SanofiProductBrands product, int startM, int startY, int endM, int endY)
{
object[] state = { product, startM, startY, endM, endY };
if (!IsLoading("GetTotalActual_PerProvince_PerMonthQuery", state))
{
CD_DomainContext context = new CD_DomainContext();
AddtoLoadingList("GetTotalActual_PerProvince_PerMonthQuery", state);
DateTime start = new DateTime(startY, startM, 1);
DateTime end = new DateTime(endY, endM, 1).AddMonths(1).AddSeconds(-1);
context.Load(context.GetTotalActual_PerProvince_PerMonthQuery(DBUtils.Get_CD_ProductIDs(Utils.GetBrandCode(product)), start, end ), TotalActualPerProvincePerMonth_ResultCallback, state);
}
}
private void LoadDistributorsMonthly()
{
CD_DomainContext context = new CD_DomainContext();
string cdIds = DBUtils.Get_CD_ProductIDs(Utils.GetBrandCode(_productBrand));
if (GetDosageSaCodes() != "")
cdIds = DBUtils.GetCdProductIds(GetDosageSaCodes());
DateTime start = new DateTime(_startYear, _startMonth, 1);
DateTime end = new DateTime(_endYear, _endMonth, 1).AddMonths(1).AddSeconds(-1);
if (this._regionType == SanofiRegionTypes.Province)
context.Load(context.GetProvince_PerDistributorQuery(cdIds, start,end , DBUtils.Get_CD_ProvinceIds(_groupRegionMapId, _productBrand)), ProvincePerDistributor_ResultCallback, null);
else if (this._regionType == SanofiRegionTypes.TotalIR)
context.Load(context.GetTotal_PerDistributorQuery(cdIds, start, end), TotalPerDistributor_ResultCallack, null);
}
