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