public Bussiness_Logic.Package GetPackage(int packageID) { string query = $"SELECT * FROM ContractType WHERE ContractTypeID = {packageID}"; Bussiness_Logic.Package package = null; SqlConnection conn = new SqlConnection(connect); SqlCommand command = new SqlCommand(query, conn); try { conn.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { package = new Bussiness_Logic.Package(reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetInt32(0)); } } catch (Exception ex) { MessageBox.Show("Could not find packages " + ex.Message); } finally { conn.Close(); } return(package); }
public List <Bussiness_Logic.Package> GetAllPackages() { List <Bussiness_Logic.Package> packages = new List <Bussiness_Logic.Package>(); string query = $"SELECT * FROM ContractType"; SqlConnection conn = new SqlConnection(connect); SqlCommand command = new SqlCommand(query, conn); try { conn.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Bussiness_Logic.Package package = new Bussiness_Logic.Package(reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetInt32(0)); packages.Add(package); } } catch (Exception ex) { MessageBox.Show("Could not find packages " + ex.Message); } finally { conn.Close(); } return(packages); }
private void PackagePerformance_Load(object sender, EventArgs e) { Bussiness_Logic.Package package = new Bussiness_Logic.Package(); lblTotalPackages.Text = package.PackagesInLast30Days().ToString(); bsBestSellers.DataSource = package.BestPackageOrPackagesOfTheMonth(); dgvBestPackageOfTheMonth.DataSource = bsBestSellers; lblBestNumbersSold.Text = package.MostSoldPackageQuantity().ToString(); }
private void btnUpdatePackage_Click(object sender, EventArgs e) { int packageID = int.Parse(txtUpdateID.Text); string serviceIDs = txtUpdateServiceIDs.Text; string serviceLevelIDs = txtUPdateServiceLevelIDs.Text; string name = txtUpdateName.Text; Bussiness_Logic.Package package = new Bussiness_Logic.Package(); package.UpdatePackage(packageID, name, serviceIDs, serviceLevelIDs); bsPackages.DataSource = dataAccess.GetAllPackages(); bsPackages.ResetBindings(true); }
private void btnSearchPackage_Click(object sender, EventArgs e) { dgvPackageByCity.Rows.Clear(); int packageID = int.Parse(txtSearchPackage.Text); Bussiness_Logic.Package package = new Bussiness_Logic.Package(); List <string> data = package.PackagePerfromance(packageID); for (int i = 0; i < data.Count; i++) { string[] saleAndCity = data[i].Split(','); dgvPackageByCity.Rows.Add(saleAndCity); } }
private void btnAddPackage_Click(object sender, EventArgs e) { string serviceIDs = txtServiceIDs.Text; string serviceLevelIds = txtServiceLevelsIDs.Text; string name = txtPackageName.Text; Bussiness_Logic.Package package = new Bussiness_Logic.Package(); package.AddPackage(name, serviceIDs, serviceLevelIds); txtServiceIDs.Clear(); txtServiceLevelsIDs.Clear(); txtPackageName.Clear(); bsPackages.DataSource = dataAccess.GetAllPackages(); bsPackages.ResetBindings(true); }