public DataSet GetProductTypeByRole(UserModel _user)
{
//Get the User Session
//Get All Events for this user
return db.ExecuteDataset("sp_GetProductTypeByRole", "GetProdcutTypes", new SqlParameter("@Role", _user.Role.ToString()), new SqlParameter("@FranchiseeId", _user.FranchiseeID));
}
public void AddProduct(string ProductTypeName, string colorCode, UserModel _user)
{
//Get the User Session
ProductTypesRepository productRepository = new ProductTypesRepository();
Tbl_ProductType newProductType = new Tbl_ProductType();
newProductType.ColorCode = colorCode;
newProductType.CreatedBy = _user.UserId.ToString();
newProductType.CreatedDate = DateTime.Now;
newProductType.FranchiseeId = _user.FranchiseeID;
newProductType.IsActive = true;
newProductType.ProductTypeName = ProductTypeName;
try
{
productRepository.Add(newProductType);
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
foreach (var errors in ex.EntityValidationErrors)
{
foreach (var error in errors.ValidationErrors)
{
throw new Exception(error.PropertyName + " " + error.ErrorMessage);
}
}
}
}
public void Insert(int OppsID, int CompanyId, int DocStatus, string DocName, DateTime LastModifyDate, UserModel _user)
{
//Get the User Info
db.ExecuteNonQuery("sp_AttachDocument", new SqlParameter("@OppsID", OppsID),
new SqlParameter("@CompanyId", CompanyId),
new SqlParameter("@DocName", DocName),
new SqlParameter("@DocStatus", DocStatus),
new SqlParameter("@LastModifyDate", LastModifyDate),
new SqlParameter("@CreatedBy", _user.UserId));
}
public void Update(int DocsID, int OppsID, string DocName, int DocStatus, DateTime LastModifyDate, UserModel _user)
{
//Get the User Info
db.ExecuteNonQuery("sp_UpdateDocumentDetails",
new SqlParameter("@DocsID", DocsID),
new SqlParameter("@OppsID", OppsID),
new SqlParameter("@DocName", DocName),
new SqlParameter("@DocStatus", DocStatus),
new SqlParameter("@LastModifyDate", LastModifyDate),
new SqlParameter("@UpdatedBy", _user.UserId));
}
public DataSet GetAllArchivedCompanies(UserModel _user)
{
//Get the User Info
if (_user.Role == SandlerRoles.SiteAdmin || _user.Role == SandlerRoles.Corporate || _user.Role == SandlerRoles.HomeOfficeAdmin || _user.Role == SandlerRoles.HomeOfficeUser)
{
//Corporate User
return db.ExecuteDataset("sp_GetAllArchivedCompanies", "Companies");
}
else if (_user.Role == SandlerRoles.Coach)
{
//Coach - To do - once User object has RegionId then pass it here
return db.ExecuteDataset("sp_GetAllArchivedCompaniesByCoachId", "CompaniesByCoachId", new SqlParameter("@CoachId", _user.CoachID));
}
else
{
//Franchisee Owner OR Franchisee User OR Client - We get by FranchiseeId
return db.ExecuteDataset("sp_GetAllArchivedCompaniesByFrId", "CompaniesByFrId", new SqlParameter("@FranchiseeId", _user.FranchiseeID));
}
}
public DataSet GetAllArchived(int COMPANIESID, UserModel _user)
{
if (COMPANIESID == 0)
{
if (_user.Role == SandlerRoles.SiteAdmin || _user.Role == SandlerRoles.Corporate || _user.Role == SandlerRoles.HomeOfficeAdmin || _user.Role == SandlerRoles.HomeOfficeUser)
{
return db.ExecuteDataset("sp_GetAllArchivedContacts", "Contacts");
}
else if (_user.Role == SandlerRoles.Coach)
{
return db.ExecuteDataset("sp_GetAllArchivedContactsByCoachID", "Contacts", new SqlParameter("@CoachID", _user.CoachID));
}
else if (_user.Role == SandlerRoles.FranchiseeOwner || _user.Role == SandlerRoles.Client)
{
//now we have to bring records as per role - Franchisee Owner Or Client
return db.ExecuteDataset("sp_GetAllArchivedContactsByFrID", "Contacts", new SqlParameter("@FranchiseeID", _user.FranchiseeID));
}
else
{
//This is for Franchisee User
return db.ExecuteDataset("sp_GetAllArchivedContactsByUserID", "Contacts", new SqlParameter("@UserID", _user.UserId));
}
}
else
{
//We have Company ID
if (_user.Role != SandlerRoles.FranchiseeUser)
{
System.Data.DataSet ds = db.ExecuteDataset("sp_GetAllArchivedContactsByCompID", "Contacts", new SqlParameter("@CompanyID", COMPANIESID));
return ds;
}
else
{
//Only for the Franchisee User
System.Data.DataSet ds = db.ExecuteDataset("sp_GetAllArchivedContactsForCompByUserID", "Contacts", new SqlParameter("@UserID", _user.UserId), new SqlParameter("@CompanyID", COMPANIESID));
return ds;
}
}
}
public IChart Get(string id, string strChartIds, string strChartSubType, string strDrillBy, string strUserName, string strSearchParameter, [System.Web.Http.ModelBinding.ModelBinder] List<ChartParameter> monthYearCombinations)
{
string[] chartIds = strChartIds.Split(new char[] { '_' });
string chartSubtype = strChartSubType;
ChartID idSelected;
ChartRepository cR;
SandlerModels.TBL_CHART dbChart;
IChart chartToLoad = null;
UserModel CurrentUser;
CurrentUser = new UserModel(strUserName);
new UserDataModel().Load(CurrentUser);
foreach (string chartId in chartIds)
{
idSelected = (ChartID)Enum.Parse(typeof(ChartID), chartId, true);
cR = new ChartRepository();
dbChart = cR.GetAll().Where(c => c.ChartID == chartId && c.IsActive == true).SingleOrDefault();
if (dbChart.TypeOfChart == "Chart")
{
chartToLoad = new Chart() { SearchParameter = strSearchParameter, SubType = string.IsNullOrEmpty(chartSubtype) ? ChartSubType.NoSubType : (ChartSubType)Enum.Parse(typeof(ChartSubType), chartSubtype), BGAlpha = dbChart.BgAlpha, BGColor = dbChart.BgColor, CanvasBGAlpha = dbChart.CanvasBgAlpha, CanvasBGColor = dbChart.CanvasBgColor, Caption = dbChart.Caption, SWF = dbChart.SWFile, NumberSuffix = dbChart.NumberSuffix, PieRadius = dbChart.PieRadius, showLabels = dbChart.ShowLabels, showLegend = dbChart.ShowLegend, XaxisName = dbChart.XaxisName, YaxisName = dbChart.YaxisName, Id = idSelected, enableRotation = dbChart.EnableRotation, DrillChartIds = (string.IsNullOrEmpty(dbChart.DrillLevelChartIDs)) ? "" : dbChart.DrillLevelChartIDs, DrillOverride = false, DrillBy = (string.IsNullOrEmpty(strDrillBy)) ? "" : strDrillBy, MonthYearCombinations = monthYearCombinations };
chartToLoad.LoadChart(CurrentUser);
chartToLoad.CreateChart();
}
else if (dbChart.TypeOfChart == "PieChart")
{
chartToLoad = new PieChart() { SearchParameter = strSearchParameter, SubType = string.IsNullOrEmpty(chartSubtype) ? ChartSubType.NoSubType : (ChartSubType)Enum.Parse(typeof(ChartSubType), chartSubtype), BGAlpha = dbChart.BgAlpha, BGColor = dbChart.BgColor, CanvasBGAlpha = dbChart.CanvasBgAlpha, CanvasBGColor = dbChart.CanvasBgColor, Caption = dbChart.Caption, SWF = dbChart.SWFile, NumberSuffix = dbChart.NumberSuffix, PieRadius = dbChart.PieRadius, showLabels = dbChart.ShowLabels, showLegend = dbChart.ShowLegend, XaxisName = dbChart.XaxisName, YaxisName = dbChart.YaxisName, Id = idSelected, enableRotation = dbChart.EnableRotation, DrillChartIds = (string.IsNullOrEmpty(dbChart.DrillLevelChartIDs)) ? "" : dbChart.DrillLevelChartIDs, DrillOverride = false, DrillBy = (string.IsNullOrEmpty(strDrillBy)) ? "" : strDrillBy };
((PieChart)chartToLoad).LoadChart(CurrentUser);
((PieChart)chartToLoad).CreateChart();
}
else if (dbChart.TypeOfChart == "BarChart")
{
chartToLoad = new BarChart() { SearchParameter = strSearchParameter, SubType = string.IsNullOrEmpty(chartSubtype) ? ChartSubType.NoSubType : (ChartSubType)Enum.Parse(typeof(ChartSubType), chartSubtype), BGAlpha = dbChart.BgAlpha, BGColor = dbChart.BgColor, CanvasBGAlpha = dbChart.CanvasBgAlpha, CanvasBGColor = dbChart.CanvasBgColor, Caption = dbChart.Caption, SWF = dbChart.SWFile, NumberSuffix = dbChart.NumberSuffix, PieRadius = dbChart.PieRadius, showLabels = dbChart.ShowLabels, showLegend = dbChart.ShowLegend, XaxisName = dbChart.XaxisName, YaxisName = dbChart.YaxisName, Id = idSelected, enableRotation = dbChart.EnableRotation, DrillChartIds = (string.IsNullOrEmpty(dbChart.DrillLevelChartIDs)) ? "" : dbChart.DrillLevelChartIDs, DrillOverride = false, DrillBy = (string.IsNullOrEmpty(strDrillBy)) ? "" : strDrillBy };
((BarChart)chartToLoad).LoadChart(CurrentUser);
((BarChart)chartToLoad).CreateChart();
}
}
return chartToLoad;
}
public void LoadChart(UserModel currentUser)
{
try
{
this.DrillChartIds = (this.DrillOverride) ? this.Id.ToString() : this.DrillChartIds;
List<ChartParameter> chartParams = null;
ChartDataSet lastDs = null;
SandlerModels.DataIntegration.DataQueries queries = new SandlerModels.DataIntegration.DataQueries();
AppointmentSourceRepository appointmentSource;
ProductTypesRepository productTypesSource;
IEnumerable<Tbl_ProductType> products;
string searchForNewCompany,searchCompanies,franchiseeName, regionName, countryName;
int yearToProcess, monthToProcess;
switch ((ChartID)Enum.Parse(typeof(ChartID), this.Id.ToString(), true))
{
#region ProductsReports Logic
case ChartID.ProductMarginContributionByProductByMonth:
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll();
foreach (var record in products.Where(r => r.IsActive == true).AsEnumerable())
{
this.Categories.Add(new Category { Label = record.ProductTypeName });
}
chartParams = new List<ChartParameter>();
chartParams.Add(new ChartParameter { Value = "-2", Color = "3300ff" });
chartParams.Add(new ChartParameter { Value = "-1", Color = "ff6600" });
chartParams.Add(new ChartParameter { Value = "0", Color = "32df00" });
foreach (ChartParameter parameter in chartParams)
{
try
{
IEnumerable<SandlerModels.DataIntegration.ProductTypeVM> productSalesCollection = queries.GetProductSalesByMonth(currentUser, DateTime.Now.AddMonths(int.Parse(parameter.Value)).Month);
if (productSalesCollection != null)
{
var productSales = from record in productSalesCollection
select new { Category = record.ProductTypeName, Value = record.AvgPrice };
this.DataSetCollection.Add(new ChartDataSet { Color = parameter.Color, SeriesName = DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM") });
foreach (Category category in this.Categories)
{
lastDs = this.DataSetCollection.Last();
lastDs.SetsCollection.Add(new SetValue { Label = category.Label, Link = ChartHelper.GeneratePageLink(lastDs.SeriesName, this.DrillChartIds) });
}
foreach (var record in productSales)
{
foreach (SetValue set in lastDs.SetsCollection)
{
if (set.Label == record.Category)
set.Value = record.Value.ToString();
}
}
}
}
catch (Exception ex)
{
throw new Exception("Error in ChartID.ProductMarginContributionByProductByMonth:" + ex.Message);
}
//}
}
break;
case ChartID.FirstSaleProductValueByProductByMonth:
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll();
foreach (var record in products.Where(r => r.IsActive == true).AsEnumerable())
{
this.Categories.Add(new Category { Label = record.ProductTypeName });
}
chartParams = new List<ChartParameter>();
chartParams.Add(new ChartParameter { Value = "-2", Color = "3300ff" });
chartParams.Add(new ChartParameter { Value = "-1", Color = "ff6600" });
chartParams.Add(new ChartParameter { Value = "0", Color = "32df00" });
foreach (ChartParameter parameter in chartParams)
{
try
{
IEnumerable<SandlerModels.DataIntegration.ProductTypeVM> productSalesCollection = queries.GetProductFirstSalesByMonth(currentUser, DateTime.Now.AddMonths(int.Parse(parameter.Value)).Month);
if (productSalesCollection != null)
{
var productSales = from record in productSalesCollection
select new { Category = record.ProductTypeName, Value = record.AvgPrice };
this.DataSetCollection.Add(new ChartDataSet { Color = parameter.Color, SeriesName = DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM") });
foreach (Category category in this.Categories)
{
lastDs = this.DataSetCollection.Last();
lastDs.SetsCollection.Add(new SetValue { Label = category.Label, Link = ChartHelper.GeneratePageLink(lastDs.SeriesName, this.DrillChartIds) });
}
foreach (var record in productSales)
{
foreach (SetValue set in lastDs.SetsCollection)
{
if (set.Label == record.Category)
set.Value = record.Value.ToString();
}
}
}
}
catch (Exception ex)
{
throw new Exception("Error in ChartID.FirstSaleProductValueByProductByMonth:" + ex.Message);
}
//}
}
break;
case ChartID.ProductSoldToCompanyByProductByMonth:
string companyName;
try
{
companyName = new CompaniesRepository().GetById(long.Parse(SearchParameter)).COMPANYNAME;
this.Caption = this.Caption.Replace("Company Name", companyName);
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll();
foreach (var record in products.Where(r => r.IsActive == true).AsEnumerable())
{
this.Categories.Add(new Category { Label = record.ProductTypeName });
}
chartParams = new List<ChartParameter>();
chartParams.Add(new ChartParameter { Value = "-2", Color = "3300ff" });
chartParams.Add(new ChartParameter { Value = "-1", Color = "ff6600" });
chartParams.Add(new ChartParameter { Value = "0", Color = "32df00" });
foreach (ChartParameter parameter in chartParams)
{
IEnumerable<SandlerModels.DataIntegration.ProductTypeVM> productSalesCollection = queries.GetProductSoldByCompanyByMonth(currentUser, DateTime.Now.AddMonths(int.Parse(parameter.Value)).Month, int.Parse(this.SearchParameter));
if (productSalesCollection != null)
{
var productSales = from record in productSalesCollection
select new { Category = record.ProductTypeName, Qty = record.Count };
this.DataSetCollection.Add(new ChartDataSet { Color = parameter.Color, SeriesName = DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM") });
foreach (Category category in this.Categories)
{
lastDs = this.DataSetCollection.Last();
lastDs.SetsCollection.Add(new SetValue { Label = category.Label, Link = ChartHelper.GeneratePageLink(lastDs.SeriesName, this.DrillChartIds, "SoldByCompany.aspx?searchParameter=" + this.SearchParameter + "&") });
}
foreach (var record in productSales)
{
foreach (SetValue set in lastDs.SetsCollection)
{
if (set.Label == record.Category)
set.Value = record.Qty.ToString();
}
}
}
}
}
catch (Exception ex)
{
throw new Exception("Error in ChartID.ProductSoldToCompanyByProductByMonth:" + ex.Message);
}
break;
case ChartID.ProductSoldBySalesRepByProductByMonth:
this.Caption = this.Caption.Replace("Sales Rep", this.SearchParameter);
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll();
foreach (var record in products.Where(r => r.IsActive == true).AsEnumerable())
{
this.Categories.Add(new Category { Label = record.ProductTypeName });
}
chartParams = new List<ChartParameter>();
chartParams.Add(new ChartParameter { Value = "-2", Color = "3300ff" });
chartParams.Add(new ChartParameter { Value = "-1", Color = "ff6600" });
chartParams.Add(new ChartParameter { Value = "0", Color = "32df00" });
foreach (ChartParameter parameter in chartParams)
{
try
{
IEnumerable<SandlerModels.DataIntegration.ProductTypeVM> productSalesCollection = queries.GetProductSoldBySalesRepByMonth(currentUser, DateTime.Now.AddMonths(int.Parse(parameter.Value)).Month, this.SearchParameter);
if (productSalesCollection != null)
{
var productSales = from record in productSalesCollection
select new { Category = record.ProductTypeName, Qty = record.Count };
this.DataSetCollection.Add(new ChartDataSet { Color = parameter.Color, SeriesName = DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM") });
foreach (Category category in this.Categories)
{
lastDs = this.DataSetCollection.Last();
lastDs.SetsCollection.Add(new SetValue { Label = category.Label, Link = ChartHelper.GeneratePageLink(lastDs.SeriesName, this.DrillChartIds, "SoldByCompanySalesRep.aspx?searchParameter=" + this.SearchParameter + "&") });
}
foreach (var record in productSales)
{
foreach (SetValue set in lastDs.SetsCollection)
{
if (set.Label == record.Category)
set.Value = record.Qty.ToString();
}
}
}
}
catch (Exception ex)
{
throw new Exception("Error in ChartID.ProductSoldToCompanyByProductByMonth:" + ex.Message);
}
//}
}
break;
#endregion
#region ClientReports Logic
case ChartID.SalesTotalsByMonthQty:
string[] monthNames = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.MonthNames;
foreach (string monthName in monthNames) // writing out
{
if (!string.IsNullOrEmpty(monthName))
this.Categories.Add(new Category { Label = monthName.Substring(0, 3) });
}
chartParams = new List<ChartParameter>();
chartParams.Add(new ChartParameter { Value = (DateTime.Now.Year - 2).ToString(), Color = "3300ff" });
chartParams.Add(new ChartParameter { Value = (DateTime.Now.Year - 1).ToString(), Color = "ff6600" });
chartParams.Add(new ChartParameter { Value = DateTime.Now.Year.ToString(), Color = "32df00" });
IEnumerable<SandlerModels.DataIntegration.SalesTotalByMonthVM> salesTotalData;
foreach (ChartParameter parameter in chartParams)
{
try
{
salesTotalData = queries.GetSalesTotalByYear(currentUser, int.Parse(parameter.Value));
if (salesTotalData != null)
{
var salesDataForAYear = from opportunity in salesTotalData
group opportunity by new { opportunity.CloseDate.Month }
into grp
select new { Count = grp.Count(), MonthName = ChartHelper.GetMonthName(grp.Key.Month) };
this.DataSetCollection.Add(new ChartDataSet { Color = parameter.Color, SeriesName = parameter.Value });
foreach (Category category in this.Categories)
{
lastDs = this.DataSetCollection.Last();
lastDs.SetsCollection.Add(new SetValue { Label = category.Label });
}
foreach (var record in salesDataForAYear)
{
foreach (SetValue set in lastDs.SetsCollection)
{
if (set.Label == record.MonthName)
set.Value = record.Count.ToString();
}
}
}
salesTotalData = null;
}
catch (Exception ex)
{
}
}
break;
case ChartID.CostOfSale:
IEnumerable<SandlerModels.DataIntegration.CostOfSaleVM> costofsaleData = queries.GetCostOfSale(currentUser);
this.DataSetCollection.Add(new ChartDataSet { Color = "0000FF", SeriesName = "Profit" });//0000FF blue
this.DataSetCollection.Add(new ChartDataSet { Color = "FF8C00", SeriesName = "Cost" });//FF8C00 darkorange
this.DataSetCollection.Add(new ChartDataSet { Color = "32CD32", SeriesName = "Revenue" });//32CD32 Lime green
foreach (SandlerModels.DataIntegration.CostOfSaleVM cosRecord in costofsaleData)
{
this.Categories.Add(new Category { Label = cosRecord.ProductName });
this.DataSetCollection[0].SetsCollection.Add(new SetValue { Value = cosRecord.Profit.ToString() });
this.DataSetCollection[1].SetsCollection.Add(new SetValue { Value = cosRecord.Cost.ToString() });
this.DataSetCollection[2].SetsCollection.Add(new SetValue { Value = cosRecord.Revenue.ToString() });
}
break;
#endregion
#region BenchmarkReports Logic
case ChartID.BenchmarkSalesRepFranchisee:
try
{
chartParams = new List<ChartParameter>();
chartParams.Add(new ChartParameter { Value = "-2" });
chartParams.Add(new ChartParameter { Value = "-1" });
chartParams.Add(new ChartParameter { Value = "0" });
franchiseeName = new FranchiseeRepository().GetById(currentUser.FranchiseeID).Name;
Caption = Caption.Replace("Sales Rep", SearchParameter).Replace("Name", franchiseeName);
IEnumerable<SandlerModels.DataIntegration.BenchMarkVM> salesRepToFranchiseeData;
this.DataSetCollection.Add(new ChartDataSet { Color = "4F94CD", SeriesName = "Franchisee" });//4F94CD steelblue3
this.DataSetCollection.Add(new ChartDataSet { Color = "FF8C00", SeriesName = "Rep" });//FF8C00 darkorange
Double totalValue = 0.0;
Double otherSalesRepsTotals = 0.0;
Double salesRepValue = 0.0;
foreach (ChartParameter parameter in chartParams)
{
salesRepToFranchiseeData = queries.GetBenchMarkSalesRepToFranchiseeByMonth(currentUser, DateTime.Now.AddMonths(int.Parse(parameter.Value)).Month);
totalValue = salesRepToFranchiseeData.Sum(r => r.Value);
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM") });
otherSalesRepsTotals = (from record in salesRepToFranchiseeData.Where(r => r.KeyGroupId != SearchParameter)
select record).Sum(r => r.Value);
this.DataSetCollection[0].SetsCollection.Add(new SetValue { Value = ((otherSalesRepsTotals / totalValue) * 100).ToString("f2"), Link = ChartHelper.GeneratePageLink(DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM"), this.DrillChartIds, "SalesRepToFranchisee.aspx?searchParameter=" + this.SearchParameter + "&") });
SandlerModels.DataIntegration.BenchMarkVM repRecord = salesRepToFranchiseeData.Where(r => r.KeyGroupId == SearchParameter).SingleOrDefault();
salesRepValue = (repRecord == null) ? 0.0 : repRecord.Value;
this.DataSetCollection[1].SetsCollection.Add(new SetValue { Value = ((salesRepValue / totalValue) * 100).ToString("f2"), Link = ChartHelper.GeneratePageLink(DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM"), this.DrillChartIds, "SalesRepToFranchisee.aspx?searchParameter=" + this.SearchParameter + "&") });
}
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.BenchmarkSalesRepFranchisee:" + ex.Message);
}
break;
case ChartID.BenchmarkFranchiseeRegion:
try
{
chartParams = new List<ChartParameter>();
chartParams.Add(new ChartParameter { Value = "-2" });
chartParams.Add(new ChartParameter { Value = "-1" });
chartParams.Add(new ChartParameter { Value = "0" });
franchiseeName = new FranchiseeRepository().GetById(int.Parse(SearchParameter)).Name;
regionName = new RegionRepository().GetById(currentUser.RegionID).Name;
Caption = Caption.Replace("Region Name", regionName).Replace("Franchisee Name", franchiseeName);
IEnumerable<SandlerModels.DataIntegration.BenchMarkVM> salesFranchiseeToRegionsData;
this.DataSetCollection.Add(new ChartDataSet { Color = "32df00", SeriesName = "Region" });
this.DataSetCollection.Add(new ChartDataSet { Color = "4F94CD", SeriesName = "Franchisee" });
Double totalValue = 0.0;
Double otherFranchiseesTotals = 0.0;
Double franchiseeValue = 0.0;
foreach (ChartParameter parameter in chartParams)
{
salesFranchiseeToRegionsData = queries.GetBenchMarkFranchiseeToRegionsByMonth(currentUser, DateTime.Now.AddMonths(int.Parse(parameter.Value)).Month);
totalValue = salesFranchiseeToRegionsData.Sum(r => r.Value);
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM") });
otherFranchiseesTotals = (from record in salesFranchiseeToRegionsData.Where(r => r.KeyGroupId != SearchParameter)
select record).Sum(r => r.Value);
this.DataSetCollection[0].SetsCollection.Add(new SetValue { Value = ((otherFranchiseesTotals / totalValue) * 100).ToString("f2"), Link = ChartHelper.GeneratePageLink(DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM"), this.DrillChartIds, "FranchiseeToRegion.aspx?searchParameter=" + this.SearchParameter + "&") });
SandlerModels.DataIntegration.BenchMarkVM franchiseeRecord = salesFranchiseeToRegionsData.Where(r => r.KeyGroupId == SearchParameter).SingleOrDefault();
franchiseeValue = (franchiseeRecord == null) ? 0.0 : franchiseeRecord.Value;
this.DataSetCollection[1].SetsCollection.Add(new SetValue { Value = ((franchiseeValue / totalValue) * 100).ToString("f2"), Link = ChartHelper.GeneratePageLink(DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM"), this.DrillChartIds, "FranchiseeToRegion.aspx?searchParameter=" + this.SearchParameter + "&") });
}
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.BenchmarkFranchiseeRegion:" + ex.Message);
}
break;
case ChartID.BenchmarkRegionCountry:
try
{
chartParams = new List<ChartParameter>();
chartParams.Add(new ChartParameter { Value = "-2" });
chartParams.Add(new ChartParameter { Value = "-1" });
chartParams.Add(new ChartParameter { Value = "0" });
regionName = new RegionRepository().GetById(int.Parse(SearchParameter)).Name;
countryName = new CountryRepository().GetById(currentUser.CountryID).Name;
Caption = Caption.Replace("Region Name", regionName).Replace("Country Name", countryName);
IEnumerable<SandlerModels.DataIntegration.BenchMarkVM> salesRegionToCountryData;
this.DataSetCollection.Add(new ChartDataSet { Color = "800080", SeriesName = "Country" });//800080 -- Purple
this.DataSetCollection.Add(new ChartDataSet { Color = "32df00", SeriesName = "Region" });
Double totalValue = 0.0;
Double otherRegionsTotal = 0.0;
Double regionValue = 0.0;
foreach (ChartParameter parameter in chartParams)
{
salesRegionToCountryData = queries.GetBenchMarkRegionToCountryByMonth(currentUser, DateTime.Now.AddMonths(int.Parse(parameter.Value)).Month);
totalValue = salesRegionToCountryData.Sum(r => r.Value);
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM") });
otherRegionsTotal = (from record in salesRegionToCountryData.Where(r => r.KeyGroupId != SearchParameter)
select record).Sum(r => r.Value);
this.DataSetCollection[0].SetsCollection.Add(new SetValue { Value = ((otherRegionsTotal / totalValue) * 100).ToString("f2"), Link = ChartHelper.GeneratePageLink(DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM"), this.DrillChartIds, "RegionToCountry.aspx?searchParameter=" + this.SearchParameter + "&") });
SandlerModels.DataIntegration.BenchMarkVM regionRecord = salesRegionToCountryData.Where(r => r.KeyGroupId == SearchParameter).SingleOrDefault();
regionValue = (regionRecord == null) ? 0.0 : regionRecord.Value;
this.DataSetCollection[1].SetsCollection.Add(new SetValue { Value = ((regionValue / totalValue) * 100).ToString("f2"), Link = ChartHelper.GeneratePageLink(DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM"), this.DrillChartIds, "RegionToCountry.aspx?searchParameter=" + this.SearchParameter + "&") });
}
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.BenchmarkRegionCountry:" + ex.Message);
}
break;
case ChartID.BenchmarkCountryAll:
try
{
chartParams = new List<ChartParameter>();
chartParams.Add(new ChartParameter { Value = "-2" });
chartParams.Add(new ChartParameter { Value = "-1" });
chartParams.Add(new ChartParameter { Value = "0" });
countryName = new CountryRepository().GetById(int.Parse(SearchParameter)).Name;
Caption = Caption.Replace("Country Name", countryName);
IEnumerable<SandlerModels.DataIntegration.BenchMarkVM> salesCountryAllData;
this.DataSetCollection.Add(new ChartDataSet { Color = "800080", SeriesName = "All" });//800080 -- Purple
this.DataSetCollection.Add(new ChartDataSet { Color = "00CED1", SeriesName = "Country" });//00CED1 -- darkturquoise
Double totalValue = 0.0;
Double otherCountriesTotal = 0.0;
Double countryValue = 0.0;
foreach (ChartParameter parameter in chartParams)
{
salesCountryAllData = queries.GetBenchMarkCountryAllByMonth(DateTime.Now.AddMonths(int.Parse(parameter.Value)).Month);
totalValue = salesCountryAllData.Sum(r => r.Value);
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM") });
otherCountriesTotal = (from record in salesCountryAllData.Where(r => r.KeyGroupId != SearchParameter)
select record).Sum(r => r.Value);
this.DataSetCollection[0].SetsCollection.Add(new SetValue { Value = ((otherCountriesTotal / totalValue) * 100).ToString("f2"), Link = ChartHelper.GeneratePageLink(DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM"), this.DrillChartIds, "CountryToAll.aspx?searchParameter=" + this.SearchParameter + "&") });
SandlerModels.DataIntegration.BenchMarkVM franchiseeRecord = salesCountryAllData.Where(r => r.KeyGroupId == SearchParameter).SingleOrDefault();
countryValue = (franchiseeRecord == null) ? 0.0 : franchiseeRecord.Value;
this.DataSetCollection[1].SetsCollection.Add(new SetValue { Value = ((countryValue / totalValue) * 100).ToString("f2"), Link = ChartHelper.GeneratePageLink(DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM"), this.DrillChartIds, "CountryToAll.aspx?searchParameter=" + this.SearchParameter + "&") });
}
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.BenchmarkCountryAll:" + ex.Message);
}
break;
#endregion
#region AdHocReports logic
case ChartID.ClosedSalesAnalysis:
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll();
if (this.SubType == ChartSubType.SalesValueOppSource || this.SubType == ChartSubType.SalesQuantityOppSource)
{
foreach (var record in new OppSourceeRepository().GetAll())
{
this.Categories.Add(new Category { Label = record.Name });
}
}
else if (this.SubType == ChartSubType.SalesValueOpportunityType || this.SubType == ChartSubType.SalesQuantityOpportunityType)
{
foreach (var record in new OpprtunityTypesRepository().GetAll())
{
this.Categories.Add(new Category { Label = record.Name });
}
}
else
{
foreach (var record in products.Where(r => r.IsActive == true).AsEnumerable())
{
this.Categories.Add(new Category { Label = record.ProductTypeName });
}
}
chartParams = new List<ChartParameter>();
chartParams.Add(new ChartParameter { Value = "-2", Color = "8A4B08" });
chartParams.Add(new ChartParameter { Value = "-1", Color = "0000FF" });
chartParams.Add(new ChartParameter { Value = "0", Color = "ff9966" });
searchForNewCompany = (HttpContext.Current.Session["searchForNewCompany"] == null) ? "" : HttpContext.Current.Session["searchForNewCompany"].ToString();
searchCompanies = (HttpContext.Current.Session["searchCompanies"] == null) ? "" : HttpContext.Current.Session["searchCompanies"].ToString();
foreach (ChartParameter parameter in chartParams)
{
try
{
if (this.SubType == ChartSubType.ProductsSoldBySalesValue)
this.Caption = "Sales Value By Product (By Month)";
if (this.SubType == ChartSubType.ProductsSoldBySalesQuantity)
this.Caption = "Sales Quantity By Product (By Month)";
if (this.SubType == ChartSubType.SalesValueOppSource)
this.Caption = "Sales Value By Opportunity Source (By Month)";
if (this.SubType == ChartSubType.SalesQuantityOppSource)
this.Caption = "Sales Quantity By Opportunity Source (By Month)";
if (this.SubType == ChartSubType.SalesValueOpportunityType)
this.Caption = "Sales Value By Opportunity Type (By Month)";
if (this.SubType == ChartSubType.SalesQuantityOpportunityType)
this.Caption = "Sales Quantity By Opportunity Type (By Month)";
IEnumerable<SandlerModels.DataIntegration.ClosedSalesVM> productTypeVMCollection = queries.GetClosedSalesAnalysis(currentUser, DateTime.Now.AddMonths(int.Parse(parameter.Value)).Month, this.SubType.ToString(), searchForNewCompany, searchCompanies);
if (productTypeVMCollection != null)
{
var clientsWithProducts = from record in productTypeVMCollection
select new { Category = record.Name, SalesValue = record.AvgPrice, SalesQuantity = record.Count };
this.DataSetCollection.Add(new ChartDataSet { Color = parameter.Color, SeriesName = DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM") });
string link = "";
foreach (Category category in this.Categories)
{
lastDs = this.DataSetCollection.Last();
link = string.Format("{0}?{1}={2}&{3}={4}&SubType={5}", "ClosedSalesAnalysis.aspx", ConfigurationManager.AppSettings["QueryStringParamDrillChartIDs"], this.DrillChartIds, ConfigurationManager.AppSettings["QueryStringParamDrillBy"], lastDs.SeriesName, this.SubType.ToString());
//lastDs.SetsCollection.Add(new SetValue { Label = category.Label, Link = ChartHelper.GeneratePageLink(lastDs.SeriesName, this.DrillChartIds, this.SubType.ToString()) });
lastDs.SetsCollection.Add(new SetValue { Label = category.Label, Link = link });
}
foreach (var record in clientsWithProducts)
{
foreach (SetValue set in lastDs.SetsCollection)
{
if (set.Label == record.Category)
{
if (this.SubType.ToString().Contains("Value"))
{
set.Value = record.SalesValue.ToString();
}
if (this.SubType.ToString().Contains("Quantity"))
{
set.Value = record.SalesQuantity.ToString();
}
}
}
}
}
}
catch (Exception ex)
{
throw new Exception("Error in ChartID.NewClientsByProductTypeMonth:" + ex.Message);
}
}
//}
break;
case ChartID.PipelineOpportunityAnalysis:
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll();
if (this.SubType == ChartSubType.SalesValueOppSource || this.SubType == ChartSubType.SalesQuantityOppSource)
{
foreach (var record in new OppSourceeRepository().GetAll())
{
this.Categories.Add(new Category { Label = record.Name });
}
}
else if (this.SubType == ChartSubType.SalesValueOpportunityType || this.SubType == ChartSubType.SalesQuantityOpportunityType)
{
foreach (var record in new OpprtunityTypesRepository().GetAll())
{
this.Categories.Add(new Category { Label = record.Name });
}
}
else
{
foreach (var record in products.Where(r => r.IsActive == true).AsEnumerable())
{
this.Categories.Add(new Category { Label = record.ProductTypeName });
}
}
chartParams = new List<ChartParameter>();
chartParams.Add(new ChartParameter { Value = "0", Color = "8A4B08" });
chartParams.Add(new ChartParameter { Value = "1", Color = "0000FF" });
chartParams.Add(new ChartParameter { Value = "2", Color = "ff9966" });
searchForNewCompany = (HttpContext.Current.Session["searchForNewCompany"] == null) ? "" : HttpContext.Current.Session["searchForNewCompany"].ToString();
searchCompanies = (HttpContext.Current.Session["searchCompanies"] == null) ? "" : HttpContext.Current.Session["searchCompanies"].ToString();
foreach (ChartParameter parameter in chartParams)
{
try
{
if (this.SubType == ChartSubType.ProductsSoldBySalesValue)
this.Caption = "Sales Value By Product (By Month)";
if (this.SubType == ChartSubType.ProductsSoldBySalesQuantity)
this.Caption = "Sales Quantity By Product (By Month)";
if (this.SubType == ChartSubType.SalesValueOppSource)
this.Caption = "Sales Value By Opportunity Source (By Month)";
if (this.SubType == ChartSubType.SalesQuantityOppSource)
this.Caption = "Sales Quantity By Opportunity Source (By Month)";
if (this.SubType == ChartSubType.SalesValueOpportunityType)
this.Caption = "Sales Value By Opportunity Type (By Month)";
if (this.SubType == ChartSubType.SalesQuantityOpportunityType)
this.Caption = "Sales Quantity By Opportunity Type (By Month)";
IEnumerable<SandlerModels.DataIntegration.PipelineOppAnalysisVM> productTypeVMCollection = queries.GetPipelineOpportunityAnalysis(currentUser, DateTime.Now.AddMonths(int.Parse(parameter.Value)).Month, this.SubType.ToString(), searchForNewCompany, searchCompanies);
if (productTypeVMCollection != null)
{
var clientsWithProducts = from record in productTypeVMCollection
select new { Category = record.Name, SalesValue = record.AvgPrice, SalesQuantity = record.Count };
this.DataSetCollection.Add(new ChartDataSet { Color = parameter.Color, SeriesName = DateTime.Now.AddMonths(int.Parse(parameter.Value)).ToString("MMM") });
string link = "";
foreach (Category category in this.Categories)
{
lastDs = this.DataSetCollection.Last();
link = string.Format("{0}?{1}={2}&{3}={4}&SubType={5}", "PipelineOppAnalysis.aspx", ConfigurationManager.AppSettings["QueryStringParamDrillChartIDs"], this.DrillChartIds, ConfigurationManager.AppSettings["QueryStringParamDrillBy"], lastDs.SeriesName, this.SubType.ToString());
lastDs.SetsCollection.Add(new SetValue { Label = category.Label, Link = link });
}
foreach (var record in clientsWithProducts)
{
foreach (SetValue set in lastDs.SetsCollection)
{
if (set.Label == record.Category)
{
if (this.SubType.ToString().Contains("Value"))
{
set.Value = record.SalesValue.ToString();
}
if (this.SubType.ToString().Contains("Quantity"))
{
set.Value = record.SalesQuantity.ToString();
}
}
}
}
}
}
catch (Exception ex)
{
throw new Exception("Error in ChartID.PipelineOpportunityAnalysis:" + ex.Message);
}
}
//}
break;
#endregion
#region FranchiseeReports Logic
case ChartID.NewAppointmentsBySourceMonth:
appointmentSource = new AppointmentSourceRepository();
foreach (var record in appointmentSource.GetAll().Where(r => r.IsActive == true).AsEnumerable())
{
this.Categories.Add(new Category { Label = record.ApptSourceName });
}
if (MonthYearCombinations == null)
{
chartParams = new List<ChartParameter>();
chartParams.Add(new ChartParameter { Value = "-2", Color = "3300ff" });
chartParams.Add(new ChartParameter { Value = "-1", Color = "ff6600" });
chartParams.Add(new ChartParameter { Value = "0", Color = "32df00" });
}
else
chartParams = MonthYearCombinations;
foreach (ChartParameter parameter in chartParams)
{
try
{
yearToProcess = (string.IsNullOrEmpty(parameter.YearVal)) ? ((DateTime.Now.AddMonths(int.Parse(parameter.Value)).Month > DateTime.Now.Month) ? DateTime.Now.AddYears(-1).Year : DateTime.Now.Year) : int.Parse(parameter.YearVal);
monthToProcess = (MonthYearCombinations == null) ? DateTime.Now.AddMonths(int.Parse(parameter.Value)).Month : int.Parse(parameter.Value);
IEnumerable<SandlerModels.DataIntegration.AppointmentSourceVM> appointmentSourceVMcollection = queries.GetNewAppointmentSource(currentUser, monthToProcess,yearToProcess);
if (appointmentSourceVMcollection != null)
{
var newAppointments = from record in appointmentSourceVMcollection
select new { Category = record.SourceName, Count = record.Count };
this.DataSetCollection.Add(new ChartDataSet { Color = parameter.Color, SeriesName = ChartHelper.GetMonthName(monthToProcess) + " (" + yearToProcess.ToString() + ")"});
foreach (Category category in this.Categories)
{
lastDs = this.DataSetCollection.Last();
lastDs.SetsCollection.Add(new SetValue { Label = category.Label, Link = (currentUser.Role == SandlerRoles.Client) ? "" : ChartHelper.GeneratePageLink(ChartHelper.GetMonthName(monthToProcess), this.DrillChartIds) });
}
foreach (var record in newAppointments)
{
foreach (SetValue set in lastDs.SetsCollection)
{
if (set.Label == record.Category)
set.Value = record.Count.ToString();
}
}
}
}
catch (Exception ex)
{
throw new Exception("Error in ChartID.NewAppointmentsBySourceMonth:" + ex.Message);
}
//}
}
break;
case ChartID.NewClientsByProductTypeMonth:
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll();
foreach (var record in products.Where(r => r.IsActive == true).AsEnumerable())
{
this.Categories.Add(new Category { Label = record.ProductTypeName });
}
if (MonthYearCombinations == null)
{
chartParams = new List<ChartParameter>();
chartParams.Add(new ChartParameter { Value = "-2", Color = "8A4B08" });
chartParams.Add(new ChartParameter { Value = "-1", Color = "0000FF" });
chartParams.Add(new ChartParameter { Value = "0", Color = "ff9966" });
}
else
chartParams = MonthYearCombinations;
foreach (ChartParameter parameter in chartParams)
{
try
{
yearToProcess = (string.IsNullOrEmpty(parameter.YearVal)) ? ((DateTime.Now.AddMonths(int.Parse(parameter.Value)).Month > DateTime.Now.Month) ? DateTime.Now.AddYears(-1).Year : DateTime.Now.Year) : int.Parse(parameter.YearVal);
monthToProcess = (MonthYearCombinations == null) ? DateTime.Now.AddMonths(int.Parse(parameter.Value)).Month : int.Parse(parameter.Value);
IEnumerable<SandlerModels.DataIntegration.ProductTypeVM> productTypeVMCollection = queries.GetNewClientsByProductType(currentUser, monthToProcess,yearToProcess);
if (productTypeVMCollection != null)
{
var newClientsByProducts = from record in productTypeVMCollection
select new { Category = record.ProductTypeName, Count = record.Count };
this.DataSetCollection.Add(new ChartDataSet { Color = parameter.Color, SeriesName = ChartHelper.GetMonthName(monthToProcess) + " (" + yearToProcess.ToString() + ")" });
foreach (Category category in this.Categories)
{
lastDs = this.DataSetCollection.Last();
lastDs.SetsCollection.Add(new SetValue { Label = category.Label, Link = (currentUser.Role == SandlerRoles.Client) ? "" : ChartHelper.GeneratePageLink(ChartHelper.GetMonthName(monthToProcess), this.DrillChartIds) });
}
foreach (var record in newClientsByProducts)
{
foreach (SetValue set in lastDs.SetsCollection)
{
if (set.Label == record.Category)
set.Value = record.Count.ToString();
}
}
}
}
catch (Exception ex)
{
throw new Exception("Error in ChartID.NewClientsByProductTypeMonth:" + ex.Message);
}
}
//}
break;
case ChartID.NewClientQuantityAverageContractPriceByMonth:
if (MonthYearCombinations == null)
{
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(-2).ToString("MMM") });
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(-1).ToString("MMM") });
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(0).ToString("MMM") });
}
else
{
foreach (ChartParameter param in MonthYearCombinations)
{
this.Categories.Add(new Category { Label = ChartHelper.GetMonthName(int.Parse(param.Value)) });
}
}
this.DataSetCollection.Add(new ChartDataSet { Color = "0000FF", SeriesName = "New Clients" });
this.DataSetCollection.Add(new ChartDataSet { Color = "ff6600", SeriesName = "Ave Contract Price" });
foreach (Category catagory in this.Categories)
{
try
{
yearToProcess = (DateTime.ParseExact(catagory.Label, "MMM", null).Month > DateTime.Now.Month) ? DateTime.Now.AddYears(-1).Year : DateTime.Now.Year;
monthToProcess = DateTime.ParseExact(catagory.Label, "MMM", null).Month;
int newClients = queries.GetNewClientCount(currentUser, monthToProcess, yearToProcess);
long aveContractPrice = queries.GetAveContractPrice(currentUser, monthToProcess, yearToProcess);
if (newClients > 0 && aveContractPrice > 0)
{
this.DataSetCollection[0].SetsCollection.Add(new SetValue { Value = newClients.ToString(), Link = (currentUser.Role == SandlerRoles.Client) ? "" : ChartHelper.GeneratePageLink(catagory.Label, this.DrillChartIds) });
this.DataSetCollection[1].SetsCollection.Add(new SetValue { Value = (aveContractPrice / 5).ToString(), Link = (currentUser.Role == SandlerRoles.Client) ? "" : ChartHelper.GeneratePageLink(catagory.Label, this.DrillChartIds) });
}
else
{
this.DataSetCollection[0].SetsCollection.Add(new SetValue());
this.DataSetCollection[1].SetsCollection.Add(new SetValue());
}
if (MonthYearCombinations != null) //Check CustomChart reports request
{
//After done process category change its label with month and year combination
catagory.Label = catagory.Label + "(" + yearToProcess.ToString() + ")";
}
}
catch (System.InvalidOperationException)
{
}
}
break;
case ChartID.ClassHeadcountByCourseIndustryMonth:
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(-2).ToString("MMM") });
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(-1).ToString("MMM") });
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(0).ToString("MMM") });
this.DataSetCollection.Add(new ChartDataSet { Color = "ff6600", SeriesName = "Course" });
this.DataSetCollection.Add(new ChartDataSet { Color = "32df00", SeriesName = "Industry" });
foreach (Category catagory in this.Categories)
{
try
{
int classHeadCountsCourse = queries.GetClassHeadCountsCourse(currentUser, DateTime.ParseExact(catagory.Label, "MMM", null).Month);
int classHeadCountsIndustry = queries.GetClassHeadCountsIndustry(currentUser, DateTime.ParseExact(catagory.Label, "MMM", null).Month);
//if (classHeadCountsCourse > 0 && classHeadCountsIndustry > 0)
//{
this.DataSetCollection[0].SetsCollection.Add(new SetValue { Value = (classHeadCountsCourse > 0) ? classHeadCountsCourse.ToString():"", Link = (currentUser.Role == SandlerRoles.Client) ? "" : (classHeadCountsCourse > 0) ? ChartHelper.GeneratePageLink(catagory.Label, this.DrillChartIds):"" });
this.DataSetCollection[1].SetsCollection.Add(new SetValue { Value = (classHeadCountsIndustry > 0) ? classHeadCountsIndustry.ToString():"", Link = (currentUser.Role == SandlerRoles.Client) ? "" : (classHeadCountsIndustry > 0) ? ChartHelper.GeneratePageLink(catagory.Label, this.DrillChartIds):"" });
//}
}
catch (System.InvalidOperationException)
{
}
}
//}
break;
case ChartID.ActualDollarsBookedComparisonGoal:
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(-4).ToString("MMM") });
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(-3).ToString("MMM") });
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(-2).ToString("MMM") });
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(-1).ToString("MMM") });
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(0).ToString("MMM") });
this.Categories.Add(new Category { Label = DateTime.Now.AddMonths(1).ToString("MMM") });
this.DataSetCollection.Add(new ChartDataSet { Color = "0066ff", SeriesName = "$$Booked" });
this.DataSetCollection.Add(new ChartDataSet { Color = "ffff99", SeriesName = "% of Goal" });
foreach (Category catagory in this.Categories)
{
try
{
long actualDollarsBooked = queries.GetActualDollarsBooked(currentUser, DateTime.ParseExact(catagory.Label, "MMM", null).Month);
long goalOfDollarsBooked = queries.GetGoalOfDollarsBooked(currentUser, DateTime.ParseExact(catagory.Label, "MMM", null).Month);
//if (actualDollarsBooked > 0 && goalOfDollarsBooked > 0)
//{
this.DataSetCollection[0].SetsCollection.Add(new SetValue { Label = catagory.Label, Value = actualDollarsBooked.ToString(), Link = (currentUser.Role == SandlerRoles.Client) ? "" : ChartHelper.GeneratePageLink("", this.DrillChartIds) });
this.DataSetCollection[1].SetsCollection.Add(new SetValue { Label = catagory.Label, Value = ((Convert.ToDouble(actualDollarsBooked) / Convert.ToDouble(goalOfDollarsBooked)) * 100).ToString("#.##"), Link = (currentUser.Role == SandlerRoles.Client) ? "" : ChartHelper.GeneratePageLink("", this.DrillChartIds) });
//}
}
catch (System.InvalidOperationException)
{
}
}
break;
#endregion
case ChartID.GapAnalysis:
this.Categories.Add(new Category { Label = "Sales Cycle Time" });
this.Categories.Add(new Category { Label = "Sales Efficiency" });
this.Categories.Add(new Category { Label = "Sales Qualification" });
this.Categories.Add(new Category { Label = "Sales Rep Retention" });
this.Categories.Add(new Category { Label = "Quota Achievement" });
this.Categories.Add(new Category { Label = "Sandler Trng Benefits" });
GATracker gaRecord = null;
GapAnalysisRepository gaData = new GapAnalysisRepository();
this.DataSetCollection.Add(new ChartDataSet { Color = "0000FF", SeriesName = "As-Is" });
this.DataSetCollection.Add(new ChartDataSet { Color = "8A4B08", SeriesName = "To-Be" });
gaRecord = gaData.GetGATrackerById(int.Parse(SearchParameter));
if (gaRecord != null)
{
this.DataSetCollection[0].SetsCollection.Add(new SetValue { Value = gaRecord.AsIsSalesCycleTimePercentVal.Value.ToString(), Link = "GapAnalysisCreate.aspx" });
this.DataSetCollection[0].SetsCollection.Add(new SetValue { Value = gaRecord.AsIsSalesEfficiencyPercentVal.Value.ToString(), Link = "GapAnalysisCreate.aspx" });
this.DataSetCollection[0].SetsCollection.Add(new SetValue { Value = gaRecord.AsIsSalesQualificationPercentVal.ToString(), Link = "GapAnalysisCreate.aspx" });
this.DataSetCollection[0].SetsCollection.Add(new SetValue { Value = gaRecord.AsIsSalesRepRetentionPercentVal.ToString(), Link = "GapAnalysisCreate.aspx" });
this.DataSetCollection[0].SetsCollection.Add(new SetValue { Value = gaRecord.AsIsQuotaAchievementPercentVal.ToString(), Link = "GapAnalysisCreate.aspx" });
this.DataSetCollection[0].SetsCollection.Add(new SetValue { Value = gaRecord.AsIsTrngBenefitsPercentVal.ToString(), Link = "GapAnalysisCreate.aspx" });
this.DataSetCollection[1].SetsCollection.Add(new SetValue { Value = gaRecord.ToBeSalesCycleTimePercentVal.ToString(), Link = "GapAnalysisCreate.aspx" });
this.DataSetCollection[1].SetsCollection.Add(new SetValue { Value = gaRecord.ToBeSalesEfficiencyPercentVal.ToString(), Link = "GapAnalysisCreate.aspx" });
this.DataSetCollection[1].SetsCollection.Add(new SetValue { Value = gaRecord.ToBeSalesQualificationPercentVal.ToString(), Link = "GapAnalysisCreate.aspx" });
this.DataSetCollection[1].SetsCollection.Add(new SetValue { Value = gaRecord.ToBeSalesRepRetentionPercentVal.ToString(), Link = "GapAnalysisCreate.aspx" });
this.DataSetCollection[1].SetsCollection.Add(new SetValue { Value = gaRecord.ToBeQuotaAchievementPercentVal.ToString(), Link = "GapAnalysisCreate.aspx" });
this.DataSetCollection[1].SetsCollection.Add(new SetValue { Value = gaRecord.ToBeTrngBenefitsPercentVal.ToString(), Link = "GapAnalysisCreate.aspx" });
}
break;
default:
break;
}
}
catch (Exception ex)
{
throw ex;
}
}
public new void LoadChart(UserModel currentUser)
{
try
{
this.DrillChartIds = (this.DrillOverride) ? this.Id.ToString() : this.DrillChartIds;
int colorIndex = 0;
SandlerModels.DataIntegration.DataQueries queries = new SandlerModels.DataIntegration.DataQueries();
AppointmentSourceRepository appointmentSource = null;
ProductTypesRepository productTypesSource = null;
string[] colors = null;
string searchForNewCompany, searchCompanies;
var totalPrice = 0.0;
var totalCounts = 0.0;
IEnumerable<Tbl_ProductType> products;
string companyName = "";
string franchiseeName = "";
string regionName = "";
string countryName = "";
int monthToProcess, yearToProcess;
double avgValue;
switch (this.Id)
{
case ChartID.SalesCycleTimeMain:
IEnumerable<SandlerModels.DataIntegration.SalesCycleTimePortfolioVM> salesCyclePortfolio = queries.GetSalesCycleTimePortfolio(currentUser);
int totalCount = salesCyclePortfolio.Count();
if (salesCyclePortfolio != null)
{
var salesCycleData = from opportunity in salesCyclePortfolio
group opportunity by new { opportunity.MultipleOfSixVal }
into grp
select new { Legend = ChartHelper.GetSCTimeLegend(grp.Key.MultipleOfSixVal), Count = grp.Count() * 100 / totalCount };
colors = new string[] { "CC6600", "9900CC", "FF3300", "0099FF", "00CC66", "FFFF00", "CC6600", "9900CC" };
foreach (var record in salesCycleData)
{
this.SetsCollection.Add(new SetValue { Color = colors.GetValue(colorIndex).ToString(), Label = record.Legend, Value = record.Count.ToString() });
colorIndex++;
}
}
break;
#region AdHocReports logic
case ChartID.PipelineOpportunityAnalysisBySource:
if (this.SubType == ChartSubType.ProductsSoldBySalesValue)
this.Caption = "Sales Value Percentage By Product";
if (this.SubType == ChartSubType.ProductsSoldBySalesQuantity)
this.Caption = "Sales Quantity Percentage By Product";
if (this.SubType == ChartSubType.SalesValueOppSource)
this.Caption = "Sales Value Percentage By Opportunity Source";
if (this.SubType == ChartSubType.SalesQuantityOppSource)
this.Caption = "Sales Quantity Percentage By Opportunity Source";
if (this.SubType == ChartSubType.SalesValueOpportunityType)
this.Caption = "Sales Value Percentage By Opportunity Source";
if (this.SubType == ChartSubType.SalesQuantityOpportunityType)
this.Caption = "Sales Quantity Percentage By Opportunity Source";
searchForNewCompany = (HttpContext.Current.Session["searchForNewCompany"] == null) ? "" : HttpContext.Current.Session["searchForNewCompany"].ToString();
searchCompanies = (HttpContext.Current.Session["searchCompanies"] == null) ? "" : HttpContext.Current.Session["searchCompanies"].ToString();
IEnumerable<SandlerModels.DataIntegration.PipelineOppAnalysisVM> pipelineSalesVMCollection = queries.GetPipelineOpportunityAnalysis(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month, this.SubType.ToString(), searchForNewCompany, searchCompanies);
colors = new string[] { "CC6600", "9900CC", "FF3300", "0099FF", "00CC66", "FFFF00", "CC6600", "9900CC" };
totalPrice = pipelineSalesVMCollection.Sum(r => r.AvgPrice);
totalCounts = pipelineSalesVMCollection.Sum(r => r.Count);
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll().Where(r => r.IsActive == true);
if (this.SubType == ChartSubType.SalesValueOppSource || this.SubType == ChartSubType.SalesQuantityOppSource)
{
foreach (var record in new OpprtunitySourceRepository().GetAll())
{
try
{
if (pipelineSalesVMCollection.Single(r => r.Name == record.Name) != null)
{
if (this.SubType.ToString().Contains("Value"))
this.SetsCollection.Add(new SetValue { Color = colors.GetValue(colorIndex).ToString(), Label = record.Name, Value = (((pipelineSalesVMCollection.Single(r => r.Name == record.Name).AvgPrice) / totalPrice) * 100).ToString() });
else
{
this.SetsCollection.Add(new SetValue { Color = colors.GetValue(colorIndex).ToString(), Label = record.Name, Value = ((pipelineSalesVMCollection.Single(r => r.Name == record.Name).Count * 100) / totalCounts).ToString() });
}
}
}
catch (System.InvalidOperationException)
{
}
colorIndex++;
}
}
else if (this.SubType == ChartSubType.SalesValueOpportunityType || this.SubType == ChartSubType.SalesQuantityOpportunityType)
{
foreach (var record in new OpprtunityTypesRepository().GetAll())
{
try
{
if (pipelineSalesVMCollection.Single(r => r.Name == record.Name) != null)
{
if (this.SubType.ToString().Contains("Value"))
this.SetsCollection.Add(new SetValue { Color = colors.GetValue(colorIndex).ToString(), Label = record.Name, Value = (((pipelineSalesVMCollection.Single(r => r.Name == record.Name).AvgPrice) / totalPrice) * 100).ToString() });
else
{
this.SetsCollection.Add(new SetValue { Color = colors.GetValue(colorIndex).ToString(), Label = record.Name, Value = ((pipelineSalesVMCollection.Single(r => r.Name == record.Name).Count * 100) / totalCounts).ToString() });
}
}
}
catch (System.InvalidOperationException)
{
}
colorIndex++;
}
}
else
{
int tmpCount = 0;
foreach (var record in products.AsEnumerable())
{
try
{
if (pipelineSalesVMCollection.Single(r => r.Name == record.ProductTypeName) != null)
{
if (this.SubType.ToString().Contains("Value"))
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ProductTypeName, Value = (((pipelineSalesVMCollection.Single(r => r.Name == record.ProductTypeName).AvgPrice) / totalPrice) * 100).ToString() });
else
{
tmpCount = pipelineSalesVMCollection.Single(r => r.Name == record.ProductTypeName).Count;
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ProductTypeName, Value = ((tmpCount * 100) / totalCounts).ToString() });
}
}
}
catch (System.InvalidOperationException)
{
}
}
}
//}
break;
case ChartID.ClosedSalesAnalysisBySource:
if (this.SubType == ChartSubType.ProductsSoldBySalesValue)
this.Caption = "Sales Value Percentage By Product";
if (this.SubType == ChartSubType.ProductsSoldBySalesQuantity)
this.Caption = "Sales Quantity Percentage By Product";
if (this.SubType == ChartSubType.SalesValueOppSource)
this.Caption = "Sales Value Percentage By Opportunity Source";
if (this.SubType == ChartSubType.SalesQuantityOppSource)
this.Caption = "Sales Quantity Percentage By Opportunity Source";
if (this.SubType == ChartSubType.SalesValueOpportunityType)
this.Caption = "Sales Value Percentage By Opportunity Source";
if (this.SubType == ChartSubType.SalesQuantityOpportunityType)
this.Caption = "Sales Quantity Percentage By Opportunity Source";
searchForNewCompany = (HttpContext.Current.Session["searchForNewCompany"] == null) ? "" : HttpContext.Current.Session["searchForNewCompany"].ToString();
searchCompanies = (HttpContext.Current.Session["searchCompanies"] == null) ? "" : HttpContext.Current.Session["searchCompanies"].ToString();
IEnumerable<SandlerModels.DataIntegration.ClosedSalesVM> productTypeVMCollection = queries.GetClosedSalesAnalysis(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month, this.SubType.ToString(), searchForNewCompany, searchCompanies);
colors = new string[] { "CC6600", "9900CC", "FF3300", "0099FF", "00CC66", "FFFF00", "CC6600", "9900CC" };
totalPrice = productTypeVMCollection.Sum(r => r.AvgPrice);
totalCounts = productTypeVMCollection.Sum(r => r.Count);
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll().Where(r => r.IsActive == true);
if (this.SubType == ChartSubType.SalesValueOppSource || this.SubType == ChartSubType.SalesQuantityOppSource)
{
foreach (var record in new OpprtunitySourceRepository().GetAll())
{
try
{
if (productTypeVMCollection.Single(r => r.Name == record.Name) != null)
{
if (this.SubType.ToString().Contains("Value"))
this.SetsCollection.Add(new SetValue { Color = colors.GetValue(colorIndex).ToString(), Label = record.Name, Value = (((productTypeVMCollection.Single(r => r.Name == record.Name).AvgPrice) / totalPrice) * 100).ToString() });
else
{
this.SetsCollection.Add(new SetValue { Color = colors.GetValue(colorIndex).ToString(), Label = record.Name, Value = ((productTypeVMCollection.Single(r => r.Name == record.Name).Count * 100) / totalCounts).ToString() });
}
}
}
catch (System.InvalidOperationException)
{
}
colorIndex++;
}
}
else if (this.SubType == ChartSubType.SalesValueOpportunityType || this.SubType == ChartSubType.SalesQuantityOpportunityType)
{
foreach (var record in new OpprtunityTypesRepository().GetAll())
{
try
{
if (productTypeVMCollection.Single(r => r.Name == record.Name) != null)
{
if (this.SubType.ToString().Contains("Value"))
this.SetsCollection.Add(new SetValue { Color = colors.GetValue(colorIndex).ToString(), Label = record.Name, Value = (((productTypeVMCollection.Single(r => r.Name == record.Name).AvgPrice) / totalPrice) * 100).ToString() });
else
{
this.SetsCollection.Add(new SetValue { Color = colors.GetValue(colorIndex).ToString(), Label = record.Name, Value = ((productTypeVMCollection.Single(r => r.Name == record.Name).Count * 100) / totalCounts).ToString() });
}
}
}
catch (System.InvalidOperationException)
{
}
colorIndex++;
}
}
else
{
int tmpCount = 0;
foreach (var record in products.AsEnumerable())
{
try
{
if (productTypeVMCollection.Single(r => r.Name == record.ProductTypeName) != null)
{
if (this.SubType.ToString().Contains("Value"))
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ProductTypeName, Value = (((productTypeVMCollection.Single(r => r.Name == record.ProductTypeName).AvgPrice) / totalPrice) * 100).ToString() });
else
{
tmpCount = productTypeVMCollection.Single(r => r.Name == record.ProductTypeName).Count;
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ProductTypeName, Value = ((tmpCount * 100) / totalCounts).ToString() });
}
}
}
catch (System.InvalidOperationException)
{
}
}
}
//}
break;
#endregion
#region FranchiseeReports logic
case ChartID.NewAppointmentsBySource:
monthToProcess = DateTime.ParseExact(this.DrillBy, "MMM", null).Month;
yearToProcess = (monthToProcess > DateTime.Now.Month) ? DateTime.Now.AddYears(-1).Year : DateTime.Now.Year;
//if (queries.GetNewAppointmentSource(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month) != null)
//{
var NewAppointmentSource = from record in queries.GetNewAppointmentSource(currentUser, monthToProcess, yearToProcess)
select new { Category = record.SourceName, Count = record.Count };
totalCount = NewAppointmentSource.Sum(r => r.Count);
appointmentSource = new AppointmentSourceRepository();
foreach (var record in appointmentSource.GetAll().Where(r => r.IsActive == true).AsEnumerable())
{
try
{
if (NewAppointmentSource.Single(r => r.Category == record.ApptSourceName) != null)
{
avgValue = NewAppointmentSource.Single(r => r.Category == record.ApptSourceName).Count * 100;
avgValue = Math.Round(avgValue/totalCount,2);
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ApptSourceName, Value = avgValue.ToString("#.##") });
}
}
catch (System.InvalidOperationException)
{
}
colorIndex++;
}
//}
break;
case ChartID.NewClientByProductType:
//if (queries.GetNewClientsByProductType(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month) != null)
//{
monthToProcess = DateTime.ParseExact(this.DrillBy, "MMM", null).Month;
yearToProcess = (monthToProcess > DateTime.Now.Month) ? DateTime.Now.AddYears(-1).Year : DateTime.Now.Year;
var NewClientsByProductType = from record in queries.GetNewClientsByProductType(currentUser,monthToProcess, yearToProcess )
select new { Category = record.ProductTypeName, Count = record.Count };
totalCount = NewClientsByProductType.Sum(r => r.Count);
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll().Where(r => r.IsActive == true);
foreach (var record in products.AsEnumerable())
{
try
{
if (NewClientsByProductType.Single(r => r.Category == record.ProductTypeName) != null)
{
avgValue = NewClientsByProductType.Single(r => r.Category == record.ProductTypeName).Count * 100;
avgValue = Math.Round(avgValue / totalCount, 2);
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ProductTypeName, Value = avgValue.ToString("#.##")});
}
}
catch (System.InvalidOperationException)
{
}
}
//}
break;
case ChartID.NewClientQuantity:
//if (queries.NewClientsWithProductTypes(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month) != null)
//{
var NewClientsWithProductTypes = from record in queries.NewClientsWithProductTypes(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month)
select new { Category = record.ProductTypeName, Count = record.Count };
productTypesSource = new ProductTypesRepository();
totalCount = NewClientsWithProductTypes.Sum(r => r.Count);
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll().Where(r => r.IsActive == true);
foreach (var record in products.AsEnumerable())
{
try
{
if (NewClientsWithProductTypes.Single(r => r.Category == record.ProductTypeName) != null)
{
avgValue = NewClientsWithProductTypes.Single(r => r.Category == record.ProductTypeName).Count * 100;
avgValue = Math.Round(avgValue / totalCount, 2);
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ProductTypeName, Value = avgValue.ToString("#.##") });
}
}
catch (System.InvalidOperationException)
{
}
}
//}
break;
case ChartID.ContractPrice:
//if (queries.ContractPriceWithProductTypes(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month) != null)
//{
var ContractPriceWithProductTypes = from record in queries.ContractPriceWithProductTypes(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month)
select new { Category = record.ProductTypeName, AvgPrice = record.AvgPrice };
productTypesSource = new ProductTypesRepository();
totalPrice = ContractPriceWithProductTypes.Sum(r => r.AvgPrice);
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll().Where(r => r.IsActive == true);
foreach (var record in products.AsEnumerable())
{
try
{
if (ContractPriceWithProductTypes.Single(r => r.Category == record.ProductTypeName) != null)
{
avgValue = ContractPriceWithProductTypes.Single(r => r.Category == record.ProductTypeName).AvgPrice * 100;
avgValue = Math.Round(avgValue / totalPrice, 2);
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ProductTypeName, Value = avgValue.ToString("#.##") });
}
}
catch (System.InvalidOperationException)
{
}
}
//}
break;
case ChartID.HeadcountByCourse:
//if (queries.GetHeadcountByCourse(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month) != null)
//{
var headCountsByCourse = from record in queries.GetHeadcountByCourse(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month)
select new { Course = record.CourseName, Count = record.Count };
totalCount = headCountsByCourse.Sum(r => r.Count);
colors = new string[] { "CC6600", "9900CC", "FF3300", "0099FF", "00CC66", "FFFF00" };
CourseRepository courseSource = new CourseRepository();
foreach (var record in courseSource.GetAll().Where(r => r.IsActive == true).AsEnumerable())
{
try
{
if (headCountsByCourse.Single(r => r.Course == record.CourseName) != null)
{
avgValue = headCountsByCourse.Single(r => r.Course == record.CourseName).Count * 100;
avgValue = Math.Round(avgValue/totalCount,2);
this.SetsCollection.Add(new SetValue { Color = colors.GetValue(colorIndex).ToString(), Label = record.CourseName, Value = avgValue.ToString("#.##") });
}
}
catch (System.InvalidOperationException)
{
}
colorIndex++;
}
//}
break;
case ChartID.HeadcountByIndustry:
var data = from record in queries.GetHeadcountByIndustry(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month)
select new { Industry = record.IndustryTypeName, Count = record.Count };
totalCount = data.Sum(r => r.Count);
colors = new string[] { "9900CC", "FF3300", "0099FF", "00CC66", "FFFF00" };
IndustryTypeRepository industrySource = new IndustryTypeRepository();
foreach (var record in industrySource.GetAll().Where(r => r.IsActive == true).AsEnumerable())
{
try
{
if (data.Single(r => r.Industry == record.IndustryTypeName) != null)
{
avgValue = data.Single(r => r.Industry == record.IndustryTypeName).Count * 100;
avgValue = Math.Round(avgValue / totalCount, 2);
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.IndustryTypeName, Value = avgValue.ToString("#.##") });
}
}
catch (System.InvalidOperationException)
{
}
colorIndex++;
}
//}
break;
#endregion
#region ProductsReports Logic
case ChartID.ProductMarginValue:
var productSalesValue = from record in queries.GetProductSalesByMonth(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month)
select new { Name = record.ProductTypeName, Value = record.AvgPrice };
totalPrice = productSalesValue.Sum(r => r.Value);
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll().Where(r => r.IsActive == true);
foreach (var record in products.AsEnumerable())
{
try
{
if (productSalesValue.Single(r => r.Name == record.ProductTypeName) != null)
{
avgValue = productSalesValue.Single(r => r.Name == record.ProductTypeName).Value * 100;
avgValue = Math.Round(avgValue / totalPrice, 2);
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ProductTypeName, Value = avgValue.ToString("#.##") });
}
}
catch (System.InvalidOperationException)
{
}
}
break;
case ChartID.ProductSalesQty:
var productSalesQty = from record in queries.GetProductSalesByMonth(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month)
select new { Name = record.ProductTypeName, Count = record.Count };
totalPrice = productSalesQty.Sum(r => r.Count);
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll().Where(r => r.IsActive == true);
foreach (var record in products.AsEnumerable())
{
try
{
if (productSalesQty.Single(r => r.Name == record.ProductTypeName) != null)
{
avgValue = productSalesQty.Single(r => r.Name == record.ProductTypeName).Count * 100;
avgValue = Math.Round(avgValue / totalPrice, 2);
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ProductTypeName, Value = avgValue.ToString("#.##") });
}
}
catch (System.InvalidOperationException)
{
}
}
break;
case ChartID.ProductFirstSalesValue:
var productFirstSalesValue = from record in queries.GetProductFirstSalesByMonth(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month)
select new { Name = record.ProductTypeName, Value = record.AvgPrice };
totalPrice = productFirstSalesValue.Sum(r => r.Value);
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll().Where(r => r.IsActive == true);
foreach (var record in products.AsEnumerable())
{
try
{
if (productFirstSalesValue.Single(r => r.Name == record.ProductTypeName) != null)
{
avgValue = productFirstSalesValue.Single(r => r.Name == record.ProductTypeName).Value*100;
avgValue = Math.Round(avgValue/totalPrice,2);
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ProductTypeName, Value = avgValue.ToString("#.##") });
}
}
catch (System.InvalidOperationException)
{
}
}
break;
case ChartID.ProductFirstSalesQty:
var productFirstSalesQty = from record in queries.GetProductFirstSalesByMonth(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month)
select new { Name = record.ProductTypeName, Count = record.Count };
totalPrice = productFirstSalesQty.Sum(r => r.Count);
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll().Where(r => r.IsActive == true);
foreach (var record in products.AsEnumerable())
{
try
{
if (productFirstSalesQty.Single(r => r.Name == record.ProductTypeName) != null)
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ProductTypeName, Value = (((productFirstSalesQty.Single(r => r.Name == record.ProductTypeName).Count) / totalPrice) * 100).ToString() });
}
catch (System.InvalidOperationException)
{
}
}
break;
case ChartID.ProductSalesByCompanyQuantity:
try
{
companyName = new CompaniesRepository().GetById(long.Parse(SearchParameter)).COMPANYNAME;
this.Caption = this.Caption.Replace("Company Name", companyName);
var productSalestoCompanyQty = from record in queries.GetProductSoldByCompanyByMonth(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month, int.Parse(this.SearchParameter))
select new { Name = record.ProductTypeName, Count = record.Count };
totalCounts = productSalestoCompanyQty.Sum(r => r.Count);
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll().Where(r => r.IsActive == true);
//double percentCount = 0.0;
foreach (var record in products.AsEnumerable())
{
try
{
if (productSalestoCompanyQty.Single(r => r.Name == record.ProductTypeName) != null)
{
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ProductTypeName, Value = (((productSalestoCompanyQty.Single(r => r.Name == record.ProductTypeName).Count) / totalCounts) * 100).ToString() });
}
}
catch (System.InvalidOperationException)
{
}
}
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.ProductSalesByCompanyQuantity:" + ex.Message);
}
break;
case ChartID.ProductSalesByCompanyValue:
try
{
companyName = new CompaniesRepository().GetById(long.Parse(SearchParameter)).COMPANYNAME;
this.Caption = this.Caption.Replace("Company Name", companyName);
var productSalestoCompanyValue = from record in queries.GetProductSoldByCompanyByMonth(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month, int.Parse(SearchParameter))
select new { Name = record.ProductTypeName, Value = record.AvgPrice };
totalPrice = productSalestoCompanyValue.Sum(r => r.Value);
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll().Where(r => r.IsActive == true);
foreach (var record in products.AsEnumerable())
{
try
{
if (productSalestoCompanyValue.Single(r => r.Name == record.ProductTypeName) != null)
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ProductTypeName, Value = (((productSalestoCompanyValue.Single(r => r.Name == record.ProductTypeName).Value) / totalPrice) * 100).ToString() });
}
catch (System.InvalidOperationException)
{
}
}
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.ProductSalesByCompanyValue:" + ex.Message);
}
break;
case ChartID.ProductSalesBySalesRepQuantity:
try
{
this.Caption = this.Caption.Replace("Sales Rep", SearchParameter);
var productSalesBySalesRepQty = from record in queries.GetProductSoldBySalesRepByMonth(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month, this.SearchParameter)
select new { Name = record.ProductTypeName, Count = record.Count };
totalCounts = productSalesBySalesRepQty.Sum(r => r.Count);
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll().Where(r => r.IsActive == true);
//double percentCount = 0.0;
foreach (var record in products.AsEnumerable())
{
try
{
if (productSalesBySalesRepQty.Single(r => r.Name == record.ProductTypeName) != null)
{
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ProductTypeName, Value = (((productSalesBySalesRepQty.Single(r => r.Name == record.ProductTypeName).Count) / totalCounts) * 100).ToString() });
}
}
catch (System.InvalidOperationException)
{
}
}
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.ProductSalesBySalesRepQuantity:" + ex.Message);
}
break;
case ChartID.ProductSalesBySalesRepValue:
try
{
this.Caption = this.Caption.Replace("Sales Rep", SearchParameter);
var productSalesBtSalesRepValue = from record in queries.GetProductSoldBySalesRepByMonth(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month, SearchParameter)
select new { Name = record.ProductTypeName, Value = record.AvgPrice };
totalPrice = productSalesBtSalesRepValue.Sum(r => r.Value);
productTypesSource = new ProductTypesRepository();
if (currentUser.Role == SandlerRoles.FranchiseeOwner || currentUser.Role == SandlerRoles.FranchiseeUser)
products = productTypesSource.GetWithFranchiseeId(currentUser.FranchiseeID);
else
products = productTypesSource.GetAll().Where(r => r.IsActive == true);
foreach (var record in products.AsEnumerable())
{
try
{
if (productSalesBtSalesRepValue.Single(r => r.Name == record.ProductTypeName) != null)
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.ProductTypeName, Value = (((productSalesBtSalesRepValue.Single(r => r.Name == record.ProductTypeName).Value) / totalPrice) * 100).ToString() });
}
catch (System.InvalidOperationException)
{
}
}
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.ProductSalesBySalesRepValue:" + ex.Message);
}
break;
#endregion
#region BenchMarkReports Logic
case ChartID.BenchmarkSalesRepFranchiseeQty:
double salesRepQty;
try
{
franchiseeName = new FranchiseeRepository().GetById(currentUser.FranchiseeID).Name;
Caption = Caption.Replace("Sales Rep", SearchParameter).Replace("Name", franchiseeName);
IEnumerable<SandlerModels.DataIntegration.BenchMarkVM> salesRepToFranchiseeData = queries.GetBenchMarkSalesRepToFranchiseeByMonth(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month); ;
totalCounts = salesRepToFranchiseeData.Sum(r => r.Count);
this.SetsCollection.Add(new SetValue
{
Color = "4F94CD",
Label = "Franchisee",
Value = ((((from record in salesRepToFranchiseeData.Where(r => r.KeyGroupId != SearchParameter)
select record).Sum(r => r.Count)) / totalCounts) * 100).ToString()
});
SandlerModels.DataIntegration.BenchMarkVM repRecord = salesRepToFranchiseeData.Where(r => r.KeyGroupId == SearchParameter).SingleOrDefault();
salesRepQty = (repRecord == null) ? 0.0 : repRecord.Count;
this.SetsCollection.Add(new SetValue
{
Color = "FF8C00",
Label = "Rep",
Value = (( salesRepQty/ totalCounts) * 100).ToString()
});
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.BenchmarkSalesRepFranchiseeQty:" + ex.Message);
}
break;
case ChartID.BenchmarkSalesRepFranchiseeValue:
double salesRepValue;
try
{
franchiseeName = new FranchiseeRepository().GetById(currentUser.FranchiseeID).Name;
Caption = Caption.Replace("Sales Rep", SearchParameter).Replace("Name", franchiseeName);
IEnumerable<SandlerModels.DataIntegration.BenchMarkVM> salesRepToFranchiseeData = queries.GetBenchMarkSalesRepToFranchiseeByMonth(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month); ;
totalPrice = salesRepToFranchiseeData.Sum(r => r.Value);
this.SetsCollection.Add(new SetValue
{
Color = "4F94CD",
Label = "Franchisee",
Value = ((((from record in salesRepToFranchiseeData.Where(r => r.KeyGroupId != SearchParameter)
select record).Sum(r => r.Value)) / totalPrice) * 100).ToString()
});
SandlerModels.DataIntegration.BenchMarkVM repRecord = salesRepToFranchiseeData.Where(r => r.KeyGroupId == SearchParameter).SingleOrDefault();
salesRepValue = (repRecord == null) ? 0.0 : repRecord.Value;
this.SetsCollection.Add(new SetValue
{
Color = "FF8C00",
Label = "Rep",
Value = ((salesRepValue / totalPrice) * 100).ToString()
});
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.BenchmarkSalesRepFranchiseeValue:" + ex.Message);
}
break;
case ChartID.BenchmarkFranchiseeRegionQty:
double franchiseeQty;
try
{
franchiseeName = new FranchiseeRepository().GetById(int.Parse(SearchParameter)).Name;
regionName = new RegionRepository().GetById(currentUser.RegionID).Name;
Caption = Caption.Replace("Region Name", regionName).Replace("Franchisee Name", franchiseeName);
IEnumerable<SandlerModels.DataIntegration.BenchMarkVM> salesFranchiseeToRegionsData = queries.GetBenchMarkFranchiseeToRegionsByMonth(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month); ;
totalCounts = salesFranchiseeToRegionsData.Sum(r => r.Count);
this.SetsCollection.Add(new SetValue
{
Color = "32df00",
Label = "Region",
Value = ((((from record in salesFranchiseeToRegionsData.Where(r => r.KeyGroupId != SearchParameter)
select record).Sum(r => r.Count)) / totalCounts) * 100).ToString()
});
SandlerModels.DataIntegration.BenchMarkVM franchiseeRecord = salesFranchiseeToRegionsData.Where(r => r.KeyGroupId == SearchParameter).SingleOrDefault();
franchiseeQty = (franchiseeRecord == null) ? 0.0 : franchiseeRecord.Count;
this.SetsCollection.Add(new SetValue
{
Color = "4F94CD",
Label = "Franchisee",
Value = ((franchiseeQty / totalCounts) * 100).ToString()
});
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.BenchmarkFranchiseeRegionQty:" + ex.Message);
}
break;
case ChartID.BenchmarkFranchiseeRegionValue:
double franchiseeValue;
try
{
franchiseeName = new FranchiseeRepository().GetById(int.Parse(SearchParameter)).Name;
regionName = new RegionRepository().GetById(currentUser.RegionID).Name;
Caption = Caption.Replace("Region Name", regionName).Replace("Franchisee Name", franchiseeName);
IEnumerable<SandlerModels.DataIntegration.BenchMarkVM> salesFranchiseeToRegionsData = queries.GetBenchMarkFranchiseeToRegionsByMonth(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month); ;
totalPrice = salesFranchiseeToRegionsData.Sum(r => r.Value);
this.SetsCollection.Add(new SetValue
{
Color = "32df00",
Label = "Region",
Value = ((((from record in salesFranchiseeToRegionsData.Where(r => r.KeyGroupId != SearchParameter)
select record).Sum(r => r.Value)) / totalPrice) * 100).ToString()
});
SandlerModels.DataIntegration.BenchMarkVM franchiseeRecord = salesFranchiseeToRegionsData.Where(r => r.KeyGroupId == SearchParameter).SingleOrDefault();
franchiseeValue = (franchiseeRecord == null) ? 0.0 : franchiseeRecord.Value;
this.SetsCollection.Add(new SetValue
{
Color = "4F94CD",
Label = "Franchisee",
Value = ((franchiseeValue / totalPrice) * 100).ToString()
});
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.BenchmarkFranchiseeRegionValue:" + ex.Message);
}
break;
case ChartID.BenchmarkRegionCountryQty:
double regionQty;
try
{
regionName = new RegionRepository().GetById(int.Parse(SearchParameter)).Name;
countryName = new CountryRepository().GetById(currentUser.CountryID).Name;
Caption = Caption.Replace("Region Name", regionName).Replace("Country Name", countryName);
IEnumerable<SandlerModels.DataIntegration.BenchMarkVM> salesRegionToCountryData = queries.GetBenchMarkRegionToCountryByMonth(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month); ;
totalCounts = salesRegionToCountryData.Sum(r => r.Count);
this.SetsCollection.Add(new SetValue
{
Color = "800080",
Label = "Country",
Value = ((((from record in salesRegionToCountryData.Where(r => r.KeyGroupId != SearchParameter)
select record).Sum(r => r.Count)) / totalCounts) * 100).ToString()
});
SandlerModels.DataIntegration.BenchMarkVM regionRecord = salesRegionToCountryData.Where(r => r.KeyGroupId == SearchParameter).SingleOrDefault();
regionQty = (regionRecord == null) ? 0.0 : regionRecord.Count;
this.SetsCollection.Add(new SetValue
{
Color = "32df00",
Label = "Region",
Value = ((regionQty / totalCounts) * 100).ToString()
});
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.BenchmarkRegionCountryQty:" + ex.Message);
}
break;
case ChartID.BenchmarkRegionCountryValue:
double regionValue;
try
{
regionName = new RegionRepository().GetById(int.Parse(SearchParameter)).Name;
countryName = new CountryRepository().GetById(currentUser.CountryID).Name;
Caption = Caption.Replace("Region Name", regionName).Replace("Country Name", countryName);
IEnumerable<SandlerModels.DataIntegration.BenchMarkVM> salesRegionToCountryData = queries.GetBenchMarkRegionToCountryByMonth(currentUser, DateTime.ParseExact(this.DrillBy, "MMM", null).Month);
totalPrice = salesRegionToCountryData.Sum(r => r.Value);
this.SetsCollection.Add(new SetValue
{
Color = "800080",
Label = "Country",
Value = ((((from record in salesRegionToCountryData.Where(r => r.KeyGroupId != SearchParameter)
select record).Sum(r => r.Value)) / totalPrice) * 100).ToString()
});
SandlerModels.DataIntegration.BenchMarkVM regionRecord = salesRegionToCountryData.Where(r => r.KeyGroupId == SearchParameter).SingleOrDefault();
regionValue = (regionRecord == null) ? 0.0 : regionRecord.Value;
this.SetsCollection.Add(new SetValue
{
Color = "32df00",
Label = "Region",
Value = ((regionValue / totalPrice) * 100).ToString()
});
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.BenchmarkFranchiseeRegionValue:" + ex.Message);
}
break;
case ChartID.BenchmarkCountryAllQty:
double countryQty;
try
{
countryName = new CountryRepository().GetById(int.Parse(SearchParameter)).Name;
Caption = Caption.Replace("Country Name", countryName);
IEnumerable<SandlerModels.DataIntegration.BenchMarkVM> salesCountryAllData = queries.GetBenchMarkCountryAllByMonth( DateTime.ParseExact(this.DrillBy, "MMM", null).Month); ;
totalCounts = salesCountryAllData.Sum(r => r.Count);
this.SetsCollection.Add(new SetValue
{
Color = "800080",
Label = "All",
Value = ((((from record in salesCountryAllData.Where(r => r.KeyGroupId != SearchParameter)
select record).Sum(r => r.Count)) / totalCounts) * 100).ToString()
});
SandlerModels.DataIntegration.BenchMarkVM countryRecord = salesCountryAllData.Where(r => r.KeyGroupId == SearchParameter).SingleOrDefault();
countryQty = (countryRecord == null) ? 0.0 : countryRecord.Count;
this.SetsCollection.Add(new SetValue
{
Color = "00CED1",
Label = "Country",
Value = ((countryQty / totalCounts) * 100).ToString()
});
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.BenchmarkRegionCountryQty:" + ex.Message);
}
break;
case ChartID.BenchmarkCountryAllValue:
double countryValue;
try
{
countryName = new CountryRepository().GetById(int.Parse(SearchParameter)).Name;
Caption = Caption.Replace("Country Name", countryName);
IEnumerable<SandlerModels.DataIntegration.BenchMarkVM> salesCountryAllData = queries.GetBenchMarkCountryAllByMonth( DateTime.ParseExact(this.DrillBy, "MMM", null).Month);
totalPrice = salesCountryAllData.Sum(r => r.Value);
this.SetsCollection.Add(new SetValue
{
Color = "800080",
Label = "All",
Value = ((((from record in salesCountryAllData.Where(r => r.KeyGroupId != SearchParameter)
select record).Sum(r => r.Value)) / totalPrice) * 100).ToString()
});
SandlerModels.DataIntegration.BenchMarkVM countryRecord = salesCountryAllData.Where(r => r.KeyGroupId == SearchParameter).SingleOrDefault();
countryValue = (countryRecord == null) ? 0.0 : countryRecord.Value;
this.SetsCollection.Add(new SetValue
{
Color = "00CED1",
Label = "Country",
Value = ((countryValue / totalPrice) * 100).ToString()
});
}
catch (Exception ex)
{
throw new Exception("Exception in ChartID.BenchmarkCountryAllValue:" + ex.Message);
}
break;
#endregion
default:
break;
}
}
catch (Exception ex)
{
throw ex;
}
}
public new void LoadChart(UserModel currentUser)
{
try
{
this.DrillChartIds = (this.DrillOverride) ? this.Id.ToString() : this.DrillChartIds;
int colorIndex = 0;
//UserEntities userEntities;
SandlerModels.DataIntegration.DataQueries queries = new SandlerModels.DataIntegration.DataQueries();
switch (this.Id)
{
case ChartID.ReturnOnTrainingInvestment:
int ROIAdjustmentFactor = int.Parse(ConfigurationManager.AppSettings["ROIAdjustmentFactor"]);
GapAnalysisRepository reposiroty = new GapAnalysisRepository();
GATracker gaTracker = reposiroty.GetGATrackerById(int.Parse(SearchParameter));
double year1ExpVal, year2ExpVal, year3ExpVal, year1AF, year2AF, year3AF;
year1ExpVal = Convert.ToDouble(gaTracker.Year1.Value);
year2ExpVal = Convert.ToDouble(gaTracker.Year2.Value);
year3ExpVal = Convert.ToDouble(gaTracker.Year3.Value);
year1AF = GetFactorValue(year1ExpVal);
year2AF = GetFactorValue(year2ExpVal);
year3AF = GetFactorValue(year3ExpVal);
double scVal, seVal, sqVal, tcsVal, qaVal, ebgVal;
double year1Savings, year1ROIBalance, year2Savings, year2ROIBalance, year3Savings, year3ROIBalance;
string year1ROIPercent, year2ROIPercent, year3ROIPercent;
//Year1 Calculations
scVal = (year1ExpVal * (gaTracker.ToBeSalesCycleTimePercentVal.Value - gaTracker.AsIsSalesCycleTimePercentVal.Value) * ROIAdjustmentFactor * year1AF) / 10000;
seVal = (year1ExpVal * (gaTracker.ToBeSalesEfficiencyPercentVal.Value - gaTracker.AsIsSalesEfficiencyPercentVal.Value) * ROIAdjustmentFactor * year1AF) / 10000;
sqVal = (year1ExpVal * (gaTracker.ToBeSalesQualificationPercentVal.Value - gaTracker.AsIsSalesQualificationPercentVal.Value) * ROIAdjustmentFactor * year1AF) / 10000;
tcsVal = (year1ExpVal * (gaTracker.ToBeSalesRepRetentionPercentVal.Value - gaTracker.AsIsSalesRepRetentionPercentVal.Value) * ROIAdjustmentFactor * year1AF) / 10000;
qaVal = (year1ExpVal * (gaTracker.ToBeQuotaAchievementPercentVal.Value - gaTracker.AsIsQuotaAchievementPercentVal.Value) * ROIAdjustmentFactor * year1AF) / 10000;
ebgVal = (year1ExpVal * (gaTracker.ToBeTrngBenefitsPercentVal.Value - gaTracker.AsIsTrngBenefitsPercentVal.Value) * ROIAdjustmentFactor * year1AF) / 10000;
year1Savings = scVal + seVal + sqVal + tcsVal + qaVal + ebgVal;
year1ROIBalance = year1Savings - year1ExpVal;
year1ROIPercent = ((year1Savings / year1ExpVal * 100)).ToString();
//Year2 Calculations
scVal = ((year2ExpVal * scVal * (1 + Convert.ToDouble(gaTracker.DesiredAnnualImptSalesCycleTime) / 100)) / year1ExpVal) * year2AF;
seVal = ((year2ExpVal * seVal * (1 + Convert.ToDouble(gaTracker.DesiredAnnualImptSalesEfficiency) / 100)) / year1ExpVal) * year2AF;
sqVal = ((year2ExpVal * sqVal * (1 + Convert.ToDouble(gaTracker.DesiredAnnualImptSalesQualfn) / 100)) / year1ExpVal) * year2AF;
tcsVal = ((year2ExpVal * tcsVal * (1 + Convert.ToDouble(gaTracker.DesiredAnnualImptSalesRepRetention) / 100)) / year1ExpVal) * year2AF;
qaVal = ((year2ExpVal * qaVal * (1 + Convert.ToDouble(gaTracker.DesiredAnnualImptQuotaAcht) / 100)) / year1ExpVal) * year2AF;
ebgVal = ((year2ExpVal * ebgVal * (1 + Convert.ToDouble(gaTracker.DesiredAnnualImptTrngBenefits) / 100)) / year1ExpVal) * year2AF;
year2Savings = scVal + seVal + sqVal + tcsVal + qaVal + ebgVal;
year2ROIBalance = year2Savings - year2ExpVal;
year2ROIPercent = ((year2Savings / year2ExpVal * 100)).ToString();
//Year3 Calculations
scVal = ((year3ExpVal * scVal * (1 + Convert.ToDouble(gaTracker.DesiredAnnualImptSalesCycleTime) / 100)) / year2ExpVal) * year3AF;
seVal = ((year3ExpVal * seVal * (1 + Convert.ToDouble(gaTracker.DesiredAnnualImptSalesEfficiency) / 100)) / year2ExpVal) * year3AF;
sqVal = ((year3ExpVal * sqVal * (1 + Convert.ToDouble(gaTracker.DesiredAnnualImptSalesQualfn) / 100)) / year2ExpVal) * year3AF;
tcsVal = ((year3ExpVal * tcsVal * (1 + Convert.ToDouble(gaTracker.DesiredAnnualImptSalesRepRetention) / 100)) / year2ExpVal) * year3AF;
qaVal = ((year3ExpVal * qaVal * (1 + Convert.ToDouble(gaTracker.DesiredAnnualImptQuotaAcht) / 100)) / year2ExpVal) * year3AF;
ebgVal = ((year3ExpVal * ebgVal * (1 + Convert.ToDouble(gaTracker.DesiredAnnualImptTrngBenefits) / 100)) / year2ExpVal) * year3AF;
year3Savings = scVal + seVal + sqVal + tcsVal + qaVal + ebgVal;
year3ROIBalance = year3Savings - year3ExpVal;
year3ROIPercent = ((year3Savings / year3ExpVal * 100)).ToString();
this.SetsCollection.Add(new SetValue { Color = "#008000", Label = "Year1", Value = year1ROIPercent });
this.SetsCollection.Add(new SetValue { Color = "#008000", Label = "Year2", Value = year2ROIPercent });
this.SetsCollection.Add(new SetValue { Color = "#008000", Label = "Year3", Value = year3ROIPercent });
break;
#region FranchiseeReports Logic
case ChartID.AverageLengthTimeActiveClientsByIndustry:
try
{
var AverageLengthTimeActiveClientsByIndustry = queries.AverageLengthTimeActiveClientsByIndustry(currentUser);
IndustryTypeRepository industrySource = new IndustryTypeRepository();
foreach (var record in industrySource.GetAll().Where(r => r.IsActive == true).AsEnumerable())
{
try
{
foreach (var d in AverageLengthTimeActiveClientsByIndustry)
{
if (record.IndustryTypeName == d.IndustryTypeName)
{
this.SetsCollection.Add(new SetValue { Color = record.ColorCode, Label = record.IndustryTypeName, Value = d.Count.ToString("#"), Link = (currentUser.Role == SandlerRoles.Client) ? "" : ChartHelper.GeneratePageLink("", this.DrillChartIds) });
break;
}
}
}
catch (System.InvalidOperationException)
{
}
colorIndex++;
}
}
catch (Exception ex)
{
throw new Exception("Error in ChartID.AverageLengthTimeActiveClientsByIndustry:" + ex.Message);
}
break;
#endregion
default:
break;
}
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertQuickStartRecord(
string COMPANYNAME, string FirstName,
string LastName, string Phone,
string Email, string OPPNAME,string SalesRepLastName, string SalesRepFirstName,
string Pain, string LengthProblem,
string Alternatives, string CostToFix,
int BudgeIdentifiedValue, int MoveForwardValue,
int ProductID, int OppStatusID,
int OppSourceID,int OppTypeID,
string OPPVALUE, string ACTIONSTEP,
int Value, int ApptSourceId, int RegForTrainingId,
int CourseId, DateTime CourseTrngDate, string TrainingCourseName, string HowManyAttended,int IsNewcompany, int IndID,
DateTime NextContactDate, DateTime OppCloseDate,string Notes, UserModel _user)
{
//Get the User Session
//For Date Fields
NextContactDate = IsValidDateCheck(NextContactDate);
OppCloseDate = IsValidDateCheck(OppCloseDate);
//For string Fields
COMPANYNAME = IsValidStringEntered(COMPANYNAME);
FirstName = IsValidStringEntered(FirstName);
LastName = IsValidStringEntered(LastName);
Phone = IsValidStringEntered(Phone);
Email = IsValidStringEntered(Email);
OPPNAME = IsValidStringEntered(OPPNAME);
SalesRepLastName = IsValidStringEntered(SalesRepLastName);
SalesRepFirstName = IsValidStringEntered(SalesRepFirstName);
Pain = IsValidStringEntered(Pain);
LengthProblem = IsValidStringEntered(LengthProblem);
Alternatives = IsValidStringEntered(Alternatives);
CostToFix = IsValidStringEntered(CostToFix);
OPPVALUE = IsValidStringEntered(OPPVALUE);
ACTIONSTEP = IsValidStringEntered(ACTIONSTEP);
CourseTrngDate = IsValidDateCheck(CourseTrngDate);
TrainingCourseName = IsValidStringEntered(TrainingCourseName);
HowManyAttended = IsValidStringEntered(HowManyAttended);
Notes = IsValidStringEntered(Notes);
//Create the record
db.ExecuteNonQuery("sp_InsertQuickStartRecord",
new SqlParameter("@COMPANYNAME", COMPANYNAME),
new SqlParameter("@FirstName", FirstName),
new SqlParameter("@LastName", LastName),
new SqlParameter("@Phone", Phone),
new SqlParameter("@Email", Email),
new SqlParameter("@OPPNAME", OPPNAME),
new SqlParameter("@Pain", Pain),
new SqlParameter("@LengthProblem", LengthProblem),
new SqlParameter("@Alternatives", Alternatives),
new SqlParameter("@CostToFix", CostToFix),
new SqlParameter("@BudgeIdentifiedValue", BudgeIdentifiedValue),
new SqlParameter("@MoveForwardValue", MoveForwardValue),
new SqlParameter("@ProductID", ProductID),
new SqlParameter("@OppStatusID", OppStatusID),
new SqlParameter("@OppSourceID", OppSourceID),
new SqlParameter("@OppTypeID", OppTypeID),
new SqlParameter("@OPPVALUE", OPPVALUE),
new SqlParameter("@ACTIONSTEP", ACTIONSTEP),
new SqlParameter("@NewAppointment", Value),
new SqlParameter("@AppointmentSource", ApptSourceId),
new SqlParameter("@RegisteredForTraining", RegForTrainingId),
new SqlParameter("@CourseType", CourseId),
new SqlParameter("@CourseTrainingDate", CourseTrngDate),
new SqlParameter("@TrainingCourseName", TrainingCourseName),
new SqlParameter("@HeadCount", HowManyAttended),
new SqlParameter("@IsNewcompany", IsNewcompany),
new SqlParameter("@Industry", IndID),
new SqlParameter("@NextContactDate", NextContactDate),
new SqlParameter("@OppCloseDate", OppCloseDate),
new SqlParameter("@CreatedBy", _user.UserId),
new SqlParameter("@LoggedInUserName", _user.UserName),
new SqlParameter("@FranchiseeId", _user.FranchiseeID),
new SqlParameter("@SalesRepLastName", SalesRepLastName),
new SqlParameter("@SalesRepFirstName", SalesRepFirstName),
new SqlParameter("@Notes", Notes));
UserEntitiesFactory.ReLoad();
}
public DataSet GetByCompId(int COMPANIESID, UserModel _user)
{
//Get the User Info
if (_user.Role != SandlerRoles.FranchiseeUser)
{
System.Data.DataSet ds = db.ExecuteDataset("sp_GetAllOpportunitiesByID", "Opportunities", new SqlParameter("@CompanyID", COMPANIESID));
return ds;
}
else
{
System.Data.DataSet ds = db.ExecuteDataset("sp_GetAllOpportunitiesByUserID", "Opportunities", new SqlParameter("@CompanyID", COMPANIESID), new SqlParameter("@UserID", _user.UserId));
return ds;
}
}
public void Insert(int COMPANIESID, string LastName, string FirstName,
string Title, string ContactsDepartment, string ContactsRole,
string Phone, string MobilePhone, string HomePhone, string Fax,
string Email, string PersonalEmail, string Address, string City, string State, string Zip, string Country, int Value,
int ApptSourceId, int RegForTrainingId, int CourseId, DateTime CourseTrngDate, string DiscussionTopic, string ACTIONSTEP,
DateTime LastAttemptedDate, DateTime Last_Contact_Date, DateTime LastEmailedDate, DateTime LastMeetingDate, DateTime LetterSentDate,
DateTime Next_Contact_Date, int CallBackValue, DateTime Birthday, string SpouseName, DateTime Anniversary, int CompanyYears, string BossName,
string ReferredBy, string Notes,
string TrainingCourseName, int HowManyAttended, string CompanyNameWhereTrainingConducted, DateTime StartTime,UserModel _user)
{
//Get the User Session
DateTime _StartTime = default(System.DateTime).AddYears(1754);
if (Next_Contact_Date.ToString() != "1/1/0001 12:00:00 AM")
{
//Means User has selected something for the Next contact Date so start time is needed
_StartTime = IsValidDateCheck(StartTime);
}
CourseTrngDate = IsValidDateCheck(CourseTrngDate);
Last_Contact_Date = IsValidDateCheck(Last_Contact_Date);
Next_Contact_Date = IsValidDateCheck(Next_Contact_Date);
Birthday = IsValidDateCheck(Birthday);
Anniversary = IsValidDateCheck(Anniversary);
CourseTrngDate = IsValidDateCheck(CourseTrngDate);
CourseTrngDate = IsValidDateCheck(CourseTrngDate);
LastAttemptedDate = IsValidDateCheck(LastAttemptedDate);
LastEmailedDate = IsValidDateCheck(LastEmailedDate);
LastMeetingDate = IsValidDateCheck(LastMeetingDate);
LetterSentDate = IsValidDateCheck(LetterSentDate);
ReferredBy = IsValidStringEntered(ReferredBy);
Notes = IsValidStringEntered(Notes);
SpouseName = IsValidStringEntered(SpouseName);
BossName = IsValidStringEntered(BossName);
Title = IsValidStringEntered(Title);
ContactsDepartment = IsValidStringEntered(ContactsDepartment);
ContactsRole = IsValidStringEntered(ContactsRole);
Phone = IsValidStringEntered(Phone);
MobilePhone = IsValidStringEntered(MobilePhone);
HomePhone = IsValidStringEntered(HomePhone);
Fax = IsValidStringEntered(Fax);
Email = IsValidStringEntered(Email);
PersonalEmail = IsValidStringEntered(PersonalEmail);
Address = IsValidStringEntered(Address);
City = IsValidStringEntered(City);
State = IsValidStringEntered(State);
Zip = IsValidStringEntered(Zip);
Country = IsValidStringEntered(Country);
DiscussionTopic = IsValidStringEntered(DiscussionTopic);
ACTIONSTEP = IsValidStringEntered(ACTIONSTEP);
TrainingCourseName = IsValidStringEntered(TrainingCourseName);
CompanyNameWhereTrainingConducted = IsValidStringEntered(CompanyNameWhereTrainingConducted);
//Insert and create contact - Both are Avl
db.ExecuteNonQuery("sp_InsertContact",
new SqlParameter("@COMPANIESID", COMPANIESID),
new SqlParameter("@LastName", LastName),
new SqlParameter("@FirstName", FirstName), new SqlParameter("@Title", Title),
new SqlParameter("@ContactsDepartment", ContactsDepartment), new SqlParameter("@ContactsRole", ContactsRole),
new SqlParameter("@Phone", Phone), new SqlParameter("@MobilePhone", MobilePhone),
new SqlParameter("@HomePhone", HomePhone), new SqlParameter("@Fax", Fax),
new SqlParameter("@Email", Email), new SqlParameter("@PersonalEmail", PersonalEmail),
new SqlParameter("@Address", Address), new SqlParameter("@City", City),
new SqlParameter("@State", State), new SqlParameter("@Zip", Zip),
new SqlParameter("@Country", Country),
new SqlParameter("@Value", Value), new SqlParameter("@ApptSourceId", ApptSourceId),
new SqlParameter("@RegForTrainingId", RegForTrainingId), new SqlParameter("@CourseId", CourseId),
new SqlParameter("@CourseTrngDate", CourseTrngDate), new SqlParameter("@DiscussionTopic", DiscussionTopic),
new SqlParameter("@ACTIONSTEP", ACTIONSTEP),
new SqlParameter("@LastAttemptedDate", LastAttemptedDate),
new SqlParameter("@LastEmailedDate", LastEmailedDate),
new SqlParameter("@LastMeetingDate", LastMeetingDate),
new SqlParameter("@LetterSentDate", LetterSentDate),
new SqlParameter("@Last_Contact_Date", Last_Contact_Date),
new SqlParameter("@Next_Contact_Date", Next_Contact_Date), new SqlParameter("@CreatedBy", _user.UserId),
new SqlParameter("@CallBackValue", CallBackValue),
new SqlParameter("@Birthday", Birthday), new SqlParameter("@Anniversary", Anniversary),
new SqlParameter("@CompanyYears", CompanyYears), new SqlParameter("@BossName", BossName),
new SqlParameter("@SpouseName", SpouseName),
new SqlParameter("@ReferredBy", ReferredBy),
new SqlParameter("@Notes", Notes),
new SqlParameter("@TrainingCourseName", TrainingCourseName),
new SqlParameter("@HowManyAttended", HowManyAttended),
new SqlParameter("@CompanyNameWhereTrainingConducted", CompanyNameWhereTrainingConducted),
new SqlParameter("@StartTime", _StartTime));
UserEntitiesFactory.ReLoad();
}
public void Update(int Contactsid, int CompanyID, string LastName, string FirstName,
string Title, string ContactsDepartment, string ContactsRole, string Phone,
string MobilePhone, string HomePhone, string Fax, string Email, string PersonalEmail,
string Address, string City, string State, string Zip, string Country,
string DiscussionTopic, string ActionStep,
DateTime LastAttemptedDate, DateTime LastEmailedDate, DateTime LastMeetingDate, DateTime LetterSentDate,
int IsRegisteredForTrng, int IsNewAppt, int CourseId,
int AppsSourceId, DateTime LastDate, DateTime NextDate, DateTime CourseTrngDate, int BlastEmailSubscription, int CallBackValue, DateTime BirthDate,
DateTime AnniversaryDate, int CompanyYears, string BossName, string SpouseName, string ReferredBy, string Notes,
string TrainingCourseName, int HowManyAttended, string CompanyNameWhereTrainingConducted, DateTime StartTime,UserModel _user)
{
//Get the User Session
DateTime _StartTime = default(System.DateTime).AddYears(1754);
if (NextDate.ToString() != "1/1/0001 12:00:00 AM")
{
//Means User has selected something for the Next contact Date so start time is needed
_StartTime = IsValidDateCheck(StartTime);
}
//date fields
CourseTrngDate = IsValidDateCheck(CourseTrngDate);
LastDate = IsValidDateCheck(LastDate);
NextDate = IsValidDateCheck(NextDate);
BirthDate = IsValidDateCheck(BirthDate);
AnniversaryDate = IsValidDateCheck(AnniversaryDate);
CourseTrngDate = IsValidDateCheck(CourseTrngDate);
CourseTrngDate = IsValidDateCheck(CourseTrngDate);
LastAttemptedDate = IsValidDateCheck(LastAttemptedDate);
LastEmailedDate = IsValidDateCheck(LastEmailedDate);
LastMeetingDate = IsValidDateCheck(LastMeetingDate);
LetterSentDate = IsValidDateCheck(LetterSentDate);
//string fields
ReferredBy = IsValidStringEntered(ReferredBy);
Notes = IsValidStringEntered(Notes);
SpouseName = IsValidStringEntered(SpouseName);
BossName = IsValidStringEntered(BossName);
Title = IsValidStringEntered(Title);
ContactsDepartment = IsValidStringEntered(ContactsDepartment);
ContactsRole = IsValidStringEntered(ContactsRole);
Phone = IsValidStringEntered(Phone);
MobilePhone = IsValidStringEntered(MobilePhone);
HomePhone = IsValidStringEntered(HomePhone);
Fax = IsValidStringEntered(Fax);
Email = IsValidStringEntered(Email);
PersonalEmail = IsValidStringEntered(PersonalEmail);
Address = IsValidStringEntered(Address);
City = IsValidStringEntered(City);
State = IsValidStringEntered(State);
Zip = IsValidStringEntered(Zip);
Country = IsValidStringEntered(Country);
DiscussionTopic = IsValidStringEntered(DiscussionTopic);
ActionStep = IsValidStringEntered(ActionStep);
TrainingCourseName = IsValidStringEntered(TrainingCourseName);
CompanyNameWhereTrainingConducted = IsValidStringEntered(CompanyNameWhereTrainingConducted);
//Both Are Avl
db.ExecuteNonQuery("sp_UpdateContactDetails",
new SqlParameter("@ContactsID", Contactsid),
new SqlParameter("@CompanyID", CompanyID),
new SqlParameter("@LastName", LastName),
new SqlParameter("@FirstName", FirstName),
new SqlParameter("@Title", Title),
new SqlParameter("@ContactsDepartment", ContactsDepartment),
new SqlParameter("@ContactsRole", ContactsRole),
new SqlParameter("@Phone", Phone),
new SqlParameter("@MobilePhone", MobilePhone),
new SqlParameter("@HomePhone", HomePhone),
new SqlParameter("@Fax", Fax),
new SqlParameter("@Email", Email),
new SqlParameter("@PersonalEmail", PersonalEmail),
new SqlParameter("@Address", Address), new SqlParameter("@City", City),
new SqlParameter("@State", State), new SqlParameter("@Zip", Zip),
new SqlParameter("@Country", Country),
new SqlParameter("@DiscussionTopic", DiscussionTopic),
new SqlParameter("@ActionStep", ActionStep),
new SqlParameter("@LastAttemptedDate", LastAttemptedDate),
new SqlParameter("@LastEmailedDate", LastEmailedDate),
new SqlParameter("@LastMeetingDate", LastMeetingDate),
new SqlParameter("@LetterSentDate", LetterSentDate),
new SqlParameter("@IsRegisteredForTrng", IsRegisteredForTrng),
new SqlParameter("@IsNewAppt", IsNewAppt),
new SqlParameter("@CourseId", CourseId),
new SqlParameter("@AppsSourceId", AppsSourceId),
new SqlParameter("@LastDate", LastDate),
new SqlParameter("@NextDate", NextDate),
new SqlParameter("@CourseTrngDate", CourseTrngDate),
new SqlParameter("@UpdatedBy", _user.UserId),
new SqlParameter("@BlastEmailSubscription", BlastEmailSubscription),
new SqlParameter("@CallBackValue", CallBackValue),
new SqlParameter("@BirthDate", BirthDate),
new SqlParameter("@AnniversaryDate", AnniversaryDate),
new SqlParameter("@CompanyYears", CompanyYears),
new SqlParameter("@BossName", BossName),
new SqlParameter("@SpouseName", SpouseName),
new SqlParameter("@ReferredBy", ReferredBy),
new SqlParameter("@Notes", Notes),
new SqlParameter("@TrainingCourseName", TrainingCourseName),
new SqlParameter("@HowManyAttended", HowManyAttended),
new SqlParameter("@CompanyNameWhereTrainingConducted", CompanyNameWhereTrainingConducted),
new SqlParameter("@StartTime", _StartTime));
UserEntitiesFactory.ReLoad();
}
public DataSet GetCallList(UserModel _user)
{
//Get the User Session
//Get Call List for this user
return db.ExecuteDataset("sp_GetCallList", "GetCallList",
new SqlParameter("@Role", _user.Role.ToString()), new SqlParameter("@UserId", _user.UserId.ToString()),
new SqlParameter("@FranchiseeId", _user.FranchiseeID), new SqlParameter("@RegionId", _user.RegionID));
}
public DataSet GetAllForSearch(UserModel _user)
{
//get the User Info
SandlerModels.DataIntegration.Contact _contact = (SandlerModels.DataIntegration.Contact)HttpContext.Current.Session["ContactSearchCriteria"];
//date fields
_contact.LastContactDate = IsValidDateCheck(_contact.LastContactDate);
_contact.NextContactDate = IsValidDateCheck(_contact.NextContactDate);
_contact.CourseTrainingDate = IsValidDateCheck(_contact.CourseTrainingDate);
_contact.BirthDay = IsValidDateCheck(_contact.BirthDay);
_contact.Anniversary = IsValidDateCheck(_contact.Anniversary);
_contact.LastContactDate = IsValidDateCheck(_contact.LastContactDate);
_contact.LastAttemptedDate = IsValidDateCheck(_contact.LastAttemptedDate);
_contact.LastEmailedDate = IsValidDateCheck(_contact.LastEmailedDate);
_contact.LetterSentDate = IsValidDateCheck(_contact.LetterSentDate);
_contact.LastMeetingDate = IsValidDateCheck(_contact.LastMeetingDate);
//Now perform search based on User role
if (_user.Role == SandlerRoles.SiteAdmin || _user.Role == SandlerRoles.Corporate || _user.Role == SandlerRoles.HomeOfficeAdmin || _user.Role == SandlerRoles.HomeOfficeUser)
{
//get data
return db.ExecuteDataset("sp_GetAllContactsSearch", "Contacts",
new SqlParameter("@LastName", _contact.LastName),
new SqlParameter("@FirstName", _contact.FirstName),
new SqlParameter("@Title", _contact.Title),
new SqlParameter("@ContactsDepartment", _contact.ContactsDepartment),
new SqlParameter("@ContactsRole", _contact.ContactsRole),
new SqlParameter("@Phone", _contact.Phone),
new SqlParameter("@MobilePhone", _contact.MobilePhone),
new SqlParameter("@HomePhone", _contact.HomePhone),
new SqlParameter("@Fax", _contact.Fax),
new SqlParameter("@Email", _contact.Email),
new SqlParameter("@PersonalEmail", _contact.PersonalEmail),
new SqlParameter("@Address", _contact.Address),
new SqlParameter("@City", _contact.City),
new SqlParameter("@State", _contact.State),
new SqlParameter("@Zip", _contact.Zip),
new SqlParameter("@Country", _contact.Country),
new SqlParameter("@IsNewApptIdList", _contact.IsNewApptList),
new SqlParameter("@ApptSourceIdList", _contact.ApptSourceList),
new SqlParameter("@IsRegForTrainingList", _contact.IsRegisteredForTrainingList),
new SqlParameter("@CourseTypeIdList", _contact.CourseIdList),
new SqlParameter("@CompanyIdList", _contact.CompanyIdList),
new SqlParameter("@NeedCallBackList", _contact.IsNeedCallBackList),
new SqlParameter("@EmailSubscriptionList", _contact.IsEmailSubscriptionList),
new SqlParameter("@DiscussionTopic", _contact.DiscussionTopic),
new SqlParameter("@ActionStep", _contact.ActionStep),
new SqlParameter("@LastContactDate", _contact.LastContactDate),
new SqlParameter("@NextContactDate", _contact.NextContactDate),
new SqlParameter("@LastAttemptedDate", _contact.LastAttemptedDate),
new SqlParameter("@LastEmailedDate", _contact.LastEmailedDate),
new SqlParameter("@LastMeetingDate", _contact.LastMeetingDate),
new SqlParameter("@LetterSentDate", _contact.LetterSentDate),
new SqlParameter("@CourseTrngDate", _contact.CourseTrainingDate),
new SqlParameter("@BirthDayDate", _contact.BirthDay),
new SqlParameter("@AnniversaryDate", _contact.Anniversary),
new SqlParameter("@CompanyYears", _contact.CompanyYears),
new SqlParameter("@BossName", _contact.BossName),
new SqlParameter("@SpouseName", _contact.SpouseName),
new SqlParameter("@ReferredBy", _contact.ReferredBy),
new SqlParameter("@Notes", _contact.Notes),
new SqlParameter("@TrainingCourseName", _contact.TrainingCourseName),
new SqlParameter("@HowManyAttended", _contact.HowManyAttended),
new SqlParameter("@CompanyNameWhereTrainingConducted", _contact.CompanyNameWhereTrainingConducted));
}
else if (_user.Role == SandlerRoles.Coach)
{
//get data
return db.ExecuteDataset("sp_GetAllContactsByCoachIDSearch", "Contacts",
new SqlParameter("@CoachID", _user.CoachID.ToString()),
new SqlParameter("@LastName", _contact.LastName),
new SqlParameter("@FirstName", _contact.FirstName),
new SqlParameter("@Title", _contact.Title),
new SqlParameter("@ContactsDepartment", _contact.ContactsDepartment),
new SqlParameter("@ContactsRole", _contact.ContactsRole),
new SqlParameter("@Phone", _contact.Phone),
new SqlParameter("@MobilePhone", _contact.MobilePhone),
new SqlParameter("@HomePhone", _contact.HomePhone),
new SqlParameter("@Fax", _contact.Fax),
new SqlParameter("@Email", _contact.Email),
new SqlParameter("@PersonalEmail", _contact.PersonalEmail),
new SqlParameter("@Address", _contact.Address),
new SqlParameter("@City", _contact.City),
new SqlParameter("@State", _contact.State),
new SqlParameter("@Zip", _contact.Zip),
new SqlParameter("@Country", _contact.Country),
new SqlParameter("@IsNewApptIdList", _contact.IsNewApptList),
new SqlParameter("@ApptSourceIdList", _contact.ApptSourceList),
new SqlParameter("@IsRegForTrainingList", _contact.IsRegisteredForTrainingList),
new SqlParameter("@CourseTypeIdList", _contact.CourseIdList),
new SqlParameter("@CompanyIdList", _contact.CompanyIdList),
new SqlParameter("@NeedCallBackList", _contact.IsNeedCallBackList),
new SqlParameter("@EmailSubscriptionList", _contact.IsEmailSubscriptionList),
new SqlParameter("@DiscussionTopic", _contact.DiscussionTopic),
new SqlParameter("@ActionStep", _contact.ActionStep),
new SqlParameter("@LastContactDate", _contact.LastContactDate),
new SqlParameter("@NextContactDate", _contact.NextContactDate),
new SqlParameter("@LastAttemptedDate", _contact.LastAttemptedDate),
new SqlParameter("@LastEmailedDate", _contact.LastEmailedDate),
new SqlParameter("@LastMeetingDate", _contact.LastMeetingDate),
new SqlParameter("@LetterSentDate", _contact.LetterSentDate),
new SqlParameter("@CourseTrngDate", _contact.CourseTrainingDate),
new SqlParameter("@BirthDayDate", _contact.BirthDay),
new SqlParameter("@AnniversaryDate", _contact.Anniversary),
new SqlParameter("@CompanyYears", _contact.CompanyYears),
new SqlParameter("@BossName", _contact.BossName),
new SqlParameter("@SpouseName", _contact.SpouseName),
new SqlParameter("@ReferredBy", _contact.ReferredBy),
new SqlParameter("@Notes", _contact.Notes),
new SqlParameter("@TrainingCourseName", _contact.TrainingCourseName),
new SqlParameter("@HowManyAttended", _contact.HowManyAttended),
new SqlParameter("@CompanyNameWhereTrainingConducted", _contact.CompanyNameWhereTrainingConducted));
}
else if (_user.Role == SandlerRoles.FranchiseeOwner || _user.Role == SandlerRoles.Client)
{
//now we have to bring records as per role - Franchisee Owner OR Client
return db.ExecuteDataset("sp_GetAllContactsByFrIDSearch", "Contacts",
new SqlParameter("@FranchiseeID", _user.FranchiseeID.ToString()),
new SqlParameter("@LastName", _contact.LastName),
new SqlParameter("@FirstName", _contact.FirstName),
new SqlParameter("@Title", _contact.Title),
new SqlParameter("@ContactsDepartment", _contact.ContactsDepartment),
new SqlParameter("@ContactsRole", _contact.ContactsRole),
new SqlParameter("@Phone", _contact.Phone),
new SqlParameter("@MobilePhone", _contact.MobilePhone),
new SqlParameter("@HomePhone", _contact.HomePhone),
new SqlParameter("@Fax", _contact.Fax),
new SqlParameter("@Email", _contact.Email),
new SqlParameter("@PersonalEmail", _contact.PersonalEmail),
new SqlParameter("@Address", _contact.Address),
new SqlParameter("@City", _contact.City),
new SqlParameter("@State", _contact.State),
new SqlParameter("@Zip", _contact.Zip),
new SqlParameter("@Country", _contact.Country),
new SqlParameter("@IsNewApptIdList", _contact.IsNewApptList),
new SqlParameter("@ApptSourceIdList", _contact.ApptSourceList),
new SqlParameter("@IsRegForTrainingList", _contact.IsRegisteredForTrainingList),
new SqlParameter("@CourseTypeIdList", _contact.CourseIdList),
new SqlParameter("@CompanyIdList", _contact.CompanyIdList),
new SqlParameter("@NeedCallBackList", _contact.IsNeedCallBackList),
new SqlParameter("@EmailSubscriptionList", _contact.IsEmailSubscriptionList),
new SqlParameter("@DiscussionTopic", _contact.DiscussionTopic),
new SqlParameter("@ActionStep", _contact.ActionStep),
new SqlParameter("@LastContactDate", _contact.LastContactDate),
new SqlParameter("@NextContactDate", _contact.NextContactDate),
new SqlParameter("@LastAttemptedDate", _contact.LastAttemptedDate),
new SqlParameter("@LastEmailedDate", _contact.LastEmailedDate),
new SqlParameter("@LastMeetingDate", _contact.LastMeetingDate),
new SqlParameter("@LetterSentDate", _contact.LetterSentDate),
new SqlParameter("@CourseTrngDate", _contact.CourseTrainingDate),
new SqlParameter("@BirthDayDate", _contact.BirthDay),
new SqlParameter("@AnniversaryDate", _contact.Anniversary),
new SqlParameter("@CompanyYears", _contact.CompanyYears),
new SqlParameter("@BossName", _contact.BossName),
new SqlParameter("@SpouseName", _contact.SpouseName),
new SqlParameter("@ReferredBy", _contact.ReferredBy),
new SqlParameter("@Notes", _contact.Notes),
new SqlParameter("@TrainingCourseName", _contact.TrainingCourseName),
new SqlParameter("@HowManyAttended", _contact.HowManyAttended),
new SqlParameter("@CompanyNameWhereTrainingConducted", _contact.CompanyNameWhereTrainingConducted));
}
else
{
//This is for Franchisee User
return db.ExecuteDataset("sp_GetAllContactsByUserIDSearch", "Contacts",
new SqlParameter("@UserID", _user.UserId.ToString()),
new SqlParameter("@LastName", _contact.LastName),
new SqlParameter("@FirstName", _contact.FirstName),
new SqlParameter("@Title", _contact.Title),
new SqlParameter("@ContactsDepartment", _contact.ContactsDepartment),
new SqlParameter("@ContactsRole", _contact.ContactsRole),
new SqlParameter("@Phone", _contact.Phone),
new SqlParameter("@MobilePhone", _contact.MobilePhone),
new SqlParameter("@HomePhone", _contact.HomePhone),
new SqlParameter("@Fax", _contact.Fax),
new SqlParameter("@Email", _contact.Email),
new SqlParameter("@PersonalEmail", _contact.PersonalEmail),
new SqlParameter("@Address", _contact.Address),
new SqlParameter("@City", _contact.City),
new SqlParameter("@State", _contact.State),
new SqlParameter("@Zip", _contact.Zip),
new SqlParameter("@Country", _contact.Country),
new SqlParameter("@IsNewApptIdList", _contact.IsNewApptList),
new SqlParameter("@ApptSourceIdList", _contact.ApptSourceList),
new SqlParameter("@IsRegForTrainingList", _contact.IsRegisteredForTrainingList),
new SqlParameter("@CourseTypeIdList", _contact.CourseIdList),
new SqlParameter("@CompanyIdList", _contact.CompanyIdList),
new SqlParameter("@NeedCallBackList", _contact.IsNeedCallBackList),
new SqlParameter("@EmailSubscriptionList", _contact.IsEmailSubscriptionList),
new SqlParameter("@DiscussionTopic", _contact.DiscussionTopic),
new SqlParameter("@ActionStep", _contact.ActionStep),
new SqlParameter("@LastContactDate", _contact.LastContactDate),
new SqlParameter("@NextContactDate", _contact.NextContactDate),
new SqlParameter("@LastAttemptedDate", _contact.LastAttemptedDate),
new SqlParameter("@LastEmailedDate", _contact.LastEmailedDate),
new SqlParameter("@LastMeetingDate", _contact.LastMeetingDate),
new SqlParameter("@LetterSentDate", _contact.LetterSentDate),
new SqlParameter("@CourseTrngDate", _contact.CourseTrainingDate),
new SqlParameter("@BirthDayDate", _contact.BirthDay),
new SqlParameter("@AnniversaryDate", _contact.Anniversary),
new SqlParameter("@CompanyYears", _contact.CompanyYears),
new SqlParameter("@BossName", _contact.BossName),
new SqlParameter("@SpouseName", _contact.SpouseName),
new SqlParameter("@ReferredBy", _contact.ReferredBy),
new SqlParameter("@Notes", _contact.Notes),
new SqlParameter("@TrainingCourseName", _contact.TrainingCourseName),
new SqlParameter("@HowManyAttended", _contact.HowManyAttended),
new SqlParameter("@CompanyNameWhereTrainingConducted", _contact.CompanyNameWhereTrainingConducted));
}
}
public DataSet GetAllFranchisee(UserModel _user)
{
return (db.ExecuteDataset("sp_GetAllFranchisee", "GetAllFranchisees",new SqlParameter("@Role", _user.Role.ToString())));
}
//GetAllArchivedCompanies
public DataSet GetCompaniesForSearch(UserModel _user)
{
//Get the User Info
SandlerModels.DataIntegration.Company _company = (SandlerModels.DataIntegration.Company)HttpContext.Current.Session["CompanySearchCriteria"];
if (_company.LastContactDate.ToString() == "1/1/0001 12:00:00 AM")
{
_company.LastContactDate = default(System.DateTime).AddYears(1754);
}
if (_company.NextContactDate.ToString() == "1/1/0001 12:00:00 AM")
{
_company.NextContactDate = default(System.DateTime).AddYears(1754);
}
if (_company.CreationDate.ToString() == "1/1/0001 12:00:00 AM")
{
_company.CreationDate = default(System.DateTime).AddYears(1754);
}
//get data
if (_user.Role == SandlerRoles.SiteAdmin || _user.Role == SandlerRoles.Corporate || _user.Role == SandlerRoles.HomeOfficeAdmin || _user.Role == SandlerRoles.HomeOfficeUser)
{
//Corporate User
return db.ExecuteDataset("sp_GetAllCompaniesSearch", "CompaniesSearch",
new SqlParameter("@CompanyName", _company.CompanyName),
new SqlParameter("@CompanyOwnership", _company.CompanyOwnership),
new SqlParameter("@CompanyDescription", _company.CompanyDescription),
new SqlParameter("@RepLastName", _company.RepLastName),
new SqlParameter("@RepFirstName", _company.RepFirstName),
new SqlParameter("@IndustryIdList", _company.IndId),
new SqlParameter("@TotalCompValue", _company.CompValueGoal),
new SqlParameter("@IsNewCompanyIdList", _company.IsNewCompany),
new SqlParameter("@IsSameBillingAdrsList", _company.IsSameBillingAddress),
new SqlParameter("@Address", _company.Address),
new SqlParameter("@Zip", _company.Zip),
new SqlParameter("@City", _company.City),
new SqlParameter("@State", _company.State),
new SqlParameter("@Country", _company.Country),
new SqlParameter("@BillingAddress", _company.BillingAddress),
new SqlParameter("@BillingZip", _company.BillingZip),
new SqlParameter("@BillingCity", _company.BillingCity),
new SqlParameter("@BillingState", _company.BillingState),
new SqlParameter("@BillingCountry", _company.BillingCountry),
new SqlParameter("@POCLastName", _company.POCLastName),
new SqlParameter("@POCFirstName", _company.POCFirstName),
new SqlParameter("@POCPhone", _company.POCPhone),
new SqlParameter("@POCDepartment", _company.POCDepartment),
new SqlParameter("@POCEmail", _company.POCEmail),
new SqlParameter("@POCFax", _company.POCFax),
new SqlParameter("@AssistantLastName", _company.AssistantLastName),
new SqlParameter("@AssistantFirstName", _company.AssistantFirstName),
new SqlParameter("@AssistantPhone", _company.AssistantPhone),
new SqlParameter("@Website", _company.WebSite),
new SqlParameter("@EmpQuantity", _company.EmpQuantity),
new SqlParameter("@Notes", _company.Notes),
new SqlParameter("@DiscussionTopic", _company.DiscussionTopic),
new SqlParameter("@ActionStep", _company.ActionStep),
new SqlParameter("@LastContactDate", _company.LastContactDate),
new SqlParameter("@NextContactDate", _company.NextContactDate),
new SqlParameter("@CreationDate", _company.CreationDate));
}
else if (_user.Role == SandlerRoles.Coach)
{
//Coach - To do - once User object has RegionId then pass it here
return db.ExecuteDataset("sp_GetAllCompaniesByCoachIdSearch", "CompaniesByCoachIdSearch",
new SqlParameter("@CoachId", _user.CoachID.ToString()),
new SqlParameter("@CompanyName", _company.CompanyName),
new SqlParameter("@CompanyOwnership", _company.CompanyOwnership),
new SqlParameter("@CompanyDescription", _company.CompanyDescription),
new SqlParameter("@RepLastName", _company.RepLastName),
new SqlParameter("@RepFirstName", _company.RepFirstName),
new SqlParameter("@IndustryIdList", _company.IndId),
new SqlParameter("@TotalCompValue", _company.CompValueGoal),
new SqlParameter("@IsNewCompanyIdList", _company.IsNewCompany),
new SqlParameter("@IsSameBillingAdrsList", _company.IsSameBillingAddress),
new SqlParameter("@Address", _company.Address),
new SqlParameter("@Zip", _company.Zip),
new SqlParameter("@City", _company.City),
new SqlParameter("@State", _company.State),
new SqlParameter("@Country", _company.Country),
new SqlParameter("@BillingAddress", _company.BillingAddress),
new SqlParameter("@BillingZip", _company.BillingZip),
new SqlParameter("@BillingCity", _company.BillingCity),
new SqlParameter("@BillingState", _company.BillingState),
new SqlParameter("@BillingCountry", _company.BillingCountry),
new SqlParameter("@POCLastName", _company.POCLastName),
new SqlParameter("@POCFirstName", _company.POCFirstName),
new SqlParameter("@POCPhone", _company.POCPhone),
new SqlParameter("@POCDepartment", _company.POCDepartment),
new SqlParameter("@POCEmail", _company.POCEmail),
new SqlParameter("@POCFax", _company.POCFax),
new SqlParameter("@AssistantLastName", _company.AssistantLastName),
new SqlParameter("@AssistantFirstName", _company.AssistantFirstName),
new SqlParameter("@AssistantPhone", _company.AssistantPhone),
new SqlParameter("@Website", _company.WebSite),
new SqlParameter("@EmpQuantity", _company.EmpQuantity),
new SqlParameter("@Notes", _company.Notes),
new SqlParameter("@DiscussionTopic", _company.DiscussionTopic),
new SqlParameter("@ActionStep", _company.ActionStep),
new SqlParameter("@LastContactDate", _company.LastContactDate),
new SqlParameter("@NextContactDate", _company.NextContactDate),
new SqlParameter("@CreationDate", _company.CreationDate));
}
else
{
//Franchisee Owner OR Franchisee User OR Client
return db.ExecuteDataset("sp_GetAllCompaniesByFrIdSearch", "CompaniesByFrIdSearch",
new SqlParameter("@FranchiseeId", _user.FranchiseeID.ToString()),
new SqlParameter("@CompanyName", _company.CompanyName),
new SqlParameter("@CompanyOwnership", _company.CompanyOwnership),
new SqlParameter("@CompanyDescription", _company.CompanyDescription),
new SqlParameter("@RepLastName", _company.RepLastName),
new SqlParameter("@RepFirstName", _company.RepFirstName),
new SqlParameter("@IndustryIdList", _company.IndId),
new SqlParameter("@TotalCompValue", _company.CompValueGoal),
new SqlParameter("@IsNewCompanyIdList", _company.IsNewCompany),
new SqlParameter("@IsSameBillingAdrsList", _company.IsSameBillingAddress),
new SqlParameter("@Address", _company.Address),
new SqlParameter("@Zip", _company.Zip),
new SqlParameter("@City", _company.City),
new SqlParameter("@State", _company.State),
new SqlParameter("@Country", _company.Country),
new SqlParameter("@BillingAddress", _company.BillingAddress),
new SqlParameter("@BillingZip", _company.BillingZip),
new SqlParameter("@BillingCity", _company.BillingCity),
new SqlParameter("@BillingState", _company.BillingState),
new SqlParameter("@BillingCountry", _company.BillingCountry),
new SqlParameter("@POCLastName", _company.POCLastName),
new SqlParameter("@POCFirstName", _company.POCFirstName),
new SqlParameter("@POCPhone", _company.POCPhone),
new SqlParameter("@POCDepartment", _company.POCDepartment),
new SqlParameter("@POCEmail", _company.POCEmail),
new SqlParameter("@POCFax", _company.POCFax),
new SqlParameter("@AssistantLastName", _company.AssistantLastName),
new SqlParameter("@AssistantFirstName", _company.AssistantFirstName),
new SqlParameter("@AssistantPhone", _company.AssistantPhone),
new SqlParameter("@Website", _company.WebSite),
new SqlParameter("@EmpQuantity", _company.EmpQuantity),
new SqlParameter("@Notes", _company.Notes),
new SqlParameter("@DiscussionTopic", _company.DiscussionTopic),
new SqlParameter("@ActionStep", _company.ActionStep),
new SqlParameter("@LastContactDate", _company.LastContactDate),
new SqlParameter("@NextContactDate", _company.NextContactDate),
new SqlParameter("@CreationDate", _company.CreationDate));
}
}
public void InsertCompany(
string COMPANYNAME,
string CompanyOwnership,
string CompanyDescription,
string Address, string City, string State, string Zip,
string Country, int BillingValue,
string BillingAddress, string BillingCity, string BillingState, string BillingZip,
string BillingCountry,
string POCLastName, string POCFirstName, string POCPhone,
string POCDepartment, string POCEmail, string POCFax, string AssistantLastName,
string AssistantFirstName, string AssistantPhone, int Value,
string Website, int EmpQuantity, int COMPANYVALUEGOAL,
int IndID, string RepLastName, string RepFirstName, string DiscussionTopic, string ACTIONSTEP,
DateTime LastContact_Date, DateTime NextContact_Date, DateTime CreationDate, string Notes, DateTime StartTime, UserModel _user
)
{
//Get the User Session
DateTime _StartTime = default(System.DateTime).AddYears(1754);
if (NextContact_Date.ToString() != "1/1/0001 12:00:00 AM")
{
//Means User has selected something for the Next contact Date so start time is needed
_StartTime = IsValidDateCheck(StartTime);
}
LastContact_Date = IsValidDateCheck(LastContact_Date);
NextContact_Date = IsValidDateCheck(NextContact_Date);
CreationDate = IsValidDateCheck(CreationDate);
RepLastName = IsValidStringEntered(RepLastName);
RepFirstName = IsValidStringEntered(RepFirstName);
DiscussionTopic = IsValidStringEntered(DiscussionTopic);
ACTIONSTEP = IsValidStringEntered(ACTIONSTEP);
CompanyOwnership = IsValidStringEntered(CompanyOwnership);
CompanyDescription = IsValidStringEntered(CompanyDescription);
Country = IsValidStringEntered(Country);
Website = IsValidStringEntered(Website);
Address = IsValidStringEntered(Address);
City = IsValidStringEntered(City);
State = IsValidStringEntered(State);
Zip = IsValidStringEntered(Zip);
Country = IsValidStringEntered(Country);
BillingAddress = IsValidStringEntered(BillingAddress);
BillingCity = IsValidStringEntered(BillingCity);
BillingState = IsValidStringEntered(BillingState);
BillingZip = IsValidStringEntered(BillingZip);
BillingCountry = IsValidStringEntered(BillingCountry);
POCDepartment = IsValidStringEntered(POCDepartment);
POCEmail = IsValidStringEntered(POCEmail);
POCFax = IsValidStringEntered(POCFax);
AssistantLastName = IsValidStringEntered(AssistantLastName);
AssistantFirstName = IsValidStringEntered(AssistantFirstName);
AssistantPhone = IsValidStringEntered(AssistantPhone);
Notes = IsValidStringEntered(Notes);
POCLastName = IsValidStringEntered(POCLastName);
POCFirstName = IsValidStringEntered(POCFirstName);
POCPhone = IsValidStringEntered(POCPhone);
//Create the record
db.ExecuteNonQuery("sp_InsertCompany",
new SqlParameter("@COMPANYNAME", COMPANYNAME),
new SqlParameter("@CompanyOwnership", CompanyOwnership),
new SqlParameter("@CompanyDescription", CompanyDescription),
new SqlParameter("@Address", Address),
new SqlParameter("@City", City),
new SqlParameter("@State", State),
new SqlParameter("@Zip", Zip),
new SqlParameter("@Country", Country),
new SqlParameter("@BillingValue", BillingValue),
new SqlParameter("@BillingAddress", BillingAddress),
new SqlParameter("@BillingCity", BillingCity),
new SqlParameter("@BillingState", BillingState),
new SqlParameter("@BillingZip", BillingZip),
new SqlParameter("@BillingCountry", BillingCountry),
new SqlParameter("@POCLastName", POCLastName),
new SqlParameter("@POCFirstName", POCFirstName),
new SqlParameter("@POCPhone", POCPhone),
new SqlParameter("@POCDepartment", POCDepartment),
new SqlParameter("@POCEmail", POCEmail),
new SqlParameter("@POCFax", POCFax),
new SqlParameter("@AssistantLastName", AssistantLastName),
new SqlParameter("@AssistantFirstName", AssistantFirstName),
new SqlParameter("@AssistantPhone", AssistantPhone),
new SqlParameter("@Value", Value),
new SqlParameter("@Website", Website),
new SqlParameter("@EmpQuantity", EmpQuantity),
new SqlParameter("@COMPANYVALUEGOAL", COMPANYVALUEGOAL),
new SqlParameter("@IndID", IndID),
new SqlParameter("@RepLastName", RepLastName),
new SqlParameter("@RepFirstName", RepFirstName),
new SqlParameter("@DiscussionTopic", DiscussionTopic),
new SqlParameter("@ACTIONSTEP", ACTIONSTEP),
new SqlParameter("@LastContact_Date", LastContact_Date),
new SqlParameter("@NextContact_Date", NextContact_Date),
new SqlParameter("@CreationDate", CreationDate),
new SqlParameter("@CreatedBy", _user.UserId),
new SqlParameter("@Notes", Notes),
new SqlParameter("@FranchiseeId", _user.FranchiseeID),
new SqlParameter("@StartTime", _StartTime));
UserEntitiesFactory.ReLoad();
}