private void UpdatePackage_Load(object sender, EventArgs e)
{
gridProductSupplierRemove.AutoGenerateColumns = false;
TravelWinRepository package = new TravelWinRepository();
gridProductSupplierAdd.DataSource = package.GetProductSuppliers();
gridProductSupplierRemove.DataSource = package.GetProducts(selectedPackage);
for (int i = 0; i < gridProductSupplierRemove.Rows.Count; i++)
{
ProductListViewModel gridRight = new ProductListViewModel();
gridRight.ProdName = gridProductSupplierRemove.Rows[i].Cells["colProdTypeRight"].Value.ToString();
gridRight.SupName = gridProductSupplierRemove.Rows[i].Cells["colSupplierRight"].Value.ToString();
gridRight.ProductSupplierId = Convert.ToInt32(gridProductSupplierRemove.Rows[i].Cells["ProductSupplierId"].Value);
toAdd.Add(gridRight);
}
string image = ConfigurationManager.AppSettings["PathToProject"] + txtFilePath.Text;
try
{
//pbImage.Image = Image.FromFile(image);
pbImage.Load(image);
}
catch
{
PictureBox errorPic = new PictureBox();
pbImage.Image = errorPic.ErrorImage;
}
}
private void ProductManager_Load(object sender, EventArgs e)
{
gridSuppliers.AutoGenerateColumns = false;
TravelWinRepository products = new TravelWinRepository();
gridProducts.DataSource = products.GetProduct();
gridSuppliers.DataSource = products.GetSuppliers();
RefreshCB();
}
private void BtnDeleteSupplier_Click(object sender, EventArgs e)
{
int SupplierId = Convert.ToInt32(gridSuppliers.CurrentRow.Cells["SupplierId"].Value);
TravelWinRepository suppliers = new TravelWinRepository();
suppliers.DeleteSupplier(SupplierId);
gridSuppliers.DataSource = suppliers.GetSuppliers();
callRefreshData();
}
private void btnApply_Click(object sender, EventArgs e)
{
try
{
string PkgName = txtPackageName.Text;
DateTime PkgStartDate = dateTimePackageStart.Value;
DateTime PkgEndDate = dateTimePackageEnd.Value;
string PkgDesc = txtPackageDescription.Text;
double PkgBasePrice = double.Parse(txtPackagePrice.Text);
double PkgAgencyCommission = double.Parse(txtPackageAgency.Text);
string PackageImageLocation = "";
if (txtFilePath.Text == "")
{
PackageImageLocation = null;
}
else
{
//string image = ConfigurationManager.AppSettings["PathToProject"];
PackageImageLocation = @"\Content\img\" + Path.GetFileName(txtFilePath.Text);
//File.Copy(txtFilePath.Text, image + PackageImageLocation);
string host = "ftp://mikebublitz.com/Content/img/" + Path.GetFileName(txtFilePath.Text);
FileInfo toUpload = new FileInfo(txtFilePath.Text);
FtpWebRequest request = (FtpWebRequest)WebRequest.Create(host);
request.Credentials = new NetworkCredential("mwbublit", "ftppassword");
request.Method = WebRequestMethods.Ftp.UploadFile;
Stream ftpStream = request.GetRequestStream();
FileStream file = File.OpenRead(txtFilePath.Text);
int length = 1024;
byte[] buffer = new byte[length];
int bytesRead = 0;
do
{
bytesRead = file.Read(buffer, 0, length);
ftpStream.Write(buffer, 0, bytesRead);
}while (bytesRead != 0);
file.Close();
ftpStream.Close();
}
List <int> productsList = new List <int>();
for (int i = 0; i < gridProductSupplierRemove.Rows.Count; i++)
{
int product = Convert.ToInt32(gridProductSupplierRemove.Rows[i].Cells["ProductSupplierId"].Value);
productsList.Add(product);
}
TravelWinRepository package = new TravelWinRepository();
package.InsertPackage(PkgName, PkgStartDate, PkgEndDate, PkgDesc, PkgBasePrice, PkgAgencyCommission, PackageImageLocation, productsList);
callRefreshData();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnDeleteProduct_Click(object sender, EventArgs e)
{
int ProductId = Convert.ToInt32(gridProducts.CurrentRow.Cells["ProductId"].Value);
TravelWinRepository products = new TravelWinRepository();
products.DeleteProduct(ProductId);
gridProducts.DataSource = products.GetProduct();
RefreshCB();
callRefreshData();
}
private void BtnProductAdd_Click(object sender, EventArgs e)
{
string ProdName = txtNewProduct.Text;
TravelWinRepository products = new TravelWinRepository();
products.InsertProduct(ProdName);
gridProducts.DataSource = products.GetProduct();
RefreshCB();
callRefreshData();
}
private void BtnDelete_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Delete " + lblPackageName.Text + "?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
TravelWinRepository package = new TravelWinRepository();
int selectedPackage = Convert.ToInt32(gridPackages.CurrentRow.Cells["PackageId"].Value);
package.DeletePackage(selectedPackage);
gridPackages.DataSource = package.GetPackages();
}
}
private void BtnSupplierAdd_Click(object sender, EventArgs e)
{
int SupplierId = Convert.ToInt32(txtSupplierId.Text);
string SupName = txtNewSuppler.Text;
//int ProductId = (int) cbProducts.SelectedItem;
Product prod = cbProducts.SelectedItem as Product;
TravelWinRepository suppliers = new TravelWinRepository();
suppliers.InsertSupplier(SupplierId, SupName, prod.ProductId);
gridSuppliers.DataSource = suppliers.GetSuppliers();
callRefreshData();
}
public void RefreshData()
{
TravelWinRepository packages = new TravelWinRepository();
gridPackages.DataSource = packages.GetPackages();
int selectedPackage = Convert.ToInt32(gridPackages.CurrentRow.Cells["PackageId"].Value);
gridProducts.DataSource = packages.GetProducts(selectedPackage);
for (int i = 0; i < gridPackages.RowCount; i++)
{
if (Convert.ToBoolean(gridPackages.Rows[i].Cells["Expired"].Value))
{
gridPackages.Rows[i].DefaultCellStyle.BackColor = Color.Red;
}
}
gridAllProducts.DataSource = packages.GetProductSuppliers();
}
private void Form1_Load(object sender, EventArgs e)
{
TravelWinRepository packages = new TravelWinRepository();
gridPackages.DataSource = packages.GetPackages();
int selectedPackage = Convert.ToInt32(gridPackages.CurrentRow.Cells["PackageId"].Value);
gridProducts.DataSource = packages.GetProducts(selectedPackage);
gridAllProducts.DataSource = packages.GetProductSuppliers();
AddPackage.callRefreshData += RefreshData;
UpdatePackage.callRefreshData += RefreshData;
ProductManager.callRefreshData += RefreshData;
for (int i = 0; i < gridPackages.RowCount; i++)
{
if (Convert.ToBoolean(gridPackages.Rows[i].Cells["Expired"].Value))
{
gridPackages.Rows[i].DefaultCellStyle.BackColor = Color.Red;
}
}
}
private void GridPackages_SelectionChanged(object sender, EventArgs e)
{
TravelWinRepository package = new TravelWinRepository();
int selectedPackage = Convert.ToInt32(gridPackages.CurrentRow.Cells["PackageId"].Value);
data = package.GetSinglePackage(selectedPackage);
lblPackageName.Text = data.PkgName;
lblDesc.Text = data.PkgDesc;
/*************************************************
*
* Causes a null value to be applied and I don't know why
*
* txtStartDate.Text = data.PkgStartDate.Value.Date.ToShortDateString();
* txtEndDate.Text = data.PkgEndDate.Value.Date.ToShortDateString();
*
*************************************************/
txtStartDate.Text = Convert.ToDateTime(data.PkgStartDate).ToShortDateString();
txtEndDate.Text = Convert.ToDateTime(data.PkgEndDate).ToShortDateString();
txtBasePrice.Text = data.PkgBasePrice.ToString("c");
txtCommission.Text = Convert.ToDouble(data.PkgAgencyCommission).ToString("c");
gridProducts.DataSource = package.GetProducts(selectedPackage);
string image = ConfigurationManager.AppSettings["PathToProject"] + data.PackageImageLocation;
try
{
//pbImage.Image = Image.FromFile(image);
pbImage.Load(image);
}
catch
{
PictureBox errorPic = new PictureBox();
//pbImage.Size = ;
pbImage.Image = errorPic.ErrorImage;
}
}
private void AddManager_Load(object sender, EventArgs e)
{
TravelWinRepository products = new TravelWinRepository();
gridProductSupplierAdd.DataSource = products.GetProductSuppliers();
}
