protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string p_return = "";
string[] p_retval;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
string transType = ((DropDownList)GridView1.Rows[i].FindControl("DDLCHANGETO")).SelectedValue.ToString();
if (transType != "Select Mode")
{
DataSet ds = new DataSet();
OracleParameter[] parms = new OracleParameter[10];
parms[0] = new OracleParameter();
parms[0] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString());
parms[1] = new OracleParameter();
parms[1] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, ddlFile.SelectedItem.ToString());
parms[2] = new OracleParameter();
parms[2] = _dbConfig.Oracle_Param("P_Trans_type", OracleType.VarChar, ParameterDirection.Input, transType);
parms[3] = new OracleParameter();
parms[3] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, GridView1.Rows[i].Cells[0].Text);
parms[4] = new OracleParameter();
parms[4] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, GridView1.Rows[i].Cells[3].Text);
parms[5] = new OracleParameter();
parms[5] = _dbConfig.Oracle_Param("p_branch_code", OracleType.VarChar, ParameterDirection.Input, GridView1.Rows[i].Cells[4].Text);
parms[6] = new OracleParameter();
parms[6] = _dbConfig.Oracle_Param("P_Userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString());
parms[7] = new OracleParameter();
parms[7] = _dbConfig.Oracle_Param("P_type", OracleType.VarChar, ParameterDirection.Input, "04");
parms[8] = new OracleParameter();
parms[8] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
parms[9] = new OracleParameter();
parms[9] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, "");
p_return = _dbConfig.Oracle_GetDataSetSP_DML("SP_Data_Segregation", parms, 9);
lblMessage.Text = p_return.Split(',').GetValue(1).ToString();
}
}
if (p_return.Split(',').GetValue(0).ToString() == "04")
{
loadGrid("S");
}
}
catch (Exception EX)
{
lblMessage.Text = EX.Message;
}
}
public void Execute_sp()
{
string v_return = "";
for (int i = 0; i < sort_table.Rows.Count; i++)
{
//string branchCode = ((HiddenField)sort_table.Rows[i].FindControl("hf_BranchCode")).Value;
string branchCode = ((TextBox)sort_table.Rows[i].FindControl("txtBranchCode")).Text;
if (branchCode != "")
{
branchCode = get_Branch(i);
}
OracleParameter[] parm = new OracleParameter[10];
int pno = 0;
if (branchCode != "" && branchCode != "0" && branchCode != "Branch not found")
{
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString());
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, ddlFile.SelectedValue.ToString());
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_Trans_type", OracleType.VarChar, ParameterDirection.Input, sort_table.Rows[i].Cells[1].Text);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, sort_table.Rows[i].Cells[0].Text);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("p_branch_code", OracleType.VarChar, ParameterDirection.Input, branchCode);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_Userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString());
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_type", OracleType.VarChar, ParameterDirection.Input, "06");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, "");
v_return = _dbConfig.Oracle_GetDataSetSP_DML("SP_Data_Segregation", parm, pno);
lblMessage.Text = v_return.Split(',').GetValue(1).ToString();
}
}
/*if (v_return.Split(',').GetValue(0).ToString() == "04")
* {
* loadGrid("S");
* }*/
}
//public string Execute_sp(OracleConnection conn, OracleTransaction tran)
//{
// string v_return = "";
// for (int i = 0; i < GridView1.Rows.Count; i++)
// {
// //if (((CheckBox)GridView1.Rows[i].FindControl("cbPublish")).Checked == true)
// OracleParameter[] parm = new OracleParameter[10];
// int pno = 0;
// parm[pno] = new OracleParameter();
// parm[pno] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString());
// pno++;
// parm[pno] = new OracleParameter();
// parm[pno] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, ddlFile.SelectedValue.ToString());
// pno++;
// parm[pno] = new OracleParameter();
// parm[pno] = _dbConfig.Oracle_Param("P_Trans_type", OracleType.VarChar, ParameterDirection.Input, (GridView1.Rows[i].Cells[1].Text == " ") ? "" : GridView1.Rows[i].Cells[1].Text);
// pno++;
// parm[pno] = new OracleParameter();
// parm[pno] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, GridView1.Rows[i].Cells[0].Text);
// pno++;
// parm[pno] = new OracleParameter();
// parm[pno] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, "");
// pno++;
// parm[pno] = new OracleParameter();
// parm[pno] = _dbConfig.Oracle_Param("p_branch_code", OracleType.VarChar, ParameterDirection.Input, "");
// pno++;
// parm[pno] = new OracleParameter();
// parm[pno] = _dbConfig.Oracle_Param("P_Userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString());
// pno++;
// parm[pno] = new OracleParameter();
// parm[pno] = _dbConfig.Oracle_Param("P_type", OracleType.VarChar, ParameterDirection.Input, "10");
// pno++;
// parm[pno] = new OracleParameter();
// parm[pno] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
// pno++;
// parm[pno] = new OracleParameter();
// parm[pno] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, "");
// v_return = _dbConfig.TransSPOracle_GetReturnStringVal1(conn, tran, "SP_Data_Segregation", parm, pno);
// if (v_return.StartsWith("04") == false)
// {
// lblMessage.Text = v_return.Split(',').GetValue(1).ToString();
// return v_return;
// }
// }
// return v_return;
//}
public string spRow_Updation(string rowid, string beneName, string AccountNO, string Type, string bank_code, string branchID)
{
string v_return = "";
//for (int i = 0; i < GridView1.Rows.Count; i++)
//{
//if (((CheckBox)GridView1.Rows[i].FindControl("cbPublish")).Checked == true)
OracleParameter[] parm = new OracleParameter[7];
int pno = 0;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("p_benename", OracleType.VarChar, ParameterDirection.Input, beneName);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_accountno", OracleType.VarChar, ParameterDirection.Input, AccountNO);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, bank_code);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("p_branchid", OracleType.VarChar, ParameterDirection.Input, branchID);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, rowid);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_type", OracleType.VarChar, ParameterDirection.Input, Type);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_retval", OracleType.VarChar, ParameterDirection.Output, "");
v_return = _dbConfig.Oracle_GetDataSetSP_DML("sp_Trans_Enquiry_upd", parm, pno);
if (v_return.StartsWith("1") == false)
{
lblMessage.Text = v_return.Split(';').GetValue(1).ToString();
return(v_return);
}
else
{
lblMessage.Text = v_return.Split(';').GetValue(1).ToString();
}
//}
return(v_return);
}
protected void btnDuplicate_Click(object sender, EventArgs e)
{
string rowCode = GridView1.DataKeys[0].Value.ToString();
if (this.GridView1.Rows.Count > 0)
{
if (rowCode.Length > 0)
{
OracleParameter[] parms = new OracleParameter[2];
parms[0] = new OracleParameter();
parms[0] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, rowCode);
parms[1] = new OracleParameter();
parms[1] = _dbConfig.Oracle_Param("p_retval", OracleType.VarChar, ParameterDirection.Output, "");
//DataSet ds = _dbConfig.Oracle_GetDataSetSP("sp_duplicate_dd", parms);
_dbConfig.Oracle_GetDataSetSP_DML("sp_duplicate_dd", parms);
if (CRUtlityGetsafeString(parms[1].Value).Length > 0)
{
string[] result = CRUtlityGetsafeString(parms[1].Value).Split(';');
if (result[0] == "0")
{
this.lblMessage.Visible = true;
this.lblMessage.Text = result[1];
this.lblRecord.Visible = false;
}
else
{
this.lblRecord.Visible = true;
this.lblRecord.Text = result[1];
this.lblMessage.Visible = false;
}
}
}
}
}
public string spRow_Updation(string rowid, string beneName, string AccountNO, string beneid, string Type)
{
string v_return = "";
OracleParameter[] parm = new OracleParameter[7];
parm[0] = _dbConfig.Oracle_Param("p_benename", OracleType.VarChar, ParameterDirection.Input, beneName);
parm[1] = _dbConfig.Oracle_Param("p_accountnumber", OracleType.VarChar, ParameterDirection.Input, AccountNO);
parm[2] = _dbConfig.Oracle_Param("p_beneficiaryid", OracleType.VarChar, ParameterDirection.Input, beneid);
parm[3] = _dbConfig.Oracle_Param("p_userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString());
parm[4] = _dbConfig.Oracle_Param("p_type", OracleType.VarChar, ParameterDirection.Input, Type);
parm[5] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, rowid);
parm[6] = _dbConfig.Oracle_Param("p_retval", OracleType.VarChar, ParameterDirection.Output, "");
v_return = _dbConfig.Oracle_GetDataSetSP_DML("sp_amedment_afterPublish", parm, 6);
if (v_return.StartsWith("04") == false)
{
lblMessage.Text = v_return.Split(',').GetValue(1).ToString();
return(v_return);
}
else
{
lblMessage.Text = v_return.Split(',').GetValue(1).ToString();
}
return(v_return);
}
public string spRow_Updation(string rowid, string beneName, string AccountNO, string Type)
{
string v_return = "";
//for (int i = 0; i < GridView1.Rows.Count; i++)
//{
//if (((CheckBox)GridView1.Rows[i].FindControl("cbPublish")).Checked == true)
OracleParameter[] parm = new OracleParameter[26];
int pno = 0;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_BENENAME", OracleType.VarChar, ParameterDirection.Input, beneName);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_BENEADDRESS", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_CONTACTNUMBER", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_CNIC", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_REMENAME", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_DATEOFREME", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_CUSTOMERREFERENCENUMBER", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_ACCOUNTNUMBER", OracleType.VarChar, ParameterDirection.Input, AccountNO);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_XPIN", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_COVERAMOUNT", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_EXCHANGERATE", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_TRANSAMOUNT", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_BANK", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_BANK_CODE", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_BRANCH_CODE", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_BRANCH_NAME", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_BRANCH_ADDRESS", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_FXCODE", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_COUNTRY", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_Userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString());
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_type", OracleType.VarChar, ParameterDirection.Input, Type);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, rowid);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, "");
v_return = _dbConfig.Oracle_GetDataSetSP_DML("SP_Data_Segregation_updation", parm, pno);
if (v_return.StartsWith("04") == false)
{
lblMessage.Text = v_return.Split(',').GetValue(1).ToString();
return(v_return);
}
else
{
lblMessage.Text = v_return.Split(',').GetValue(1).ToString();
}
//}
return(v_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 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;
}
}
}
}
void DMLOperation(string Action)
{
OracleParameter[] parms = new OracleParameter[15];
for (int i = 0; i < grd_matrix.Rows.Count; i++)
{
GetTemplateControlReference(i);
if (txtfrmamt.Text != "")
{
parms[0] = new OracleParameter();
parms[0] = obj_DBLayer.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, ddlcompany.SelectedValue);
parms[1] = new OracleParameter();
parms[1] = obj_DBLayer.Oracle_Param("P_product_code", OracleType.VarChar, ParameterDirection.Input, ddlproduct.SelectedValue);
parms[2] = new OracleParameter();
parms[2] = obj_DBLayer.Oracle_Param("P_follow_seq", OracleType.VarChar, ParameterDirection.Input, chkflowSeq.Checked == true ? "Y" : "N");
parms[3] = new OracleParameter();
parms[3] = obj_DBLayer.Oracle_Param("P_from_amount", OracleType.VarChar, ParameterDirection.Input, txtfrmamt.Text);
parms[4] = new OracleParameter();
parms[4] = obj_DBLayer.Oracle_Param("P_to_amount", OracleType.VarChar, ParameterDirection.Input, txttoamt.Text);
parms[5] = new OracleParameter();
parms[5] = obj_DBLayer.Oracle_Param("P_maker_cat", OracleType.VarChar, ParameterDirection.Input, ddlMak.SelectedItem.Text);
parms[6] = new OracleParameter();
parms[6] = obj_DBLayer.Oracle_Param("P_check_cat", OracleType.VarChar, ParameterDirection.Input, ddlChk.SelectedItem.Text);
parms[7] = new OracleParameter();
parms[7] = obj_DBLayer.Oracle_Param("P_no_of_sign", OracleType.VarChar, ParameterDirection.Input, txtnumofSign.Text);
parms[8] = new OracleParameter();
parms[8] = obj_DBLayer.Oracle_Param("P_single_cat", OracleType.VarChar, ParameterDirection.Input, ddlSingle.SelectedItem.Text);
parms[9] = new OracleParameter();
parms[9] = obj_DBLayer.Oracle_Param("P_dual_cat", OracleType.VarChar, ParameterDirection.Input, ddlDual.SelectedItem.Text);
parms[10] = new OracleParameter();
parms[10] = obj_DBLayer.Oracle_Param("P_triple_cat", OracleType.VarChar, ParameterDirection.Input, ddlTriple.SelectedItem.Text);
parms[11] = new OracleParameter();
parms[11] = obj_DBLayer.Oracle_Param("P_publisher", OracleType.VarChar, ParameterDirection.Input, ddlPublish.SelectedItem.Text);
parms[12] = new OracleParameter();
parms[12] = obj_DBLayer.Oracle_Param("P_User", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString());
parms[13] = new OracleParameter();
parms[13] = obj_DBLayer.Oracle_Param("P_active", OracleType.VarChar, ParameterDirection.Input, chkactive.Checked == true ? "Y" : "N");
parms[14] = new OracleParameter();
parms[14] = obj_DBLayer.Oracle_Param("P_What", OracleType.VarChar, ParameterDirection.Input, Action);
obj_DBLayer.Oracle_GetDataSetSP_DML("SP_DMLAuthorizationMatrix", parms);
parms.Initialize();
}
}
}