protected void BTNLOGINFORM_Click(object sender, EventArgs e)
{
try
{
DataSet DS = new DataSet();
DMAuthorisedPurchaseOrder DMPO = new DMAuthorisedPurchaseOrder();
DS = DMPO.GETACCESS(Convert.ToInt32(Session["UserId"]), TXTPASSWORDFORM.Text.Trim(), out StrError);
if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
{
Response.Redirect("~/Transactions/EditAuthPurchaseOrder.aspx");
Panel1.Visible = false;
}
else
{
obj_Comman.ShowPopUpMsg("Password Not Match......Please Try Again!", this.Page);
}
}
catch (ThreadAbortException)
{
}
catch (Exception ex) { obj_Comman.ShowPopUpMsg(ex.Message + " --> THIS ERROR OCCURED WHILE UPDATING DATA.", this.Page); }
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
int InsertRowDtls = 0, iUpdate = 0;
if (ddlCompany.SelectedValue != "0")
{
Entity_PurchaseOrder.POId = Convert.ToInt32(ddlpono.SelectedValue.ToString());
Entity_PurchaseOrder.PODate = Convert.ToDateTime(txtpodate.Text.ToString());
Entity_PurchaseOrder.SubTotal = txtSubTotal.Text.Equals("") ? 0 : Convert.ToDecimal(txtSubTotal.Text);
Entity_PurchaseOrder.Discount = txtDiscount.Text.Equals("") ? 0 : Convert.ToDecimal(txtDiscount.Text);
Entity_PurchaseOrder.Vat = txtVATAmount.Text.Equals("") ? 0 : Convert.ToDecimal(txtVATAmount.Text);
Entity_PurchaseOrder.GrandTotal = txtGrandTotal.Text.Equals("") ? 0 : Convert.ToDecimal(txtGrandTotal.Text);
Entity_PurchaseOrder.HamaliAmt = txtHamaliAmt.Text.Equals("") ? 0 : Convert.ToDecimal(txtHamaliAmt.Text);
Entity_PurchaseOrder.FreightAmt = txtFreightAmt.Text.Equals("") ? 0 : Convert.ToDecimal(txtFreightAmt.Text);
Entity_PurchaseOrder.PostageAmt = txtPostageAmt.Text.Equals("") ? 0 : Convert.ToDecimal(txtPostageAmt.Text);
Entity_PurchaseOrder.OtherCharges = txtOtherCharges.Text.Equals("") ? 0 : Convert.ToDecimal(txtOtherCharges.Text);
Entity_PurchaseOrder.ServiceTaxPer = Convert.ToDecimal(DDLSERVICETAX.SelectedItem.ToString());
Entity_PurchaseOrder.ServiceTaxAmt = Convert.ToDecimal(txtSerTax.Text.ToString());
Entity_PurchaseOrder.CompanyID = Convert.ToInt32(ddlCompany.SelectedValue.ToString());
Entity_PurchaseOrder.Instruction = txtNarration.Text.Trim();
Entity_PurchaseOrder.UserId = Convert.ToInt32(Session["UserId"]);
Entity_PurchaseOrder.LoginDate = DateTime.Now;
Entity_PurchaseOrder.POQTDATE = Convert.ToDateTime(txtquotdate.Text.ToString()).ToString();
Entity_PurchaseOrder.ExcisePer = Convert.ToDecimal(txtexcisedutyper.Text.ToString());
Entity_PurchaseOrder.ExciseAmount = Convert.ToDecimal(txtexciseduty.Text.ToString());
if (CHKHAMALI.Checked == true)
{
Entity_PurchaseOrder.HamaliActual = 1;
}
if (CHKHAMALI.Checked == false)
{
Entity_PurchaseOrder.HamaliActual = 0;
}
if (CHKFreightAmt.Checked == true)
{
Entity_PurchaseOrder.FreightActual = 1;
}
if (CHKFreightAmt.Checked == false)
{
Entity_PurchaseOrder.FreightActual = 0;
}
if (CHKOtherCharges.Checked == true)
{
Entity_PurchaseOrder.OtherChargeActual = 1;
}
if (CHKOtherCharges.Checked == false)
{
Entity_PurchaseOrder.OtherChargeActual = 0;
}
if (CHKLoading.Checked == true)
{
Entity_PurchaseOrder.LoadingActual = 1;
}
if (CHKLoading.Checked == false)
{
Entity_PurchaseOrder.LoadingActual = 0;
}
iUpdate = Obj_PurchaseOrder.UpdateRecord(ref Entity_PurchaseOrder, out StrError);
if (iUpdate > 0)
{
if (ViewState["POCurrentTable"] != null)
{
DataTable dttable = new DataTable();
dttable = (DataTable)ViewState["POCurrentTable"];
for (int v = 0; v < GrdReqPO.Rows.Count; v++)
{
DMPurchaseOrder oDMPO = new DMPurchaseOrder();
PurchaseOrder pod = new PurchaseOrder();
pod.POId = Convert.ToInt32(ddlpono.SelectedValue.ToString());
pod.ItemId = Convert.ToInt32(GrdReqPO.Rows[v].Cells[2].Text);
pod.Qty = Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtOrdQty")).Text);
pod.Rate = Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtRate")).Text);
pod.Amount = Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtOrdQty")).Text) * Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtRate")).Text);
pod.TaxPer = Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtPerVAT")).Text);
pod.TaxAmount = Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtVAT")).Text);
pod.DiscPer = Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtPerDISC")).Text);
pod.DiscAmt = Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtDISC")).Text);
pod.NetAmount = ((Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtOrdQty")).Text) * Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtRate")).Text)) - Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtDISC")).Text)) + Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtVAT")).Text);
pod.RequisitionCafeId = Convert.ToInt32(GrdReqPO.Rows[v].Cells[3].Text);
pod.FK_UnitConvDtlsId = Convert.ToInt32(((DropDownList)GrdReqPO.Rows[v].FindControl("GrdddlUOM")).SelectedValue);
pod.MainQty = 0;
pod.RemarkForPO = Convert.ToString(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtRemarkForPO")).Text);
pod.CHKFLAG = (((CheckBox)GrdReqPO.Rows[v].FindControl("GrdReqPO_CHK")).Checked)?1:0;
InsertRowDtls = Obj_PurchaseOrder.Insert_PurchaseOrderDtls(ref pod, Convert.ToInt32(GrdReqPO.Rows[v].Cells[4].Text), out StrError);
oDMPO = null;
pod = null;
}
}
if (InsertRowDtls > 0)
{
DMAuthorisedPurchaseOrder ODMPUR = new DMAuthorisedPurchaseOrder();
PurchaseOrder ENPUR = new PurchaseOrder();
ENPUR.POId = Convert.ToInt32(ddlpono.SelectedValue.ToString());
ENPUR.Title = "";
ENPUR.TermsCondition = Convert.ToString(TXTTERMSCONDITION.Text);
InsertRowDtls = ODMPUR.Update_PurchaseOrderTandC(ref ENPUR, Convert.ToString(TXTPaymentTerms.Text), out StrError);
ODMPUR = null;
ENPUR = null;
}
if (InsertRowDtls != 0)
{
obj_Comman.ShowPopUpMsg("Record Updated Successfully!", this.Page);
int GETUPDATES = Obj_PurchaseOrder.UpdateInsert_PurchseOrder(Convert.ToInt32(ddlpono.SelectedValue.ToString()), out StrError);
//Response.Redirect("~/CrystalPrint/PrintCryRpt.aspx?ID=" + Convert.ToInt32(ddlpono.SelectedValue.ToString()) + "&Flag=CPS&SFlag=Authorised&PDFFlag=PDF&PrintFlag=NO");
MakeEmptyForm();
}
else
{
obj_Comman.ShowPopUpMsg(StrError, this.Page);
}
}
}
else
{
obj_Comman.ShowPopUpMsg("Please select company!", this.Page);
}
}
catch (Exception ex) { obj_Comman.ShowPopUpMsg(ex.Message + " --> THIS ERROR OCCURED WHILE UPDATING DATA.", this.Page); }
}
