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);
}
}
