public YTDYTG(SanofiProductBrands productBrand, DateTime endDate, string dosageName)
{
InitializeComponent();
_productBrand = productBrand;
_endDate = endDate;
_dosageName = dosageName;
SetDosageCombo();
}
public Bubble(SanofiProductBrands productBrand, DateTime startDate, DateTime endDate, string dosageName)
{
InitializeComponent();
_productBrand = productBrand;
_startDate = startDate;
_endDate = endDate;
_dosageName = dosageName;
SetTitle();
SetDosageCombo();
}
public SalesPerDSDaily(SanofiProductBrands productBrand, SanofiRegionTypes regionType, DateTime startDate, DateTime endDate, int aGroupRegionMapId, string dosageName)
{
InitializeComponent();
_productBrand = productBrand;
_regionType = regionType;
_startDate = startDate;
_endDate = endDate;
_groupRegionMapId = aGroupRegionMapId;
_dosageName = dosageName;
SetDosageCombo();
}
public DistributorsMatOutQuarterly(SanofiProductBrands productBrand, SanofiRegionTypes regionType, int aGroupRegionMapId, DateTime startDate, DateTime endDate, string dosageName)
{
InitializeComponent();
_productBrand = productBrand;
_regionType = regionType;
_groupRegionMapId = aGroupRegionMapId;
_startDate = startDate;
_endDate = endDate;
_dosageName = dosageName;
SetTitle();
SetDosageCombo();
}
public ShareOfRegion(SanofiProductBrands productBrand, int startmonth, int startyear, int endmonth, int endyear, string dosageName)
{
InitializeComponent();
_productBrand = productBrand;
_startMonth = startmonth;
_startYear = startyear;
_endMonth = endmonth;
_endYear = endyear;
_dosageName = dosageName;
Initialize_MonthWith_Dictionaries();
SetTitle();
SetDosageCombo();
}
public DistributorsMonthly(SanofiProductBrands productBrand, SanofiRegionTypes regionType, int aGroupRegionMapId, int startM, int startY, int endM, int endY, string dosageName)
{
InitializeComponent();
_productBrand = productBrand;
_regionType = regionType;
_groupRegionMapId = aGroupRegionMapId;
_startMonth = startM;
_startYear = startY;
_endMonth = endM;
_endYear = endY;
_dosageName = dosageName;
SetTitle();
SetDosageCombo();
}
public CustomersRanking(SanofiProductBrands product, SanofiRegionTypes regionType, int aGroupRegionMapId, int startMonth, int startYear, int endMonth, int endYear, string dosageName)
{
InitializeComponent();
_productBrand = product;
_startMonth = startMonth;
_startYear = startYear;
_endMonth = endMonth;
_endYear = endYear;
_regionType = regionType;
_groupRegionMapId = aGroupRegionMapId;
_dosageName = dosageName;
SetDosageCombo();
Initialize_MonthWith_Dictionaries();
SetTitle();
}
public AccountMatOut(SanofiProductBrands product,SanofiRegionTypes regionType, int aGroupRegionMapId, int endMonth, int endYear, List<AccountGridObj> accounts)
{
InitializeComponent();
_productBrand = product;
_endMonth = endMonth;
_endYear = endYear;
_dsIds = new List<string>();
foreach (AccountGridObj a in accounts)
{
_dsIds.AddRange(a.DisCustomerCodes);
_dsIdsString += "-"+ a.DSID;
}
_dsIdsString = (_dsIdsString == "") ? "" : _dsIdsString.Substring(1);
_accounts = accounts;
_regionType = regionType;
_groupRegionMapId = aGroupRegionMapId;
_loadedData = new List<CommonRawData>();
SetTitle();
Initialize_MonthWith_Dictionaries();
InitializeCollections();
}
public SalesTeamWindow(SanofiProductBrands productBrand, SanofiRegionTypes regionT , int aRegionMapId, string regionName,int startmonth, int startyear, int endmonth, int endyear)
{
InitializeComponent();
_productBrand = productBrand;
_startMonth = startmonth;
_startYear = startyear;
_endMonth = endmonth;
_endYear = endyear;
_regionMapId = aRegionMapId;
_regionType = regionT;
if (regionT == SanofiRegionTypes.Province)
{
_groupRegionMapIds = DBUtils.GetGroupMember_RegionMapIdsList(aRegionMapId, _productBrand);
LoadOperation<TotalSalesTeam> loadOp = _optimaContext.Load(_optimaContext.Get_ProvinceSalesTeamQuery(Utils.GetOptimaCode(_productBrand), _startMonth, _startYear, _endMonth, _endYear,Utils.GetStringSeperated2(_groupRegionMapIds,"-")), TotalSalesTeam_ResultCallBack, null);
}
else
{
LoadOperation<TotalSalesTeam> loadOp = _optimaContext.Load(_optimaContext.Get_TotalSalesTeamQuery(Utils.GetOptimaCode(_productBrand), _startMonth, _startYear, _endMonth, _endYear), TotalSalesTeam_ResultCallBack, null);
}
SetTitle();
}
public static bool IfVolumeRadioShouldBeEnabledForDosage(SanofiProductBrands product)
{
if (product == SanofiProductBrands.Depakine)
return true;
return false;
}
public static bool IfVolumeRadioShouldBeDisabled(SanofiProductBrands product)
{
if (product == SanofiProductBrands.Clexane || product == SanofiProductBrands.Depakine || product == SanofiProductBrands.TotalProducts)
return true;
return false;
}
public static string GetOptimaCode(SanofiProductBrands product)
{
switch (product)
{
case SanofiProductBrands.Plavix:
return "PLAVIX";
case SanofiProductBrands.Clexane:
return "CLEXAN";
case SanofiProductBrands.Taxotere:
return "TAXOTE";
case SanofiProductBrands.Targocid:
return "TARGOC";
case SanofiProductBrands.Lantus:
return "LANTUS";
case SanofiProductBrands.Eloxatin:
return "ELOXAT";
}
return "";
}
private static bool AreReasonableParameters(SanofiProductBrands product, int startMonth, int startY, int endMonth, int endY)
{
return ((product == SanofiProductBrands.Clexane || product == SanofiProductBrands.Eloxatin || product == SanofiProductBrands.Lantus
|| product == SanofiProductBrands.Plavix || product == SanofiProductBrands.Targocid || product == SanofiProductBrands.Taxotere
|| product == SanofiProductBrands.Stilnox || product == SanofiProductBrands.Telfast || product == SanofiProductBrands.Depakine /*|| product == SanofiProductBrands.Epilim */
|| product == SanofiProductBrands.Jevtana || product == SanofiProductBrands.Primacor || product == SanofiProductBrands.Thymo
|| product == SanofiProductBrands.Renagel || product == SanofiProductBrands.Phenergan || product == SanofiProductBrands.Rilutek
|| product == SanofiProductBrands.Fludara || product == SanofiProductBrands.Evoltra || product == SanofiProductBrands.Suprefact
|| product == SanofiProductBrands.Glucantime || product == SanofiProductBrands.Trental || product == SanofiProductBrands.Mozobil || product == SanofiProductBrands.Apidra || product == SanofiProductBrands.TotalProducts
|| product == SanofiProductBrands.Cardio || product == SanofiProductBrands.Onco || product == SanofiProductBrands.Diabetes
|| product == SanofiProductBrands.CNS || product == SanofiProductBrands.CHC || product == SanofiProductBrands.Antibiotic
|| product == SanofiProductBrands.OtherEthical || product == SanofiProductBrands.OtherProducts) &&
startMonth >= 1 && startMonth <= 12 && endMonth >= 1 && endMonth <= 12 && startY > 0 && endY > 0 && endY >= startY && (endMonth >= startMonth || endY > startY));
}
private void ConditionChanged(SanofiProductBrands product, SanofiRegionTypes regionT, int startMonth, int startYear, int endMonth, int endYear)
{
SetPageForStartOfLoadData();
ClearPage();
if (AreReasonableParameters((SanofiProductBrands)_selected_Product, _selected_StartMonth, _selected_StartYear, _selected_EndMonth, _selected_EndYear))
{
LoadNewConditionData(product, regionT, startMonth, endMonth, startYear, endYear);
SetPageByData(_regionsData, regionT);
}
else
{
SetPageForEndOfLoadData();
}
}
public static string GetUnitLabel_Long(SanofiProductBrands product, bool isvalue, KilooMega KM)
{
string valUnit = "(Euro)";
if (KM == KilooMega.Kiloo)
valUnit = "(KEuro)";
else if (KM == KilooMega.Mega)
valUnit = "(MEuro)";
string qtyUnit = "";
if (KM == KilooMega.Kiloo)
qtyUnit = "(000)";
else if (KM == KilooMega.Mega)
qtyUnit = "(000,000)";
switch (product)
{
case SanofiProductBrands.Clexane:
return "Value " + valUnit;
case SanofiProductBrands.Eloxatin:
if (isvalue)
return "Value " + valUnit;
else
return "Volume (Equ. 100)" + qtyUnit;
case SanofiProductBrands.Lantus:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Plavix:
if (isvalue)
return "Value " + valUnit;
else
return "QTY (BOX 28)" + qtyUnit;
case SanofiProductBrands.Targocid:
if (isvalue)
return "Value " + valUnit;
else
return "Volume (Equ. 400)" + qtyUnit;
case SanofiProductBrands.Taxotere:
if (isvalue)
return "Value " + valUnit;
else
return "Volume (Equ. 80)" + qtyUnit;
case SanofiProductBrands.Telfast:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Depakine:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
/*case SanofiProductBrands.Epilim:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;*/
case SanofiProductBrands.Jevtana:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Primacor:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Thymo:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Renagel:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Stilnox:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Phenergan:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Rilutek:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Fludara:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Evoltra:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Suprefact:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Glucantime:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Trental:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Mozobil:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Apidra:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.TotalProducts:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Cardio:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Onco:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Diabetes:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.CNS:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.CHC:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.Antibiotic:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.OtherEthical:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
case SanofiProductBrands.OtherProducts:
if (isvalue)
return "Value " + valUnit;
else
return "Volume " + qtyUnit;
}
return "";
}
public static List<string> GetGroupMember_DATRegionCodesList(int aRegionMapId, SanofiProductBrands product)
{
if (!IsProvinceDataLoaded())
return null;
List<string> result = new List<string>();
List<int> productMapIds = DBUtils.GetAllProductMapIds(product);
int provinceGroupId = -1;
// find the province group id
foreach (ProvinceGroupingView pgv in _provinceGroupingView)
{
foreach (int pid in productMapIds)
{
if (pid == pgv.ProductMapID && pgv.RegionMapID == aRegionMapId)
{
provinceGroupId = pgv.GroupID;
break;
}
}
if (provinceGroupId != -1)
break;
}
// get all the region codes in that group
foreach (ProvinceGroupingView pgv in _provinceGroupingView)
if (pgv.GroupID == provinceGroupId)
if (!result.Contains(pgv.DAT_REGIONCODE))
result.Add(pgv.DAT_REGIONCODE);
if (result.Count == 0)
result.Add(DBUtils.Get_Dat_RegionCode2(aRegionMapId));
return result;
}
/*
public static string Get_Dat_GroupRegionCode(int aRegionCode, SanofiProductBrands product, bool isRegionMapId)
{
if (!IsProvinceDataLoaded())
return "";
if (isRegionMapId)
{
List<int> productMapIds = DBUtils.GetAllProductMapIds(product);
foreach (ProvinceGroupingView pgv in _provinceGroupingView)
if (pgv.CD_ProvinceID == GetCdProvinceId(aRegionCode))
foreach (int pid in productMapIds)
if (pid == pgv.ProductMapID)
return pgv.ParentRegionCode;
foreach (RegionMap rm in _regionMapTable)
if (rm.RegionMapID == aRegionCode)
return rm.DAT_REGIONCODE;
return "";
}
else
{
List<int> productMapIds = DBUtils.GetAllProductMapIds(product);
foreach (ProvinceGroupingView pgv in _provinceGroupingView)
if (pgv.CD_ProvinceID == aRegionCode)
foreach (int pid in productMapIds)
if (pid == pgv.ProductMapID)
return pgv.ParentRegionCode;
foreach (RegionMap rm in _regionMapTable)
if (rm.CD_ProvinceID == aRegionCode)
return rm.DAT_REGIONCODE;
return "";
}
/*
foreach (RegionMap rm in _regionMapTable)
{
string datRegionCode = Get_Dat_RegionCode(cdProvinceId);
if (datRegionCode != null && datRegionCode != "" &&
rm.DAT_REGIONCODE.Trim().ToLower() == datRegionCode.ToLower().Trim())
return rm.DAT_GROUPREGIONCODE;
}
}*/
public static string GetGroupRegionName(int aRegionMapId, SanofiProductBrands product)
{
//foreach (RegionMap rm in _regionMapTable)
// if (rm.DAT_REGIONCODE.Trim().ToLower() == datRegionCode.ToLower().Trim())
// return rm.DAT_GROUPREGIONNAME;
//return "";
/* if (!IsProvinceDataLoaded() || datRegionCode == null)
return "";
List<int> productMapIds = DBUtils.GetAllProductMapIds(product);
foreach (ProvinceGroupingView pgv in _provinceGroupingView)
if (Utils.String_Trim_ToLower_Equals(pgv.DAT_REGIONCODE, datRegionCode))
foreach (int pid in productMapIds)
if (pid == pgv.ProductMapID)
return pgv.GroupName;
foreach (RegionMap rm in _regionMapTable)
if (Utils.String_Trim_ToLower_Equals(rm.DAT_REGIONCODE, datRegionCode))
return rm.DAT_EnREGIONNAME;
return "";*/
if (!IsProvinceDataLoaded() || aRegionMapId == -1)
return "";
List<int> productMapIds = DBUtils.GetAllProductMapIds(product);
foreach (ProvinceGroupingView pgv in _provinceGroupingView)
if (pgv.RegionMapID == aRegionMapId)
foreach (int pid in productMapIds)
if (pid == pgv.ProductMapID)
return pgv.GroupName;
foreach (RegionMap rm in _regionMapTable)
if (rm.RegionMapID == aRegionMapId)
return GetRegionName(aRegionMapId);
return "";
}
public static int GetGroupRegionMapId(int aRegionMapId, SanofiProductBrands product)
{
if (!IsProvinceDataLoaded() || aRegionMapId == -1)
return -1;
List<int> productMapIds = DBUtils.GetAllProductMapIds(product);
foreach (ProvinceGroupingView pgv in _provinceGroupingView)
if (pgv.RegionMapID == aRegionMapId)
foreach (int pid in productMapIds)
if (pid == pgv.ProductMapID)
return pgv.ParentRegionMapID;
//foreach (RegionMap rm in _regionMapTable)
// if (rm.DAT_REGIONCODE.Trim().ToLower() == datRegionCode.ToLower().Trim())
// return rm.DAT_GROUPREGIONCODE;
return aRegionMapId;
}
public static string Get_GroupName(int regionMapId, SanofiProductBrands product)
{
if (!IsProvinceDataLoaded())
return "";
List<int> productMapIds = DBUtils.GetAllProductMapIds(product);
foreach (ProvinceGroupingView pgv in _provinceGroupingView)
foreach (int id in productMapIds)
if (pgv.RegionMapID == regionMapId && pgv.ProductMapID == id)
return pgv.GroupName;
foreach (RegionMap rm in _regionMapTable)
if (rm.RegionMapID == regionMapId)
return rm.DAT_EnREGIONNAME;
return "";
}
private static List<string> GetAllCdProductBrands(SanofiProductBrands product)
{
List<string> result = new List<string>();
foreach (ProductMap pm in _productMapTable)
if (Utils.String_Trim_ToLower_Equals(Utils.GetBrandCode(product), pm.DAT_BRANDCODE))
if (!result.Contains(pm.CD_BrandDIName) && pm.CD_BrandDIName != null)
result.Add(pm.CD_BrandDIName);
return result;
}
public static List<int> GetAllProductMapIds(SanofiProductBrands product)
{
if (!Is_ProductMapTable_Loaded())
return null;
List<int> result = new List<int>();
foreach (ProductMap pm in _productMapTable)
foreach(string cdBrand in GetAllCdProductBrands(product))
if (Utils.String_Trim_ToLower_Equals(pm.CD_BrandDIName, cdBrand))
result.Add(pm.ProductMapID);
return result;
}
public static bool IfSalesTeamReportShouldBeDisable(SanofiProductBrands product)
{
if (product == SanofiProductBrands.Telfast || product == SanofiProductBrands.Depakine /*|| product == SanofiProductBrands.Epilim*/ || product == SanofiProductBrands.Jevtana
|| product == SanofiProductBrands.Primacor || product == SanofiProductBrands.Thymo || product == SanofiProductBrands.Renagel
|| product == SanofiProductBrands.Stilnox || product == SanofiProductBrands.Phenergan || product == SanofiProductBrands.Rilutek
|| product == SanofiProductBrands.Fludara || product == SanofiProductBrands.Evoltra || product == SanofiProductBrands.Suprefact
|| product == SanofiProductBrands.Glucantime || product == SanofiProductBrands.Trental || product == SanofiProductBrands.Mozobil || product == SanofiProductBrands.Trental || product == SanofiProductBrands.TotalProducts
|| product == SanofiProductBrands.Cardio || product == SanofiProductBrands.Onco || product == SanofiProductBrands.Diabetes
|| product == SanofiProductBrands.CNS || product == SanofiProductBrands.CHC || product == SanofiProductBrands.Antibiotic
|| product == SanofiProductBrands.OtherEthical || product == SanofiProductBrands.OtherProducts)
return true;
else
return false;
}
public static string GetBrandCode(SanofiProductBrands product)
{
switch (product)
{
case SanofiProductBrands.Plavix:
return C.PLAVIX_BC;
case SanofiProductBrands.Clexane:
return C.CLEXANE_BC;
case SanofiProductBrands.Taxotere:
return C.TAXOTERE_BC;
case SanofiProductBrands.Targocid:
return C.TARGOCID_BC;
case SanofiProductBrands.Lantus:
return C.LANTUS_BC;
case SanofiProductBrands.Eloxatin:
return C.ELOXATINE_BC;
case SanofiProductBrands.Telfast:
return C.TELFAST_BC;
case SanofiProductBrands.Depakine:
return C.DEPAKINE_BC;
/* case SanofiProductBrands.Epilim:
return C.EPILIM_BC;*/
case SanofiProductBrands.Jevtana:
return C.JEVTANA_BC;
case SanofiProductBrands.Primacor:
return C.PRIMACOR_BC;
case SanofiProductBrands.Thymo:
return C.THYMO_BC;
case SanofiProductBrands.Renagel:
return C.RENAGEL_BC;
case SanofiProductBrands.Stilnox:
return C.STILNOX_BC;
case SanofiProductBrands.Phenergan:
return C.PHENERGAN_BC;
case SanofiProductBrands.Rilutek:
return C.RILUTEK_BC;
case SanofiProductBrands.Fludara:
return C.FLUDARA_BC;
case SanofiProductBrands.Evoltra:
return C.EVOLTRA_BC;
case SanofiProductBrands.Suprefact:
return C.SUPREFACT_BC;
case SanofiProductBrands.Glucantime:
return C.GLUCANTIME_BC;
case SanofiProductBrands.Trental:
return C.TRENTAL_BC;
case SanofiProductBrands.Mozobil:
return C.MOZOBIL_BC;
case SanofiProductBrands.Apidra:
return C.APIDRA_BC;
case SanofiProductBrands.TotalProducts:
return C.TOTAL_PRODUCTS_BC;
case SanofiProductBrands.Cardio:
return C.CARDIO_BC;
case SanofiProductBrands.Onco:
return C.ONCO_BC;
case SanofiProductBrands.Diabetes:
return C.DIABETES_BC;
case SanofiProductBrands.CNS:
return C.CNS_BC;
case SanofiProductBrands.CHC:
return C.CHC_BC;
case SanofiProductBrands.Antibiotic:
return C.ANTIBIOTIC_BC;
case SanofiProductBrands.OtherEthical:
return C.OTHERETHICAL_BC;
case SanofiProductBrands.OtherProducts:
return C.OTHERPRODUCTS_BC;
}
return "";
}
private void LoadProvinceObjectives(SanofiProductBrands product, int startM, int startY, int endM, int endY)
{
object[] state = { product, startM, startY, endM, endY };
if (!IsLoading("GetTotalObjective_PerProvince_PerMonthQuery", state))
{
DAT_DomainContext context = new DAT_DomainContext();
AddtoLoadingList("GetTotalObjective_PerProvince_PerMonthQuery", state);
context.Load(context.GetTotalObjective_PerProvince_PerMonthQuery(Utils.GetBrandCode(product), startM, startY, endM, endY,""), TotalObjective_PerProvince_PerMonth_ResultCallback, state);
}
}
public YTDPerformance(SanofiProductBrands product, SanofiRegionTypes regionT, int aGroupRegionMapId, int endMonth, int endYear, string dosageName)
{
InitializeComponent();
_productBrand = product;
_regionType = regionT;
_groupRegionMapId = aGroupRegionMapId;
_endMonth = endMonth;
_endYear = endYear;
_dosageName = dosageName;
_loadedData = new CommonRawDataCollection();
InitializeMonthWithDictionaries();
SetTitles();
SetDosageCombo();
}
public static string Get_CD_ProvinceIds(int aGroupRegionMapId, SanofiProductBrands product)
{
if (!IsProvinceDataLoaded())
return null;
string result = "";
List<int> tempIds = new List<int>();
foreach (int theRegionMapId in DBUtils.GetGroupMember_RegionMapIdsList(aGroupRegionMapId, product))
foreach (RegionMap rm in _regionMapTable)
if (theRegionMapId == rm.RegionMapID)
if (rm.CD_ProvinceID != null)
{
if (tempIds.Contains((int)rm.CD_ProvinceID))
continue;
tempIds.Add((int)rm.CD_ProvinceID);
result += rm.CD_ProvinceID + "-";
}
result = (result.Length > 0) ? result.Substring(0, result.Length - 1) : result;
return result;
}
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 LoadNewConditionData(SanofiProductBrands product, SanofiRegionTypes regionT, int startMonth, int endMonth, int startYear, int endYear)
{
if (!IsPolygonsLoaded(regionT) && !IsLoadingPolygons(regionT))
LoadPolygons(regionT);
if (!IsRegionsDataAvailable(product, startMonth, startYear, endMonth, endYear, regionT))
LoadResult_AccTo_RegionType();
}
public static string GetGroupMember_DATRegionCodes(int aRegionMapId, SanofiProductBrands product)
{
if (!IsProvinceDataLoaded())
return null;
string result = "";
List<string> tempIds = GetGroupMember_DATRegionCodesList(aRegionMapId, product);
foreach (string theDATRegionCode in tempIds)
result += "-" + theDATRegionCode;
/*
string datGroupRegionCode = Get_Dat_GroupRegionCode(regionCode,product);
foreach (RegionMap rm in _regionMapTable)
{
if (rm.DAT_GROUPREGIONCODE.Trim().ToLower() == datGroupRegionCode.Trim().ToLower())
{
if (rm.DAT_REGIONCODE != null)
{
if (tempIds.Contains(rm.DAT_REGIONCODE.Trim().ToLower()))
continue;
tempIds.Add(rm.DAT_REGIONCODE.Trim().ToLower());
result += rm.DAT_REGIONCODE + "-";
}
}
}*/
result = (result.Length > 0) ? result.Substring(1) : result;
return result;
}
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);
}
