public bool UpdatePackages() { LoadPackage Lpk = new LoadPackage(); System.Data.SqlClient.SqlConnection conn = Connection.GetConnection(); string updateStatement = "UPDATE Packages SET PkgName = @PkgName,PkgStartDate=@PkgStartDate,PkgEndDate=@PkgEndDate,PkgDesc=@PkgDesc,PkgBasePrice=@PkgBasePrice,PkgAgencyCommission=@PCommission WHERE PackageId = @PackageID"; System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(updateStatement, conn); cmd.Parameters.AddWithValue("@PackageID", Lpk.PackageId); cmd.Parameters.AddWithValue("@PkgName", Lpk.PkgName); cmd.Parameters.AddWithValue("@PkgStartDate", Lpk.PkgStartDate); cmd.Parameters.AddWithValue("@PkgEndDate", Lpk.PkgEndDate); cmd.Parameters.AddWithValue("@PkgDesc", Lpk.PkgDesc); cmd.Parameters.AddWithValue("@PkgBasePrice", Lpk.PkgBasePrice); cmd.Parameters.AddWithValue("@PCommission", Lpk.PkgAgencyCommission); try { conn.Open(); if (cmd.ExecuteNonQuery() > 0) { return(true); } } catch (System.Data.SqlClient.SqlException ex) { throw ex; } finally { conn.Close(); } return(false); }
//public static bool InsertPackages() //{ // SqlConnection connection = Connection.GetConnection(); // String query = "INSERT INTO dbo.Packages (PkgName,PkgStartDate,PkgEndDate,PkgDesc,PkgBasePrice,PkgAgencyCommission) VALUES (@id,@username,@password, @email)"; // using (SqlCommand command = new SqlCommand(query, connection)) // { // command.Parameters.AddWithValue("@PkgName", "abc"); // command.Parameters.AddWithValue("@PkgStartDate", "abc"); // command.Parameters.AddWithValue("@PkgEndDate", "abc"); // command.Parameters.AddWithValue("@PkgDesc", "abc"); // command.Parameters.AddWithValue("@PkgBasePrice", "abc"); // command.Parameters.AddWithValue("@PkgAgencyCommission", "abc"); // connection.Open(); // int result = command.ExecuteNonQuery(); // // Check Error // if (result < 0) // Console.WriteLine("Error inserting data into Database!"); // } // try // { // connection.Open(); // if (cmd.ExecuteNonQuery() > 0) return true; // } // catch (SqlException ex) // { // throw ex; // } // finally // { // connection.Close(); // } // return false; //} public int SavePackages() { LoadPackage Lpk = new LoadPackage(); System.Data.SqlClient.SqlConnection conn = Connection.GetConnection(); String savePackages = "INSERT INTO dbo.Packages (PkgName,PkgStartDate,PkgEndDate,PkgDesc,PkgBasePrice,PkgAgencyCommission) VALUES (@PkgName,@PkgStartDate,@PkgEndDate,@PkgDesc,@PkgBasePrice,@PCommission)"; System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(savePackages, conn); cmd.Parameters.AddWithValue("@PkgName", Lpk.PkgName); cmd.Parameters.AddWithValue("@PkgStartDate", Lpk.PkgStartDate); cmd.Parameters.AddWithValue("@PkgEndDate", Lpk.PkgEndDate); cmd.Parameters.AddWithValue("@PkgDesc", Lpk.PkgDesc); cmd.Parameters.AddWithValue("@PkgBasePrice", Lpk.PkgBasePrice); cmd.Parameters.AddWithValue("@PCommission", Lpk.PkgAgencyCommission); try { conn.Open(); if (cmd.ExecuteNonQuery() > 0) { GetDataId = new LoadData(); return(GetDataId.MaxId("Select MAX(PackageId) from Packages")); } } catch (System.Data.SqlClient.SqlException ex) { throw ex; } finally { conn.Close(); } return(0); }