private void insertXML()
{
StringBuilder Doc_Detail = new StringBuilder();
string Pur_num = string.Empty;
string rtr = string.Empty;
string isdata = string.Empty;
string XmlString = string.Empty;
string isSaved;
XmlString += "|ROWSET||";
try
{
DataTable dt = (DataTable)ActionController.ExecuteAction("", "SAP_Employee_Data.aspx", "getusers", ref isdata);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Pur_num += dt.Rows[i]["EMP_ID"].ToString() + '=';
Pur_num += "201502" + '=';
Pur_num += '-';
}
Vendor_Portal.Vendor_Portal_DetailsService Vendor = new Vendor_Portal.Vendor_Portal_DetailsService();
string[] Vendor_data_array = new string[2];
Vendor_data_array = Vendor.MOBILE_DEDUCTION(Pur_num.ToString());
string[] cmpanyArray;
cmpanyArray = Vendor_data_array[0].Split('|');
if (cmpanyArray.Length > 0)
{
for (int j = 0; j < cmpanyArray.Length - 1; j++)
{
string[] CompanyCode_Data;
CompanyCode_Data = cmpanyArray[j].Split('$');
XmlString += "|ROW||";
XmlString += "|PERNR||" + Convert.ToString(CompanyCode_Data[0]) + "|/PERNR||";
XmlString += "|YYMM||" + CompanyCode_Data[1] + "|/YYMM||";
XmlString += "|AMOUNT||" + CompanyCode_Data[2] + "|/AMOUNT||";
XmlString += "|WAERS||" + CompanyCode_Data[3] + "|/WAERS||";
XmlString += "|/ROW||";
}
}
XmlString += "|/ROWSET||";
string inser_FileXML = XmlString;
inser_FileXML = inser_FileXML.Replace("&", "&");
inser_FileXML = inser_FileXML.Replace(">", ">");
inser_FileXML = inser_FileXML.Replace("<", "<");
inser_FileXML = inser_FileXML.Replace("||", ">");
inser_FileXML = inser_FileXML.Replace("|", "<");
inser_FileXML = inser_FileXML.Replace("'", "'");
XmlString = inser_FileXML.ToString();
isSaved = (string)ActionController.ExecuteAction("", "SAP_Employee_Data.aspx", "mobilededuction", ref isdata, XmlString);
}
}
catch (Exception Exc) { Logger.WriteEventLog(false, Exc); }
}
public string RFC_CAll(string Vendor_code, string PO_Number, string Transpoter_Name, string Vehicle_No, string Contact_Person, string Contact_Person_No, string LR_No, string LR_Date, string Invoice_No, string Invoice_Date, string Invoice_Amount, string Delivery_Note, string Unique_Id, string RFC_DTL)
{
string SAP_Message = string.Empty;
Vendor_Portal.Vendor_Portal_DetailsService Dispatch_Note = new Vendor_Portal.Vendor_Portal_DetailsService();
string[] Dispatch_Array = new string[2];
Dispatch_Array = Dispatch_Note.VENDOR_UNIQUE_ID(Vendor_code, PO_Number, Transpoter_Name, Vehicle_No, Contact_Person, Contact_Person_No, LR_No, LR_Date, Invoice_No, Invoice_Date, Invoice_Amount, Delivery_Note, Unique_Id, RFC_DTL);
SAP_Message = Dispatch_Array[0];
return(SAP_Message);
}
public string RFC_CAll(string Vendor_code, string PO_Number, string Transpoter_Name, string Vehicle_No, string Contact_Person, string Contact_Person_No, string LR_No, string LR_Date, string Invoice_No, string Invoice_Date, string Invoice_Amount, string Delivery_Note, string Unique_Id, string BUDAT, string TXTZ01, string LBLNE, string DLORT, string LZVON, string LZBIS, string SBNAMAG, string SBNAMAN, string RFC_DTL)
{
string SAP_Message = string.Empty;
Vendor_Portal.Vendor_Portal_DetailsService Dispatch_Note = new Vendor_Portal.Vendor_Portal_DetailsService();
string[] Dispatch_Array = new string[2];
Dispatch_Array = Dispatch_Note.PO_VENDOR_UNIQUE_ID(Vendor_code, PO_Number, Transpoter_Name, Vehicle_No, Contact_Person, Contact_Person_No, LR_No, LR_Date, Invoice_No, Invoice_Date, Invoice_Amount, Delivery_Note, Unique_Id, BUDAT, TXTZ01, LBLNE, DLORT, LZVON, LZBIS, SBNAMAG, SBNAMAN, RFC_DTL);
SAP_Message = Dispatch_Array[1] + '$' + Dispatch_Array[0];
return(SAP_Message);
}
public string ACCOUNT_RFC_CAll(string Unique_No, string Status)
{
string SAP_Message = string.Empty;
Vendor_Portal.Vendor_Portal_DetailsService Dispatch_Note = new Vendor_Portal.Vendor_Portal_DetailsService();
string[] Dispatch_Array = new string[2];
Dispatch_Array = Dispatch_Note.TAX_INVOICE_HARD_COPY(Unique_No, Status);
SAP_Message = Dispatch_Array[0];
return(SAP_Message);
}
protected void btnRequest_Click(object sender, EventArgs e)
{
try
{
ActionController.DisablePageCaching(this);
if (ActionController.IsSessionExpired(this))
{
ActionController.RedirctToLogin(this);
}
else
{
divins.Style.Add("display", "none");
string refData = string.Empty;
string alert_message = string.Empty;
string rfc_string = string.Empty;
string cash_flag = string.Empty;
string cash_no = string.Empty;
string bank_flag = string.Empty;
string bank_no = string.Empty;
string rfc_no = "";
DataSet dt_sap_rfc = (DataSet)ActionController.ExecuteAction("", "Advance_Return_Request.aspx", "getcashrfc", ref refData, spn_ret_no.InnerHtml);
if (dt_sap_rfc != null)
{
DataTable dtManage = (DataTable)ActionController.ExecuteAction("", "Bulk_Travel_Expense_Doc_Verification.aspx", "saverfcdata1", ref refData, spn_ret_no.InnerHtml, "SELECT", "", "", "", "", "", "", "");
if (dtManage != null && dtManage.Rows.Count > 0)
{
cash_flag = Convert.ToString(dtManage.Rows[0]["CASH_FLAG"]);
cash_no = Convert.ToString(dtManage.Rows[0]["CASH_NO"]);
rfc_string = cash_flag;
rfc_no = cash_no;
}
if (dt_sap_rfc.Tables[1].Rows.Count > 0)
{
if (cash_flag == "E" || cash_flag == "")
{
Vendor_Portal.Vendor_Portal_DetailsService Vendor = new Vendor_Portal.Vendor_Portal_DetailsService();
string[] Vendor_data_array = new string[3];
Vendor_data_array = Vendor.CASH_LEGDER(Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][0]), Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][1]), Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][2]),
Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][3]), Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][4]), Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][5]), Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][6]),
Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][7]), "", Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][9]), Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][10]),
Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][11]), Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][12]), Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][13]),
Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][14]), Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][15]), Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][16]), Convert.ToString(dt_sap_rfc.Tables[1].Rows[0][17]));
rfc_string = Vendor_data_array[1];
if (rfc_string != "E" && rfc_string != "")
{
string[] sp_data1 = Convert.ToString(Vendor_data_array[0]).Split(' ');
for (int k = 0; k < sp_data1.Length; k++)
{
if (Convert.ToString(sp_data1[k]).Length == 10 && rfc_no == "")
{
cash_no = rfc_no = Convert.ToString(sp_data1[k]);
alert_message = "Data Posted Successfully : " + Convert.ToString(cash_no);
}
}
}
else
{
alert_message = Vendor_data_array[0];
}
string rfc = (string)ActionController.ExecuteAction("", "Bulk_Travel_Expense_Doc_Verification.aspx", "saverfcdata", ref refData, spn_ret_no.InnerHtml, "CASH", Convert.ToString(Vendor_data_array[1]).ToUpper(), rfc_no, Convert.ToString(Vendor_data_array[0]), "", "", "", spn_ret_no.InnerHtml);
}
else
{
rfc_string = "S";
alert_message = "Data Posted Successfully : " + Convert.ToString(cash_no);
}
}
}
if (rfc_string != "E" && rfc_string != "")
{
condition.Text = "1";
advtype.Text = "1";
string isSaved = (string)ActionController.ExecuteAction("", "Advance_Return_Request.aspx", "update", ref refData, return_pk_id.Text, txt_pk_id.Text, condition.Text, txt_Username.Text, advtype.Text);
if (isSaved == null || isSaved == "" || refData.Length > 0 || isSaved == "false")
{
//string[] errmsg = refData.Split(':');
ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", "alert('" + refData.ToString() + "')", true);
}
else
{
string[] Dval = new string[1];
Dval[0] = txt_Username.Text;
bool isCreate1 = (bool)WFE.Action.ReleaseStep(txtProcessID.Text, txtInstanceID.Text, "288", "ADVANCE RETURN APPROVAL", "SUBMIT", txt_Username.Text, txt_Username.Text.Trim(), "", "", "", "", "", "", "", "", "", "", Dval, spn_ret_no.InnerHtml, txtWIID.Text, ref refData);
if (isCreate1)
{
try
{
string auditid = (string)ActionController.ExecuteAction(txt_Username.Text, "Advance_Return_Request.aspx", "insertaudittrail", ref refData, txtProcessID.Text, txtInstanceID.Text, "ADVANCE RETURN APPROVAL", "USER", txt_Username.Text, "SUBMIT", spn_return_remark.InnerHtml, "0", "0");
string msg = "<pre><font size='3'>Dear Sir/Madam,</font></pre><p/> <pre><font size='3'>Advance Return Request has been Processed Successfully.</font></pre><p/> <pre><font size='3'>Request No: " + spn_ret_no.InnerHtml + "</font></pre> <pre><font size='3'>Created By: " + span_ename.InnerHtml + "</font></pre></p><pre>INTERNET URL:https://" + compname + "/Sudarshan-Portal/Login.aspx</pre><pre></pre><br/><pre><font size='3' color='red'><i><b>This is a system generated message. We request you not to reply to this message.</b></i></font></pre>";
string emailid = (string)ActionController.ExecuteAction(txt_Username.Text, "Advance_Return_Request.aspx", "insetmaildata", ref refData, txtProcessID.Text, txtInstanceID.Text, 0, "ADVANCE RETURN APPROVAL", "SUBMIT", txtEmailID.Text, "", msg, "Request No: " + spn_ret_no.InnerHtml);
}
catch (Exception)
{
throw;
}
finally
{
string msg2 = "alert('Advance Return Request Has Been Processed Successfully : " + rfc_no + "...!');window.open('../../Portal/SCIL/Home.aspx','frmset_WorkArea')";
ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", msg2, true);
}
}
}
}
else
{
string msg2 = alert_message;
ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", msg2, true);
}
}
}
catch (Exception Exc) { Logger.WriteEventLog(false, Exc); }
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
ActionController.DisablePageCaching(this);
if (ActionController.IsSessionExpired(this))
{
ActionController.RedirctToLogin(this);
}
else
{
divIns.Style.Add("display", "none");
string refData = string.Empty;
string isInserted = string.Empty;
string ISValid = string.Empty;
/***************************************************************************************************************************************************************/
string rfc_string = string.Empty;
string rfc_string1 = string.Empty;
string line_item = string.Empty;
string bank_flag = string.Empty;
string bank_no = string.Empty;
string rfc_no = "";
string rfc_flag = "";
string alert_msg = "";
DataTable dtManage = (DataTable)ActionController.ExecuteAction("", "Bulk_Travel_Expense_Doc_Verification.aspx", "saverfcdata1", ref refData, spn_ret_no.InnerHtml, "SELECT", "", "", "", "", "", "", "");
if (dtManage != null && dtManage.Rows.Count > 0)
{
bank_flag = Convert.ToString(dtManage.Rows[0]["BANK_FLAG"]);
bank_no = Convert.ToString(dtManage.Rows[0]["BANK_NO"]);
}
if (bank_flag == "E" || bank_flag == "")
{
string rfc_action = "";
DataSet dt_sap_rfc = (DataSet)ActionController.ExecuteAction("", "Advance_Return_Request.aspx", "getbankrfc", ref refData, 0, rfc_action, spn_ret_no.InnerHtml, 1, a_adv_amount.Text, a_exp_amount.Text);
if (dt_sap_rfc != null)
{
if (dt_sap_rfc.Tables[0].Rows.Count > 0)
{
string ref_no = Convert.ToString(dt_sap_rfc.Tables[0].Rows[0][0]);
}
if (dt_sap_rfc.Tables[1].Rows.Count > 0)
{
for (int index = 0; index < dt_sap_rfc.Tables[1].Rows.Count; index++)
{
if (rfc_string == "")
{
rfc_string += Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["COMP_CODE"]);
}
else
{
rfc_string += "|" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["COMP_CODE"]);
}
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["DOC_DATE"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["PSTNG_DATE"]);
rfc_string += "$";
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["DOC_TYPE"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["REF_DOC_NO"]);
rfc_string += "$" + (index + 1).ToString();
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["GL_ACCOUNT"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["REF_KEY_1"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["VENDOR_NO"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["ALLOC_NMBR"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["ITEM_TEXT"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["BUS_AREA"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["COSTCENTER"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["PROFIT_CTR"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["CURRENCY"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["AMT_DOCCUR"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["ZLSCH"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["PERSON_NO"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["SECCO"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["BUPLA"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["ZFBDT"]);
rfc_string += "$ ";
}
}
}
rfc_string1 = rfc_string;
if (rfc_string1 != "")
{
string ref_key_no = "";
line_item = getLine_Item();
Vendor_Portal.Vendor_Portal_DetailsService Vendor = new Vendor_Portal.Vendor_Portal_DetailsService();
string[] Vendor_data_array = new string[3];
Vendor_data_array = Vendor.BANK_DETAILS(rfc_string1, line_item);
// Vendor_data_array[0] = "";
rfc_flag = Convert.ToString(Vendor_data_array[1]);
alert_msg = Convert.ToString(Vendor_data_array[0]);
string[] sp_data = Convert.ToString(Vendor_data_array[0]).Split(' ');
if (Convert.ToString(Vendor_data_array[1]) == "S")
{
for (int k = 0; k < sp_data.Length; k++)
{
if (Convert.ToString(sp_data[k]).ToUpper().Contains("SCIL"))
{
rfc_no = Convert.ToString(sp_data[k]).Substring(0, 10);
}
}
}
string rfc = (string)ActionController.ExecuteAction("", "Bulk_Travel_Expense_Doc_Verification.aspx", "saverfcdata", ref refData, spn_ret_no.InnerHtml, "BANK", "", "", "", Convert.ToString(Vendor_data_array[1]).ToUpper(), rfc_no, Convert.ToString(Vendor_data_array[0]), ref_key_no);
}
}
else
{
rfc_flag = "S";
rfc_no = bank_no;
alert_msg = "Advance Return Request Has Been Completed Successfully : " + rfc_no;
}
//Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + alert_msg + "...!');}</script>");
/***************************************************************************************************************************************/
if (Convert.ToString(rfc_flag) != "E" && Convert.ToString(rfc_flag) != "")
{
string isSaved = (string)ActionController.ExecuteAction("", "Advance_Return_Request.aspx", "insertfta", ref refData, txt_StepId.Text, txtInstanceID.Text, 2, return_pk_id.Text, txt_Username.Text, "", req_base_currency.InnerHtml, 0, 0, txt_ret_money.Text, txt_exc_rate.Text, tbl_adv.InnerHtml, tbl_exp.InnerHtml, (Convert.ToDouble(req_base_currency.InnerHtml) - Convert.ToDouble(txt_ret_money.Text)), 2, 0);
if (isSaved == null || isSaved == "" || refData.Length > 0 || isSaved == "false")
{
//string[] errmsg = refData.Split(':');
ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", "alert('" + refData.ToString() + "')", true);
}
else
{
string[] Dval = new string[1];
Dval[0] = txt_Username.Text;
bool isCreate1 = (bool)WFE.Action.ReleaseStep(txt_StepId.Text, txtInstanceID.Text, "291", "ADVANCE RETURN FOREIGN APPROVAL", "SUBMIT", txt_Username.Text, txt_Username.Text.Trim(), "", "", "", "", "", "", "", "", "", "", Dval, isSaved, txtWIID.Text, ref refData);
if (isCreate1)
{
try
{
string auditid = (string)ActionController.ExecuteAction(txt_Username.Text, "Advance_Return_Request.aspx", "insertaudittrail", ref isInserted, txt_StepId.Text, txtInstanceID.Text, "ADVANCE RETURN FOREIGN APPROVAL", "USER", txt_Username.Text, "SUBMIT", "", "0", "0");
string msg = "<pre><font size='3'>Dear Sir/Madam,</font></pre><p/> <pre><font size='3'>Advance Return Request has been Completed Successfully.</font></pre><p/> <pre><font size='3'>Request No: " + isSaved + "</font></pre> <pre><font size='3'>Created By: " + lbl_EmpName.Text + "</font></pre></p><pre>INTERNET URL:https://" + compname + "/Sudarshan-Portal/Login.aspx</pre><pre></pre><br/><pre><font size='3' color='red'><i><b>This is a system generated message. We request you not to reply to this message.</b></i></font></pre>";
string emailid = (string)ActionController.ExecuteAction(txt_Username.Text, "Advance_Return_Request.aspx", "insetmaildata", ref isInserted, txt_StepId.Text, txtInstanceID.Text, 0, "ADVANCE RETURN FOREIGN APPROVAL", "SUBMIT", txtEmailID.Text, "", msg, "Request No: " + isSaved);
}
catch (Exception)
{
throw;
}
finally
{
string msg2 = "alert('Advance Return Request Has Been Completed Successfully : " + rfc_no + "...!');window.open('../../Portal/SCIL/Home.aspx','frmset_WorkArea')";
ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", msg2, true);
}
}
}
}
else
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + alert_msg + "...!');window.open('../../Portal/SCIL/Home.aspx','frmset_WorkArea');}</script>");
}
/**************************************************************************************************************************************************************/
}
}
catch (Exception Exc) { Logger.WriteEventLog(false, Exc); }
}
protected void btnExport_Click(object sender, EventArgs e)
{
DataSet dt_sap_rfc = new DataSet();
try
{
divIns.Style.Add("display", "none");
string data = string.Empty;
DataTable dt = new DataTable();
if (json_data.Text.ToUpper() == "HDFC")
{
dt.Columns.AddRange(new DataColumn[28] {
new DataColumn("Transaction Type"), new DataColumn("Blank1"), new DataColumn("Beneficiary Account Number"), new DataColumn("Instrument Amount"), new DataColumn("Beneficiary Name"), new DataColumn("Blank2"), new DataColumn("Blank3"), new DataColumn("Bene Address 1"), new DataColumn("Bene Address 2"), new DataColumn("Bene Address 3"), new DataColumn("Bene Address 4"), new DataColumn("Bene Address 5"), new DataColumn("Instruction Reference Number"), new DataColumn("Customer Reference Number"), new DataColumn("Payment details 1"), new DataColumn("Payment details 2"), new DataColumn("Payment details 3"), new DataColumn("Payment details 4"), new DataColumn("Payment details 5"), new DataColumn("Payment details 6"), new DataColumn("Payment details 7"), new DataColumn("Blank4"), new DataColumn("Transaction Date"), new DataColumn("Blank5"), new DataColumn("IFSC Code"), new DataColumn("Bene Bank Name"), new DataColumn("Bene Bank Branch Name"), new DataColumn("Beneficiary email id")
});
foreach (GridViewRow grow in gvhdfc1.Rows)
{
CheckBox chkdel = (CheckBox)grow.FindControl("chkCtrl");
if (chkdel.Checked)
{
string f1 = Convert.ToString(grow.Cells[1].Text);
string f2 = Convert.ToString(grow.Cells[2].Text);
string f3 = Convert.ToString(grow.Cells[3].Text);
string f4 = Convert.ToString(grow.Cells[4].Text);
string f5 = Convert.ToString(grow.Cells[5].Text);
string f6 = Convert.ToString(grow.Cells[6].Text);
string f7 = Convert.ToString(grow.Cells[7].Text);
string f8 = Convert.ToString(grow.Cells[8].Text);
string f9 = Convert.ToString(grow.Cells[9].Text);
string f10 = Convert.ToString(grow.Cells[10].Text);
string f11 = Convert.ToString(grow.Cells[11].Text);
string f12 = Convert.ToString(grow.Cells[12].Text);
string f13 = Convert.ToString(grow.Cells[13].Text);
string f14 = Convert.ToString(grow.Cells[14].Text);
string f15 = Convert.ToString(grow.Cells[15].Text);
string f16 = Convert.ToString(grow.Cells[16].Text);
string f17 = Convert.ToString(grow.Cells[17].Text);
string f18 = Convert.ToString(grow.Cells[18].Text);
string f19 = Convert.ToString(grow.Cells[19].Text);
string f20 = Convert.ToString(grow.Cells[20].Text);
string f21 = Convert.ToString(grow.Cells[21].Text);
string f22 = Convert.ToString(grow.Cells[22].Text);
string f23 = Convert.ToString(grow.Cells[23].Text);
string f24 = Convert.ToString(grow.Cells[24].Text);
string f25 = Convert.ToString(grow.Cells[25].Text);
string f26 = Convert.ToString(grow.Cells[26].Text);
string f27 = Convert.ToString(grow.Cells[27].Text);
string f28 = Convert.ToString(grow.Cells[28].Text);
dt.Rows.Add(f1, f2, f3, f4, f5, f6, f7, f8, f9, f10, f11, f12, f13, f14, f15, f16, f17, f18, f19, f20, f21, f22, f23, f24, f25, f26, f27, f28);
if (data == "")
{
data = f15;
}
else
{
data += "," + f15;
}
}
}
gvhdfc2.DataSource = dt;
gvhdfc2.DataBind();
}
else if (json_data.Text.ToUpper() == "HSBC")
{
dt.Columns.AddRange(new DataColumn[21] {
new DataColumn("Transaction Type"), new DataColumn("Reference Number1"), new DataColumn("Dr Account No"), new DataColumn("Bene Name"), new DataColumn("Remitter A/c no"), new DataColumn("Remitter Name"), new DataColumn("Narration"), new DataColumn("Value Date"), new DataColumn("Amount"), new DataColumn("eMail Address 1"), new DataColumn("eMail Address 2"), new DataColumn("eMail Address 3"), new DataColumn("Advise Col1"), new DataColumn("Advise Col2"), new DataColumn("Advise Col3"), new DataColumn("Advise Col4"), new DataColumn("Advise Col5"), new DataColumn("Bene Bank Account"), new DataColumn("BeneRTGSCodes"), new DataColumn("Bene Bank Name"), new DataColumn("Reference Number")
});
foreach (GridViewRow grow in gvDetails.Rows)
{
CheckBox chkdel = (CheckBox)grow.FindControl("chkCtrl");
if (chkdel.Checked)
{
string f1 = Convert.ToString(grow.Cells[1].Text);
string f2 = Convert.ToString(grow.Cells[2].Text);
string f3 = Convert.ToString(grow.Cells[3].Text);
string f4 = Convert.ToString(grow.Cells[4].Text);
string f5 = Convert.ToString(grow.Cells[5].Text);
string f6 = Convert.ToString(grow.Cells[6].Text);
string f7 = Convert.ToString(grow.Cells[7].Text);
string f8 = Convert.ToString(grow.Cells[8].Text);
string f9 = Convert.ToString(grow.Cells[9].Text);
string f10 = Convert.ToString(grow.Cells[10].Text);
string f11 = Convert.ToString(grow.Cells[11].Text);
string f12 = Convert.ToString(grow.Cells[12].Text);
string f13 = Convert.ToString(grow.Cells[13].Text);
string f14 = Convert.ToString(grow.Cells[14].Text);
string f15 = Convert.ToString(grow.Cells[15].Text);
string f16 = Convert.ToString(grow.Cells[16].Text);
string f17 = Convert.ToString(grow.Cells[17].Text);
string f18 = Convert.ToString(grow.Cells[18].Text);
string f19 = Convert.ToString(grow.Cells[19].Text);
string f20 = Convert.ToString(grow.Cells[20].Text);
string f21 = Convert.ToString(grow.Cells[21].Text);
dt.Rows.Add(f1, f2, f3, f4, f5, f6, f7, f8, f9, f10, f11, f12, f13, f14, f15, f16, f17, f18, f19, f20, f21);
if (data == "")
{
data = f21;
}
else
{
data += "," + f21;
}
}
}
gvSelected.DataSource = dt;
gvSelected.DataBind();
}
if (data != "")
{
try
{
// Response.End();
}
catch (Exception ex)
{ }
finally
{
string ref_key_no = "";
string rfc_string1 = string.Empty;
string ref_data = string.Empty;
string[] values = data.Split(',');
int cnt;
for (int i = 0; i < values.Length; i++)
{
if (i == 0)
{
cnt = 1;
}
else
{
cnt = 0;
}
string rfc_string = string.Empty;
string rfc_action = return_msg(values[i]);
dt_sap_rfc = (DataSet)ActionController.ExecuteAction("", "Bulk_Travel_Expense_Doc_Verification.aspx", "getbankrfc", ref ref_data, pk_bank_id.Text, rfc_action, values[i], cnt);
if (dt_sap_rfc != null)
{
if (dt_sap_rfc.Tables[0].Rows.Count > 0)
{
string ref_no = Convert.ToString(dt_sap_rfc.Tables[0].Rows[0][0]);
}
if (dt_sap_rfc.Tables[1].Rows.Count > 0)
{
for (int index = 0; index < dt_sap_rfc.Tables[1].Rows.Count; index++)
{
if (rfc_string == "")
{
rfc_string += Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["COMP_CODE"]);
}
else
{
rfc_string += "|" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["COMP_CODE"]);
}
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["DOC_DATE"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["PSTNG_DATE"]);
rfc_string += "$";
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["DOC_TYPE"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["REF_DOC_NO"]);
rfc_string += "$" + (index + 1).ToString();
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["GL_ACCOUNT"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["REF_KEY_1"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["VENDOR_NO"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["ALLOC_NMBR"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["ITEM_TEXT"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["BUS_AREA"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["COSTCENTER"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["PROFIT_CTR"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["CURRENCY"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["AMT_DOCCUR"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["ZLSCH"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["PERSON_NO"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["SECCO"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["BUPLA"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["ZFBDT"]);
rfc_string += "$ ";
}
}
}
rfc_string1 = rfc_string;
}
if (rfc_string1 != "")
{
DataTable dtBank = (DataTable)ActionController.ExecuteAction("", "Bulk_Travel_Expense_Doc_Verification.aspx", "getbankrfcsum", ref ref_data, pk_bank_id.Text);
if (dtBank != null && dtBank.Rows.Count > 0)
{
int li = dt_sap_rfc.Tables[1].Rows.Count + 1;
ref_key_no = Convert.ToString(dtBank.Rows[0]["REF_DOC_NO"]);
if (rfc_string1 == "")
{
rfc_string1 += Convert.ToString(dtBank.Rows[0]["COMP_CODE"]);
}
else
{
rfc_string1 += "|" + Convert.ToString(dtBank.Rows[0]["COMP_CODE"]);
}
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["DOC_DATE"]);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["PSTNG_DATE"]);
rfc_string1 += "$";
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["DOC_TYPE"]);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["REF_DOC_NO"]);
rfc_string1 += "$" + Convert.ToString(li);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["GL_ACCOUNT"]);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["REF_KEY_1"]);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["VENDOR_NO"]);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["REF_DOC_NO"]);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["ITEM_TEXT"]);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["BUS_AREA"]);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["COSTCENTER"]);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["PROFIT_CTR"]);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["CURRENCY"]);
rfc_string1 += "$" + Convert.ToInt32(dtBank.Rows[0]["AMT_DOCCUR"]);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["ZLSCH"]);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["PERSON_NO"]);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["SECCO"]);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["BUPLA"]);
rfc_string1 += "$" + Convert.ToString(dtBank.Rows[0]["ZFBDT"]);
rfc_string1 += "$ ";
}
}
Vendor_Portal.Vendor_Portal_DetailsService Vendor = new Vendor_Portal.Vendor_Portal_DetailsService();
string[] Vendor_data_array = new string[3];
Vendor_data_array = Vendor.BANK_DETAILS(rfc_string1, "");
//Vendor_data_array[0] = "";
string[] values1 = data.Split(',');
string[] sp_data = Convert.ToString(Vendor_data_array[0]).Split(' ');
string rfc_no = "";
if (Convert.ToString(Vendor_data_array[1]) == "S")
{
for (int k = 0; k < sp_data.Length; k++)
{
if (Convert.ToString(sp_data[k]).ToUpper().Contains("SCIL"))
{
rfc_no = Convert.ToString(sp_data[k]).Substring(0, 10);
}
}
}
for (int k = 0; k < values1.Length; k++)
{
string rfc = (string)ActionController.ExecuteAction("", "Bulk_Travel_Expense_Doc_Verification.aspx", "saverfcdata", ref ref_data, values1[k], "BANK", "", "", "", Convert.ToString(Vendor_data_array[1]).ToUpper(), rfc_no, Convert.ToString(Vendor_data_array[0]), ref_key_no);
}
if (Convert.ToString(Vendor_data_array[1]).ToUpper() != "E" && Convert.ToString(Vendor_data_array[1]) != "")
{
for (int k = 0; k < values1.Length; k++)
{
string dts = (string)ActionController.ExecuteAction("", "Bulk_Travel_Expense_Doc_Verification.aspx", "changeflag", ref ref_data, txt_Username.Text, json_data.Text, values1[k]);
}
btnExp.Enabled = true;
btnExport.Enabled = false;
gvDetails.Style.Add("display", "none");
gvhdfc1.Style.Add("display", "none");
if (Convert.ToString(Vendor_data_array[1]).ToUpper() == "S")
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Data Posted Successfully : " + rfc_no + "...!');}</script>");
}
else
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Data Posted Successfully : " + Convert.ToString(Vendor_data_array[0]) + "...!');}</script>");
}
}
else
{
gvSelected.Style.Add("display", "none");
gvhdfc2.Style.Add("display", "none");
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + Convert.ToString(Vendor_data_array[0]) + "...!');window.open('../../Portal/SCIL/Home.aspx','frmset_WorkArea');}</script>");
}
}
}
else
{
gvSelected.Style.Add("display", "none");
gvhdfc2.Style.Add("display", "none");
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Please Select atleast One Reference Number...!');}</script>");
}
}
catch (Exception Exc) {
gvSelected.Style.Add("display", "none");
gvhdfc2.Style.Add("display", "none");
FSL.Logging.Logger.WriteEventLog(false, Exc);
}
}
private void insertXML()
{
StringBuilder Doc_Detail = new StringBuilder();
string Pur_num = string.Empty;
string rtr = string.Empty;
string isdata = string.Empty;
string XmlString = string.Empty;
string isSaved;
XmlString += "|ROWSET||";
try
{
DataTable dt = (DataTable)ActionController.ExecuteAction("", "SAP_Employee_Data.aspx", "getusers", ref isdata);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Pur_num += dt.Rows[i]["EMP_ID"].ToString() + '=';
Pur_num += '-';
}
Vendor_Portal.Vendor_Portal_DetailsService Vendor = new Vendor_Portal.Vendor_Portal_DetailsService();
string[] Vendor_data_array = new string[2];
Vendor_data_array = Vendor.CMA_EMPLOYEE_DETAILS(DateTime.Now.ToString("yyyyMMdd"), Pur_num.ToString());
string[] cmpanyArray;
cmpanyArray = Vendor_data_array[0].Split('|');
if (cmpanyArray.Length > 0)
{
for (int j = 0; j < cmpanyArray.Length - 1; j++)
{
string[] CompanyCode_Data;
CompanyCode_Data = cmpanyArray[j].Split('$');
if (CompanyCode_Data[2] != "")
{
XmlString += "|ROW||";
XmlString += "|PERNR||" + Convert.ToString(CompanyCode_Data[0]) + "|/PERNR||";
XmlString += "|TITLE||" + CompanyCode_Data[1] + "|/TITLE||";
XmlString += "|FNAME||" + CompanyCode_Data[2] + "|/FNAME||";
XmlString += "|LNAME||" + CompanyCode_Data[3] + "|/LNAME||";
XmlString += "|CARAL||" + CompanyCode_Data[4] + "|/CARAL||";
XmlString += "|MEDIR||" + CompanyCode_Data[5] + "|/MEDIR||";
XmlString += "|WAERS||" + Convert.ToString(CompanyCode_Data[6]) + "|/WAERS||";
XmlString += "|MBACC||" + CompanyCode_Data[7] + "|/MBACC||";
XmlString += "|MIFSC||" + Convert.ToString(CompanyCode_Data[8]) + "|/MIFSC||";
XmlString += "|TBACC||" + CompanyCode_Data[9] + "|/TBACC||";
XmlString += "|TIFSC||" + CompanyCode_Data[10] + "|/TIFSC||";
XmlString += "|BUKRS||" + CompanyCode_Data[11] + "|/BUKRS||";
XmlString += "|BUTXT||" + CompanyCode_Data[12] + "|/BUTXT||";
XmlString += "|GSBER||" + Convert.ToString(CompanyCode_Data[13]) + "|/GSBER||";
XmlString += "|GTEXT||" + CompanyCode_Data[14] + "|/GTEXT||";
XmlString += "|WERKS||" + CompanyCode_Data[15] + "|/WERKS||";
XmlString += "|WERKT||" + CompanyCode_Data[16] + "|/WERKT||";
XmlString += "|BTRTL||" + CompanyCode_Data[17] + "|/BTRTL||";
XmlString += "|BTRTT||" + CompanyCode_Data[18] + "|/BTRTT||";
XmlString += "|PERSG||" + CompanyCode_Data[19] + "|/PERSG||";
XmlString += "|PERST||" + CompanyCode_Data[20] + "|/PERST||";
XmlString += "|PERSK||" + CompanyCode_Data[21] + "|/PERSK||";
XmlString += "|PERKT||" + CompanyCode_Data[22] + "|/PERKT||";
XmlString += "|ABKRS||" + CompanyCode_Data[23] + "|/ABKRS||";
XmlString += "|ABKRT||" + CompanyCode_Data[24] + "|/ABKRT||";
XmlString += "|KOSTL||" + CompanyCode_Data[25] + "|/KOSTL||";
XmlString += "|KOSTT||" + CompanyCode_Data[26] + "|/KOSTT||";
XmlString += "|ORGEH||" + CompanyCode_Data[27] + "|/ORGEH||";
XmlString += "|ORGTX||" + CompanyCode_Data[28] + "|/ORGTX||";
XmlString += "|ZBYD||" + CompanyCode_Data[29] + "|/ZBYD||";
XmlString += "|ZCPM||" + CompanyCode_Data[30] + "|/ZCPM||";
XmlString += "|ZDCN||" + CompanyCode_Data[31] + "|/ZDCN||";
XmlString += "|CARMN||" + CompanyCode_Data[32] + "|/CARMN||";
XmlString += "|FUELR||" + CompanyCode_Data[33] + "|/FUELR||";
XmlString += "|DRVSL||" + CompanyCode_Data[34] + "|/DRVSL||";
XmlString += "|POSTED_DATE||" + DateTime.Now.ToString("dd.MM.yyy") + "|/POSTED_DATE||";
XmlString += "|ZLOC||" + CompanyCode_Data[35] + "|/ZLOC||";
XmlString += "|ZDIV||" + CompanyCode_Data[36] + "|/ZDIV||";
XmlString += "|/ROW||";
}
}
}
XmlString += "|/ROWSET||";
string inser_FileXML = XmlString;
inser_FileXML = inser_FileXML.Replace("&", "&");
inser_FileXML = inser_FileXML.Replace(">", ">");
inser_FileXML = inser_FileXML.Replace("<", "<");
inser_FileXML = inser_FileXML.Replace("||", ">");
inser_FileXML = inser_FileXML.Replace("|", "<");
inser_FileXML = inser_FileXML.Replace("'", "'");
XmlString = inser_FileXML.ToString();
isSaved = (string)ActionController.ExecuteAction("", "SAP_Employee_Data.aspx", "insertreimbursement", ref isdata, XmlString);
}
}
catch (Exception Exc) {
Logger.WriteEventLog(false, Exc);
}
}
protected string bindReport(string ccode, string fdate, string tdate, string note_line, string searchData, int pageno, int rpp)
{
StringBuilder str = new StringBuilder();
try
{
DataTable dt = new DataTable();
string vcode = Convert.ToString(Session["USER_ADID"]);
// Vendor_Details.Vendor_Portal_DetailsService Vendor = new Vendor_Details.Vendor_Portal_DetailsService();
Vendor_Portal.Vendor_Portal_DetailsService Vendor = new Vendor_Portal.Vendor_Portal_DetailsService();
string[] Vendor_data_array = new string[2];
Vendor_data_array = Vendor.VENDOR_AC_STATEMENT_DETAILS(ccode, vcode, fdate, tdate, note_line);
//Vendor_data_array[0] = "d1$2$$4$5$$v7$2016-03-01$9$10$11$12$$14$15$$17$18$19$20|d1$2$$4$5$$v7$2016-03-01$9$10$11$12$$14$15$$17$18$19$20|d1$2$$4$5$$v7$2016-03-01$9$10$11$12$$14$15$$17$18$19$20|1$2$2016-03-02$4$5$$v7$2016-03-01$9$10$11$12$$14$15$$17$18$19$20|1$2$2016-03-02$4$5$$v7$2016-03-01$9$10$11$12$$14$15$$17$18$19$20|1$2$2016-03-06$4$5$$v7$2016-03-01$9$10$11$12$$14$15$$17$18$19$20|1$2$2016-03-02$4$5$$v7$2016-03-01$9$10$11$12$$14$15$$17$18$19$20|d1$2$$4$5$$v7$2016-03-01$9$10$11$12$$14$15$$17$18$19$20|d1$2$$4$5$$v7$2016-03-01$9$10$11$12$$14$15$$17$18$19$20|d1$2$$4$5$$v7$2016-03-01$9$10$11$12$$14$15$$17$18$19$20|1$2$2016-03-02$4$5$$v7$2016-03-01$9$10$11$12$$14$15$$17$18$19$20|1$2$2016-03-02$4$5$$v7$2016-03-01$9$10$11$12$$14$15$$17$18$19$20|1$2$2016-03-06$4$5$$v7$2016-03-01$9$10$11$12$$14$15$$17$18$19$20|1$2$2016-03-02$4$5$$v7$2016-03-01$9$10$11$12$$14$15$$17$18$19$20";
// Vendor_data_array[1] = "";
if (Convert.ToString(Vendor_data_array[0]) == "")
{
dt = null;
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + Convert.ToString(Vendor_data_array[1]) + "');}</script>");
}
else
{
dt.Columns.Add("CLEAR_DATE");
dt.Columns.Add("CLR_DOC_NO");
dt.Columns.Add("DOC_NO");
dt.Columns.Add("PSTNG_DATE");
dt.Columns.Add("REF_DOC_NO");
dt.Columns.Add("BUS_AREA");
dt.Columns.Add("LC_AMOUNT");
dt.Columns.Add("W_TAX_BASE");
string[] cmpanyArray;
cmpanyArray = Vendor_data_array[0].Split('|');
for (int j = 0; j < cmpanyArray.Length; j++)
{
if (j < cmpanyArray.Length)
{
string[] val;
val = cmpanyArray[j].Split('$');
int flag = 0;
for (int inc = 0; inc < val.Length; inc++)
{
string strData = Convert.ToString(val[inc]);
if (strData.ToLower().Contains(searchData.ToLower()))
{
flag = 1;
}
}
if (flag == 1)
{
string[] CompanyCode_Data;
CompanyCode_Data = cmpanyArray[j].Split('$');
if (CompanyCode_Data.Length != 1)
{
DataRow dr = dt.NewRow();
if (CompanyCode_Data[0] != "0000-00-00" && CompanyCode_Data[0] != "")
{
dr["CLEAR_DATE"] = Convert.ToDateTime(CompanyCode_Data[0]).ToString("dd-MMM-yyyy");
}
else
{
dr["CLEAR_DATE"] = "";
}
dr["CLR_DOC_NO"] = CompanyCode_Data[1];
dr["DOC_NO"] = CompanyCode_Data[2];
if (CompanyCode_Data[3] != "0000-00-00" && CompanyCode_Data[3] != "")
{
dr["PSTNG_DATE"] = Convert.ToDateTime(CompanyCode_Data[3]).ToString("dd-MMM-yyyy");
}
else
{
dr["PSTNG_DATE"] = "";
}
dr["REF_DOC_NO"] = CompanyCode_Data[4];
dr["BUS_AREA"] = CompanyCode_Data[5];
dr["LC_AMOUNT"] = CompanyCode_Data[6];
dr["W_TAX_BASE"] = CompanyCode_Data[7];
dt.Rows.Add(dr);
dt.AcceptChanges();
}
}
}
}
}
str.Append("<div class='row'>");
str.Append("<table class='table table-bordered table-hover'> <thead>");
str.Append("<tr class='grey'><th>Clearing Date</th><th>Clearing Doc No.</th><th>Acc Doc No</th><th>Posting Date</th><th>Ref Doc No</th><th>Business Area</th><th>Amt in Local Currency</th><th>Withholding Tax Base Amount</th></tr> ");
str.Append("</thead><tbody>");
if (dt != null)
{
int from = (pageno - 1) * rpp;
int to = ((pageno - 1) * rpp) + rpp;
for (int i = from; i < to; i++)
{
if (i < dt.Rows.Count)
{
str.Append("<tr class='grey'><td>" + Convert.ToString(dt.Rows[i]["CLEAR_DATE"]) + "</td><td>" + Convert.ToString(dt.Rows[i]["CLR_DOC_NO"]) + "</td><td>" + Convert.ToString(dt.Rows[i]["DOC_NO"]) + "</td><td>" + Convert.ToString(dt.Rows[i]["PSTNG_DATE"]) + "</td><td>" + Convert.ToString(dt.Rows[i]["REF_DOC_NO"]) + "</td><td>" + Convert.ToString(dt.Rows[i]["BUS_AREA"]) + "</td><td>" + Convert.ToString(dt.Rows[i]["LC_AMOUNT"]) + "</td><td>" + Convert.ToString(dt.Rows[i]["W_TAX_BASE"]) + "</td></tr> ");
}
}
}
str.Append("</tbody></table> ");
double cnt = Convert.ToDouble(dt.Rows.Count) / rpp;
if (cnt > Convert.ToInt16(Convert.ToInt32(dt.Rows.Count) / rpp))
{
cnt = (int)cnt + 1;
}
if (cnt > 1)
{
str.Append("<div class='dataTables_paginate paging_simple_numbers' style='text-align:center'>");
str.Append("<ul class='pagination'>");
for (int j = 1; j <= cnt; j++)
{
str.Append("<li class='paginate_button' style='margin:2px;'><input type='button' value='" + j + "' class='btn btn-default buttons-copy buttons-flash' style=' font-weight:normal' onclick='gotopage(this," + rpp + ")'></li>");
}
str.Append("</ul></div>");
}
str.Append("</div>");
}
catch (Exception ex)
{
FSL.Logging.Logger.WriteEventLog(false, ex);
}
return(Convert.ToString(str));
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
ActionController.DisablePageCaching(this);
if (ActionController.IsSessionExpired(this))
{
ActionController.RedirctToLogin(this);
}
else
{
divIns.Style.Add("display", "none");
string isInserted = string.Empty;
string ref_data = string.Empty;
txt_Audit.Text = "FOREIGN ADVANCE REQUEST ACCOUNT PAYABLE APPROVAL";
if (ddlAction.SelectedItem.Text == "Approve")
{
string rfc_flag_chk = string.Empty;
string rfc_flag_no = string.Empty;
/**********************************************************************************************************************************************************/
if (txt_release.Text != "1")
{
string rfc_no = "";
string rfc_string = string.Empty;
string rfc_string1 = string.Empty;
string line_item = string.Empty;
string bank_flag = string.Empty;
string bank_no = string.Empty;
string ref_key_no = "";
DataTable dtManage = (DataTable)ActionController.ExecuteAction("", "Bulk_Travel_Expense_Doc_Verification.aspx", "saverfcdata1", ref ref_data, spn_req_no.Text, "SELECT", "", "", "", "", "", "", "");
if (dtManage != null && dtManage.Rows.Count > 0)
{
bank_flag = Convert.ToString(dtManage.Rows[0]["BANK_FLAG"]);
bank_no = Convert.ToString(dtManage.Rows[0]["BANK_NO"]);
rfc_flag_chk = bank_flag;
rfc_flag_no = bank_no;
}
//bank_flag = "S";
if (bank_flag == "E" || bank_flag == "")
{
string rfc_action = "ADVANCE PAID FOREIGN";
DataSet dt_sap_rfc = (DataSet)ActionController.ExecuteAction("", "Foreign_Advance_Request_Approval.aspx", "getbankrfc1", ref ref_data, 1, rfc_action, spn_req_no.Text, 1, ddlVendor.SelectedValue, inr_amount.Text, serv_amount.Text, vendor_bill.Text);
if (dt_sap_rfc != null)
{
if (dt_sap_rfc.Tables[0].Rows.Count > 0)
{
string ref_no = Convert.ToString(dt_sap_rfc.Tables[0].Rows[0][0]);
ref_key_no = ref_no;
}
if (dt_sap_rfc.Tables[1].Rows.Count > 0)
{
for (int index = 0; index < dt_sap_rfc.Tables[1].Rows.Count; index++)
{
if (rfc_string == "")
{
rfc_string += Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["COMP_CODE"]);
}
else
{
rfc_string += "|" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["COMP_CODE"]);
}
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["DOC_DATE"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["PSTNG_DATE"]);
rfc_string += "$";
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["DOC_TYPE"]);
rfc_string += "$" + vendor_no.Text;
rfc_string += "$" + (index + 1).ToString();
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["GL_ACCOUNT"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["REF_KEY_1"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["VENDOR_NO"]);
rfc_string += "$" + spn_req_no.Text;
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["ITEM_TEXT"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["BUS_AREA"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["COSTCENTER"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["PROFIT_CTR"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["CURRENCY"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["AMT_DOCCUR"]);
rfc_string += "$" + txt_pay_mode_sap.Text.ToUpper();
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["PERSON_NO"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["SECCO"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["BUPLA"]);
rfc_string += "$" + Convert.ToString(dt_sap_rfc.Tables[1].Rows[index]["ZFBDT"]);
rfc_string += "$ ";
}
}
}
rfc_string1 = rfc_string;
if (rfc_string1 != "")
{
line_item = getLine_Item();
//Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + rfc_string1 + "');}</script>");
Vendor_Portal.Vendor_Portal_DetailsService Vendor = new Vendor_Portal.Vendor_Portal_DetailsService();
string[] Vendor_data_array = new string[3];
Vendor_data_array = Vendor.BANK_DETAILS(rfc_string1, line_item);
//Vendor_data_array[0] = "";
rfc_flag_chk = bank_flag = Convert.ToString(Vendor_data_array[1]);
string[] sp_data = Convert.ToString(Vendor_data_array[0]).Split(' ');
if (Convert.ToString(Vendor_data_array[1]) == "S")
{
for (int k = 0; k < sp_data.Length; k++)
{
if (Convert.ToString(sp_data[k]).ToUpper().Contains("SCIL"))
{
rfc_flag_no = rfc_no = Convert.ToString(sp_data[k]).Substring(0, 10);
}
}
}
string rfc = (string)ActionController.ExecuteAction("", "Bulk_Travel_Expense_Doc_Verification.aspx", "saverfcdata", ref ref_data, spn_req_no.Text, "BANK", "", "", "", Convert.ToString(Vendor_data_array[1]).ToUpper(), rfc_no, Convert.ToString(Vendor_data_array[0]), ref_key_no);
}
}
}
else
{
rfc_flag_chk = "S";
}
if (rfc_flag_chk != "E" && rfc_flag_chk != "")
{
txt_Condition.Text = "1";
string isSaved = (string)ActionController.ExecuteAction("", "Foreign_Advance_Request_Approval.aspx", "updatepayment", ref ref_data, txtProcessID.Text, txtInstanceID.Text, txt_inp_rate.Text, ddlVendor.SelectedValue, vendor_no.Text, vendor_bill.Text, ddlFin_Year.SelectedItem.Text, payment_method.Text, tax_code.Text, txt_Username.Text, txt_xml_data_vehicle.Text, ddlApprover.SelectedValue);
if (isSaved == null || ref_data.Length > 0 || isSaved == "false")
{
string[] errmsg = ref_data.Split(':');
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + errmsg[0].ToString() + "');}</script>");
}
else
{
string[] Dval = new string[1];
if (txt_release.Text != "1")
{
Dval[0] = txt_Username.Text;
}
else
{
Dval[0] = acc_approver.Text;
}
bool isCreate = (bool)WFE.Action.ReleaseStep(txtProcessID.Text, txtInstanceID.Text, "276", "FOREIGN ADVANCE REQUEST ACCOUNT PAYABLE APPROVAL", "APPROVE", txt_Username.Text, txt_Username.Text.Trim(), "", "", "", "", "", "", "", "", "", "", Dval, txt_Request.Text, txtWIID.Text, ref isInserted);
if (isCreate)
{
try
{
string msg = "<pre><font size='3'>Dear Sir/Madam,</font></pre><p/> <pre><font size='3'>Foreign Advance Request has been Approved.</font></pre><p/> <pre><font size='3'>Request No: " + spn_req_no.Text + "</font></pre> <pre><font size='3'>Created By: " + lbl_EmpName.Text.Trim() + "</font></pre></p><pre></b><pre>INTERNET URL:https://" + compname + "/Sudarshan-Portal/Login.aspx</pre><pre></pre><br/><pre><font size='3' color='red'><i><b>This is a system generated message. We request you not to reply to this message.</b></i></font></pre>";
string emailid = (string)ActionController.ExecuteAction(txt_Username.Text, "Foreign_Advance_Request.aspx", "insetmaildata", ref isInserted, txtProcessID.Text, txtInstanceID.Text, 0, "FOREIGN ADVANCE REQUEST ACCOUNT PAYABLE APPROVAL", "APPROVE", Init_Email.Text, "", msg, "Request No: " + spn_req_no.Text);
if (txt_release.Text == "1")
{
string pay_email = "";
DataTable DTAP = (DataTable)ActionController.ExecuteAction("", "Domestic_Travel_Request_Approval.aspx", "getaccapprover", ref ref_data, "ACCOUNT PAYMENT PERSONNEL", 0, 2);
if (DTAP != null && DTAP.Rows.Count > 0)
{
for (int cnt = 0; cnt < DTAP.Rows.Count; cnt++)
{
if (acc_approver.Text == Convert.ToString(DTAP.Rows[cnt]["USER_ADID"]))
{
pay_email = Convert.ToString(DTAP.Rows[cnt]["EMAIL_ID"]);
}
}
}
msg = "<pre><font size='3'>Dear Sir/Madam,</font></pre><p/> <pre><font size='3'>Foreign Advance Request has been Approved and Pending for payment.</font></pre><p/><pre><font size='3'>Request No: " + spn_req_no.Text + "</font></pre> <pre><font size='3'>Created By: " + lbl_EmpName.Text.Trim() + "</font></pre></p><pre></b><pre>INTERNET URL:https://" + compname + "/Sudarshan-Portal/Login.aspx</pre><pre></pre><br/><pre><font size='3' color='red'><i><b>This is a system generated message. We request you not to reply to this message.</b></i></font></pre>";
emailid = (string)ActionController.ExecuteAction(txt_Username.Text, "Foreign_Advance_Request.aspx", "insetmaildata", ref isInserted, txtProcessID.Text, txtInstanceID.Text, 0, "FOREIGN ADVANCE REQUEST ACCOUNT PAYABLE APPROVAL", "APPROVE", pay_email, "", msg, "Request No: " + spn_req_no.Text);
}
}
catch (Exception ex)
{
throw;
}
finally
{
if (txt_release.Text != "1")
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Foreign Advance Request has been Approved : " + rfc_flag_no + "');window.open('../../Portal/SCIL/Home.aspx','frmset_WorkArea');}</script>");
}
else
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Foreign Advance Request has been Approved and sent for payment');window.open('../../Portal/SCIL/Home.aspx','frmset_WorkArea');}</script>");
}
}
}
}
}
/***************************************************************************************************************************************/
/**********************************************************************************************************************************************************/
}
else if (ddlAction.SelectedItem.Text == "Reject")
{
txt_Condition.Text = "2";
txt_Audit.Text = "FOREIGN ADVANCE REQUEST ACCOUNT PAYABLE APPROVAL";
string isSaved = (string)ActionController.ExecuteAction("", "Foreign_Advance_Request_Approval.aspx", "update", ref ref_data, Convert.ToInt32(txt_Condition.Text), txtProcessID.Text, txtInstanceID.Text, txt_Audit.Text, txt_Username.Text, spn_Remark.InnerHtml, ddlAction.SelectedItem.Text);
if (isSaved == null || ref_data.Length > 0 || isSaved == "false")
{
string[] errmsg = ref_data.Split(':');
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + errmsg[0].ToString() + "');}</script>");
}
else
{
string[] Dval = new string[1];
Dval[0] = txt_Username.Text;
string ref_data1 = string.Empty;
string release_id = (string)ActionController.ExecuteAction("", "Foreign_Advance_Request.aspx", "getreleaseid", ref ref_data1, txtProcessID.Text, step_name.Text, "REJECT");
if (release_id != "")
{
bool isCreate = (bool)WFE.Action.ReleaseStep(txtProcessID.Text, txtInstanceID.Text, release_id, step_name.Text, "REJECT", txt_Username.Text, txt_Username.Text.Trim(), "", "", "", "", "", "", "", "", "", "", Dval, txt_Request.Text, txtWIID.Text, ref isInserted);
if (isCreate)
{
try
{
string msg = "<pre><font size='3'>Dear Sir/Madam,</font></pre><p/> <pre><font size='3'>Foreign Advance Request has been Rejected.</font></pre><p/> <pre><font size='3'>Request No: " + spn_req_no.Text + "</font></pre> <pre><font size='3'>Created By: " + lbl_EmpName.Text.Trim() + "</font></pre></p><pre></b><pre>INTERNET URL:https://" + compname + "/Sudarshan-Portal/Login.aspx</pre><pre></pre><br/><pre><font size='3' color='red'><i><b>This is a system generated message. We request you not to reply to this message.</b></i></font></pre>";
string emailid = (string)ActionController.ExecuteAction(txt_Username.Text, "Foreign_Advance_Request.aspx", "insetmaildata", ref isInserted, txtProcessID.Text, txtInstanceID.Text, 0, "FOREIGN ADVANCE REQUEST APPROVAL", "REJECT", Init_Email.Text, "", msg, "Request No: " + spn_req_no.Text);
}
catch (Exception)
{
throw;
}
finally
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Foreign Advance Request has been Rejected.');window.open('../../Portal/SCIL/Home.aspx','frmset_WorkArea');}</script>");
}
}
}
else
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Release Step Not Found ...!');window.open('../../Portal/SCIL/TaskDetails.aspx','frmset_WorkArea');}</script>");
}
}
}
else //if (ddlAction.SelectedItem.Text == "Send-Back")
{
txt_Condition.Text = "3";
txt_Audit.Text = "FOREIGN ADVANCE REQUEST ACCOUNT PAYABLE APPROVAL";
string isSaved = (string)ActionController.ExecuteAction("", "Foreign_Advance_Request_Approval.aspx", "update", ref ref_data, Convert.ToInt32(txt_Condition.Text), txtProcessID.Text, txtInstanceID.Text, txt_Audit.Text, txt_Username.Text, spn_Remark.InnerHtml, ddlAction.SelectedItem.Text);
if (isSaved == null || ref_data.Length > 0 || isSaved == "false")
{
string[] errmsg = ref_data.Split(':');
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + errmsg[0].ToString() + "');}</script>");
}
else
{
string[] Dval = new string[1];
Dval[0] = initiator.Text;
string ref_data1 = string.Empty;
string release_id = (string)ActionController.ExecuteAction("", "Foreign_Advance_Request.aspx", "getreleaseid", ref ref_data1, txtProcessID.Text, step_name.Text, "SEND-BACK");
if (release_id != "")
{
bool isCreate = (bool)WFE.Action.ReleaseStep(txtProcessID.Text, txtInstanceID.Text, release_id, step_name.Text, "SEND-BACK", txt_Username.Text, txt_approvar.Text.Trim(), "", "", "", "", "", "", "", "", "", "", Dval, txt_Request.Text, txtWIID.Text, ref isInserted);
if (isCreate)
{
try
{
string msg = "<pre><font size='3'>Dear Sir/Madam,</font></pre><p/> <pre><font size='3'>Foreign Advance Request has been Sent back to the initiator.</font></pre><p/> <pre><font size='3'>Request No: " + spn_req_no.Text + "</font></pre> <pre><font size='3'>Created By: " + lbl_EmpName.Text.Trim() + "</font></pre></p><pre></b><pre>INTERNET URL:https://" + compname + "/Sudarshan-Portal/Login.aspx</pre><pre></pre><br/><pre><font size='3' color='red'><i><b>This is a system generated message. We request you not to reply to this message.</b></i></font></pre>";
string emailid = (string)ActionController.ExecuteAction(txt_Username.Text, "Foreign_Advance_Request.aspx", "insetmaildata", ref isInserted, txtProcessID.Text, txtInstanceID.Text, 0, "FOREIGN ADVANCE REQUEST APPROVAL", "SEND-BACK", Init_Email.Text, "", msg, "Request No: " + spn_req_no.Text);
}
catch (Exception)
{
throw;
}
finally
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Foreign Advance Request has been Sent back to the initiator...!');window.open('../../Portal/SCIL/Home.aspx','frmset_WorkArea');}</script>");
}
}
}
else
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Release Step Not Found ...!');window.open('../../Portal/SCIL/TaskDetails.aspx','frmset_WorkArea');}</script>");
}
}
}
}
}
catch (Exception ex)
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + ex.ToString() + "');window.open('../../Portal/SCIL/Home.aspx','frmset_WorkArea');}</script>");
FSL.Logging.Logger.WriteEventLog(false, ex);
}
}
private void insertXML()
{
StringBuilder Doc_Detail = new StringBuilder();
string Pur_num = string.Empty;
string rtr = string.Empty;
string isdata = string.Empty;
string XmlString = string.Empty;
string isSaved;
XmlString += "|ROWSET||";
try
{
DataTable dt = (DataTable)ActionController.ExecuteAction("", "SAP_Employee_Data.aspx", "getusers", ref isdata);
if (dt.Rows.Count > 0)
{
int fy = 2016;
string fm = "05";
int curf = DateTime.Now.Year;
string curm = (DateTime.Now.Month - 3).ToString();
if (Convert.ToInt32(curm) <= 0)
{
curf = curf - 1;
curm = (12 + Convert.ToInt32(curm)).ToString();
}
if (Convert.ToInt32(curm) < 10)
{
curm = "0" + curm;
}
//for (int ind = 1; fy <= curf && Convert.ToInt32(fm) <= Convert.ToInt32(curm); ind++)
//{
// cnt = cnt + 1;
//}
string tempf = fy.ToString();
string tempm = fm;
string str = tempf + tempm;
int months = (curf - fy) * 12 + Convert.ToInt32(curm) - Convert.ToInt32(fm);
for (int j = 0; j < months; j++)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Pur_num += dt.Rows[i]["EMP_ID"].ToString() + '=';
Pur_num += str + '=';
Pur_num += '-';
}
if (tempm == "12")
{
tempf = (Convert.ToInt32(tempf) + 1).ToString();
tempm = "01";
}
else
{
tempm = (Convert.ToInt32(tempm) + 1).ToString();
if (Convert.ToInt32(tempm) < 10)
{
tempm = "0" + tempm;
}
}
str = tempf + tempm;
}
Vendor_Portal.Vendor_Portal_DetailsService Vendor = new Vendor_Portal.Vendor_Portal_DetailsService();
string[] Vendor_data_array = new string[2];
Vendor_data_array = Vendor.MOBILE_DEDUCTION(Pur_num.ToString());
string[] cmpanyArray;
cmpanyArray = Vendor_data_array[0].Split('|');
if (cmpanyArray.Length > 0)
{
for (int j = 0; j < cmpanyArray.Length - 1; j++)
{
string[] CompanyCode_Data;
CompanyCode_Data = cmpanyArray[j].Split('$');
XmlString += "|ROW||";
XmlString += "|PERNR||" + Convert.ToString(CompanyCode_Data[0]) + "|/PERNR||";
XmlString += "|YYMM||" + CompanyCode_Data[1] + "|/YYMM||";
XmlString += "|AMOUNT||" + CompanyCode_Data[2] + "|/AMOUNT||";
XmlString += "|WAERS||" + CompanyCode_Data[3] + "|/WAERS||";
XmlString += "|/ROW||";
}
}
XmlString += "|/ROWSET||";
string inser_FileXML = XmlString;
inser_FileXML = inser_FileXML.Replace("&", "&");
inser_FileXML = inser_FileXML.Replace(">", ">");
inser_FileXML = inser_FileXML.Replace("<", "<");
inser_FileXML = inser_FileXML.Replace("||", ">");
inser_FileXML = inser_FileXML.Replace("|", "<");
inser_FileXML = inser_FileXML.Replace("'", "'");
XmlString = inser_FileXML.ToString();
//spn_data.InnerHtml = XmlString;
isSaved = (string)ActionController.ExecuteAction("", "SAP_Employee_Data.aspx", "mobilededuction", ref isdata, XmlString);
//spn_data.InnerText = Pur_num.ToString();
}
}
catch (Exception Exc) { Logger.WriteEventLog(false, Exc); }
}