public void ddlCompanyBind() { LOV_COLLECTION lov = new LOV_COLLECTION(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); ds = lov.Get_Company_setup_lov("%", "%"); if (ds.Tables[0].Rows.Count > 0) { ((DropDownList)FormView1.FindControl("ddlCompanyCode")).DataSource = ds; ((DropDownList)FormView1.FindControl("ddlCompanyCode")).DataValueField = "Company_Code"; ((DropDownList)FormView1.FindControl("ddlCompanyCode")).DataTextField = "Company_Name"; ((DropDownList)FormView1.FindControl("ddlCompanyCode")).DataBind(); dt = ds.Tables[0]; ViewState["COMPANYDATATABLE"] = dt; Get_CompanyBal(); } else { DataTable dt1 = new DataTable(); DataRow DR = null; dt1.Columns.Add("Company_Code"); dt1.Columns.Add("Company_Name"); DR = dt1.NewRow(); DR[0] = "Company not found"; DR[1] = "Company not found"; dt1.Rows.Add(DR); ((DropDownList)FormView1.FindControl("ddlCompanyCode")).DataSource = dt1; ((DropDownList)FormView1.FindControl("ddlCompanyCode")).DataValueField = "Company_Code"; ((DropDownList)FormView1.FindControl("ddlCompanyCode")).DataTextField = "Company_Name"; ((DropDownList)FormView1.FindControl("ddlCompanyCode")).DataBind(); ViewState["COMPANYDATATABLE"] = ""; } }
protected void CMD_AUTHORIZE_Click(object sender, EventArgs e) { LOV_COLLECTION L = new LOV_COLLECTION(); DataSet DS; DS = L.SP_AuthorizeRecord("SPDS_InstrumentSetup", Session["U_NAME"].ToString(), DateTime.Now.ToString("MM-dd-yyyy"), Session["SPDS_InstrumentSetup_ID"].ToString()); Response.Redirect("../InstrumentSetup/frmSPDS_InstrumentSetupSPC.aspx" + "?" + "s1=" + Request.QueryString[0].ToString()); }
protected void EditToolbar_ItemClick(object sender, EO.Web.ToolBarEventArgs e) { Page.Validate(); if (e.Item.ToolTip == "Update") { if (Page.IsValid) { LOV_COLLECTION L = new LOV_COLLECTION(); DataSet DS; DS = L.SP_AuthorizationMatrix_DP (((TextBox)FormView1.FindControl("TXT_CUSTOMER_ID_EDIT")).Text, ///((TextBox)FormView1.FindControl("TXT_INSTRUMENT_ID_EDIT")).Text, "123", ((TextBox)FormView1.FindControl("TXT_MAKE_SIGNATORY_ID_EDIT")).Text, ((TextBox)FormView1.FindControl("TXT_CHECKER_SIGNATORY_ID_EDIT")).Text, ((TextBox)FormView1.FindControl("TXT_CATEGORY_ID_EDIT")).Text, Session["SPDS_AuthorizationMatrix_ID"].ToString()); if (DS.Tables[0].Rows.Count > 0) { ((Label)FormView1.FindControl("lblDuplicate_EDIT")).Text = "Duplicate Record"; } else { if (DS.Tables[0].Rows.Count <= 0) { P_SPDS_AuthorizationMatrix.RecordInputStart(); P_SPDS_AuthorizationMatrix.Get_ID = Session["SPDS_AuthorizationMatrix_ID"].ToString(); P_SPDS_AuthorizationMatrix.Get_CUSTOMER_ID = ((TextBox)FormView1.FindControl("TXT_CUSTOMER_ID_EDIT")).Text; P_SPDS_AuthorizationMatrix.Get_INSTRUMENT_ID = "123";///((TextBox)FormView1.FindControl("TXT_INSTRUMENT_ID_EDIT")).Text; P_SPDS_AuthorizationMatrix.Get_MAKE_SIGNATORY_ID = ((TextBox)FormView1.FindControl("TXT_MAKE_SIGNATORY_ID_EDIT")).Text; P_SPDS_AuthorizationMatrix.Get_CHECKER_SIGNATORY_ID = ((TextBox)FormView1.FindControl("TXT_CHECKER_SIGNATORY_ID_EDIT")).Text; P_SPDS_AuthorizationMatrix.Get_CATEGORY_ID = ((TextBox)FormView1.FindControl("TXT_CATEGORY_ID_EDIT")).Text; P_SPDS_AuthorizationMatrix.Get_A_UserID = Session["U_NAME"].ToString(); P_SPDS_AuthorizationMatrix.Get_A_DateTime = DateTime.Now.ToString("dd-MMM-yyyy").ToString(); P_SPDS_AuthorizationMatrix.Get_E_UserID = Session["U_NAME"].ToString();//((TextBox)FormView1.FindControl("TXT_E_UserID_EDIT")).Text; P_SPDS_AuthorizationMatrix.Get_E_DateTime = DateTime.Now.ToString("dd-MMM-yyyy").ToString(); P_SPDS_AuthorizationMatrix.RecordInputCommit(); P_SPDS_AuthorizationMatrix.EditNewGroup(); BackPage(); } else { ((TextBox)FormView1.FindControl("TXT_CUSTOMER_ID_EDIT")).Text = ""; ((TextBox)FormView1.FindControl("TXT_INSTRUMENT_ID_EDIT")).Text = ""; ((TextBox)FormView1.FindControl("TXT_MAKE_SIGNATORY_ID_EDIT")).Text = ""; ((TextBox)FormView1.FindControl("TXT_CHECKER_SIGNATORY_ID_EDIT")).Text = ""; ((TextBox)FormView1.FindControl("TXT_CATEGORY_ID_EDIT")).Text = ""; ((RequiredFieldValidator)FormView1.FindControl("REQ_CUSTOMER_ID_EDIT")).Validate(); } } } } else if (e.Item.ToolTip == "Cancel") { BackPage(); } }
protected void InsertToolbar_ItemClick(object sender, EO.Web.ToolBarEventArgs e) { Page.Validate(); if (e.Item.ToolTip == "Insert") { if (Page.IsValid) { LOV_COLLECTION L = new LOV_COLLECTION(); DataSet DS; DS = L.SP_AuthorizationMatrix_DP (Convert.ToString(CustomerID), Convert.ToString(InstrumentID), Convert.ToString(MakerSignatoryID), Convert.ToString(CheckerSignatoryID), Convert.ToString(CategoryID), "0"); if (DS.Tables[0].Rows.Count > 0) { ((Label)FormView1.FindControl("lblDuplicate_INSERT")).Text = "Duplicate Record"; } else { if (DS.Tables[0].Rows.Count <= 0) { P_SPDS_AuthorizationMatrix.RecordInputStart(); P_SPDS_AuthorizationMatrix.Get_ID = "0"; P_SPDS_AuthorizationMatrix.Get_CUSTOMER_ID = CustomerID; P_SPDS_AuthorizationMatrix.Get_INSTRUMENT_ID = InstrumentID; P_SPDS_AuthorizationMatrix.Get_MAKE_SIGNATORY_ID = MakerSignatoryID; P_SPDS_AuthorizationMatrix.Get_CHECKER_SIGNATORY_ID = CheckerSignatoryID; P_SPDS_AuthorizationMatrix.Get_CATEGORY_ID = CategoryID; P_SPDS_AuthorizationMatrix.Get_A_UserID = Session["U_NAME"].ToString();//((TextBox)FormView1.FindControl("TXT_A_UserID_INSERT")).Text; P_SPDS_AuthorizationMatrix.Get_A_DateTime = DateTime.Now.ToString("dd-MMM-yyyy").ToString(); P_SPDS_AuthorizationMatrix.Get_E_UserID = Session["U_NAME"].ToString(); P_SPDS_AuthorizationMatrix.Get_E_DateTime = DateTime.Now.ToString("dd-MMM-yyyy").ToString(); P_SPDS_AuthorizationMatrix.RecordInputCommit(); P_SPDS_AuthorizationMatrix.AddNewGroup(); BackPage(); } else { ((TextBox)FormView1.FindControl("TXT_CUSTOMER_ID_INSERT")).Text = ""; ((TextBox)FormView1.FindControl("TXT_INSTRUMENT_ID_INSERT")).Text = ""; ((TextBox)FormView1.FindControl("TXT_MAKE_SIGNATORY_ID_INSERT")).Text = ""; ((TextBox)FormView1.FindControl("TXT_CHECKER_SIGNATORY_ID_INSERT")).Text = ""; ((TextBox)FormView1.FindControl("TXT_CATEGORY_ID_INSERT")).Text = ""; ((RequiredFieldValidator)FormView1.FindControl("REQ_CUSTOMER_ID_INSERT")).Validate(); } } } } else if (e.Item.ToolTip == "Cancel") { BackPage(); } }
public DataSet Add(List <CBFileDataCommand> fileDataCmdList, string fileName, string userId, int correspondingBankId) { DataSet dst = new DataSet(); LOV_COLLECTION lov = new LOV_COLLECTION(); dst = lov.Get_RPS_SP_CorrespondingBankFile_Add(0, correspondingBankId, fileName, DateTime.Now, userId, DateTime.Now, "", DateTime.MinValue); dst = Get_RPS_SP_CorrespondingBankFilesId(); foreach (CBFileDataCommand cmd in fileDataCmdList) { lov.Get_RPS_SP_CorrespondingBankFileData_Add(cmd.Id, Convert.ToInt32(dst.Tables[0].Rows[0][0].ToString()), cmd.CorrespondingBankUniqueId, cmd.ProcessingDate, cmd.DraftNo, cmd.DraftPaidDate, cmd.BeneficiaryName, cmd.Amount, cmd.ProcessingRemarks, cmd.BranchCode, cmd.Charges, cmd.Remarks, cmd.Type, cmd.TEZStatus, cmd.TCSNo, cmd.DispatchDate, cmd.DeliveryDate, cmd.RecievedBy, cmd.A_UserId, cmd.A_DateTime, cmd.E_UserId, cmd.E_DateTime); } return(dst); }
protected void DisplayToolBar_ItemClick(object sender, EO.Web.ToolBarEventArgs e) { if (e.Item.ToolTip == "Edit") { FormView1.ChangeMode(FormViewMode.Edit); } else if (e.Item.ToolTip == "Cancel") { BackPage(); } else if (e.Item.ToolTip == "Authorize / Unauthorize") { LOV_COLLECTION L = new LOV_COLLECTION(); DataSet DS; DS = L.SP_AuthorizeRecord("RPS_CUSTOMER_BALANCE", Session["U_NAME"].ToString(), DateTime.Now.ToString("MM-dd-yyyy"), Session["CustBalCode"].ToString()); Response.Redirect("../CustomerSetup/frmCustomerBalanceSPC.aspx?s1=" + Request.QueryString[0].ToString()); } }
protected void DisplayToolBar_ItemClick(object sender, EO.Web.ToolBarEventArgs e) { if (e.Item.ToolTip == "Edit") { FormView1.ChangeMode(FormViewMode.Edit); } else if (e.Item.ToolTip == "Cancel") { BackPage(); } else if (e.Item.ToolTip == "Authorize / Unauthorize") { LOV_COLLECTION L = new LOV_COLLECTION(); DataSet DS; DS = L.SP_AuthorizeRecord("SPDS_AuthorizationMatrix", Session["U_NAME"].ToString(), DateTime.Now.ToString("MM-dd-yyyy"), Session["SPDS_AuthorizationMatrix_ID"].ToString()); Response.Redirect("../AuthorizationMatrix/frmSPDS_AuthorizationMatrixSPC.aspx" + "?" + "s1=" + Request.QueryString[0].ToString()); } }
protected void btnAuthorize_Click(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { LOV_COLLECTION L = new LOV_COLLECTION(); DataSet DS; string v_return = ""; OracleParameter[] parm = new OracleParameter[3]; int pno = 0; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("p_id", OracleType.VarChar, ParameterDirection.Input, Session["SPDS_SignatorySetup_ID"].ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("p_user_id", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("p_return", OracleType.VarChar, ParameterDirection.Output, ""); v_return = obj_DBLayer.Oracle_GetDataSetSP_DML("sp_signatorysetup_autho", parm, pno); if (v_return.StartsWith("0")) { //Response.Redirect("../InstrumentSetup/frmSPDS_InstrumentSetupSPC.aspx" + "?" + "s1=" + Request.QueryString[0].ToString()); Response.Redirect("../SignatorySetup/frmSPDS_SignatorySetupSPC.aspx" + "?" + "s1=" + Request.QueryString[0].ToString()); //BackPage(); //((FileUpload)FormView1.FindControl("TXT_UPLOAD_IMAGE_PATH_EDIT")).SaveAs(Server.MapPath("~") + "\\SignatureImage\\" + ((FileUpload)FormView1.FindControl("TXT_UPLOAD_IMAGE_PATH_EDIT")).FileName.ToString()); } else { ((Label)FormView1.FindControl("lblDuplicate_Auth")).Text = v_return.Replace("1;", ""); } } }
protected void btnHoldReleasedraft_Click(object sender, EventArgs e) { try { lbl_Message.Text = ""; DraftDataManager DraftEntityDataManager = RuntimeClassLoader.GetDataManager("Draft") as DraftDataManager; if (this.btnHoldReleasedraft.Text == "Release Draft") { btnHoldReleasedraft.OnClientClick = "return confirm('Are you sure you want to Release the Draft?');"; //rslt = DraftEntityDataManager.MarkRelease((int)Session["RowId"]); rslt = DraftEntityDataManager.MarkRelease(Convert.ToInt32(Session["RowId"])); LOV_COLLECTION t = new LOV_COLLECTION(); DataSet ds; string remiaml = ""; string remisdn = ""; if (chbRemAMLDiscrepant.Checked == true) { remiaml = "1"; } else { remiaml = "0"; } if (chbRemSDNDiscrepant.Checked == true) { remisdn = "1"; } else { remisdn = "0"; } ds = t.RPS_SP_Remitter_UpdateSDNAML(Convert.ToInt32(Session["RowId"]), remiaml, remisdn); if (ds.Tables[0].Rows.Count > 0) { lbl_Message.Text = ApplicationMessages.UPDATE_SUCCESS_MESSAGE; this.btnHoldReleasedraft.Text = "Hold Draft"; btnHoldReleasedraft.OnClientClick = "return confirm('Are you sure you want to Hold the Draft?')"; this.txbHoldReason.ReadOnly = this.txbTextCode.ReadOnly = false; this.btnTextCodeLookup.Enabled = true; } else { lbl_Message.Text = ApplicationMessages.UPDATE_FAILURE_MESSAGE; } } else if (this.btnHoldReleasedraft.Text == "Hold Draft") { btnHoldReleasedraft.OnClientClick = "return confirm('Are you sure you want to Hold the Draft?')"; rslt = DraftEntityDataManager.MarkHold(Convert.ToInt32(Session["RowId"]), this.txbHoldReason.Text); LOV_COLLECTION rsltBeneficiary = new LOV_COLLECTION(); DataSet ds; string beniaml = ""; string benisdn = ""; if (chbBeneAMLDiscrepant.Checked == true) { beniaml = "1"; } else { beniaml = "0"; } if (chbBeneSDNDiscrepant.Checked == true) { benisdn = "1"; } else { benisdn = "0"; } //ds = rsltBeneficiary.RPS_SP_Beneficiary_UpdateSDNAML((int)Session["BeneficiaryId"], beniaml, benisdn); //Session["BeneficiaryId"] = "1821"; ds = rsltBeneficiary.RPS_SP_Beneficiary_UpdateSDNAML(Session["BeneficiaryId"].ToString(), beniaml, benisdn); //rsltBeneficiary = DraftEntityDataManager.MarkBeneficiarySDNAML((int)Session["BeneficiaryId"], chbBeneAMLDiscrepant.Checked,chbBeneSDNDiscrepant.Checked); //Session["RemitterId"] = "1821"; //rsltRemitter = DraftEntityDataManager.MarkRemitterSDNAML(Convert.ToInt32(Session["RemitterId"]), chbRemSDNDiscrepant.Checked, chbRemAMLDiscrepant.Checked); rsltRemitter = DraftEntityDataManager.MarkRemitterSDNAML(Convert.ToInt32(Session["RemitterId"]), (chbRemSDNDiscrepant.Checked == true) ? "0" : "1", (chbRemAMLDiscrepant.Checked == true) ? "0" : "1"); if (rslt.isSuccessful) { /* * if ((int)Session["RowId"] > 0 && Session["DraftNo"].ToString().Length > 0 && btnHoldReleasedraft.Text == "Hold Draft") * btnHoldReleasedraft.Attributes.Add("onclick", "wid=window.showModalDialog('../Transaction/MiscellaneousMsg.aspx?DraftId=" + Session["RowId"].ToString() + "&PriorityCode=601&DraftNo=" + Session["DraftNo"].ToString() + "&HoldReason=" + txbHoldReason.Text + "',null,'status:no;dialogWidth:1200px;dialogHeight:850px;dialogHide:true;help:no;scroll:yes');"); * else * { * btnHoldReleasedraft.Attributes.Remove("onclick"); * } */ lbl_Message.Text = ApplicationMessages.UPDATE_SUCCESS_MESSAGE; this.btnHoldReleasedraft.Text = "Release Draft"; this.txbHoldReason.ReadOnly = this.txbTextCode.ReadOnly = true; this.btnTextCodeLookup.Enabled = false; Response.Redirect("../MiscellaneousMessage/frmRPS_FreeTextMessageSPC.aspx?DraftId=" + Session["RowId"].ToString() + "&RI=987&PC=601&DraftNo=" + Session["DraftNo"].ToString() + "&TC=" + txbTextCode.Text + "&HoldReason=" + txbHoldReason.Text); } //else //lbl_Message.Text = ApplicationMessages.UPDATE_FAILURE_MESSAGE; } } catch (Exception ex) { lbl_Message.Text = ex.Message; //DataManager.SQLManager.LogException("HR_Transaction_CourierFeedback", "btnHoldReleaseDraft_Click", ex, Session["UserId"].ToString()); } }
private void FillData() { try { if (Session["drv"].ToString() != "") { //drv = (GridViewRow)Session["drv"]; DataRow drw = (DataRow)Session["drw"]; txbTextCode.Text = null; Session["RowId"] = drw["ID"]; this.txbBeneficiaryNo.Text = drw["BeneficiaryNo"].ToString(); this.txbDraftNo.Text = drw["DraftNo"].ToString(); Session["DraftNo"] = drw["DraftNo"].ToString(); this.txbRemitterNo.Text = drw["RemitterNo"].ToString(); this.txbPODNo.Text = drw["PODNo"].ToString(); this.txbDraftDate.Text = drw["DraftDate"].ToString(); this.txbDraftRate.Text = drw["Rate"].ToString(); rsltDraft = (draftdatamanager as DraftDataManager).GetByCode(drw["DraftNo"].ToString()); //rsltRemitter = (Remitterdatamanager as RemitterDataManager).GetByCode(drw["RemitterNo"].ToString()); rsltRemitter = (Remitterdatamanager as RemitterDataManager).GetByCode(drw["DraftNo"].ToString()); //IBRAHIM //rsltPOD = (poddatamanager as PODDataManager).GetByCode(drw["PODNo"].ToString()); if (rsltRemitter.dstResult.Tables[0].Rows.Count > 0) { Session["RemitterId"] = Convert.ToInt32(rsltRemitter.dstResult.Tables[0].Rows[0]["ID"]); this.txbRemitterCity.Text = rsltRemitter.dstResult.Tables[0].Rows[0]["City"].ToString(); this.txbRemitterFirstName.Text = rsltRemitter.dstResult.Tables[0].Rows[0]["FirstName"].ToString(); this.txbRemitterLastName.Text = rsltRemitter.dstResult.Tables[0].Rows[0]["LastName"].ToString(); this.txbRemitterMiddleName.Text = rsltRemitter.dstResult.Tables[0].Rows[0]["MiddleName"].ToString(); this.txbRemitterPOBoxNo.Text = rsltRemitter.dstResult.Tables[0].Rows[0]["POBoxNo"].ToString(); this.txbRemitterZipCode.Text = rsltRemitter.dstResult.Tables[0].Rows[0]["ZipCode"].ToString(); if (rsltRemitter.dstResult.Tables[0].Rows[0]["SDNDiscrepant"].ToString() == "True") { chbRemSDNDiscrepant.Checked = true; } else { chbRemSDNDiscrepant.Checked = false; } if (rsltRemitter.dstResult.Tables[0].Rows[0]["AMLDiscrepant"].ToString() == "True") { chbRemAMLDiscrepant.Checked = true; } else { chbRemAMLDiscrepant.Checked = false; } //rsltBeneficiary = (Beneficiarydatamanager as BeneficiaryDataManager).GetByCode(Convert.ToInt32(rsltRemitter.dstResult.Tables[0].Rows[0]["ID"]), this.txbBeneficiaryNo.Text); // rsltBeneficiary = (Beneficiarydatamanager as BeneficiaryDataManager).GetByCode(326889, drw["BeneficiaryNo"].ToString()); LOV_COLLECTION L = new LOV_COLLECTION(); DataSet DS; //DS = L.RPS_SP_Beneficiary_GetByCode((int)Session["RemitterId"], drw["BeneficiaryNo"].ToString()); DS = L.RPS_SP_Beneficiary_GetByCode(Session["RemitterId"].ToString(), drw["BeneficiaryNo"].ToString()); if (DS.Tables[0].Rows.Count > 0) { Session["BeneficiaryId"] = Convert.ToInt32(DS.Tables[0].Rows[0]["ID"]); this.txbAlternateFirstName.Text = DS.Tables[0].Rows[0]["AlternateFirstName"].ToString(); this.txbAlternateMiddleName.Text = DS.Tables[0].Rows[0]["AlternateMiddleName"].ToString(); this.txbAlternateLastName.Text = DS.Tables[0].Rows[0]["AlternateLastName"].ToString(); this.txbBeneficiaryAddress.Text = DS.Tables[0].Rows[0]["Address1"].ToString(); this.txbBeneficiaryCity.Text = DS.Tables[0].Rows[0]["City"].ToString(); this.txbBeneficiaryFirstName.Text = DS.Tables[0].Rows[0]["FirstName"].ToString(); this.txbBeneficiaryLastName.Text = DS.Tables[0].Rows[0]["LastName"].ToString();; this.txbBeneficiaryMiddleName.Text = DS.Tables[0].Rows[0]["MiddleName"].ToString(); this.txbBeneficiaryZipCode.Text = DS.Tables[0].Rows[0]["ZipCode"].ToString(); if (DS.Tables[0].Rows[0]["SDNDiscrepant"].ToString() == "True") { chbBeneSDNDiscrepant.Checked = true; } else { chbBeneSDNDiscrepant.Checked = false; } if (DS.Tables[0].Rows[0]["AMLDiscrepant"].ToString() == "True") { chbBeneAMLDiscrepant.Checked = true; } else { chbBeneAMLDiscrepant.Checked = false; } } } this.txbDraftBankCode.Text = drw["Bank_Code"].ToString(); this.txbDraftBankName.Text = drw["Bank_Name"].ToString(); this.txbDraftCoverAmountUSD.Text = drw["CoverAmountUSD"].ToString(); this.txbDraftCurrency.Text = drw["CurrencyCode"].ToString(); this.txbDraftTransactionAmount.Text = drw["TransactionAmount"].ToString(); this.txbRemitterReferenceNo.Text = drw["RemittanceRefNo"].ToString(); // this.txbDraftZipCode.Text = rsltDraft.dstResult.Tables[0].Rows[0]["StatusDate"].ToString(); //<IBRAHIM> //if (rsltPOD.dstResult.Tables[0].Rows.Count > 0) //{ // this.txbPODDate.Text = rsltPOD.dstResult.Tables[0].Rows[0]["PODDate"].ToString(); // this.txbPODDeliveryDate.Text = rsltPOD.dstResult.Tables[0].Rows[0]["DeliveryDate"].ToString(); // this.txbPODNo.Text = rsltPOD.dstResult.Tables[0].Rows[0]["PODNo"].ToString(); // this.txbPODStatusCode.Text = rsltPOD.dstResult.Tables[0].Rows[0]["StatusID"].ToString(); // this.txbPODStatusDate.Text = rsltPOD.dstResult.Tables[0].Rows[0]["StatusDate"].ToString(); // this.txbPODStatusDescription.Text = rsltPOD.dstResult.Tables[0].Rows[0]["StatusDescription"].ToString(); //} //</IBRAHIM> bool holdRelease = Convert.ToBoolean(rsltDraft.dstResult.Tables[0].Rows[0]["Holded"].ToString()); this.txbHoldReason.Text = drw["HoldReason"].ToString(); if (holdRelease) { this.txbHoldReason.ReadOnly = this.txbTextCode.ReadOnly = true; this.btnTextCodeLookup.Enabled = false; } else { this.txbHoldReason.ReadOnly = this.txbTextCode.ReadOnly = false; this.btnTextCodeLookup.Enabled = true; } ButtonFunctional(holdRelease); Session["drv"] = ""; Session["drw"] = ""; } } catch (Exception ex) { lbl_Message.Text = ex.Message; //DataManager.SQLManager.LogException("HR_Transaction_CourierFeedback", "FillData", ex, Session["UserId"].ToString()); } }
protected void BTN_INSERT_Click(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { LOV_COLLECTION L = new LOV_COLLECTION(); DataSet DS; DS = L.SP_SignatorySetup_DP(((TextBox)FormView1.FindControl("TXT_SIGNATORY_NAME_INSERT")).Text, "0"); if (DS.Tables[0].Rows.Count > 0) { Session["error1"] = "Duplicate Record"; ((Label)FormView1.FindControl("lblDuplicate_INSERT")).Text = "Duplicate Record"; } else { if (Path.GetExtension(((FileUpload)FormView1.FindControl("TXT_UPLOAD_IMAGE_PATH_INSERT")).FileName.ToLower()) == ".jpg") { if (DS.Tables[0].Rows.Count <= 0) { string v_return = ""; OracleParameter[] parm = new OracleParameter[7]; int pno = 0; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_ID", OracleType.VarChar, ParameterDirection.Input, "0"); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_SIGNATORY_NAME", OracleType.VarChar, ParameterDirection.Input, ((TextBox)FormView1.FindControl("TXT_SIGNATORY_NAME_INSERT")).Text); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_UPLOAD_IMAGE_PATH", OracleType.VarChar, ParameterDirection.Input, ((FileUpload)FormView1.FindControl("TXT_UPLOAD_IMAGE_PATH_INSERT")).FileName.ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_UPLOAD_IMAGE", OracleType.Blob, ParameterDirection.Input, ((FileUpload)FormView1.FindControl("TXT_UPLOAD_IMAGE_PATH_INSERT")).FileBytes); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_CURRENT_STATUS", OracleType.VarChar, ParameterDirection.Input, ((DropDownList)FormView1.FindControl("DDL_CURRENT_STATUS_INSERT")).SelectedValue); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_A_UserID", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_return", OracleType.VarChar, ParameterDirection.Output, ""); v_return = obj_DBLayer.Oracle_GetDataSetSP_DML("SP_SET_INSERT_SignatorySetup", parm, pno); if (v_return.StartsWith("0")) { ((FileUpload)FormView1.FindControl("TXT_UPLOAD_IMAGE_PATH_INSERT")).SaveAs(Server.MapPath("~") + "\\SignatureImage\\" + ((FileUpload)FormView1.FindControl("TXT_UPLOAD_IMAGE_PATH_INSERT")).FileName.ToString()); BackPage(); } else { ((Label)FormView1.FindControl("lblDuplicate_INSERT")).Text = v_return.Replace("1;", ""); } } else { ((TextBox)FormView1.FindControl("TXT_SIGNATORY_NAME_INSERT")).Text = ""; } } else { ((Label)FormView1.FindControl("lblDuplicate_INSERT")).Text = "Select JPG image file"; return; } } } }
protected void UpdateButton_Click(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { LOV_COLLECTION L = new LOV_COLLECTION(); DataSet DS; DS = L.SP_SignatorySetup_DP(((TextBox)FormView1.FindControl("TXT_SIGNATORY_NAME_EDIT")).Text, Session["SPDS_SignatorySetup_ID"].ToString()); if (DS.Tables[0].Rows.Count > 0) { ((Label)FormView1.FindControl("lblDuplicate_EDIT")).Text = "Duplicate Record"; } else { //SP_SET_UPDATE_SPDS_SignSetup if (DS.Tables[0].Rows.Count <= 0) { string v_return = ""; OracleParameter[] parm = new OracleParameter[7]; int pno = 0; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_ID", OracleType.VarChar, ParameterDirection.Input, Session["SPDS_SignatorySetup_ID"].ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_SIGNATORY_NAME", OracleType.VarChar, ParameterDirection.Input, ((TextBox)FormView1.FindControl("TXT_SIGNATORY_NAME_EDIT")).Text); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_UPLOAD_IMAGE_PATH", OracleType.VarChar, ParameterDirection.Input, ((FileUpload)FormView1.FindControl("TXT_UPLOAD_IMAGE_PATH_EDIT")).FileName.ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_CURRENT_STATUS", OracleType.VarChar, ParameterDirection.Input, ((DropDownList)FormView1.FindControl("DDL_CURRENT_STATUS_EDIT")).SelectedValue); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_UPLOAD_IMAGE", OracleType.Blob, ParameterDirection.Input, ((FileUpload)FormView1.FindControl("TXT_UPLOAD_IMAGE_PATH_EDIT")).FileBytes); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_E_UserID", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("V_RETURN", OracleType.VarChar, ParameterDirection.Output, ""); v_return = obj_DBLayer.Oracle_GetDataSetSP_DML("SP_SET_UPDATE_SPDS_SignSetup", parm, pno); if (v_return.StartsWith("0")) { ((FileUpload)FormView1.FindControl("TXT_UPLOAD_IMAGE_PATH_EDIT")).SaveAs(Server.MapPath("~") + "\\SignatureImage\\" + ((FileUpload)FormView1.FindControl("TXT_UPLOAD_IMAGE_PATH_EDIT")).FileName.ToString()); BackPage(); } else { ((Label)FormView1.FindControl("lblDuplicate_EDIT")).Text = v_return.Replace("1;", ""); } } else { ((TextBox)FormView1.FindControl("TXT_SIGNATORY_NAME_EDIT")).Text = ""; ((RequiredFieldValidator)FormView1.FindControl("REQ_Name_EDIT")).Validate(); } } } }
protected void BTN_INSERT_Click(object sender, EventArgs e) { string FileName = ""; string FilePath = ""; string fullPath = ""; string fullExtention = ""; Page.Validate(); if (Page.IsValid) { LOV_COLLECTION L = new LOV_COLLECTION(); DataSet DS; DS = L.SP_InstrumentSetup_DP(((TextBox)FormView1.FindControl("TXT_INSTRUMENT_NAME_INSERT")).Text, "0"); if (DS.Tables[0].Rows.Count > 0) { ((Label)FormView1.FindControl("lblDuplicate_INSERT")).Text = "Duplicate Record"; } else { if (DS.Tables[0].Rows.Count <= 0) { if (((FileUpload)FormView1.FindControl("TXT_RDLC_UPLOAD_PATH_INSERT")).HasFile) { fullPath = ((FileUpload)FormView1.FindControl("TXT_RDLC_UPLOAD_PATH_INSERT")).FileName; FileName = System.IO.Path.GetFileNameWithoutExtension(fullPath); FilePath = System.IO.Path.GetDirectoryName(fullPath); fullPath = fullPath.ToString(); fullExtention = System.IO.Path.GetExtension(((FileUpload)FormView1.FindControl("TXT_RDLC_UPLOAD_PATH_INSERT")).FileName); ((FileUpload)FormView1.FindControl("TXT_RDLC_UPLOAD_PATH_INSERT")).SaveAs(Server.MapPath("~") + "\\RDLCReports\\" + fullPath); if (fullExtention.ToUpper() == ".RDLC") { P_SPDS_InstrumentSetup.RecordInputStart(); P_SPDS_InstrumentSetup.Get_ID = "0"; P_SPDS_InstrumentSetup.Get_INSTRUMENT_NAME = ((TextBox)FormView1.FindControl("TXT_INSTRUMENT_NAME_INSERT")).Text; P_SPDS_InstrumentSetup.Get_RDLC_UPLOAD = fullPath; //((TextBox)FormView1.FindControl("TXT_RDLC_UPLOAD_INSERT")).Text; P_SPDS_InstrumentSetup.Get_RDLC_UPLOAD_PATH = Server.MapPath("~") + "\\RDLCReports\\"; //fullPath; P_SPDS_InstrumentSetup.Get_A_UserID = Session["U_NAME"].ToString(); //((TextBox)FormView1.FindControl("TXT_A_UserID_INSERT")).Text; P_SPDS_InstrumentSetup.Get_A_DateTime = DateTime.Now.ToString("dd-MMM-yyyy").ToString(); P_SPDS_InstrumentSetup.Get_E_UserID = Session["U_NAME"].ToString(); // ((TextBox)FormView1.FindControl("TXT_E_UserID_INSERT")).Text; P_SPDS_InstrumentSetup.Get_E_DateTime = DateTime.Now.ToString("dd-MMM-yyyy").ToString(); P_SPDS_InstrumentSetup.RecordInputCommit(); P_SPDS_InstrumentSetup.AddNewGroup(); BackPage(); } else { ((Label)FormView1.FindControl("lblDuplicate_INSERT")).Text = "File format must be RDLC"; } } else { ((Label)FormView1.FindControl("lblDuplicate_INSERT")).Text = "Please select RDLC File"; } } else { ((TextBox)FormView1.FindControl("TXT_INSTRUMENT_NAME_INSERT")).Text = ""; ((RequiredFieldValidator)FormView1.FindControl("REQ_INSTRUMENT_NAME_INSERT")).Validate(); } } } }
protected void UpdateButton_Click(object sender, EventArgs e) { string FileName = ""; string FilePath = ""; string fullPath = ""; string fullExtention = ""; Page.Validate(); { if (Page.IsValid) { LOV_COLLECTION L = new LOV_COLLECTION(); DataSet DS; DS = L.SP_InstrumentSetup_DP(((TextBox)FormView1.FindControl("TXT_INSTRUMENT_NAME_EDIT")).Text, Session["SPDS_InstrumentSetup_ID"].ToString()); if (DS.Tables[0].Rows.Count > 0) { ((Label)FormView1.FindControl("lblDuplicate_EDIT")).Text = "Duplicate Record"; } else { if (DS.Tables[0].Rows.Count <= 0) { if (((FileUpload)FormView1.FindControl("TXT_RDLC_UPLOAD_PATH_EDIT")).HasFile == true) { FileName = System.IO.Path.GetFileName(((FileUpload)FormView1.FindControl("TXT_RDLC_UPLOAD_PATH_EDIT")).PostedFile.FileName); FilePath = System.IO.Path.GetDirectoryName(((FileUpload)FormView1.FindControl("TXT_RDLC_UPLOAD_PATH_EDIT")).PostedFile.FileName); fullPath = System.IO.Path.GetFullPath(((FileUpload)FormView1.FindControl("TXT_RDLC_UPLOAD_PATH_EDIT")).PostedFile.FileName); fullExtention = System.IO.Path.GetExtension(((FileUpload)FormView1.FindControl("TXT_RDLC_UPLOAD_PATH_EDIT")).PostedFile.FileName); //{ } else { ((Label)FormView1.FindControl("lblDuplicate_EDIT")).Text = ("Select File First"); } if (fullExtention.ToUpper() == ".RDLC") { P_SPDS_InstrumentSetup.RecordInputStart(); P_SPDS_InstrumentSetup.Get_ID = Session["SPDS_InstrumentSetup_ID"].ToString(); P_SPDS_InstrumentSetup.Get_INSTRUMENT_NAME = ((TextBox)FormView1.FindControl("TXT_INSTRUMENT_NAME_EDIT")).Text; P_SPDS_InstrumentSetup.Get_RDLC_UPLOAD = FileName; //((TextBox)FormView1.FindControl("TXT_RDLC_UPLOAD_EDIT")).Text; P_SPDS_InstrumentSetup.Get_RDLC_UPLOAD_PATH = Server.MapPath("~") + "\\RDLCReports\\"; P_SPDS_InstrumentSetup.Get_A_UserID = "0"; // ((TextBox)FormView1.FindControl("TXT_A_UserID_EDIT")).Text; P_SPDS_InstrumentSetup.Get_A_DateTime = DateTime.Now.ToString("dd-MMM-yyyy").ToString(); P_SPDS_InstrumentSetup.Get_E_UserID = Session["U_NAME"].ToString(); // ((TextBox)FormView1.FindControl("TXT_E_UserID_EDIT")).Text; P_SPDS_InstrumentSetup.Get_E_DateTime = DateTime.Now.ToString("dd-MMM-yyyy").ToString(); P_SPDS_InstrumentSetup.RecordInputCommit(); //if (File.Exists(DS1.Tables[0].Rows[0][0].ToString() + @"\" + FileName)) //{ // ((Label)FormView1.FindControl("lblDuplicate_EDIT")).Text = "File Already Exist"; //} //else //{ //File.Copy(fullPath, DS1.Tables[0].Rows[0][0].ToString() + @"\" + FileName, true); P_SPDS_InstrumentSetup.EditNewGroup(); //DataSet DS1 = new DataSet(); //DS1 = LOV.RPT_Path(); //String FP = System.IO.Path.GetFullPath(((FileUpload)FormView1.FindControl("TXT_RDLC_UPLOAD_PATH_EDIT")).PostedFile.FileName); //FileOp FO = new FileOp(); //String RP = ""; //RP = FO.uploadFileUsingFTP(FPS.SP_FILE_PATH("4").ToString() + ((FileUpload)FormView1.FindControl("TXT_RDLC_UPLOAD_PATH_EDIT")).FileName.ToString(), FP.ToString(), Session["FTPUserID"].ToString(), Session["FTPPASSWORD"].ToString()); BackPage(); //} } else { ((Label)FormView1.FindControl("lblDuplicate_EDIT")).Text = "File format must be RDLC"; //lblMessage.Text = "File format must be RDLC"; } } else { ((TextBox)FormView1.FindControl("TXT_INSTRUMENT_NAME_EDIT")).Text = ""; ((RequiredFieldValidator)FormView1.FindControl("REQ_INSTRUMENT_NAME_EDIT")).Validate(); } } } } }
protected void InsertToolbar_ItemClick(object sender, EO.Web.ToolBarEventArgs e) { Page.Validate(); if (e.Item.ToolTip == "Insert") { if (Page.IsValid) { LOV_COLLECTION L = new LOV_COLLECTION(); DataSet DS; DS = L.SP_CustomerSetup_DP(((TextBox)FormView1.FindControl("TXT_BankCode_INSERT")).Text, "0"); if (DS.Tables[0].Rows.Count > 0) { ((Label)FormView1.FindControl("lblDuplicate_INSERT")).Text = "Duplicate Record"; } else { if (DS.Tables[0].Rows.Count <= 0) { P_RPS_Bank.RecordInputStart(); P_RPS_Bank.Get_ID = "0"; P_RPS_Bank.Get_BankCode = ((TextBox)FormView1.FindControl("TXT_BankCode_INSERT")).Text; P_RPS_Bank.Get_BankName = ((TextBox)FormView1.FindControl("TXT_BankName_INSERT")).Text; P_RPS_Bank.Get_Abbreviation = ((TextBox)FormView1.FindControl("TXT_Abbreviation_INSERT")).Text; P_RPS_Bank.Get_AssignedCitiBankId = ((TextBox)FormView1.FindControl("TXT_AssignedCitiBankId_INSERT")).Text; //---------Primary contact------- P_RPS_Bank.Get_Address = ((TextBox)FormView1.FindControl("TXT_Address_INSERT")).Text; P_RPS_Bank.Get_PhoneNo = ((TextBox)FormView1.FindControl("TXT_PhoneNo_INSERT")).Text; P_RPS_Bank.Get_FaxNo = ((TextBox)FormView1.FindControl("TXT_FaxNo_INSERT")).Text; P_RPS_Bank.Get_Email = ((TextBox)FormView1.FindControl("TXT_Email_INSERT")).Text; P_RPS_Bank.Get_ServiceTypeID = "1"; if (((CheckBox)FormView1.FindControl("TXT_InputFileAllowed_INSERT")).Checked == true) { //P_RPS_Bank.Get_InputFileAllowed = "True"; P_RPS_Bank.Get_InputFileAllowed = "1"; } else { //P_RPS_Bank.Get_InputFileAllowed = "False"; P_RPS_Bank.Get_InputFileAllowed = "0"; } //((TextBox)FormView1.FindControl("TXT_InputFileAllowed_INSERT")).Text; P_RPS_Bank.Get_UnclaimedDraftPeriod = "0"; //((TextBox)FormView1.FindControl("TXT_UnclaimedDraftPeriod_INSERT")).Text; P_RPS_Bank.Get_FloorLimit = "0"; //((TextBox)FormView1.FindControl("TXT_FloorLimit_INSERT")).Text; P_RPS_Bank.Get_DraftFooterMessage = "0"; //((TextBox)FormView1.FindControl("TXT_DraftFooterMessage_INSERT")).Text; P_RPS_Bank.Get_URL = "0"; //((TextBox)FormView1.FindControl("TXT_URL_INSERT")).Text; P_RPS_Bank.Get_RemitType = "0"; //((TextBox)FormView1.FindControl("TXT_RemitType_INSERT")).Text; //P_RPS_Bank.Get_IsCitiBank = "True"; //((TextBox)FormView1.FindControl("TXT_IsCitiBank_INSERT")).Text; P_RPS_Bank.Get_IsCitiBank = "1"; P_RPS_Bank.Get_A_UserID = Session["U_NAME"].ToString(); P_RPS_Bank.Get_A_DateTime = DateTime.Now.ToString("dd-MMM-yyyy").ToString(); P_RPS_Bank.Get_E_UserID = Session["U_NAME"].ToString(); P_RPS_Bank.Get_E_DateTime = DateTime.Now.ToString("dd-MMM-yyyy").ToString(); P_RPS_Bank.Get_OnlineDraftStartingNo = "0"; //((TextBox)FormView1.FindControl("TXT_OnlineDraftStartingNo_INSERT")).Text; P_RPS_Bank.Get_OfflineDraftStartingNo = "0"; //((TextBox)FormView1.FindControl("TXT_OfflineDraftStartingNo_INSERT")).Text; P_RPS_Bank.Get_ReportTitle = ((TextBox)FormView1.FindControl("TXT_ReportTitle_INSERT")).Text; if (((RadioButton)FormView1.FindControl("TXT_IsDollarBased_INSERT")).Checked == true) { //P_RPS_Bank.Get_IsDollarBased = "True"; P_RPS_Bank.Get_IsDollarBased = "1"; } else if (((RadioButton)FormView1.FindControl("TXT_IsRupeeBased_INSERT")).Checked == true) { //P_RPS_Bank.Get_IsDollarBased = "False"; P_RPS_Bank.Get_IsDollarBased = "0"; } //P_RPS_Bank.Get_IsDollarBased = "True";//((TextBox)FormView1.FindControl("TXT_IsDollarBased_INSERT")).Text; P_RPS_Bank.Get_AccountNo = ((TextBox)FormView1.FindControl("TXT_Account_No_Insert")).Text; if (((RadioButton)FormView1.FindControl("TXT_CustomerTypeMTO_INSERT")).Checked == true) { //P_RPS_Bank.Get_CustomerType = "True"; P_RPS_Bank.Get_CustomerType = "1"; } else if (((RadioButton)FormView1.FindControl("TXT_CustomerTypeCORP_INSERT")).Checked == true) { //P_RPS_Bank.Get_CustomerType = "False"; P_RPS_Bank.Get_CustomerType = "0"; } //P_RPS_Bank.Get_IsPRI = "True"; P_RPS_Bank.Get_IsPRI = "1"; P_RPS_Bank.Get_Customer_Balance = ((TextBox)FormView1.FindControl("TXT_CustomerBal_Insert")).Text; P_RPS_Bank.RecordInputCommit(); P_RPS_Bank.AddNewGroup(); //-------------Secondary Contact ----------------- /// DataSet DS; DS = L.SP_CustomerSetup_MaxID(); Session["RPS_Bank_ID"] = DS.Tables[0].Rows[0][0].ToString(); P_RPS_BankContact.RecordInputStart(); P_RPS_BankContact.Get_ID = "0"; P_RPS_BankContact.Get_BankID = Session["RPS_Bank_ID"].ToString(); P_RPS_BankContact.Get_Address = ((TextBox)FormView1.FindControl("TXT_SecondayAddress_INSERT")).Text; P_RPS_BankContact.Get_Email = ((TextBox)FormView1.FindControl("TXT_SecondayEmail_INSERT")).Text; P_RPS_BankContact.Get_PhoneNo = ((TextBox)FormView1.FindControl("TXT_SecondayPhoneNo_INSERT")).Text; P_RPS_BankContact.Get_FaxNo = ((TextBox)FormView1.FindControl("TXT_SecondayFaxNo_INSERT")).Text; P_RPS_BankContact.RecordInputCommit(); P_RPS_BankContact.AddNewGroup(); BackPage(); } else { ((TextBox)FormView1.FindControl("TXT_BankCode_INSERT")).Text = ""; ((RequiredFieldValidator)FormView1.FindControl("REQ_BankCode_INSERT")).Validate(); } } } } else if (e.Item.ToolTip == "Cancel") { BackPage(); } }
protected void UpdateButton_Click(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { LOV_COLLECTION L = new LOV_COLLECTION(); DataSet DS; DS = L.SP_SignatorySetup_DP(TXT_SIGNATORY_NAME_INSERT.Text, Session["SPDS_SignatorySetup_ID"].ToString()); if (DS.Tables[0].Rows.Count > 0) { lblDuplicate_INSERT.Text = "Duplicate Record"; } else { if (Path.GetExtension(TXT_UPLOAD_IMAGE_PATH_INSERT.FileName.ToLower()) == ".jpg") { if (DS.Tables[0].Rows.Count <= 0) { string v_return = ""; OracleParameter[] parm = new OracleParameter[7]; int pno = 0; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_ID", OracleType.VarChar, ParameterDirection.Input, Session["SPDS_SignatorySetup_ID"].ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_SIGNATORY_NAME", OracleType.VarChar, ParameterDirection.Input, TXT_SIGNATORY_NAME_INSERT.Text); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_UPLOAD_IMAGE_PATH", OracleType.VarChar, ParameterDirection.Input, TXT_UPLOAD_IMAGE_PATH_INSERT.FileName.ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_CURRENT_STATUS", OracleType.VarChar, ParameterDirection.Input, DDL_CURRENT_STATUS_INSERT.SelectedValue); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_UPLOAD_IMAGE", OracleType.Blob, ParameterDirection.Input, TXT_UPLOAD_IMAGE_PATH_INSERT.FileBytes); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_E_UserID", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("V_RETURN", OracleType.VarChar, ParameterDirection.Output, ""); v_return = obj_DBLayer.Oracle_GetDataSetSP_DML("SP_SET_UPDATE_SPDS_SignSetup", parm, pno); if (v_return.StartsWith("0")) { TXT_UPLOAD_IMAGE_PATH_INSERT.SaveAs(Server.MapPath("~") + "\\SignatureImage\\" + TXT_UPLOAD_IMAGE_PATH_INSERT.FileName.ToString()); } else { lblDuplicate_INSERT.Text = v_return.Replace("1;", ""); } Response.Redirect("../SignatorySetup/frmSPDS_SignatorySetup.aspx?s1=" + Request.QueryString[0].ToString()); } else { TXT_SIGNATORY_NAME_INSERT.Text = ""; } } else { lblDuplicate_INSERT.Text = "Select JPG image file"; return; } } } }