public Discounts GetCustomerDiscounts(string customerNo)
{
Discounts discounts = new Discounts();
try
{
using (SqlConnection conn = new SqlConnection(connString))
using (SqlCommand comm = new SqlCommand("usp_GetCustomerDiscounts", conn))
{
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Clear();
comm.Parameters.Add(new SqlParameter("@Customer_ID", customerNo));
conn.Open();
using (SqlDataReader dr = comm.ExecuteReader())
{
while (dr.Read())
{
Discount d = new Discount();
d.DiscountID = dr["Discount ID"].ToString();
d.DiscountDescription = dr["Discount Description"].ToString();
d.Percent = decimal.Round(Convert.ToDecimal(dr["Discount Percentage"].ToString()), 2);
d.DiscountType = (Discount_Type)Convert.ToInt32(dr["Discount Type"].ToString());
d.Computed = false;
discounts.Add(d);
}
}
}
}
catch (Exception ex)
{
log.Error(ex);
throw;
}
return discounts;
}
public Discounts GetAssessmentDiscountsByDocID(string transactionNo, Transaction_Type type)
{
Discounts discounts = new Discounts();
try
{
using (SqlConnection conn = new SqlConnection(connString))
using (SqlCommand comm = new SqlCommand("usp_GetAssessmentDiscountsByDocID", conn))
{
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Clear();
comm.Parameters.Add(new SqlParameter("@Assessment_No", transactionNo));
comm.Parameters.Add(new SqlParameter("@SOPType", (int)type));
conn.Open();
using (SqlDataReader dr = comm.ExecuteReader())
{
while (dr.Read())
{
Discount d = new Discount();
d.DiscountID = dr["Discount ID"].ToString();
d.DiscountDescription = dr["Discount Description"].ToString();
d.Percent = decimal.Round(Convert.ToDecimal((dr["Percent"]).ToString()), 2);
d.DiscountType = (Discount_Type)Convert.ToInt32(dr["Discount Type"].ToString());
d.Amount = decimal.Round(Convert.ToDecimal((dr["Discount Amount"]).ToString()), 2);
d.ItemAppliedTo = dr["Applied To"].ToString();
d.Computed = true;
discounts.Add(d);
}
}
}
}
catch (Exception ex)
{
log.Error(ex);
throw;
}
return discounts;
}