public override int GetHashCode()
{
unchecked
{
int hashCode = (SecurityCode != null
? SecurityCode.GetHashCode()
: 0);
hashCode = (hashCode * 397) ^ (OptionNumber != null
? OptionNumber.GetHashCode()
: 0);
hashCode = (hashCode * 397) ^ (OptionCode != null
? OptionCode.GetHashCode()
: 0);
hashCode = (hashCode * 397) ^ Bid.GetHashCode();
hashCode = (hashCode * 397) ^ BidVolume.GetHashCode();
hashCode = (hashCode * 397) ^ Ask.GetHashCode();
hashCode = (hashCode * 397) ^ AskVolume.GetHashCode();
hashCode = (hashCode * 397) ^ Volume.GetHashCode();
hashCode = (hashCode * 397) ^ Bid2.GetHashCode();
hashCode = (hashCode * 397) ^ BidVolume2.GetHashCode();
hashCode = (hashCode * 397) ^ Ask2.GetHashCode();
hashCode = (hashCode * 397) ^ AskVolume2.GetHashCode();
hashCode = (hashCode * 397) ^ Bid3.GetHashCode();
hashCode = (hashCode * 397) ^ BidVolume3.GetHashCode();
hashCode = (hashCode * 397) ^ Ask3.GetHashCode();
hashCode = (hashCode * 397) ^ AskVolume3.GetHashCode();
hashCode = (hashCode * 397) ^ Bid4.GetHashCode();
hashCode = (hashCode * 397) ^ BidVolume4.GetHashCode();
hashCode = (hashCode * 397) ^ Ask4.GetHashCode();
hashCode = (hashCode * 397) ^ AskVolume4.GetHashCode();
hashCode = (hashCode * 397) ^ Bid5.GetHashCode();
hashCode = (hashCode * 397) ^ BidVolume5.GetHashCode();
hashCode = (hashCode * 397) ^ Ask5.GetHashCode();
hashCode = (hashCode * 397) ^ AskVolume5.GetHashCode();
hashCode = (hashCode * 397) ^ (Greeks != null
? Greeks.GetHashCode()
: 0);
hashCode = (hashCode * 397) ^ OpenInterest.GetHashCode();
hashCode = (hashCode * 397) ^ Turnover.GetHashCode();
hashCode = (hashCode * 397) ^ UncoveredPositionQuantity.GetHashCode();
hashCode = (hashCode * 397) ^ PreviousSettlementPrice.GetHashCode();
hashCode = (hashCode * 397) ^ OpeningPrice.GetHashCode();
hashCode = (hashCode * 397) ^ AuctionReferencePrice.GetHashCode();
hashCode = (hashCode * 397) ^ AuctionReferenceQuantity.GetHashCode();
hashCode = (hashCode * 397) ^ HighestPrice.GetHashCode();
hashCode = (hashCode * 397) ^ LowestPrice.GetHashCode();
hashCode = (hashCode * 397) ^ LatestTradedPrice.GetHashCode();
hashCode = (hashCode * 397) ^ Change.GetHashCode();
hashCode = (hashCode * 397) ^ ChangePercentage.GetHashCode();
hashCode = (hashCode * 397) ^ PreviousClose.GetHashCode();
hashCode = (hashCode * 397) ^ (Name != null
? Name.GetHashCode()
: 0);
return(hashCode);
}
}
protected bool Equals(OptionViewModel other)
{
return(string.Equals(OptionNumber, other.OptionNumber) &&
Bid.Equals(other.Bid) &&
BidVolume == other.BidVolume &&
Ask.Equals(other.Ask) &&
AskVolume == other.AskVolume &&
Volume == other.Volume &&
Bid2.Equals(other.Bid2) &&
BidVolume2 == other.BidVolume2 &&
Ask2.Equals(other.Ask2) &&
AskVolume2 == other.AskVolume2 &&
Bid3.Equals(other.Bid3) &&
BidVolume3 == other.BidVolume3 &&
Ask3.Equals(other.Ask3) &&
AskVolume3 == other.AskVolume3 &&
Bid4.Equals(other.Bid4) &&
BidVolume4 == other.BidVolume4 &&
Ask4.Equals(other.Ask4) &&
AskVolume4 == other.AskVolume4 &&
Bid5.Equals(other.Bid5) &&
BidVolume5 == other.BidVolume5 &&
Ask5.Equals(other.Ask5) &&
AskVolume5 == other.AskVolume5 &&
Equals(Greeks, other.Greeks) &&
OpenInterest == other.OpenInterest &&
Turnover.Equals(other.Turnover) &&
UncoveredPositionQuantity == other.UncoveredPositionQuantity &&
PreviousSettlementPrice.Equals(other.PreviousSettlementPrice) &&
OpeningPrice.Equals(other.OpeningPrice) &&
AuctionReferencePrice.Equals(other.AuctionReferencePrice) &&
AuctionReferenceQuantity == other.AuctionReferenceQuantity &&
HighestPrice.Equals(other.HighestPrice) &&
LowestPrice.Equals(other.LowestPrice) &&
LatestTradedPrice.Equals(other.LatestTradedPrice) &&
Change.Equals(other.Change) &&
ChangePercentage.Equals(other.ChangePercentage) &&
PreviousClose.Equals(other.PreviousClose) &&
string.Equals(Name, other.Name));
}
public override int GetHashCode()
{
var hashCode = -1519320215;
hashCode = hashCode * -1521134295 + IsStarted.GetHashCode();
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(TickerID);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Ticker);
hashCode = hashCode * -1521134295 + Type.GetHashCode();
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(FullName);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Prefix);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Currency);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(ISIN);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Name);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(ShortName);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(ChartName);
hashCode = hashCode * -1521134295 + Decimals.GetHashCode();
hashCode = hashCode * -1521134295 + ForgDecimals.GetHashCode();
hashCode = hashCode * -1521134295 + Open.GetHashCode();
hashCode = hashCode * -1521134295 + Close.GetHashCode();
hashCode = hashCode * -1521134295 + Last.GetHashCode();
hashCode = hashCode * -1521134295 + LastHTML.GetHashCode();
hashCode = hashCode * -1521134295 + LastSize.GetHashCode();
hashCode = hashCode * -1521134295 + LastTime.GetHashCode();
hashCode = hashCode * -1521134295 + LastHtmlTime.GetHashCode();
hashCode = hashCode * -1521134295 + Change.GetHashCode();
hashCode = hashCode * -1521134295 + ChangePercentage.GetHashCode();
hashCode = hashCode * -1521134295 + Min.GetHashCode();
hashCode = hashCode * -1521134295 + Max.GetHashCode();
hashCode = hashCode * -1521134295 + DealsCount.GetHashCode();
hashCode = hashCode * -1521134295 + EqualityComparer <List <StockDeal> > .Default.GetHashCode(Deals);
hashCode = hashCode * -1521134295 + Traffic.GetHashCode();
hashCode = hashCode * -1521134295 + TrafficCount.GetHashCode();
hashCode = hashCode * -1521134295 + OpenInterest.GetHashCode();
hashCode = hashCode * -1521134295 + Status.GetHashCode();
hashCode = hashCode * -1521134295 + PanelJS.GetHashCode();
hashCode = hashCode * -1521134295 + ID.GetHashCode();
hashCode = hashCode * -1521134295 + RealTime.GetHashCode();
hashCode = hashCode * -1521134295 + Pe2000.GetHashCode();
hashCode = hashCode * -1521134295 + Pe2001.GetHashCode();
hashCode = hashCode * -1521134295 + CloseOneMonth.GetHashCode();
hashCode = hashCode * -1521134295 + EqualityComparer <TimeSpan> .Default.GetHashCode(CloseOneMonthInterval);
hashCode = hashCode * -1521134295 + CloseThreeMonth.GetHashCode();
hashCode = hashCode * -1521134295 + EqualityComparer <TimeSpan> .Default.GetHashCode(CloseThreeMonthInterval);
hashCode = hashCode * -1521134295 + CloseOneYear.GetHashCode();
hashCode = hashCode * -1521134295 + EqualityComparer <TimeSpan> .Default.GetHashCode(CloseOneYearInterval);
hashCode = hashCode * -1521134295 + OneMonthVolatility.GetHashCode();
hashCode = hashCode * -1521134295 + ThreeMonthVolatility.GetHashCode();
hashCode = hashCode * -1521134295 + OneYearVolatility.GetHashCode();
hashCode = hashCode * -1521134295 + Eps2000.GetHashCode();
hashCode = hashCode * -1521134295 + Eps2001.GetHashCode();
hashCode = hashCode * -1521134295 + MinOneYear.GetHashCode();
hashCode = hashCode * -1521134295 + MinOneYearAt.GetHashCode();
hashCode = hashCode * -1521134295 + MaxOneYear.GetHashCode();
hashCode = hashCode * -1521134295 + MaxOneYearAt.GetHashCode();
hashCode = hashCode * -1521134295 + MinOfAllTime.GetHashCode();
hashCode = hashCode * -1521134295 + MinOfAllTimeAt.GetHashCode();
hashCode = hashCode * -1521134295 + MaxOfAllTime.GetHashCode();
hashCode = hashCode * -1521134295 + MaxOfAllTimeAt.GetHashCode();
hashCode = hashCode * -1521134295 + CloseMinOneYear.GetHashCode();
hashCode = hashCode * -1521134295 + CloseMinOneYearAt.GetHashCode();
hashCode = hashCode * -1521134295 + CloseMaxOneYear.GetHashCode();
hashCode = hashCode * -1521134295 + CloseMaxOneYearAt.GetHashCode();
hashCode = hashCode * -1521134295 + CloseMinAllTime.GetHashCode();
hashCode = hashCode * -1521134295 + CloseMinAllTimeAt.GetHashCode();
hashCode = hashCode * -1521134295 + CloseMaxOfAllTime.GetHashCode();
hashCode = hashCode * -1521134295 + CloseMaxAllTimeAt.GetHashCode();
hashCode = hashCode * -1521134295 + TrafficAvgInSixMonth.GetHashCode();
hashCode = hashCode * -1521134295 + TrafficAvgInOneYear.GetHashCode();
hashCode = hashCode * -1521134295 + StartCount.GetHashCode();
hashCode = hashCode * -1521134295 + Kapit.GetHashCode();
hashCode = hashCode * -1521134295 + BuxKapit.GetHashCode();
hashCode = hashCode * -1521134295 + ChangeInOneMonth.GetHashCode();
hashCode = hashCode * -1521134295 + ChangeInThreeMonth.GetHashCode();
hashCode = hashCode * -1521134295 + ChangeInOneYear.GetHashCode();
hashCode = hashCode * -1521134295 + StartPrice.GetHashCode();
hashCode = hashCode * -1521134295 + MinInOneYear.GetHashCode();
hashCode = hashCode * -1521134295 + MaxInOneYear.GetHashCode();
hashCode = hashCode * -1521134295 + EqualityComparer <ChartData> .Default.GetHashCode(ImageData);
return(hashCode);
}
public ArrayList GetMatrixReportData(out List <MasterMatrixSummary> masterMatrix, out List <ChangePercentage> changePercentageList, out string programYear, Guid agencyId, Guid userId, Guid roleId, string year)
{
string queryCommand = "SELECT";
MatrixSummary summary = null;
MasterMatrixSummary masterSummary = null;
List <MatrixSummary> summaryList = new List <MatrixSummary>();
List <MatrixSummary> summaryList1 = new List <MatrixSummary>();
List <MasterMatrixSummary> masterSummaryList = new List <MasterMatrixSummary>();
ArrayList list1 = new ArrayList();
ArrayList list2 = new ArrayList();
List <long> catIdList = new List <long>();
List <long> aNoList = new List <long>();
changePercentageList = new List <ChangePercentage>();
ChangePercentage changePercentage = null;
programYear = string.Empty;
const string upArrow = "/images/dw-arw.png";
const string downArrow = "/images/tp-arw.png";
const string fontColorDecrease = "rgb(231, 76, 60)";
const string fontColorIncrease = "rgb(46, 204, 113)";
const string fontColorBlack = "rgb(0, 0, 0)";
masterMatrix = new List <MasterMatrixSummary>();
_dataset = new DataSet();
command.Connection = Connection;
command.CommandText = "USP_MatrixSummary";
command.Parameters.Add(new SqlParameter("@AgencyId", agencyId));
command.Parameters.Add(new SqlParameter("@ProgramTypeYear", year));
command.Parameters.Add(new SqlParameter("@UserId", userId));
command.Parameters.Add(new SqlParameter("@RoleId", roleId));
command.Parameters.Add(new SqlParameter("@Command", queryCommand));
command.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(_dataset);
if (_dataset.Tables[0] != null)
{
if (_dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in _dataset.Tables[0].Rows)
{
summary = new MatrixSummary();
summary.AgencyId = new Guid(dr["AgencyId"].ToString());
summary.TotalAnswered = Convert.ToInt64(dr["TotalAnswered"]);
summary.TotalClients = Convert.ToInt64(dr["TotalClients"]);
summary.TotalPoints = Convert.ToInt64(dr["TotalPoints"]);
summary.TotalRatio = Convert.ToDouble(dr["TotalRatio"]);
summary.AssessmentCategoryId = Convert.ToInt64(dr["AssessmentCategoryId"]);
summary.AssessmentGroupId = Convert.ToInt64(dr["AssessmentGroupId"]);
summary.AssessmentGroupType = dr["AssessmentGroupType"].ToString();
summary.AssessmentNumber = Convert.ToInt64(dr["AssessmentNumber"]);
summary.Category = dr["Category"].ToString();
summary.ProgramYear = string.IsNullOrEmpty(dr["ProgramYear"].ToString()) ? "" : dr["ProgramYear"].ToString();
summary.CategoryPosition = Convert.ToInt64(dr["CategoryPosition"]);
summary.MaxMatrixValue = Convert.ToInt64(dr["MaxMatrixValue"]);
summaryList.Add(summary);
}
programYear = summaryList.Where(x => x.ProgramYear != "").Select(x => x.ProgramYear).Distinct().FirstOrDefault().ToString();
var convlist = summaryList.GroupBy(x => x.AssessmentGroupId).ToList();
double as1value = 0;
double as2value = 0;
double as3value = 0;
foreach (var item in convlist)
{
changePercentage = new ChangePercentage();
foreach (var item2 in item)
{
if (item2.AssessmentNumber == 1)
{
as1value = item2.TotalRatio;
}
if (item2.AssessmentNumber == 2)
{
as2value = item2.TotalRatio;
}
if (item2.AssessmentNumber == 3)
{
as3value = item2.TotalRatio;
}
changePercentage.AssessmentGroupId = item2.AssessmentGroupId;
changePercentage.AssessmentCategoryId = item2.AssessmentCategoryId;
changePercentage.AssessmentGroupType = item2.AssessmentGroupType;
changePercentage.Category = item2.Category;
changePercentage.CategoryPosition = item2.CategoryPosition;
}
if (as3value != 0 && as1value != 0)
{
changePercentage.ChangePercent = ((as1value - as3value) / (as1value)) * 100;
}
else if (as1value != 0 && as2value != 0)
{
changePercentage.ChangePercent = ((as1value - as2value) / (as1value)) * 100;
}
if (changePercentage.ChangePercent > 0)
{
changePercentage.ArrowType = downArrow;
changePercentage.FontColor = fontColorDecrease;
}
else if (changePercentage.ChangePercent < 0)
{
changePercentage.ArrowType = upArrow;
changePercentage.FontColor = fontColorIncrease;
}
else if (changePercentage.ChangePercent == 0 && ((as1value != 0 && as2value != 0) || (as1value != 0 && as3value != 0)))
{
changePercentage.ArrowType = upArrow;
changePercentage.FontColor = fontColorIncrease;
}
else if (as1value == 0 && as2value == 0 && as3value == 0)
{
changePercentage.ArrowType = string.Empty;
changePercentage.FontColor = fontColorBlack;
changePercentage.ChangePercent = 0;
}
else if (as1value == 0 && as2value == 0 || as3value == 0)
{
changePercentage.ArrowType = string.Empty;
changePercentage.FontColor = fontColorBlack;
changePercentage.ChangePercent = 0;
}
else if (as3value == 0 && as2value == 0 || as1value == 0)
{
changePercentage.ArrowType = string.Empty;
changePercentage.FontColor = fontColorBlack;
changePercentage.ChangePercent = 0;
}
changePercentage.ChangePercent = Math.Abs(changePercentage.ChangePercent);
changePercentageList.Add(changePercentage);
}
catIdList = summaryList.Select(x => x.AssessmentCategoryId).Distinct().ToList();
aNoList = summaryList.Select(x => x.AssessmentNumber).Distinct().ToList();
foreach (var id in catIdList)
{
summaryList1 = summaryList.Where(x => x.AssessmentCategoryId == id).ToList();
list2.Add(summaryList1);
}
}
}
if (_dataset.Tables[1] != null)
{
if (_dataset.Tables[1].Rows.Count > 0)
{
foreach (DataRow dr in _dataset.Tables[1].Rows)
{
masterSummary = new MasterMatrixSummary();
masterSummary.AssessmentNumberMaster = Convert.ToInt64(dr["AssessmentNumber"]);
masterSummary.FamiliesEntered = Convert.ToInt64(dr["FamiliesEntered"]);
masterSummary.PercentFamilyEntered = string.IsNullOrEmpty(dr["PercentFamilyEntered"].ToString()) ? 0 : Convert.ToDouble(dr["PercentFamilyEntered"]);
masterSummaryList.Add(masterSummary);
}
}
}
masterMatrix = masterSummaryList;
return(list2);
}
