public void InsertintoTarrifPlanTable(TarrifPlan tp) { SqlConnection con = null; try { // Creating Connection con = new SqlConnection("Data Source=(localdb)\\MSSQLLocalDB;Database=DispurWireless; integrated security=SSPI"); // writing sql query SqlCommand cm = new SqlCommand ("insert into TarrifPlan" + "(planId,name,type,tarrif,validity,rental)" + "values(@planId,@name,@type,@tarrif,@validity,@rental)", con); cm.Parameters.AddWithValue("@planId", tp.PlanId); cm.Parameters.AddWithValue("@name", tp.Name); cm.Parameters.AddWithValue("@type", tp.Type); cm.Parameters.AddWithValue("@tarrif", tp.Tarrif); cm.Parameters.AddWithValue("@validity", tp.Validity); cm.Parameters.AddWithValue("@rental", tp.Rental); // Opening Connection con.Open(); // Executing the SQL query int i = cm.ExecuteNonQuery(); // Displaying a message Console.WriteLine("Record Inserted Successfully"); } catch (Exception e) { Console.WriteLine("OOPs, something went wrong here." + e); } // Closing the connection finally { con.Close(); } }
public TarrifPlanManagementPortal() { while (true) { Console.WriteLine("Press 1 to Add New Tarrif Plan..."); Console.WriteLine("Press 2 to View Plan details..."); Console.WriteLine("Press 3 to Remove a Plan..."); Console.WriteLine("Press 4 to update tarrif for a plan..."); Console.WriteLine("Press 5 to move back to main menu..."); int choice = int.Parse(Console.ReadLine()); switch (choice) { case 1: Console.WriteLine("--------------------------------------------------------------------------"); Console.WriteLine("Welcome to the Tarrif Plan Page...\n\n"); bool result = AuthenticateAdmin(); if (result) { Console.WriteLine("####Enter the Details####\n"); Console.Write("Enter plan name: "); string name = Console.ReadLine(); Console.Write("Enter paln type: "); string type = Console.ReadLine(); Console.Write("Enter tarrif(rate/min): "); int tarrif = int.Parse(Console.ReadLine()); Console.Write("Enter validity: "); int validity = int.Parse(Console.ReadLine()); Console.Write("Enter rental(if any): "); int rental = int.Parse(Console.ReadLine()); TarrifPlan tp = new TarrifPlan(name, type, tarrif, validity, rental); new TarrifPlanDbAccessLayer().InsertintoTarrifPlanTable(tp); Console.WriteLine("Please make a note of the Plan ID :" + tp.PlanId); } Console.WriteLine("--------------------------------------------------------------------------"); break; case 2: Console.WriteLine("--------------------------------------------------------------------------"); Console.WriteLine("........Voice/Data Plans........"); new TarrifPlanDbAccessLayer().FetchPlanData(); Console.WriteLine("--------------------------------------------------------------------------"); break; case 3: Console.WriteLine("--------------------------------------------------------------------------"); Console.WriteLine("Remove Plan Page...\n\n"); bool isAuthencated = AuthenticateAdmin(); if (isAuthencated) { Console.Write("Enter plan ID: "); int id = int.Parse(Console.ReadLine()); new TarrifPlanDbAccessLayer().RemovePlan(id); } Console.WriteLine("--------------------------------------------------------------------------"); break; case 4: Console.WriteLine("--------------------------------------------------------------------------"); Console.WriteLine("Update Tarrif Page...\n\n"); bool isAdmin = AuthenticateAdmin(); if (isAdmin) { Console.Write("Enter plan ID: "); int id1 = int.Parse(Console.ReadLine()); Console.Write("Enter new tarrif: "); int t = int.Parse(Console.ReadLine()); new TarrifPlanDbAccessLayer().UpdateTarrif(id1, t); } Console.WriteLine("--------------------------------------------------------------------------"); break; case 5: break; default: Console.WriteLine("--------------------------------------------------------------------------"); Console.WriteLine("Please enter correct choice...\n\n"); Console.WriteLine("--------------------------------------------------------------------------"); break; } if (choice == 5) { break; } } }