protected void ddlItemName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
CreateAdjustmentVoucherBL bl = new CreateAdjustmentVoucherBL();
ddlSupplier.Enabled = true;
//Bind the Supplier name into the dropdown and price of their item into value
string ItemNumber = ddlItemName.SelectedValue;
ArrayList al = new ArrayList();
al.Add(bl.getSupplier1(ItemNumber));
al.Add(bl.getSupplier2(ItemNumber));
al.Add(bl.getSupplier3(ItemNumber));
//Supplier Name dropdownlist
ddlSupplier.DataTextField = "Supplier1";
ddlSupplier.DataValueField = "Price1";
ddlSupplier.DataSource = al;
ddlSupplier.DataBind();
// Check to bind footable
if (gvInventoryAdjustmentList.Rows.Count != 0)
{
footableSettings();
}
}
catch (Exception x)
{
System.Diagnostics.Debug.WriteLine(x);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
CreateAdjustmentVoucherBL bl = new CreateAdjustmentVoucherBL();
EmployeeBO ebo = (EmployeeBO)Session["employee"];
string empId = ebo.EmployeeId;
double totalPrice = 0;
for (int r = 0; r < gvInventoryAdjustmentList.Rows.Count; r++)
{
Label lbPrice = (Label)gvInventoryAdjustmentList.Rows[r].FindControl("lbPrice");
totalPrice += Convert.ToDouble(lbPrice.Text);
}
if (bl.createAdjustmentVoucher(empId, totalPrice) == true)
{//if the insert for the Adjustment voucher is successful the perform the following
string voucherNum = bl.getAdjustmentVoucherId();
for (int r = 0; r < gvInventoryAdjustmentList.Rows.Count; r++)
{
string getADNum = bl.getAdjustmentDetailsVoucherId();
int calnum = getADNum.Length - 3; //get old primary key
int increADV = Convert.ToInt32(getADNum.Substring(3, calnum)) + 1;
string adNum = "AD0" + increADV.ToString(); //auto increment primary key
System.Diagnostics.Debug.Write(adNum);
Label lbItemNumber = (Label)gvInventoryAdjustmentList.Rows[r].FindControl("lbItemNumber");
bl.createAdjustmentVoucherDetails(adNum, voucherNum, lbItemNumber.Text, Convert.ToInt32(gvInventoryAdjustmentList.Rows[r].Cells[4].Text),
gvInventoryAdjustmentList.Rows[r].Cells[3].Text, gvInventoryAdjustmentList.Rows[r].Cells[6].Text); //insert into database
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Adjustment Voucher created successfully.')", true);
Clear(); //clear session and everything
Response.Redirect("~/Store/AdjustmentVoucherList.aspx");
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Adjustment Voucher not created. Please try again.')", true);
}
//apply the footable settings
footableSettings();
}
catch (Exception x)
{
System.Diagnostics.Debug.WriteLine(x);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
if (Session["employee"] != null)
{
EmployeeBO ebo = (EmployeeBO)Session["employee"];
string empId = ebo.EmployeeId;
string title = ebo.EmployeeTitle;
CreateAdjustmentVoucherBL bl = new CreateAdjustmentVoucherBL();
//Category Control
ddlCategory.DataSource = bl.getDistinctCategory();
ddlCategory.DataBind();
ddlCategory.Items.Insert(0, new ListItem("-Select-", "NA"));
//ItemName Control
ddlItemName.Enabled = false;
ddlItemName.Width = 250;
//Textbox Control
tbUOM.Text = bl.getUOM(ddlCategory.SelectedValue);
int defaultQuantity = 0;
tbQuantity.Text = defaultQuantity.ToString();
//Supplier Control
ddlSupplier.Enabled = false;
ddlSupplier.Width = 200;
btnSubmit.Visible = false;
//Session for GridView
al = new ArrayList(); // initialization for ArrayList
Session["AdjustmentDetails"] = al; // Stores array into Session Object
gvInventoryAdjustmentList.Columns[0].Visible = false; // Hide gridview column
gvInventoryAdjustmentList.Columns[1].Visible = false; // Hide gridview column
}
}
catch (Exception x)
{
System.Diagnostics.Debug.WriteLine(x);
}
}
}
protected void ddlCategory_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
//Instantiate BL Object
CreateAdjustmentVoucherBL bl = new CreateAdjustmentVoucherBL();
//Item Name dropdownlist
ddlItemName.DataTextField = "ItemName";
ddlItemName.DataValueField = "ItemNumber";
ddlItemName.DataSource = bl.getItemListByCategory(ddlCategory.SelectedValue);
ddlItemName.DataBind();
ddlItemName.Enabled = true;
ddlItemName.Items.Insert(0, new ListItem("-Select-", "NA"));
//Unit of Measure Textbox
tbUOM.Text = bl.getUOM(ddlCategory.SelectedValue);
//Clear Controls
if (ddlCategory.SelectedValue.Equals("NA"))
{
tbUOM.Text = String.Empty;
ddlItemName.Enabled = false;
ddlSupplier.Items.Clear();
ddlSupplier.Enabled = false;
tbQuantity.Text = String.Empty;
}
// Check to bind footable
if (gvInventoryAdjustmentList.Rows.Count != 0)
{
footableSettings();
}
}
catch (Exception x)
{
System.Diagnostics.Debug.WriteLine(x);
}
}
