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