private void StoreNewAndOldInventoryChanges(ItemChangeTracking changeItem, object[] extra, object[] objPageDetails)
{
string strQueryName = "StoreNewAndOldInventoryChanges";
string sqlCmd = "INSERT INTO tbl_itemChangeTracking VALUES(@dtmChangeDate, @dtmChangeTime, @intEmployeeID, @intLocationID, "
+ "@intInventoryID, @fltOriginalCost, @fltNewCost, @fltOriginalPrice, @fltNewPrice, @intOriginalQuantity, "
+ "@intNewQuantity, @varOriginalDescription, @varNewDescription)";
object[][] parms =
{
new object[] { "@dtmChangeDate", DateTime.Now },
new object[] { "@dtmChangeTime", DateTime.Now },
new object[] { "@intEmployeeID", extra[0] },
new object[] { "@intLocationID", extra[1] },
new object[] { "@intInventoryID", changeItem.intInventoryID },
new object[] { "@fltOriginalCost", changeItem.fltOriginalCost },
new object[] { "@fltNewCost", changeItem.fltNewCost },
new object[] { "@fltOriginalPrice", changeItem.fltOriginalPrice },
new object[] { "@fltNewPrice", changeItem.fltNewPrice },
new object[] { "@intOriginalQuantity", changeItem.intOriginalQuantity },
new object[] { "@intNewQuantity", changeItem.intNewQuantity },
new object[] { "@varOriginalDescription", changeItem.varOriginalDescription },
new object[] { "@varNewDescription", changeItem.varNewDescription }
};
DBC.MakeDataBaseCallToNonReturnDataQuery(sqlCmd, parms, objPageDetails, strQueryName);
}
public void SaveInventoryChanges(ItemChangeTracking changeItem, object[] extra, object[] objPageDetails)
{
StoreNewAndOldInventoryChanges(changeItem, extra, objPageDetails);
}
protected void BtnSaveItem_Click(object sender, EventArgs e)
{
//Collects current method for error tracking
string method = "BtnSaveItem_Click";
object[] objPageDetails = { Session["currPage"].ToString(), method };
try
{
txtCost.Enabled = false;
ddlBrand.Enabled = false;
txtPrice.Enabled = false;
txtQuantity.Enabled = false;
ddlLocation.Enabled = false;
txtClubType.Enabled = false;
txtShaft.Enabled = false;
txtComments.Enabled = false;
changeItem = (ItemChangeTracking)Session["changer"];
object o = new object();
if (Convert.ToInt32(ddlType.SelectedValue) == 1)
{
Clubs club = new Clubs
{
//if item type is club then save as club class
intInventoryID = Convert.ToInt32(Request.QueryString["inventory"].ToString()),
fltCost = Convert.ToDouble(txtCost.Text),
intBrandID = Convert.ToInt32(ddlBrand.SelectedValue),
fltPrice = Convert.ToDouble(txtPrice.Text),
intQuantity = Convert.ToInt32(txtQuantity.Text),
intLocationID = Convert.ToInt32(ddlLocation.SelectedValue),
varTypeOfClub = txtClubType.Text,
intModelID = Convert.ToInt32(ddlModel.SelectedValue),
varShaftType = txtShaft.Text,
varNumberOfClubs = txtNumberofClubs.Text,
varClubSpecification = txtClubSpec.Text,
varShaftSpecification = txtShaftSpec.Text,
varShaftFlexability = txtShaftFlex.Text,
varClubDexterity = txtDexterity.Text,
varAdditionalInformation = txtComments.Text,
bitIsUsedProduct = chkUsed.Checked
};
o = club as object;
changeItem.fltNewCost = club.fltCost;
changeItem.fltNewPrice = club.fltPrice;
changeItem.intNewQuantity = club.intQuantity;
changeItem.varNewDescription = "Location ID: " + club.intLocationID.ToString() + "; Brand ID: " + club.intBrandID.ToString() + "; Model ID: "
+ club.intModelID.ToString() + "; Club Type: " + club.varTypeOfClub.ToString() + "; Shaft: " + club.varShaftType.ToString() + "; Number "
+ "of Clubs: " + club.varNumberOfClubs.ToString() + "; Club Spec: " + club.varClubSpecification.ToString() + "; Shaft Spec: "
+ club.varShaftSpecification.ToString() + "; Shaft Flex: " + club.varShaftFlexability.ToString() + "; Dexterity: "
+ club.varClubDexterity.ToString() + "; Used: " + club.bitIsUsedProduct.ToString() + "; Comments: " + club.varAdditionalInformation.ToString();
//changes all text boxes and dropdowns to labels
ddlModel.Enabled = false;
txtNumberofClubs.Enabled = false;
txtClubSpec.Enabled = false;
txtShaftSpec.Enabled = false;
txtShaftFlex.Enabled = false;
txtDexterity.Enabled = false;
chkUsed.Enabled = false;
}
else if (Convert.ToInt32(ddlType.SelectedValue) == 2)
{
Accessories accessory = new Accessories
{
//if item type is accesory then save as accessory class
intInventoryID = Convert.ToInt32(Request.QueryString["inventory"].ToString()),
intBrandID = Convert.ToInt32(ddlBrand.SelectedValue),
fltCost = Convert.ToDouble(txtCost.Text),
fltPrice = Convert.ToDouble(txtPrice.Text),
intQuantity = Convert.ToInt32(txtQuantity.Text),
intLocationID = Convert.ToInt32(ddlLocation.SelectedValue),
varSize = txtNumberofClubs.Text,
varColour = txtShaft.Text,
varTypeOfAccessory = txtClubType.Text,
intModelID = Convert.ToInt32(ddlModel.SelectedValue),
varAdditionalInformation = txtComments.Text
};
o = accessory as object;
changeItem.fltNewCost = accessory.fltCost;
changeItem.fltNewPrice = accessory.fltPrice;
changeItem.intNewQuantity = accessory.intQuantity;
changeItem.varNewDescription = "Location ID: " + accessory.intLocationID.ToString() + "; Brand ID: " + accessory.intBrandID.ToString() + "; Model ID: "
+ accessory.intModelID.ToString() + "; Size: " + accessory.varSize.ToString() + "; Colour: " + accessory.varColour.ToString() + "; Accessory Type: "
+ accessory.varTypeOfAccessory.ToString() + "; Comments: " + accessory.varAdditionalInformation.ToString();
//changes all text boxes and dropdowns to labels
ddlModel.Enabled = false;
txtNumberofClubs.Enabled = false;
}
else if (Convert.ToInt32(ddlType.SelectedValue) == 3)
{
Clothing clothing = new Clothing
{
//if item type is clothing then save as clothing class
intInventoryID = Convert.ToInt32(Request.QueryString["inventory"].ToString()),
intBrandID = Convert.ToInt32(ddlBrand.SelectedValue),
fltCost = Convert.ToDouble(txtCost.Text),
fltPrice = Convert.ToDouble(txtPrice.Text),
intQuantity = Convert.ToInt32(txtQuantity.Text),
intLocationID = Convert.ToInt32(ddlLocation.SelectedValue),
varSize = txtNumberofClubs.Text,
varColour = txtShaft.Text,
varGender = txtClubSpec.Text,
varStyle = txtClubType.Text,
varAdditionalInformation = txtComments.Text
};
o = clothing as object;
changeItem.fltNewCost = clothing.fltCost;
changeItem.fltNewPrice = clothing.fltPrice;
changeItem.intNewQuantity = clothing.intQuantity;
changeItem.varNewDescription = "Location ID: " + clothing.intLocationID.ToString() + "; Brand ID: " + clothing.intBrandID.ToString() + "; Size: "
+ clothing.varSize.ToString() + "; Colour: " + clothing.varColour.ToString() + "; Gender: " + clothing.varGender.ToString() + "; Style: "
+ clothing.varStyle.ToString() + "; Comments: " + clothing.varAdditionalInformation.ToString();
//changes all text boxes and dropdowns to labels
txtClubSpec.Enabled = false;
txtNumberofClubs.Enabled = false;
}
//hides and displays the proper buttons for access
BtnSaveItem.Visible = false;
BtnEditItem.Visible = true;
pnlDefaultButton.DefaultButton = "btnEditItem";
BtnCancel.Visible = false;
BtnAddItem.Visible = false;
BtnBackToSearch.Visible = true;
BtnCreateSimilar.Visible = true;
object[] extra = { CU.employee.intEmployeeID, CU.location.intLocationID };
IDU.SaveInventoryChanges(changeItem, extra, objPageDetails);
var nameValues = HttpUtility.ParseQueryString(Request.QueryString.ToString());
nameValues.Set("inventory", IDU.UpdateItemInDatabase(o, objPageDetails).ToString());
//Refreshes current page
Response.Redirect(Request.Url.AbsolutePath + "?" + nameValues, false);
}
//Exception catch
catch (ThreadAbortException tae) { }
catch (Exception ex)
{
//Log all info into error table
ER.CallLogError(ex, CU.employee.intEmployeeID, Convert.ToString(Session["currPage"]) + "-V3.2", method, this);
//Display message box
MessageBoxCustom.ShowMessage("An Error has occurred and been logged. "
+ "If you continue to receive this message please contact "
+ "your system administrator.", this);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Collects current method and page for error tracking
string method = "Page_Load";
Session["currPage"] = "InventoryAddNew.aspx";
object[] objPageDetails = { Session["currPage"].ToString(), method };
try
{
//checks if the user has logged in
if (Session["currentUser"] == null)
{
//Go back to Login to log in
Response.Redirect("LoginPage.aspx", false);
}
else
{
CU = (CurrentUser)Session["currentUser"];
if (CU.employee.intJobID != 0)
{
//If user is not an admin then disable the edit item button
BtnEditItem.Enabled = false;
}
//Check to see if an item was selected
if (Convert.ToInt32(Request.QueryString["inventory"].ToString()) != -10)
{
if (!IsPostBack)
{
ItemChangeTracking tempItem = new ItemChangeTracking();
//Grabs a list of objects that match the sku in query string. There should only ever be 1 that is returned
List <Object> o = IDU.CallReturnListOfObjectsFromThreeTablesForInventoryAddNew(Convert.ToInt32(Request.QueryString["inventory"].ToString()), objPageDetails, DateTime.Now, CU.location.intProvinceID);
ddlBrand.DataSource = IM.CallReturnDropDownForBrand(objPageDetails);
ddlBrand.DataBind();
ddlLocation.DataSource = LM.CallReturnLocationDropDown(objPageDetails);
ddlLocation.DataBind();
ddlType.DataSource = IM.CallReturnDropDownForItemType(objPageDetails);
ddlType.DataBind();
ddlModel.DataSource = IM.CallReturnDropDownForModel(objPageDetails);
ddlModel.DataBind();
if (o[0] is Clubs)
{
//When a club, pass class and populate DropDowns and TextBoxes
Clubs club = o[0] as Clubs;
ddlType.SelectedValue = club.intItemTypeID.ToString();
lblSKUDisplay.Text = club.varSku.ToString();
txtCost.Text = club.fltCost.ToString();
ddlBrand.SelectedValue = club.intBrandID.ToString();
txtPrice.Text = club.fltPrice.ToString();
txtQuantity.Text = club.intQuantity.ToString();
ddlLocation.SelectedValue = club.intLocationID.ToString();
txtClubType.Text = club.varTypeOfClub.ToString();
ddlModel.SelectedValue = club.intModelID.ToString();
txtShaft.Text = club.varShaftType.ToString();
txtNumberofClubs.Text = club.varNumberOfClubs.ToString();
txtClubSpec.Text = club.varClubSpecification.ToString();
txtShaftSpec.Text = club.varShaftSpecification.ToString();
txtShaftFlex.Text = club.varShaftFlexability.ToString();
txtDexterity.Text = club.varClubDexterity.ToString();
chkUsed.Checked = club.bitIsUsedProduct;
txtComments.Text = club.varAdditionalInformation.ToString();
GrdInventoryTaxes.DataSource = club.lstTaxTypePerInventoryItem;
GrdInventoryTaxes.DataBind();
tempItem.intInventoryID = club.intInventoryID;
tempItem.fltOriginalCost = club.fltCost;
tempItem.fltOriginalPrice = club.fltPrice;
tempItem.intOriginalQuantity = club.intQuantity;
tempItem.varOriginalDescription = "Location ID: " + club.intLocationID.ToString() + "; Brand ID: " + club.intBrandID.ToString()
+ "; Model ID: " + club.intModelID.ToString() + "; Club Type: " + club.varTypeOfClub.ToString() + "; Shaft: " + club.varShaftType.ToString()
+ "; Number of Clubs: " + club.varNumberOfClubs.ToString() + "; Club Spec: " + club.varClubSpecification.ToString() + "; Shaft Spec: "
+ club.varShaftSpecification.ToString() + "; Shaft Flex: " + club.varShaftFlexability.ToString() + "; Dexterity: " + club.varClubDexterity.ToString()
+ "; Used: " + club.bitIsUsedProduct.ToString() + "; Comments: " + club.varAdditionalInformation.ToString();
}
else if (o[0] is Accessories)
{
//When accessories, pass class and populate DropDowns and TextBoxes
Accessories accessory = o[0] as Accessories;
ddlType.SelectedValue = accessory.intItemTypeID.ToString();
lblSKUDisplay.Text = accessory.varSku.ToString();
txtCost.Text = accessory.fltCost.ToString();
ddlBrand.SelectedValue = accessory.intBrandID.ToString();
txtPrice.Text = accessory.fltPrice.ToString();
txtQuantity.Text = accessory.intQuantity.ToString();
ddlLocation.SelectedValue = accessory.intLocationID.ToString();
lblClubType.Text = "Accessory Type:";
txtClubType.Text = accessory.varTypeOfAccessory.ToString();
lblNumberofClubs.Text = "Size:";
txtNumberofClubs.Text = accessory.varSize.ToString();
ddlModel.SelectedValue = accessory.intModelID.ToString();
lblShaft.Text = "Colour:";
txtShaft.Text = accessory.varColour.ToString();
txtComments.Text = accessory.varAdditionalInformation.ToString();
lblClubSpec.Visible = false;
txtClubSpec.Visible = false;
lblShaftSpec.Visible = false;
txtShaftSpec.Visible = false;
lblShaftFlex.Visible = false;
txtShaftFlex.Visible = false;
lblDexterity.Visible = false;
txtDexterity.Visible = false;
chkUsed.Visible = false;
GrdInventoryTaxes.DataSource = accessory.lstTaxTypePerInventoryItem;
GrdInventoryTaxes.DataBind();
tempItem.intInventoryID = accessory.intInventoryID;
tempItem.fltOriginalCost = accessory.fltCost;
tempItem.fltOriginalPrice = accessory.fltPrice;
tempItem.intOriginalQuantity = accessory.intQuantity;
tempItem.varOriginalDescription = "Location ID: " + accessory.intLocationID.ToString() + "; Brand ID: " + accessory.intBrandID.ToString()
+ "; Model ID: " + accessory.intModelID.ToString() + "; Size: " + accessory.varSize.ToString() + "; Colour: " + accessory.varColour.ToString()
+ "; Accessory Type: " + accessory.varTypeOfAccessory.ToString() + "; Comments: " + accessory.varAdditionalInformation.ToString();
}
else if (o[0] is Clothing)
{
//When clothing, pass class and populate DropDowns and TextBoxes
Clothing clothing = o[0] as Clothing;
ddlType.SelectedValue = clothing.intItemTypeID.ToString();
lblSKUDisplay.Text = clothing.varSku.ToString();
txtCost.Text = clothing.fltCost.ToString();
ddlBrand.SelectedValue = clothing.intBrandID.ToString();
txtPrice.Text = clothing.fltPrice.ToString();
txtQuantity.Text = clothing.intQuantity.ToString();
ddlLocation.SelectedValue = clothing.intLocationID.ToString();
txtComments.Text = clothing.varAdditionalInformation.ToString();
lblNumberofClubs.Text = "Size:";
txtNumberofClubs.Text = clothing.varSize.ToString();
lblModel.Visible = false;
ddlModel.Visible = false;
lblShaft.Text = "Colour:";
txtShaft.Text = clothing.varColour.ToString();
lblShaftFlex.Visible = false;
txtShaftFlex.Visible = false;
lblClubSpec.Text = "Gender:";
txtClubSpec.Text = clothing.varGender.ToString();
lblClubType.Text = "Style:";
txtClubType.Text = clothing.varStyle.ToString();
lblShaftSpec.Visible = false;
txtShaftSpec.Visible = false;
lblDexterity.Visible = false;
txtDexterity.Visible = false;
chkUsed.Visible = false;
GrdInventoryTaxes.DataSource = clothing.lstTaxTypePerInventoryItem;
GrdInventoryTaxes.DataBind();
tempItem.intInventoryID = clothing.intInventoryID;
tempItem.fltOriginalCost = clothing.fltCost;
tempItem.fltOriginalPrice = clothing.fltPrice;
tempItem.intOriginalQuantity = clothing.intQuantity;
tempItem.varOriginalDescription = "Location ID: " + clothing.intLocationID.ToString() + "; Brand ID: " + clothing.intBrandID.ToString()
+ "; Size: " + clothing.varSize.ToString() + "; Colour: " + clothing.varColour.ToString() + "; Gender: " + clothing.varGender.ToString()
+ "; Style: " + clothing.varStyle.ToString() + "; Comments: " + clothing.varAdditionalInformation.ToString();
}
BtnCreateSimilar.Visible = true;
changeItem = tempItem;
Session["changer"] = changeItem;
}
}
else
{
//When no item was selected display drop downs and text boxes
ddlType.Enabled = true;
txtCost.Enabled = true;
ddlBrand.Enabled = true;
txtPrice.Enabled = true;
txtQuantity.Enabled = true;
ddlLocation.Enabled = true;
txtClubType.Enabled = true;
txtShaft.Enabled = true;
txtComments.Enabled = true;
BtnCreateSimilar.Visible = false;
if (!IsPostBack)
{
ddlBrand.DataSource = IM.CallReturnDropDownForBrand(objPageDetails);
ddlBrand.DataBind();
ddlLocation.DataSource = LM.CallReturnLocationDropDown(objPageDetails);
ddlLocation.DataBind();
ddlType.DataSource = IM.CallReturnDropDownForItemType(objPageDetails);
ddlType.DataBind();
ddlModel.DataSource = IM.CallReturnDropDownForModel(objPageDetails);
ddlModel.DataBind();
ddlLocation.SelectedValue = CU.location.intLocationID.ToString();
ddlType.SelectedValue = "1";
ddlModel.Enabled = true;
txtNumberofClubs.Enabled = true;
txtClubSpec.Enabled = true;
txtShaftSpec.Enabled = true;
txtShaftFlex.Enabled = true;
txtDexterity.Enabled = true;
chkUsed.Enabled = true;
}
else
{
//Clubs
if (Convert.ToInt32(ddlType.SelectedValue) == 1)
{
//adjust labels displaying for clubs
lblClubType.Text = "Club Type:";
lblModel.Visible = true;
ddlModel.Visible = true;
ddlModel.Enabled = true;
lblShaft.Text = "Shaft:";
lblNumberofClubs.Text = "Number of Clubs:";
lblNumberofClubs.Visible = true;
txtNumberofClubs.Visible = true;
txtNumberofClubs.Enabled = true;
lblClubSpec.Text = "Club Spec:";
lblClubSpec.Visible = true;
txtClubSpec.Visible = true;
txtClubSpec.Enabled = true;
lblShaftSpec.Visible = true;
txtShaftSpec.Visible = true;
txtShaftSpec.Enabled = true;
lblShaftFlex.Text = "Shaft Flex:";
lblShaftFlex.Visible = true;
txtShaftFlex.Visible = true;
txtShaftFlex.Enabled = true;
lblDexterity.Visible = true;
txtDexterity.Visible = true;
txtDexterity.Enabled = true;
chkUsed.Visible = true;
chkUsed.Enabled = true;
}
//Accessories
else if (Convert.ToInt32(ddlType.SelectedValue) == 2)
{
//adjust labels displaying for accessories
lblNumberofClubs.Text = "Size:";
lblModel.Visible = true;
ddlModel.Visible = true;
ddlModel.Enabled = true;
lblShaft.Text = "Colour:";
lblClubType.Text = "Accessory Type:";
lblNumberofClubs.Visible = true;
txtNumberofClubs.Visible = true;
txtNumberofClubs.Enabled = true;
lblClubSpec.Visible = false;
txtClubSpec.Visible = false;
txtClubSpec.Enabled = false;
lblShaftSpec.Visible = false;
txtShaftSpec.Visible = false;
txtShaftSpec.Enabled = false;
lblShaftFlex.Visible = false;
txtShaftFlex.Visible = false;
txtShaftFlex.Enabled = false;
lblDexterity.Visible = false;
txtDexterity.Visible = false;
txtDexterity.Enabled = false;
chkUsed.Visible = false;
chkUsed.Enabled = false;
}
//Clothing
else if (Convert.ToInt32(ddlType.SelectedValue) == 3)
{
//adjust labels displaying for clubs
lblNumberofClubs.Text = "Size:";
lblModel.Visible = false;
ddlModel.Visible = false;
ddlModel.Enabled = false;
lblShaft.Text = "Colour:";
lblNumberofClubs.Visible = true;
txtNumberofClubs.Visible = true;
txtNumberofClubs.Enabled = true;
lblClubSpec.Text = "Gender:";
lblClubSpec.Visible = true;
txtClubSpec.Visible = true;
txtClubSpec.Enabled = true;
lblShaftSpec.Visible = false;
txtShaftSpec.Visible = false;
txtShaftSpec.Enabled = false;
lblClubType.Text = "Style:";
lblShaftFlex.Visible = false;
txtShaftFlex.Visible = false;
txtShaftFlex.Enabled = false;
lblDexterity.Visible = false;
txtDexterity.Visible = false;
txtDexterity.Enabled = false;
chkUsed.Visible = false;
chkUsed.Enabled = false;
}
}
//hides and displays the proper buttons for access
BtnSaveItem.Visible = false;
BtnAddItem.Visible = true;
pnlDefaultButton.DefaultButton = "btnAddItem";
BtnEditItem.Visible = false;
BtnCancel.Visible = false;
BtnBackToSearch.Visible = true;
}
}
}
//Exception catch
catch (ThreadAbortException tae) { }
catch (Exception ex)
{
//Log all info into error table
ER.CallLogError(ex, CU.employee.intEmployeeID, Convert.ToString(Session["currPage"]) + "-V3.2", method, this);
//Display message box
MessageBoxCustom.ShowMessage("An Error has occurred and been logged. "
+ "If you continue to receive this message please contact "
+ "your system administrator.", this);
}
}
