public IEnumerable <QuoteDiscrepancy> GetQuoteDiscrepancy(int QuoteHeaderID) { var quoteDiscreps = new List <QuoteDiscrepancy>(); using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SSIRentConnectionString"].ConnectionString)) using (SqlCommand command = connection.CreateCommand()) { command.CommandType = CommandType.StoredProcedure; command.CommandText = "sp_Quotes_rptPriceDiscrepancy"; command.Parameters.AddWithValue("@QuoteID", QuoteHeaderID); command.Connection.Open(); using (SqlDataReader dr = command.ExecuteReader()) { while (dr.Read()) { var quoteDiscr = new QuoteDiscrepancy { QuoteNumber = dr["QuoteNumber"].ToString(), QuoteDate = dr["QuoteDate"].ToString(), Customer = dr["Customer Name"].ToString(), JobType = dr["Job Type"].ToString(), Item = dr["Item"].ToString(), ItemDescription = dr["ItemDescription"].ToString(), MinimumCode = dr["MinCode"].ToString(), AddDayCode = dr["AddDayCode"].ToString(), QuoteMinimum = dr["MinAmt"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["MinAmt"]), CatalogMinimum = dr["CatalogMinAmt"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["CatalogMinAmt"]), QuoteAddDay = dr["AddDay"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["AddDay"]), CatalogAddDay = dr["CatalogAddDay"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["CatalogAddDay"]), NotInPCBook = dr["NotInPCBook"].ToString() }; quoteDiscreps.Add(quoteDiscr); } } return(quoteDiscreps); } }
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { Literal Quote = (Literal)repeater1.Controls[0].Controls[0].FindControl("Quote"); Literal QDate = (Literal)repeater1.Controls[0].Controls[0].FindControl("QDate"); Literal Customer = (Literal)repeater1.Controls[0].Controls[0].FindControl("Customer"); Literal JobType = (Literal)repeater1.Controls[0].Controls[0].FindControl("JobType"); dynamic dataitem = e.Item.DataItem as dynamic; QuoteDiscrepancy q = (QuoteDiscrepancy)dataitem; if (fixheaderonce == 0) //don't need to run this code evertime hence the variable fixheaderonce { Quote.Text = q.QuoteNumber; QDate.Text = q.QuoteDate; Customer.Text = q.Customer; JobType.Text = q.JobType; fixheaderonce = 2; } } }