//Page Load Events
protected void Page_Load(object sender, EventArgs e)
{
if (Session["IBT_UserName"] == null)
{
string usrValid = "SessionExpired";
Response.Redirect("~/FAS_Home.aspx?usr="******"IBT_UserName"].ToString();
Session["PagePermissions"] = null;
string pageName = (System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath));
dtPageControls = clsCom.getUserRoleAndPageControls(usrName, pageName);
Session["PagePermissions"] = dtPageControls;
bool x = clsCom.getPermissions(usrName, pageName);
if (x == true)
{
if (!IsPostBack)
{
LoadData();
}
}
else
{
Response.Redirect("~/FAS_Home.aspx?valid=" + x, false);
Context.ApplicationInstance.CompleteRequest();
}
}
protected void Page_Load(object sender, EventArgs e)//-----------------------------------------Page Load Events---------------------------------------------------//
{
if (Session["IBT_UserName"] == null)
{
string usrValid = "SessionExpired";
Response.Redirect("~/FAS_Home.aspx?usr="******"IBT_UserName"].ToString();
Session["PagePermissions"] = null;
string pageName = (System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath));
dtPageControls = clsCom.getUserRoleAndPageControls(usrName, pageName);
Session["PagePermissions"] = dtPageControls;
bool x = clsCom.getPermissions(usrName, pageName);
if (x == true)
{
try
{
if (!IsPostBack)
{
disableBatchButtons();
formControlsAuthentication();
getDataCategory("-");
}
//LoadData(Convert.ToString(ddlCategory.SelectedValue));
}
catch (Exception ex)
{
CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.InnerException.ToString(), Server.MapPath("~/IBTLogFiles/Log.txt"));
lblResult.Text = ex.InnerException.ToString();
}
}
else
{
Response.Redirect("~/FAS_Home.aspx?valid=" + x, false);
Context.ApplicationInstance.CompleteRequest();
}
}
catch (Exception ex)
{
CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, "View Data Co-", Server.MapPath("~/IBTLogFiles/Log_New.txt"));
CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.InnerException.ToString(), Server.MapPath("~/IBTLogFiles/Log.txt"));
call_error_msg(false);
lblResult.Text = ex.InnerException.ToString();
}
}
//public static int usr_role = 0;
protected void Page_Load(object sender, EventArgs e)//Page Load Events
{
if (Session["IBT_UserName"] == null)
{
string usrValid = "SessionExpired";
Response.Redirect("~/FAS_Home.aspx?usr="******"IBT_UserName"].ToString();
//Access controls for 'User Role And Assign Users' Function
if ((usrName == "deshapriya.sooriya") || (usrName == "janaka.indrajith"))
{
lb_createUserRole.Visible = true;
lb_createUserRole.Enabled = true;
}
else
{
lb_createUserRole.Visible = false;
lb_createUserRole.Enabled = false;
}
string pageName = (System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath));
bool x = clsCom.getPermissions(usrName, pageName);
if (x == true)
{
if (!IsPostBack)
{
lb_createUserRole.Enabled = false;
get_userRoleData();
check_for_IT_User();
populateChkBoxList_IBT_Pages(); //IBT Pages
populateChkBoxList_IBT_Departments(); //IBT Departments
get_assignedPages();
ddl_usrRoles_PageControls_SelectedIndexChanged(null, null);
get_IBT_UserDetails();
this.SetFocus(btnSetFocusTop1);
}
}
else
{
Response.Redirect("~/FAS_Home.aspx?valid=" + x, false);
Context.ApplicationInstance.CompleteRequest();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["IBT_UserName"] == null)
{
string usrValid = "SessionExpired";
Response.Redirect("~/FAS_Home.aspx?usr="******"IBT_UserName"].ToString();
string pageName = (System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath));
dtPageControls = clsCom.getUserRoleAndPageControls(usrName, pageName);
Session["PagePermissions"] = dtPageControls;
bool y = clsCom.getPermissions(usrName, pageName);
if (y == true)
{
string x = "";
x = Request.QueryString["valid"];
if ((x == null) || (x == ""))
{
lblResult.Visible = false;
}
else if (x == "False")
{
call_error_msg(false);
lblResult.Text = "Access Denied...!";
}
}
else
{
Response.Redirect("~/FAS_Home.aspx", false);
}
//else
//{
// lblLoginError.Visible = true;
// lblLoginError.Text = "Access Denied...!";
//}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["IBT_UserName"] == null)
{
string usrValid = "SessionExpired";
Response.Redirect("~/FAS_Home.aspx?usr="******"IBT_UserName"].ToString();
string pageName = (System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath));
bool x = clsCom.getPermissions(usrName, pageName);
if (x == true)
{
try
{
if (!IsPostBack)
{
RuleDataTable();
IBTAccountsFor_ddl();
IBTColumns();
IBTRulesFor_ddl();
LoadColumns();
}
}
catch (Exception ex)
{
CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.InnerException.ToString(), Server.MapPath("~/IBTLogFiles/Log.txt"));
call_error_msg(false);
lblResult.Text = ex.InnerException.ToString();
}
}
else
{
Response.Redirect("~/FAS_Home.aspx?valid=" + x, false);
Context.ApplicationInstance.CompleteRequest();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["IBT_UserName"] == null)
{
string usrValid = "SessionExpired";
Response.Redirect("~/FAS_Home.aspx?usr="******"IBT_UserName"].ToString();
string pageName = (System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath));
bool x = clsCom.getPermissions(usrName, pageName);
if (x == true)
{
if (pageLoad_error != "")
{
call_error_msg(false);
lblResult.Text = "Page Load Error! " + " " + pageLoad_error;
pageLoad_error = "";
}
if (!IsPostBack)
{
IBTAccountsFor_ddl();
getAvailableIBTFormats();
getAvailableIBTAccounts();
getAssignedFormats();
}
}
else
{
Response.Redirect("~/FAS_Home.aspx?valid=" + x, false);
Context.ApplicationInstance.CompleteRequest();
}
}
protected void Page_Load(object sender, EventArgs e)//------------------------------Page Load Events--------------------------------------------------------------//
{
if (Session["IBT_UserName"] == null)
{
string usrValid = "SessionExpired";
Response.Redirect("~/FAS_Home.aspx?usr="******"IBT_UserName"].ToString();
string pageName = (System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath));
bool x = clsCom.getPermissions(usrName, pageName);
if (x == true)
{
if (!IsPostBack)
{
RuleDataTable();
getProducts();
getDepartments();
getRules();
getColumns();
getAvailableDepartments();
}
}
else
{
Response.Redirect("~/FAS_Home.aspx?valid=" + x, false);
Context.ApplicationInstance.CompleteRequest();
}
}
int running_count = 0; //For Lock Record Validation
protected void Page_Load(object sender, EventArgs e)//-----------------------------------------Page Load Events---------------------------------------------------//
{
if (Session["IBT_UserName"] == null)
{
string usrValid = "SessionExpired";
Response.Redirect("~/FAS_Home.aspx?usr="******"BulkDetailVariables"];
if (cookie == null)
{
string usrValid = "SessionExpired";
Response.Redirect("~/FAS_Home.aspx?usr="******"BulkDetailVariables"]["DtlID"]);
DtlTransDate = Request.Cookies["BulkDetailVariables"]["DtlTransDate"];
DtlSerialNo = Request.Cookies["BulkDetailVariables"]["DtlSerialNo"];
DtlPolicyNo = Request.Cookies["BulkDetailVariables"]["DtlPolicyNo"];
DtlTotalAmount = Convert.ToDecimal(Request.Cookies["BulkDetailVariables"]["DtlTotalAmount"]);
CommonCLS.CommonFunctions clsCom = new CommonCLS.CommonFunctions();
usrName = Session["IBT_UserName"].ToString();
string pageName = (System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath));
bool x = clsCom.getPermissions(usrName, pageName);
Session["PagePermissions"] = null;
dtPageControls = clsCom.getUserRoleAndPageControls(usrName, pageName);
Session["PagePermissions"] = dtPageControls;
if (x == true)
{
if (!IsPostBack)
{
//hf_selectedRowID.Value = null;
disableBatchButtons();
txtSerialNo.Text = DtlSerialNo;
txtTotal.Text = DtlTotalAmount.ToString("#,##0.00");
txtAvailableBal.Text = DtlTotalAmount.ToString("#,##0.00");
TempTotal = DtlTotalAmount;
LoadData(DtlID);
//----------------------------------ORIGINAL CODE (NEW)----------------------------//
if (running_count == 0)
{
get_TotalRecords_WhenPageLoad();
running_count = running_count + 1;
}
get_LiveRecords_Total();
//--------------------------------------------------------------------------------//
formControlsAuthentication();
}
}
else
{
Response.Redirect("~/FAS_Home.aspx?valid=" + x, false);
Context.ApplicationInstance.CompleteRequest();
}
}
protected void cmdConfirm_Click(object sender, EventArgs e)//----------------------------------Records Confirm Click Event----------------------------------------//
{
//double dr_total = 0;
if (page_result.Visible == true)
{
page_result.Visible = false;
}
get_LiveRecords_Total();
if (int.Parse(Session["TotalRecords_WhenPageLoad"].ToString()) == LiveRecord_Count)
{
//Check Totals-------------
Double TempTot = 0;
DataTable dtTemp = (DataTable)Session["TransList"];
if (dtTemp == null)
{
return;
}
foreach (DataRow item in dtTemp.Rows)
{
TempTot = TempTot + Convert.ToDouble(item["Amount"].ToString());
}
//*****************************************-----New Fn-----**********************************//
double real_total = double.Parse(txtTotal.Text);
double calculation_differance = TempTot - real_total;
if ((Math.Abs(calculation_differance) <= 0.1) || (calculation_differance == 0))
{
if (calculation_differance > 0)
{
calculation_differance = (-1) * (calculation_differance);
}
else
{
calculation_differance = (1) * (calculation_differance);
}
}
else
{
call_error_msg(false);
lblResult.Text = "Calculation Differance Is Greater than 0.1 ";
return;
}
//********************************************************************************************//
CommonCLS.CommonFunctions clsCom = new CommonCLS.CommonFunctions();
DataTable Dt = (DataTable)Session["TransList"];
Int16 SubNo = 1;
CommonCLS.IBTBatches IBTBatch = new CommonCLS.IBTBatches();
String BatchNo = IBTBatch.GetBatchNo("BATCH_NO");
using (OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["ORAWF"].ToString()))
{
conn.Open();
OracleCommand command = conn.CreateCommand();
OracleTransaction transaction;
transaction = conn.BeginTransaction(System.Data.IsolationLevel.Serializable);
// Assign transaction object for a pending local transaction
command.Transaction = transaction;
try
{
Int16 Count = 1;
foreach (DataRow item in Dt.Rows)
{
if (item["Status"].ToString().Trim() != "New")
{
continue;
}
OracleCommand cmd = new OracleCommand();//conn.CreateCommand();
cmd.Connection = conn;
cmd.CommandText = "sp_fas_ibt_BulkReceipt";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("vID", OracleType.Int32).Value = DtlID;
cmd.Parameters.AddWithValue("vSubNo", OracleType.VarChar).Value = SubNo;
cmd.Parameters.AddWithValue("vRefNumber", OracleType.VarChar).Value = item["Ref_no"].ToString();
//cmd.Parameters.AddWithValue("vAmount", OracleType.Number).Value = double.Parse(item["Amount"].ToString());
cmd.Parameters.AddWithValue("vAmount", OracleType.Number).Value = double.Parse(item["Amount"].ToString()) + (calculation_differance);
calculation_differance = 0;
cmd.Parameters.AddWithValue("vCreatedBy", OracleType.Number).Value = usrName;
cmd.Parameters.AddWithValue("vCount", OracleType.Number).Value = Count;
cmd.Parameters.AddWithValue("vBatchNo", OracleType.Number).Value = BatchNo;
SubNo = Convert.ToInt16(SubNo + 1);
cmd.Transaction = transaction;
cmd.ExecuteNonQuery();
Count++;
}
arrRemoveListRV = (ArrayList)Session["arrRemoveListRV"];
if (arrRemoveListRV != null)
{
foreach (Object obj in arrRemoveListRV)
{
OracleCommand cmd = new OracleCommand();//conn.CreateCommand();
cmd.Connection = conn;
cmd.CommandText = "sp_fas_ibt_bulk_rv_Remove";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("BulkRV_ID", OracleType.Int32).Value = Convert.ToInt32(obj);
cmd.Transaction = transaction;
cmd.ExecuteNonQuery();
}
}
transaction.Commit();
CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, "----Bulk Receipt Confirmed!---- By: " + usrName + " Base Record ID :" + DtlID, Server.MapPath("~/IBTLogFiles/Log.txt"));
conn.Close();
}
catch (Exception ex)
{
CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.InnerException.ToString(), Server.MapPath("~/IBTLogFiles/Log.txt"));
call_error_msg(false);
lblResult.Text = ex.InnerException.ToString();
}
}
ClearControls();
running_count = 0;
if (running_count == 0)
{
get_TotalRecords_WhenPageLoad();
running_count = running_count + 1;//New
}
call_error_msg(true);
lblResult.Text = "Records Confirmed For Receipt...!";
}
else
{
running_count = 0;
call_error_msg(false);
lblResult.Text = "Record Locked By Another User...! Please Refresh And Try Again!";
}
}
protected void cmdAdd_Click(object sender, EventArgs e)//--------------------------------------Add Click----------------------------------------------------------//
{
try
{
CommonCLS.CommonFunctions clsCom = new CommonCLS.CommonFunctions();
if (page_result.Visible == true)
{
page_result.Visible = false;
}
grdTransList.DataSource = Session["TransList"];
grdTransList.DataBind();
Decimal TotalAmount = 0;
Decimal Amount = 0;
if (txtRefNo.Text.Trim().Length == 0)
{
call_error_msg(false);
lblResult.Text = "Reference Number Can Not Be Empty...!";
return;
}
if (txtPerc.Text.Trim().Length == 0 && txtAmount.Text.Trim().Length == 0)
{
call_error_msg(false);
lblResult.Text = "Percentage and Amount both can not have Empty values at the same time...!";
return;
}
if (txtPerc.Text.Trim().Length > 0 && txtAmount.Text.Trim().Length > 0)
{
call_error_msg(false);
lblResult.Text = "Percentage and Amount both can not have values at the same time...!";
return;
}
if (txtAmount.Text.Trim() != "")
{
if (Convert.ToDecimal(txtAvailableBal.Text.Trim()) < Convert.ToDecimal(txtAmount.Text.Trim()))
{
call_error_msg(false);
lblResult.Text = "You can not exceed the available amount...!";
return;
}
}
DataTable dtTemp = new DataTable();
dtTemp = (DataTable)Session["TransList"];
//---------------Calculate Start
TotalAmount = Convert.ToDecimal(txtAvailableBal.Text);
if (txtPerc.Text.Trim().Length > 0)
{
Amount = TotalAmount * Convert.ToDecimal(Convert.ToDecimal(txtPerc.Text) / 100);
}
if (txtAmount.Text.Trim().Length > 0)
{
Amount = Convert.ToDecimal(txtAmount.Text);
}
if (Amount == 0)
{
call_error_msg(false);
lblResult.Text = "Zero value not allowed...!";
return;
}
TotalAmount = TotalAmount - Amount;
TempTotal = TempTotal - Amount;
dtTemp.Rows.Add(-1, txtRefNo.Text, Amount.ToString("#,##0.00"), usrName, System.DateTime.Now, "New", "");
txtAvailableBal.Text = TotalAmount.ToString("#,##0.00");
Session["TransList"] = dtTemp;
grdTransList.DataSource = Session["TransList"];
grdTransList.DataBind();
Double TempTot = 0;
foreach (DataRow item in dtTemp.Rows)
{
TempTot = TempTot + Convert.ToDouble(item["Amount"].ToString());
}
txtRefNo.Text = "";
txtPerc.Text = "";
txtAmount.Text = "";
}
catch (Exception ex)
{
CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.InnerException.ToString(), Server.MapPath("~/IBTLogFiles/Log.txt"));
call_error_msg(false);
lblResult.Text = ex.InnerException.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)//-----------------------------Page Load----------------------------------------------------//
{
if (Session["IBT_UserName"] == null)
{
string usrValid = "SessionExpired";
Response.Redirect("~/FAS_Home.aspx?usr="******"IBT_UserName"].ToString();
string pageName = (System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath));
bool x = clsCom.getPermissions(usrName, pageName);
if (x == true)
{
lblResult.Text = "";
if (pageLoad_Error != "")
{
call_error_msg(false);
lblResult.Text = pageLoad_Error;
pageLoad_Error = "";
}
if (!IsPostBack)
{
LoadIBTFormats();//dropdownlist data bind method call
if (tempID != 0)
{
this.BindGrid(tempID);
}
}
if (ddlIBTFormat.SelectedIndex == -1)
{
grdInsert.DataSource = null;
grdInsert.DataBind();
//tblHdr.Visible = false;//Header Fixed
btnUpdate.Visible = false;
btnCancel.Visible = false; //new
btnInsert.Visible = false; //new
}
if (ddlIBTFormat.SelectedIndex == 0)
{
//tblHdr.Visible = false;//Header Fixed
btnUpdate.Visible = false;
btnCancel.Visible = false; //new
btnInsert.Visible = false; //new
grdInsert.DataSource = null;
grdInsert.DataBind();
}
}
else
{
Response.Redirect("~/FAS_Home.aspx?valid=" + x, false);
Context.ApplicationInstance.CompleteRequest();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["IBT_UserName"] == null)
{
string usrValid = "SessionExpired";
Response.Redirect("~/FAS_Home.aspx?usr="******"reportName"];
string parFrom = Request.QueryString["parFrom"];
string parTo = Request.QueryString["parTo"];
CommonCLS.CommonFunctions clsCom = new CommonCLS.CommonFunctions();
//usrName = clsCom.getCurentUser();
usrName = Session["IBT_UserName"].ToString();
Session["PagePermissions"] = null;
string pageName = (System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath));
dtPageControls = clsCom.getUserRoleAndPageControls(usrName, pageName);
Session["PagePermissions"] = dtPageControls;
bool x = clsCom.getPermissions(usrName, pageName);
if (x == true)
{
try
{
if (!IsPostBack)
{
if (reportName == "FAS_IBT_GI_RECEIPT")//General
{
// if (Session["IBT_UserName"].ToString() == "tharindu.bandara" || Session["IBT_UserName"].ToString() == "janaka.indrajith" || Session["IBT_UserName"].ToString() == "deshapriya.sooriya")
// {
// ltrlExcelExport.Text = "<iframe src=\"http://sourcesafe:42000/reportserver_stnddbsql/pages/reportviewer.aspx?%2fhnba_mis%2f" + reportName + "&rs:command=render&FromRV=" + parFrom + "&ToRV=" + parTo + "\" width=\"100%\" height=\"600\" frameborder=\"0\" id=\"iframe1\">";
// }
// else
// {
// ltrlExcelExport.Text = "<iframe src=\"http://websrvgi:42000/ReportServer_HNBGIRS/Pages/ReportViewer.aspx?%2fHNBGIMIS%2f" + reportName + "&rs:command=render&FromRV=" + parFrom + "&ToRV=" + parTo + "\" width=\"100%\" height=\"600\" frameborder=\"0\" id=\"iframe1\">";
// }
ltrlExcelExport.Text = "<iframe src=\"http://websrvgi:42000/ReportServer_HNBGIRS/Pages/ReportViewer.aspx?%2fHNBGIMIS%2f" + reportName + "&rs:command=render&FromRV=" + parFrom + "&ToRV=" + parTo + "\" width=\"100%\" height=\"600\" frameborder=\"0\" id=\"iframe1\">";
}
if (reportName == "FAS_IBT_TCS_RECEIPT")//Life
{
ltrlExcelExport.Text = "<iframe src=\"http://sourcesafe:42000/reportserver_stnddbsql/pages/reportviewer.aspx?%2fhnba_mis%2f" + reportName + "&rs:command=render&parFrom=" + parFrom + "&parTo=" + parTo + "\" width=\"100%\" height=\"600\" frameborder=\"0\" id=\"iframe1\">";
}
if (reportName == "FAS_IBT_NONTCS_RECEIPT")//Life
{
ltrlExcelExport.Text = "<iframe src=\"http://sourcesafe:42000/reportserver_stnddbsql/pages/reportviewer.aspx?%2fhnba_mis%2f" + reportName + "&rs:command=render&parFrom=" + parFrom + "&parTo=" + parTo + "\" width=\"100%\" height=\"600\" frameborder=\"0\" id=\"iframe1\">";
}
}
}
catch (Exception ex)
{
CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.InnerException.ToString(), Server.MapPath("~/IBTLogFiles/Log.txt"));
//lblResult.Text = ex.InnerException.ToString();
}
}
else
{
Response.Redirect("FAS_Home.aspx?valid=" + x, false);
Context.ApplicationInstance.CompleteRequest();
}
}
catch (Exception ex)
{
CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.InnerException.ToString(), Server.MapPath("~/IBTLogFiles/Log.txt"));
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["IBT_UserName"] == null)
{
string usrValid = "SessionExpired";
Response.Redirect("~/FAS_Home.aspx?usr="******"IBT_UserName"].ToString();
Session["PagePermissions"] = null;
string pageName = (System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath));
dtPageControls = clsCom.getUserRoleAndPageControls(usrName, pageName);
Session["PagePermissions"] = dtPageControls;
bool x = clsCom.getPermissions(usrName, pageName);
if (x == true)
{
try
{
if (!IsPostBack)
{
//disableBatchButtons();
//formControlsAuthentication();
string ReportName = "FAS_IBT_Excel_Export"; //FAS_IBT_Excel_Export.rdl
string UserName = usrName; // "deshapriya.sooriya";
//ltrlExcelExport.Text = "<iframe src=\"http://sourcesafe:42000/ReportServer_STNDDBSQL/Pages/ReportViewer.aspx?%2fHNBA_MIS%2f" + ReportName + "&rs:Command=Render&UserID=" + UserName + "\" width=\"100%\" height=\"600\" frameborder=\"0\" id=\"IFRAME1\">";
//Working
//ltrlExcelExport.Text = "<iframe src=\"http://sourcesafe:42000/reportserver_stnddbsql/pages/reportviewer.aspx?%2fhnba_mis%2f" + ReportName + "&rs:command=render\" width=\"100%\" height=\"600\" frameborder=\"0\" id=\"iframe1\">";
ltrlExcelExport.Text = "<iframe src=\"http://sourcesafe:42000/reportserver_stnddbsql/pages/reportviewer.aspx?%2fhnba_mis%2f" + ReportName + "&rs:command=render&UserID=" + UserName + "\" width=\"100%\" height=\"600\" frameborder=\"0\" id=\"iframe1\">";
}
}
catch (Exception ex)
{
CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.InnerException.ToString(), Server.MapPath("~/IBTLogFiles/Log.txt"));
//lblResult.Text = ex.InnerException.ToString();
}
}
else
{
Response.Redirect("~/FAS_Home.aspx?valid=" + x, false);
Context.ApplicationInstance.CompleteRequest();
}
}
catch (Exception ex)
{
CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.InnerException.ToString(), Server.MapPath("~/IBTLogFiles/Log.txt"));
throw;
}
}
protected void cmdSaveRule_Click(object sender, EventArgs e)//--------------------------------------Save New Rule-----------------------------------------------//
{
try
{
if ((ddlIBTRules.SelectedIndex == 0) || (ddlAllProducts.SelectedIndex == 0) || (ddlDepartment.SelectedIndex == 0))
{
call_error_msg(false);
lblResult.Text = "IBT Rule, Product And Department Fields Are Mandentory, Please Try Again...!";
return;
}
else
{
CommonCLS.CommonFunctions clsCom = new CommonCLS.CommonFunctions();
String UserName = usrName;// clsCom.getCurentUser();
String SQLWhere = "";
foreach (GridViewRow row in GrdRules.Rows)
{
DropDownList DDLOPENBrackets = row.Cells[0].FindControl("ddlOpenBracket") as DropDownList;
TextBox TXTColID = row.Cells[1].FindControl("txtcolID") as TextBox;
TextBox TXTColDesc = row.Cells[2].FindControl("txtDescription") as TextBox;
DropDownList DDLOperator = row.Cells[3].FindControl("ddlOperator") as DropDownList;
TextBox TXTValue = row.Cells[4].FindControl("txtValue") as TextBox;
//DropDownList DDLPolicyDTL = row.Cells[3].FindControl("ddlPolicyDtl") as DropDownList;
TextBox TXTUserInput = row.Cells[5].FindControl("txtUsrInput") as TextBox;
DropDownList DDLCLOSEBrackets = row.Cells[6].FindControl("ddlCloseBracket") as DropDownList;
DropDownList DDLConditions = row.Cells[7].FindControl("ddlConditions") as DropDownList;
if (DDLOperator.SelectedIndex != 0)
{
//SQLWhere = SQLWhere + CreateSQLWhere(SQLWhere, DDLOPENBrackets.SelectedItem.Text, TXTColDesc.Text, Convert.ToInt16(DDLOperator.SelectedValue), TXTValue.Text, DDLPolicyDTL.SelectedItem.Text, DDLCLOSEBrackets.SelectedItem.Text, DDLConditions.SelectedItem.Text, ddlDepartment.SelectedItem.Text);
SQLWhere = SQLWhere + CreateSQLWhere(SQLWhere, DDLOPENBrackets.SelectedItem.Text, TXTColDesc.Text, Convert.ToInt16(DDLOperator.SelectedValue), TXTValue.Text, TXTUserInput.Text, DDLCLOSEBrackets.SelectedItem.Text, DDLConditions.SelectedItem.Text, int.Parse(ddlDepartment.SelectedValue.ToString()));
}
}
txtViewRule.Text = SQLWhere;
//Rule Header Update
OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["ORAWF"].ToString());
conn.Open();
OracleCommand cmd = new OracleCommand();//conn.CreateCommand();
cmd.Connection = conn;
cmd.CommandText = "SP_FAS_IBT_MCPMCR_RULES_HDR";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("RULE_ID", OracleType.Int32).Value = Convert.ToInt32(ddlIBTRules.SelectedValue);//ToInt64
cmd.Parameters.AddWithValue("DESCRIPTION", OracleType.VarChar).Value = SQLWhere.ToUpper();
cmd.Parameters.AddWithValue("product_id", OracleType.Int32).Value = ddlAllProducts.SelectedValue;
cmd.Parameters.AddWithValue("mcpmcr_value", OracleType.Int32).Value = ddlDepartment.SelectedItem.Value;
cmd.Parameters.AddWithValue("vCreatedby", OracleType.VarChar).Value = usrName;
cmd.ExecuteNonQuery();
conn.Close();
CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, "----New Type Of Product Rule Saved---- By: " + usrName, Server.MapPath("~/IBTLogFiles/Log.txt"));
call_error_msg(true);
lblResult.Text = "Rule Inserted Successfully...!";
this.SetFocus(cmdViewRule);
ClearInputs(Page.Controls);
GrdRules.DataSource = null;
GrdRules.DataBind();
}
}
catch (Exception ex)
{
CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.InnerException.ToString() + "---Type Of Product Rule Insertion Fail...! - Active User: "******"~/IBTLogFiles/Log.txt"));
call_error_msg(false);
lblResult.Text = ex.InnerException.ToString();
}
}
protected void cmdSaveRule_Click(object sender, EventArgs e)
{
try
{
if (ddlIBTRules.SelectedIndex == 0)
{
call_error_msg(false);
lblResult.Text = "Please Select A Rule And Try Again...!";
return;
}
else
{
CommonCLS.CommonFunctions clsCom = new CommonCLS.CommonFunctions();
String UserName = usrName;// clsCom.getCurentUser();
String SQLWhere = "";
foreach (GridViewRow row in GrdRules.Rows)
{
DropDownList DDLOPENBrackets = row.Cells[0].FindControl("ddlOpenBracket") as DropDownList;
TextBox TXTColID = row.Cells[1].FindControl("txtcolID") as TextBox;
TextBox TXTColDesc = row.Cells[2].FindControl("txtDescription") as TextBox;
DropDownList DDLOperator = row.Cells[3].FindControl("ddlOperator") as DropDownList;
TextBox TXTValue = row.Cells[4].FindControl("txtValue") as TextBox;
DropDownList DDLPolicyDTL = row.Cells[3].FindControl("ddlPolicyDtl") as DropDownList;
DropDownList DDLCLOSEBrackets = row.Cells[4].FindControl("ddlCloseBracket") as DropDownList;
DropDownList DDLConditions = row.Cells[5].FindControl("ddlConditions") as DropDownList;
if (DDLOperator.SelectedIndex != 0)
{
SQLWhere = SQLWhere + CreateSQLWhere(SQLWhere, DDLOPENBrackets.SelectedItem.Text, TXTColDesc.Text, Convert.ToInt16(DDLOperator.SelectedValue), TXTValue.Text, DDLPolicyDTL.SelectedItem.Text, DDLCLOSEBrackets.SelectedItem.Text, DDLConditions.SelectedItem.Text);
}
}
txtViewRule.Text = SQLWhere;
//Rule Header Update
OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["ORAWF"].ToString());
conn.Open();
OracleCommand cmd = new OracleCommand();//conn.CreateCommand();
cmd.Connection = conn;
cmd.CommandText = "SP_FAS_IBT_MATCHING_RULES_HDR";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("RULE_ID", OracleType.Int32).Value = Convert.ToInt64(ddlIBTRules.SelectedValue);
cmd.Parameters.AddWithValue("DESCRIPTION", OracleType.VarChar).Value = SQLWhere.ToUpper();
cmd.Parameters.AddWithValue("CREATEDBY", OracleType.VarChar).Value = UserName; //"ss";
cmd.ExecuteNonQuery();
conn.Close();
call_error_msg(true);
lblResult.Text = "Matching Rule Inserted Successfully...!";
this.SetFocus(cmdViewRule);
ClearInputs(Page.Controls);
}
}
catch (Exception ex)
{
CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.InnerException.ToString(), Server.MapPath("~/IBTLogFiles/Log.txt"));
call_error_msg(false);
lblResult.Text = ex.InnerException.ToString();
}
}
