public void CalculateNetAmount(SalesDetails details) { float discount = 0; double wholeSaleRate = 75350; double NetAmount = 0; if (details.NoOfUnits <= 5) { discount = 0; } else if (details.NoOfUnits > 5 && details.NoOfUnits <= 10) { discount = 0.02f; } else if (details.NoOfUnits > 10 && details.NoOfUnits <= 15) { discount = 0.05f; } else if (details.NoOfUnits > 15 && details.NoOfUnits <= 20) { discount = 0.08f; } else { discount = 0.10f; } details.NetAmount = Math.Round((details.NoOfUnits * wholeSaleRate) - ((details.NoOfUnits * wholeSaleRate) * discount)); }
public void AddSalesDetails(SalesDetails sd) { DBHandler dBHandler = new DBHandler(); SqlCon = dBHandler.GetConnection(); SqlCommand sqlCommand = new SqlCommand("Insert into SalesDetails values(@Sales_id, @Customer_name , @No_of_units, @Net_amount)", SqlCon); sqlCommand.Parameters.AddWithValue("@Sales_id", sd.SalesId); sqlCommand.Parameters.AddWithValue("@Customer_name", sd.CustomerName); sqlCommand.Parameters.AddWithValue("@No_of_units", sd.NoOfUnits); sqlCommand.Parameters.AddWithValue("@Net_amount", sd.NetAmount); SqlCon.Open(); sqlCommand.ExecuteNonQuery(); SqlCon.Close(); sqlCommand.Dispose(); SqlCon.Dispose(); }
static void Main(string[] args) { try { Console.WriteLine("Enter sales id"); int SalesId = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter customer name"); string CustomerName = Console.ReadLine(); Console.WriteLine("Enter the no of units sold"); int NoOfUnits = Convert.ToInt32(Console.ReadLine()); if (NoOfUnits < 5) { throw new ArgumentOutOfRangeException("No Sales for units below 5"); } else { MetalApps metalApps = new MetalApps(); SalesDetails salesDetails = new SalesDetails(); salesDetails.SalesId = SalesId; salesDetails.CustomerName = CustomerName; salesDetails.NoOfUnits = NoOfUnits; metalApps.CalculateNetAmount(salesDetails); metalApps.AddSalesDetails(salesDetails); Console.WriteLine("Sales Bill \n***********"); Console.WriteLine("Sales Id : {0}", SalesId); Console.WriteLine("Customer Name : {0}", CustomerName); Console.WriteLine("Number of Units Sold : {0}", NoOfUnits); Console.WriteLine("Net Amount : {0}", salesDetails.NetAmount); } } catch (ArgumentOutOfRangeException obj) { Console.WriteLine(obj.Message); } }