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