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