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;
}
}
}
