protected void buttonUpdateProduct_Click(object sender, EventArgs e)
{
try
{
Session["ProductID"] = textBoxProductID.Text;
Session["ProductName"] = textBoxAddProductName.Text;
Session["ProductDescription"] = textBoxAddProductDescription.Text;
Session["ProductCategory"] = dropDownAddCategory.SelectedItem;
Session["ProductSubCategory"] = dropDownAddSubCategory.SelectedValue;
Session["ProductPrice"] = Convert.ToDouble(textBoxAddProductPrice.Text);
Session["ProductSalePrice"] = Convert.ToDouble(textBoxAddProductSalePrice.Text);
Session["ProductQuantity"] = Convert.ToInt32(textBoxProductQuantity.Text);
Session["ProductColor"] = textBoxAddProductColor.Text;
Session["ProductWeight"] = textBoxAddProductWeight.Text;
//Session["ProductImage"] = fileUploadProductImage.PostedFile;
if (checkBoxInSale.Checked)
{
Session["ProductOnSale"] = 1;
}
else
{
Session["ProductOnSale"] = 0;
}
if (checkBoxInSale.Checked = true && textBoxAddProductSalePrice.Text == "" || textBoxAddProductSalePrice.Text == " ")
{
Session["ProductSalePrice"] = textBoxAddProductPrice.Text;
}
int status;
string PID = "0000";
Products prodObj = new Products();
prodObj.fn_UpdateProductDetails(Session["ProductID"].ToString(), Session["ProductName"].ToString(), Session["ProductDescription"].ToString(), Convert.ToDecimal(Session["ProductPrice"]), Convert.ToDecimal(Session["ProductSalePrice"]), Convert.ToInt16(Session["ProductOnSale"]), Convert.ToInt32(Session["ProductQuantity"]), Session["ProductCategory"].ToString(), Session["ProductSubCategory"].ToString(), Session["ProductColor"].ToString(), Session["ProductWeight"].ToString(), fileUploadProductImage, out status, out PID);
Session["ProductID"] = PID;
Response.Write("<script>alert('Product " + PID + " was updated successfully!')</script>");
}
catch (Exception ex)
{
Response.Write("<SCRIPT LANGUAGE='JavaScript'>alert('" + ex.Message + "')</SCRIPT>");
//Server.Transfer("UnderConstruction.aspx");
}
finally
{
Response.Redirect("SalesDashboard.aspx");
}
}
protected void buttonCreateProduct_Click(object sender, EventArgs e)
{
Session["ProductID"] = textBoxProductID.Text;
Session["ProductName"] = textBoxAddProductName.Text;
Session["ProductDescription"] = textBoxAddProductDescription.Text;
Session["ProductCategory"] = dropDownAddCategory.SelectedItem;
Session["ProductSubCategory"] = dropDownAddSubCategory.SelectedValue;
Session["ProductPrice"] = Convert.ToDouble(textBoxAddProductPrice.Text);
Session["ProductSalePrice"] = Convert.ToDouble(textBoxAddProductSalePrice.Text);
Session["ProductQuantity"] = Convert.ToInt32(textBoxProductQuantity.Text);
Session["ProductColor"] = textBoxAddProductColor.Text;
Session["ProductWeight"] = textBoxAddProductWeight.Text + dropDownWeightUnit.Text;
//Session["ProductImage"] = fileUploadProductImage.PostedFile;
if ( checkBoxInSale.Checked)
{
Session["ProductOnSale"] = 1;
}else{
Session["ProductOnSale"] = 0;
}
if (checkBoxInSale.Checked = true && textBoxAddProductSalePrice.Text == "" || textBoxAddProductSalePrice.Text == " ")
{
Session["ProductSalePrice"] = textBoxAddProductPrice.Text;
}
int status;
string ProductID = "0000";
Products prodObj = new Products();
prodObj.fn_InsertProducts(Session["ProductName"].ToString(), Session["ProductDescription"].ToString(), Convert.ToDecimal(Session["ProductPrice"]), Convert.ToDecimal(Session["ProductSalePrice"]), Convert.ToInt16(Session["ProductOnSale"]), Convert.ToInt32(Session["ProductQuantity"]), Session["ProductCategory"].ToString(), Session["ProductSubCategory"].ToString(), Session["ProductColor"].ToString(), Session["ProductWeight"].ToString(), out status ,out ProductID );
Session["ProductID"] = ProductID;
Response.Write("<script>alert('Product added successfully" +ProductID + "')</script>");
Server.Transfer("SalesDashboard.aspx");
}
protected void textBoxProductID_TextChanged(object sender, EventArgs e)
{
string ProductID = textBoxProductID.Text;
string Name = "";
string Description = "";
decimal Price;
decimal SalePrice;
int InSale;
int Quantity;
string CategoryName = "";
string SubCategoryName = "";
string Color = "";
string Weight = "";
//int ProductStatus;
try
{
Products prodObj = new Products();
prodObj.fnGetProductDetails(ProductID, out Name, out Description, out Price, out SalePrice, out InSale,
out Quantity, out CategoryName, out SubCategoryName, out Color, out Weight);
//out ProductStatus);
Session["ProductCategory"] = CategoryName;
if (Name != null)
{
textBoxAddProductName.Text = Name;
}
if (Description != null)
{
textBoxAddProductDescription.Text = Description;
}
textBoxAddProductPrice.Text = Price.ToString();
textBoxAddProductSalePrice.Text = SalePrice.ToString();
textBoxProductQuantity.Text = Quantity.ToString();
if (Color != null)
{
textBoxAddProductColor.Text = Color;
}
if (CategoryName != null)
{
dropDownAddCategory.Text = CategoryName;
}
if (Weight != null)
{
textBoxAddProductWeight.Text = Weight;
}
Session["ProductID"] = textBoxProductID.Text;
Session["ProductName"] = textBoxAddProductName.Text;
Session["ProductDescription"] = textBoxAddProductDescription.Text;
Session["ProductCategory"] = dropDownAddCategory.SelectedItem;
Session["ProductSubCategory"] = SubCategoryName.ToString();
Session["ProductPrice"] = Convert.ToDouble(textBoxAddProductPrice.Text);
Session["ProductSalePrice"] = Convert.ToDouble(textBoxAddProductSalePrice.Text);
Session["ProductQuantity"] = Convert.ToInt32(textBoxProductQuantity.Text);
Session["ProductColor"] = textBoxAddProductColor.Text;
Session["ProductWeight"] = textBoxAddProductWeight.Text;
if (InSale == 1)
{
checkBoxInSale.Checked = true;
}
else
{
checkBoxInSale.Checked = false;
textBoxAddProductSalePrice.Enabled = false;
}
dropDownAddCategory.Text = Session["ProductCategory"].ToString();
dropDownAddCategory_SelectedIndexChanged(this.dropDownAddCategory, EventArgs.Empty);
}
catch (Exception ex)
{
Response.Write("<SCRIPT LANGUAGE='JavaScript'>alert('" + ex.Message + "')</SCRIPT>");
Response.Redirect("Error.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["userID"] == null)
{
// Redirect user to login before doing anything else
Response.Redirect("~/Login.aspx?redirect=ManageProductInformation.aspx");
}
else if (Session["userID"] != null && Session["userRole"].Equals("1"))
{
// Redirect user to login before doing anything else
Response.Redirect("~/Home.aspx");
}
textBoxAddProductSalePrice.Enabled = false;
Products prodObj = new Products();
textBoxProductID.Text = prodObj.fn_getNextProductId();
}
protected void textBoxProductID_TextChanged(object sender, EventArgs e)
{
string ProductID = textBoxProductID.Text;
string Name = "";
string Description = "";
decimal Price;
decimal SalePrice;
int InSale;
int Quantity;
string CategoryName = "";
string SubCategoryName = "";
string Color = "";
string Weight = "";
//int ProductStatus;
Products prodObj = new Products();
prodObj.fnGetProductDetails(ProductID, out Name, out Description, out Price, out SalePrice, out InSale,
out Quantity, out CategoryName, out SubCategoryName, out Color, out Weight);
//out ProductStatus);
textBoxAddProductName.Text = Name;
textBoxAddProductDescription.Text = Description;
textBoxAddProductPrice.Text = Price.ToString();
textBoxAddProductSalePrice.Text = SalePrice.ToString();
textBoxProductQuantity.Text = Quantity.ToString();
textBoxAddProductColor.Text = Color;
dropDownAddCategory.Text = CategoryName;
textBoxAddProductWeight.Text = Weight;
Session["ProductID"] = textBoxProductID.Text;
Session["ProductName"] = textBoxAddProductName.Text;
Session["ProductDescription"] = textBoxAddProductDescription.Text;
Session["ProductCategory"] = dropDownAddCategory.SelectedItem;
Session["ProductSubCategory"] = SubCategoryName;
Session["ProductPrice"] = Convert.ToDouble(textBoxAddProductPrice.Text);
Session["ProductSalePrice"] = Convert.ToDouble(textBoxAddProductSalePrice.Text);
Session["ProductQuantity"] = Convert.ToInt32(textBoxProductQuantity.Text);
Session["ProductColor"] = textBoxAddProductColor.Text;
Session["ProductWeight"] = textBoxAddProductWeight.Text;
if (InSale == 1)
{
checkBoxInSale.Checked = true;
}
else
{
checkBoxInSale.Checked = false;
}
dropDownAddCategory.SelectedValue = Session["ProductCategory"].ToString();
dropDownAddCategory_SelectedIndexChanged(this.dropDownAddCategory, EventArgs.Empty);
}
protected void Page_Load(object sender, EventArgs e)
{
textBoxAddProductSalePrice.Enabled = false;
Products prodObj = new Products();
textBoxProductID.Text = prodObj.fn_getNextProductId();
}
