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