protected void GetProductPriceListByProductGroup(string productGroupId)
{
ProductPriceBLL productPrice = new ProductPriceBLL();
try
{
DataTable dt = productPrice.GetProductPriceListByProductGroup(productGroupId);
productPriceListGridView.DataSource = dt;
productPriceListGridView.DataBind();
for (int i = 0; i < productPriceListGridView.Rows.Count; i++)
{
TextBox newPriceTextBox = (TextBox)productPriceListGridView.Rows[i].Cells[5].FindControl("newPriceTextBox");
TextBox newVATPercentageTextBox = (TextBox)productPriceListGridView.Rows[i].Cells[7].FindControl("newVATPercentageTextBox");
newPriceTextBox.Text = dt.Rows[i]["RatePerUnit"].ToString();
newVATPercentageTextBox.Text = dt.Rows[i]["VATPercentage"].ToString();
}
if (productPriceListGridView.Rows.Count > 0)
{
productPriceListGridView.UseAccessibleHeader = true;
productPriceListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
updateButton.Visible = true;
}
else
{
updateButton.Visible = false;
msgbox.Visible = true; msgTitleLabel.Text = "No price list is found for the selected product group."; msgDetailLabel.Text = "";
msgbox.Attributes.Add("class", "alert alert-warning");
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
productPrice = null;
MyAlertBox("MyOverlayStop();");
}
}
protected void GetOverallVATPercentage()
{
ProductPriceBLL productPrice = new ProductPriceBLL();
try
{
DataTable dt = productPrice.GetOverallProductVAT();
vatTextBox.Text = dt.Rows[0][0].ToString();
vatTextBox.ReadOnly = true;
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
productPrice = null;
MyAlertBox("MyOverlayStop();");
}
}
protected void updateAVGvatButton_Click(object sender, EventArgs e)
{
ProductPriceBLL productPrice = new ProductPriceBLL();
try
{
if (overallVATTextBox.Text.Trim() == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Overall VAT(%) field is required.";
}
else
{
productPrice.UpdateOverallProductVAT(overallVATTextBox.Text.Trim());
string message = "Overall VAT(%) <span class='actionTopic'>Updated</span> Successfully.";
MyAlertBox("SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");");
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
productPrice = null;
MyAlertBox("MyOverlayStop();");
}
}
protected void updateButton_Click(object sender, EventArgs e)
{
string msg = string.Empty;
List<ProductPriceBLL> productPrices = new List<ProductPriceBLL>();
ProductPriceBLL productPrice;
decimal newRate = 0;
decimal newUnitPrice = 0;
float newVAT = 0;
CheckBox selectCheckBox;
TextBox newPriceTextBox;
TextBox newUnitPriceTextBox;
TextBox newVATPercentageTextBox;
int i = 0;
try
{
for (i = 0; i < productPriceListGridView.Rows.Count; i++)
{
selectCheckBox = (CheckBox)productPriceListGridView.Rows[i].Cells[7].FindControl("selectCheckBox");
newUnitPriceTextBox = (TextBox)productPriceListGridView.Rows[i].Cells[4].FindControl("lastUnitTextBox");
newPriceTextBox = (TextBox)productPriceListGridView.Rows[i].Cells[5].FindControl("newPriceTextBox");
newVATPercentageTextBox = (TextBox)productPriceListGridView.Rows[i].Cells[6].FindControl("newVATPercentageTextBox");
if (selectCheckBox.Checked && string.IsNullOrEmpty(newPriceTextBox.Text.Trim()))
{
msg = "Product ID [" + productPriceListGridView.Rows[i].Cells[0].Text.ToString() + "] has no price to update new price.";
msgbox.Visible = true; msgTitleLabel.Text = "Warning!!!"; msgDetailLabel.Text = msg;
return;
}
else if (selectCheckBox.Checked && string.IsNullOrEmpty(newVATPercentageTextBox.Text.Trim()))
{
msg = "Product ID [" + productPriceListGridView.Rows[i].Cells[0].Text.ToString() + "] has no Discount(%) to update Discount VAT(%).";
msgbox.Visible = true; msgTitleLabel.Text = "Warning!!!"; msgDetailLabel.Text = msg;
return;
}
else if (selectCheckBox.Checked)
{
newUnitPrice = decimal.Parse(newUnitPriceTextBox.Text.Trim());
newRate = decimal.Parse(newPriceTextBox.Text.Trim());
newVAT = float.Parse(newVATPercentageTextBox.Text.Trim());
productPrice = new ProductPriceBLL();
productPrice.ProductId = productPriceListGridView.Rows[i].Cells[0].Text.ToString();
productPrice.RatePerUnit = newRate;
productPrice.VATPercentage = newVAT;
productPrice.NewUnitPrice = newUnitPrice;
productPrices.Add(productPrice);
}
}
if (productPrices.Count > 0)
{
productPrice = new ProductPriceBLL();
productPrice.UpdateProductPriceList(productPrices);
string message = "Product Price(s) & Discount(%) <span class='actionTopic'>Updated</span> Successfully.";
MyAlertBox("var callbackOk = function () { $('#allProductListButton').click(); }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");
}
else if (string.IsNullOrEmpty(msg))
{
msgbox.Visible = true; msgTitleLabel.Text = "Warning!!!"; msgDetailLabel.Text = "No Product is selected to update product price.";
}
}
catch (Exception ex)
{
if (ex.Message == "Input string was not in a correct format.")
{
msg = "Product ID [" + productPriceListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid price or VAT(%) to update new price.";
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg;
}
else
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
}
finally
{
productPrice = null;
MyAlertBox("MyOverlayStop();");
}
}
