public Boolean InsertPricedItemsQuery(int iGeneralPricingIndex, int FromMonth, int FromYear, int rNumber, float UnitPrice,
decimal rVATPercentage, int iMonthFrequency, string dbName)
{
string connectionString = cons.GetConn(dbName);
PricedItemForPricing pricingItem = new PricedItemForPricing();
using (SqlConnection con = new SqlConnection(connectionString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("spInsertPricedItems", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@iGeneralPricingIndex", iGeneralPricingIndex);
cmd.Parameters.AddWithValue("@iMonth", FromMonth);
cmd.Parameters.AddWithValue("@iYear", FromYear);
cmd.Parameters.AddWithValue("@rNumber", rNumber);
cmd.Parameters.AddWithValue("@mUnitPrice", UnitPrice);
cmd.Parameters.AddWithValue("@rVATPercentage", rVATPercentage);
cmd.Parameters.AddWithValue("@iMonthPeriod", iMonthFrequency);
}
con.Close();
}
return(false);
}
public PricedItemForPricing GetPricedItemForPricingQuery(int GeneralPricingIndex, int Year, int Month, string dbName)
{
string connectionString = cons.GetConn(dbName);
PricedItemForPricing pricingItem = new PricedItemForPricing();
using (SqlConnection con = new SqlConnection(connectionString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("spCountPricedItems", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@iGeneralPricingIndex", GeneralPricingIndex);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
pricingItem.GeneralPricingIndex = Convert.ToInt32(reader["iGeneralPricingIndex"].ToString());;
pricingItem.InvoiceNbr = Convert.ToInt32(reader["iInvoiceNbr"].ToString());
pricingItem.Month = Convert.ToInt32(reader["iMonth"].ToString());;
pricingItem.MonthPeriod = Convert.ToInt32(reader["iMonthPeriod"].ToString());
pricingItem.Number = Convert.ToInt32(reader["rNumber"].ToString());;
pricingItem.PricedItemsIndex = Convert.ToInt32(reader["iPricedItemsIndex"].ToString());
pricingItem.UnitPrice = Convert.ToInt32(reader["mUnitPrice"].ToString());
pricingItem.VATPercentage = Convert.ToInt32(reader["rVATPercentage"].ToString());;
pricingItem.Year = Convert.ToInt32(reader["iYear"].ToString());
}
}
con.Close();
}
return(pricingItem);
}
