public List <DealTypes> GetDealTypes(List <IMapIndexData> dfs, MapSearch map) { List <DealTypes> dealTypes = new List <DealTypes>(); string query = @"SELECT dealtypeid, DealType FROM [MapIndex].[dbo].[DealType] WHERE IsDfs = 1 ORDER BY DealType ASC"; System.Data.DataTable dt = GetDataTable(query); List <DfsData> vals = GetProperList(dfs); foreach (System.Data.DataRow dr in dt.Rows) { DealTypes dealType = new DealTypes(); try { dealType.DealCount = vals.Where(s => s.DealTypeId == dr["dealtypeid"].ToString()).Count(); } catch (Exception e) { } dealType.DealType = dr["DealType"].ToString(); dealType.Id = dr["dealtypeid"].ToString(); //if (dealType.DealCount > 0) //{ dealTypes.Add(dealType); //} } return(dealTypes); }
public static Deal ParseCreateDeal(string dealData) { string dealItem = PickAndCutItem(ref dealData); DateTime dealMoment = ParseMoment(dealItem); string removingBlock = PickAndCutItem(ref dealData); dealItem = PickAndCutItem(ref dealData); DealTypes dealType = ParseType(dealItem); dealItem = PickAndCutItem(ref dealData); float dealAmount = ParseAmount(dealItem); return(new Deal(dealMoment, dealType, dealAmount)); }
public Deal(DateTime dealMoment, DealTypes dealType, float dealAmount) { DealMoment = dealMoment; DealType = dealType; DealAmount = dealAmount; }