protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
ActionController.DisablePageCaching(this);
if (ActionController.IsSessionExpired(this))
{
ActionController.RedirctToLogin(this);
}
else
{
string isdata = string.Empty;
string isSaved = string.Empty;
string fuelxml_string = txt_xml_data_fuel.Text;
fuelxml_string = fuelxml_string.Replace("&", "&");
fuelxml_string = fuelxml_string.Replace(">", ">");
fuelxml_string = fuelxml_string.Replace("<", "<");
fuelxml_string = fuelxml_string.Replace("||", ">");
fuelxml_string = fuelxml_string.Replace("|", "<");
fuelxml_string = fuelxml_string.Replace("'", "'");
txt_xml_data_fuel.Text = fuelxml_string.ToString();
string maintainancexml_string = txt_xml_data_maitainance.Text;
maintainancexml_string = maintainancexml_string.Replace("&", "&");
maintainancexml_string = maintainancexml_string.Replace(">", ">");
maintainancexml_string = maintainancexml_string.Replace("<", "<");
maintainancexml_string = maintainancexml_string.Replace("||", ">");
maintainancexml_string = maintainancexml_string.Replace("|", "<");
maintainancexml_string = maintainancexml_string.Replace("'", "'");
txt_xml_data_maitainance.Text = maintainancexml_string.ToString();
string driverxml_string = txt_xml_data_driver.Text;
driverxml_string = driverxml_string.Replace("&", "&");
driverxml_string = driverxml_string.Replace(">", ">");
driverxml_string = driverxml_string.Replace("<", "<");
driverxml_string = driverxml_string.Replace("||", ">");
driverxml_string = driverxml_string.Replace("|", "<");
driverxml_string = driverxml_string.Replace("'", "'");
txt_xml_data_driver.Text = driverxml_string.ToString();
string tyrexml_string = txt_xml_data_tyre.Text;
tyrexml_string = tyrexml_string.Replace("&", "&");
tyrexml_string = tyrexml_string.Replace(">", ">");
tyrexml_string = tyrexml_string.Replace("<", "<");
tyrexml_string = tyrexml_string.Replace("||", ">");
tyrexml_string = tyrexml_string.Replace("|", "<");
tyrexml_string = tyrexml_string.Replace("'", "'");
txt_xml_data_tyre.Text = tyrexml_string.ToString();
string batteryexml_string = txt_xml_data_battery.Text;
batteryexml_string = batteryexml_string.Replace("&", "&");
batteryexml_string = batteryexml_string.Replace(">", ">");
batteryexml_string = batteryexml_string.Replace("<", "<");
batteryexml_string = batteryexml_string.Replace("||", ">");
batteryexml_string = batteryexml_string.Replace("|", "<");
batteryexml_string = batteryexml_string.Replace("'", "'");
txt_xml_data_battery.Text = batteryexml_string.ToString();
string FILEXML = Txt_File_xml.Text;
FILEXML = FILEXML.Replace("&", "&");
FILEXML = FILEXML.Replace(">", ">");
FILEXML = FILEXML.Replace("<", "<");
FILEXML = FILEXML.Replace("||", ">");
FILEXML = FILEXML.Replace("|", "<");
FILEXML = FILEXML.Replace("'", "'");
Txt_File_xml.Text = FILEXML.ToString();
//txt_Document_Xml.Text="<ROWSET></ROWSET>";
string isInserted = string.Empty;
string instanceID = (string)WFE.Action.StartCase(isInserted, txtProcessID.Text, txt_Username.Text, txt_Username.Text, txtEmailID.Text, "15");
txtInstanceID.Text = instanceID;
DataTable dtRole = (DataTable)ActionController.ExecuteAction("", "Car_Expense_Approval.aspx", "getdocapprover", ref isInserted, "CAR EXPENSE PAYMENT APPROVAL");
if (dtRole != null && dtRole.Rows.Count > 0)
{
string[] Dval = new string[dtRole.Rows.Count];
string Emailids = "";
for (int i = 0; i < dtRole.Rows.Count; i++)
{
Dval[i] = dtRole.Rows[i]["USER_ADID"].ToString().Trim();
if (Emailids == "")
{
Emailids = dtRole.Rows[i]["EMAIL_ID"].ToString().Trim();
}
else
{
Emailids = Emailids + "," + dtRole.Rows[i]["EMAIL_ID"].ToString().Trim();
}
}
isSaved = (string)ActionController.ExecuteAction("", "Car_Expense.aspx", "insert", ref isdata, txtProcessID.Text, txtInstanceID.Text, txt_Username.Text, txt_xml_data_fuel.Text, txt_xml_data_maitainance.Text, txt_xml_data_driver.Text, Txt_File_xml.Text, txtexpnsamt.Text, ddl_Payment_Mode.SelectedValue, ddlAdv_Location.SelectedValue, txt_fule_Dev.Text, txt_maintain_Dev.Text, txt_xml_data_tyre.Text, txt_xml_data_battery.Text, txtEmailID.Text, Emailids);
if (isSaved == null || isdata.Length > 0 || isSaved == "false")
{
string[] errmsg = isdata.Split(':');
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + errmsg[0].ToString() + "');}</script>");
}
else
{
bool isCreate = false;
isCreate = (bool)WFE.Action.ReleaseStep(txtProcessID.Text, txtInstanceID.Text, txt_StepId.Text, "CAR EXPENSE REQUEST", "SUBMIT", "", txt_Username.Text.Trim(), "", "", "", "", "", "", "", "", "", "", Dval, isSaved.ToString(), "0", ref isInserted);
if (isCreate)
{
try
{
string isValid = string.Empty;
DataTable dt = (DataTable)ActionController.ExecuteAction(txt_Username.Text, "Car_Expense.aspx", "getfilenames", ref isValid, "CAR POLICY", isSaved.ToString());
if (dt.Rows.Count > 0)
{
string activeDir = ConfigurationManager.AppSettings["DOCPATH"].ToString();
string path = string.Empty;
string foldername = isSaved.ToString();
foldername = foldername.Replace("/", "_");
path = activeDir + "\\" + foldername;
if (Directory.Exists(path))
{
}
else
{
Directory.CreateDirectory(path);
string[] directories = Directory.GetFiles(activeDir);
path = path + "\\";
foreach (var directory in directories)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
var sections = directory.Split('\\');
var fileName = sections[sections.Length - 1];
if (dt.Rows[i]["filename"].ToString() == fileName)
{
System.IO.File.Move(activeDir + "\\" + fileName, path + fileName);
}
}
}
}
}
}
catch (Exception exs)
{
Logger.WriteEventLog(false, exs);
}
finally
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Car Expense Submitted Successfully and Voucher No : " + isSaved.ToString() + "');window.open('../../Portal/SCIL/Home.aspx','frmset_WorkArea');}</script>");
}
}
else
{
string[] errmsg = isInserted.Split(':');
if (errmsg[1].ToString().Trim() != "")
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + errmsg[1].ToString() + "');}</script>");
}
else
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + (string)isSaved + "');}</script>");
}
}
}
}
}
MP_Loading.Hide();
}
catch (Exception Exc) { FSL.Logging.Logger.WriteEventLog(false, Exc); MP_Loading.Hide(); }
}
protected void btnApprove_Click(object sender, EventArgs e)
{
try
{
ActionController.DisablePageCaching(this);
if (ActionController.IsSessionExpired(this))
{
ActionController.RedirctToLogin(this);
}
else
{
string remark = txtRemark.Value;
string refData = string.Empty;
string isInserted = string.Empty;
string ISValid = string.Empty;
if (ddlAction.SelectedItem.Text == "Approve")
{
string isSaved = (string)ActionController.ExecuteAction("", "Car_Expense_Approval.aspx", "update", ref refData, txtProcessID.Text, txtInstanceID.Text, remark, txt_Username.Text, "7");
if (isSaved == null || refData.Length > 0 || isSaved == "false")
{
string[] errmsg = refData.Split(':');
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + errmsg[0].ToString() + "');}</script>");
}
else
{
string[] Dval = new string[1];
Dval[0] = "FLOLOGIC1";
bool isCreate = (bool)WFE.Action.ReleaseStep(txtProcessID.Text, txtInstanceID.Text, "230", "CAR EXPENSE PAYMENT APPROVAL", "SUBMIT", "", txt_Username.Text.Trim(), "", "", "", "", "", "", "", "", "", "", Dval, spn_req_no.InnerHtml, txtWIID.Text, ref isInserted);
if (isCreate)
{
try
{
string msg = "<pre><font size='3'>Dear Sir/Madam,</font></pre><p/><pre><font size='3'>The Car Expense request has been Approved Successfully.</font></pre><pre><font size='3'>Car Expense No: " + spn_req_no.InnerHtml + "</font></pre><pre><font size='3'>Created By: " + span_ename.InnerHtml + "</font></pre></p><pre></b><pre>INTRANET URL:http://" + compname + "/Sudarshan-Portal/Login.aspx</pre><pre>INTERNET URL:https://" + compname + "/Sudarshan-Portal/Login.aspx</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, "Early_Payment_Request.aspx", "insetmaildata", ref isInserted, txtProcessID.Text, txtInstanceID.Text, 0, "CAR EXPENSE PAYMENT APPROVAL", "SUBMIT", Init_Email.Text, txtEmailID.Text, msg, "Car Expense No: " + spn_req_no.InnerHtml);
}
catch (Exception)
{
throw;
}
finally
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Car Expense Request has been Approved Successfully...!');window.open('../../Portal/SCIL/Home.aspx','frmset_WorkArea');}</script>");
}
}
}
}
else if (ddlAction.SelectedItem.Text == "Send-Back")
{
refData = string.Empty;
isInserted = string.Empty;
ISValid = string.Empty;
txt_Condition.Text = "3";
remark = txtRemark.Value;
DataTable dtback = (DataTable)ActionController.ExecuteAction("", "Car_Expense_Approval.aspx", "getsendback", ref refData, txtProcessID.Text, txtInstanceID.Text);
if (dtback != null && dtback.Rows.Count > 0)
{
txtEmailID.Text = dtback.Rows[0]["EMAIL_ID"].ToString();
string isSaved = (string)ActionController.ExecuteAction("", "Car_Expense_Approval.aspx", "update", ref refData, txtProcessID.Text, txtInstanceID.Text, remark, txt_Username.Text, "8");
if (isSaved == null || refData.Length > 0 || isSaved == "false")
{
string[] errmsg = refData.Split(':');
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + errmsg[0].ToString() + "');}</script>");
}
else
{
string[] Dval = new string[1];
Dval[0] = dtback.Rows[0]["actionbyuser"].ToString();
bool isCreate = (bool)WFE.Action.ReleaseStep(txtProcessID.Text, txtInstanceID.Text, "229", "CAR EXPENSE PAYMENT APPROVAL", "SEND-BACK", dtback.Rows[0]["actionbyuser"].ToString(), txt_Username.Text.Trim(), "", "", "", "", "", "", "", "", "", "", Dval, spn_req_no.InnerHtml, txtWIID.Text, ref isInserted);
if (isCreate)
{
try
{
string msg = "<pre><font size='3'>Dear Sir/Madam,</font></pre><p/> <pre><font size='3'>The Car Expense request has been Send Back To Initiator.</font></pre><p/><pre><font size='3'>Car Expense No: " + spn_req_no.InnerHtml + "</font></pre><pre><font size='3'>Created By: " + span_ename.InnerHtml + "</font></pre></p><pre></b><pre>INTRANET URL:http://" + compname + "/Sudarshan-Portal/Login.aspx</pre><pre>INTERNET URL:https://" + compname + "/Sudarshan-Portal/Login.aspx</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, "Early_Payment_Request.aspx", "insetmaildata", ref isInserted, txtProcessID.Text, txtInstanceID.Text, 0, "CAR EXPENSE PAYMENT APPROVAL", "SUBMIT", Init_Email.Text, "", msg, "Car Expense No: " + spn_req_no.InnerHtml);
}
catch (Exception ex)
{
// throw;
FSL.Logging.Logger.WriteEventLog(false, ex);
}
finally
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Car Expense Request send-back Successfully...!');window.open('../../Portal/SCIL/Home.aspx','frmset_WorkArea');}</script>");
}
}
}
}
else
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Send-back Approver Not Found...!');}</script>");
}
}
else if (ddlAction.SelectedItem.Text == "Send For Payment Mode Change")
{
refData = string.Empty;
isInserted = string.Empty;
ISValid = string.Empty;
txt_Condition.Text = "3";
remark = txtRemark.Value;
DataTable dtback = (DataTable)ActionController.ExecuteAction("", "Car_Expense_Approval.aspx", "getsendback", ref refData, txtProcessID.Text, txtInstanceID.Text);
if (dtback != null && dtback.Rows.Count > 0)
{
txtEmailID.Text = dtback.Rows[0]["EMAIL_ID"].ToString();
string isSaved = (string)ActionController.ExecuteAction("", "Car_Expense_Approval.aspx", "update", ref refData, txtProcessID.Text, txtInstanceID.Text, remark, txt_Username.Text, "14");
if (isSaved == null || refData.Length > 0 || isSaved == "false")
{
string[] errmsg = refData.Split(':');
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + errmsg[0].ToString() + "');}</script>");
}
else
{
string[] Dval = new string[1];
Dval[0] = dtback.Rows[0]["actionbyuser"].ToString();
bool isCreate = (bool)WFE.Action.ReleaseStep(txtProcessID.Text, txtInstanceID.Text, "237", "CAR EXPENSE PAYMENT APPROVAL", "SENDBACK-MODE", dtback.Rows[0]["actionbyuser"].ToString(), txt_Username.Text.Trim(), "", "", "", "", "", "", "", "", "", "", Dval, spn_req_no.InnerHtml, txtWIID.Text, ref isInserted);
if (isCreate)
{
try
{
string msg = "<pre><font size='3'>Dear Sir/Madam,</font></pre><p/> <pre><font size='3'>The Car Expense request has been Send Back To Initiator For Payment Mode Change.</font></pre><p/><pre><font size='3'>Car Expense No: " + spn_req_no.InnerHtml + "</font></pre><pre><font size='3'>Created By: " + span_ename.InnerHtml + "</font></pre></p><pre></b><pre>INTRANET URL:http://" + compname + "/Sudarshan-Portal/Login.aspx</pre><pre>INTERNET URL:https://" + compname + "/Sudarshan-Portal/Login.aspx</pre><br/><pre>Regards</pre><pre><b>Reporting Admin<b></pre><br/><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, "Early_Payment_Request.aspx", "insetmaildata", ref isInserted, txtProcessID.Text, txtInstanceID.Text, 0, "CAR EXPENSE PAYMENT APPROVAL", "SUBMIT", Init_Email.Text, "", msg, "Car Expense No: " + spn_req_no.InnerHtml);
}
catch (Exception ex)
{
// throw;
FSL.Logging.Logger.WriteEventLog(false, ex);
}
finally
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Car Expense Request send-back Successfully For Payment Mode Change...!');window.open('../../Portal/SCIL/Home.aspx','frmset_WorkArea');}</script>");
}
}
}
}
else
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Send-back Approver Not Found...!');}</script>");
}
}
else if (ddlAction.SelectedItem.Text == "Reject")
{
remark = txtRemark.Value;
refData = string.Empty;
string isSaved = (string)ActionController.ExecuteAction("", "Car_Expense_Approval.aspx", "update", ref refData, txtProcessID.Text, txtInstanceID.Text, remark, txt_Username.Text, "11");
if (isSaved == null || refData.Length > 0 || isSaved == "false")
{
string[] errmsg = refData.Split(':');
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('" + errmsg[0].ToString() + "');}</script>");
}
else
{
string[] Dval = new string[1];
Dval[0] = txt_Username.Text;
bool isCreate = (bool)WFE.Action.ReleaseStep(txtProcessID.Text, txtInstanceID.Text, "236", "CAR EXPENSE PAYMENT APPROVAL", "REJECT", txt_Username.Text, txt_Username.Text.Trim(), "", "", "", "", "", "", "", "", "", "", Dval, spn_req_no.InnerHtml, txtWIID.Text, ref isInserted);
if (isCreate)
{
try
{
string msg = "<pre><font size='3'>Dear Sir/Madam,</font></pre><p/> <pre><font size='3'>Car Expense Request has been Rejected.</font></pre><p/> <pre><font size='3'>Car Expense No: " + spn_req_no.InnerHtml + "</font></pre> <pre><font size='3'>Created By: " + txt_Initiator.Text + "</font></pre></p><pre></b><pre>INTERNET URL:https://" + compname + "/Sudarshan-Portal/Login.aspx</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, "Early_Payment_Request.aspx", "insetmaildata", ref isInserted, txtProcessID.Text, txtInstanceID.Text, 0, "CAR EXPENSE PAYMENT APPROVAL", "REJECT", Init_Email.Text, txtEmailID.Text, msg, "Request No: " + spn_req_no.InnerHtml);
}
catch (Exception)
{
throw;
}
finally
{
Page.RegisterStartupScript("onclick", "<script language='javascript'>{alert('Car Expense Request has been Rejected...!');window.open('../../Portal/SCIL/Home.aspx','frmset_WorkArea');}</script>");
}
}
}
}
}
MP_Loading.Hide();
}
catch (Exception ex)
{
FSL.Logging.Logger.WriteEventLog(false, ex);
MP_Loading.Hide();
}
}
