protected void btnSearch_Click(object sender, EventArgs e) { if (!CheckEndSession()) { string strSearchDetail = (string.IsNullOrEmpty(txtSrchName.Text.Trim())) ? "" : "NAME=" + txtSrchName.Text.Trim() + "&"; strSearchDetail = (string.IsNullOrEmpty(txtAddress.Text.Trim())) ? strSearchDetail + "" : strSearchDetail + "ADRS=" + txtAddress.Text.Trim() + "&"; strSearchDetail = (ddlSdnType.SelectedValue.ToString() == "0") ? strSearchDetail + "" : strSearchDetail + "SDNTYPE=" + ddlSdnType.SelectedItem.Text.Trim() + "&"; strSearchDetail = (ddlPurpose.SelectedValue.ToString() == "0") ? strSearchDetail + "" : strSearchDetail + "PURPOSE=" + ddlPurpose.SelectedItem.Text.Trim() + "&"; strSearchDetail = (string.IsNullOrEmpty(txtPercentage.Text.Trim())) ? strSearchDetail + "" : strSearchDetail + "PERCENTAGE=" + txtPercentage.Text.Trim() + "&"; strSearchDetail = (string.IsNullOrEmpty(txtDOB.Text.Trim())) ? strSearchDetail + "" : strSearchDetail + "DOB=" + txtDOB.Text.Trim() + "&"; strSearchDetail = (ddlCountry.SelectedValue.ToString() == "0") ? strSearchDetail + "" : strSearchDetail + "COUNTRY=" + ddlCountry.SelectedItem.Text.Trim() + "&"; strSearchDetail = (string.IsNullOrEmpty(txtLCRefNo.Text.Trim())) ? strSearchDetail + "" : strSearchDetail + "LCREF=" + txtLCRefNo.Text.Trim() + "&"; Session["SText"] = strSearchDetail; string EmpId = Session["CurrentUser"].ToString(); string srchRefNo = DateTime.Now.ToString("yyMMddHHmmssff", CultureInfo.InvariantCulture) + EmpId.Substring(EmpId.Length - 4, 4); oOSSearchHistory = new OSSearchHistory(); oOSSearchHistory.EmployeeID = Session["CurrentUser"].ToString().Trim(); oOSSearchHistory.CreatedBy = Session["CurrentUser"].ToString().Trim(); oOSSearchHistory.CreatedOn = DateTime.Now; oOSSearchHistory.EmpBranchCode = Session["CurrentBranchCode"].ToString().Trim(); oOSSearchHistory.IsActive = true; oOSSearchHistory.Purpose = ddlPurpose.SelectedValue; oOSSearchHistory.SearchCompIP = GetIp().ToString(); oOSSearchHistory.SearchDate = DateTime.Now; oOSSearchHistory.SearchDetail = strSearchDetail; oOSSearchHistory.SearchRefNo = srchRefNo; oOSSearchHistory.LCRefNo = txtLCRefNo.Text.Trim(); obDBCtxt.OSSearchHistories.AddObject(oOSSearchHistory); obDBCtxt.SaveChanges(); LoadGrid(); lblRefNo.Text = "Reference Number : " + srchRefNo; lblSearchID.Text = srchRefNo; Session["SRCHID"] = srchRefNo; SetReferInfo(srchRefNo); ScriptManager.RegisterStartupScript(this, this.GetType(), "scrpt1", "ShowSuccessBox()", true); } else { } }
protected void btnSuspSave_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(lblSearchID.Text)) { try { string refId = lblSearchID.Text.Trim(); string EmpId = Session["CurrentUser"].ToString().Trim(); oOSSearchHistory = obDBCtxt.OSSearchHistories.FirstOrDefault(t => t.SearchRefNo == refId); if (oOSSearchHistory != null) { //oOSSearchHistory.IsSuspicious = true; //oOSSearchHistory.ACOpenBy = txtACOpen.Text.Trim(); if (oOSSearchHistory.OSREFERINFOes.Count > 0 && oOSSearchHistory.OSREFERINFOes.OrderByDescending(t => t.ID).First().REFERSTATUS == Convert.ToInt32(Enumaretion.ReferStatus.Approve) && oOSSearchHistory.EmployeeID == EmpId) { oOSSearchHistory.IsOpen = false; oOSSearchHistory.ACOpenBy = txtACOpen.Text.Trim(); } else { OSREFERINFO oOSREFERINFO = new OSREFERINFO(); oOSREFERINFO.SEARCHID = oOSSearchHistory.ID; oOSREFERINFO.REFERFROM = Session["CurrentUser"].ToString().Trim(); if (Convert.ToInt32(ddlRefStatus.SelectedValue) > Convert.ToInt32(Enumaretion.ReferStatus.Recommend)) { oOSREFERINFO.REFERSTATUS = Convert.ToInt32(ddlRefStatus.SelectedValue.ToString()); ddlReferTo.SelectedIndex = ddlReferTo.Items.Count - 1; oOSREFERINFO.REFERTO = ddlReferTo.SelectedValue.ToString(); } else { oOSREFERINFO.REFERSTATUS = Convert.ToInt32(ddlRefStatus.SelectedValue.ToString()); oOSREFERINFO.REFERTO = ddlReferTo.SelectedValue.ToString(); } oOSREFERINFO.REFERDATE = DateTime.Now; oOSREFERINFO.REFERREMARKS = txtReferRemark.Text.Trim(); oOSREFERINFO.ISOPEN = true; oOSREFERINFO.CREATEDBY = Session["CurrentUser"].ToString().Trim(); oOSREFERINFO.CREATEDON = DateTime.Now; obDBCtxt.OSREFERINFOes.AddObject(oOSREFERINFO); obDBCtxt.SaveChanges(); oOSSearchHistory.IsOpen = true; oOSSearchHistory.ReferStatus = Convert.ToInt32(ddlRefStatus.SelectedValue); } oOSSearchHistory.ModifiedBy = Session["CurrentUser"].ToString().Trim(); oOSSearchHistory.ModifiedOn = DateTime.Now; obDBCtxt.SaveChanges(); btnSuspSave.Enabled = false; lblRefNo.Text = "Refer Information is saved SUCCESSFULLY "; ScriptManager.RegisterStartupScript(this, this.GetType(), "scrpt1", "ShowSuccessBox()", true); } else { lblRefNo.Text = "DATA is not Found!"; ScriptManager.RegisterStartupScript(this, this.GetType(), "scrpt1", "ShowAlertBox()", true); } } catch (Exception ex) { lblRefNo.Text = ex.Message; ScriptManager.RegisterStartupScript(this, this.GetType(), "scrpt1", "ShowAlertBox()", true); } } else { lblRefNo.Text = "DATA is not Found!"; ScriptManager.RegisterStartupScript(this, this.GetType(), "scrpt1", "ShowAlertBox()", true); } }
private void SetReferInfo(string ReferenceNo) { List <vwReferCaseList> CaseList = null; btnSuspSave.Enabled = true; OSSearchHistory oOSSearchHistoryTemp = obDBCtxt.OSSearchHistories.FirstOrDefault(t => t.SearchRefNo == ReferenceNo); if (oOSSearchHistory.OSREFERINFOes.Count > 0) { OSUSER oOSUSERInitiator = new OSUSER(); oOSUSERInitiator.EMPLOYEEID = oOSSearchHistory.EmployeeID; oOSUSERInitiator.DETAILINFO = oOSUSERInitiator.EMPLOYEEID + " - INITIATOR"; CaseList = obDBCtxt.vwReferCaseLists.Where(t => t.SearchRefNo == ReferenceNo).ToList(); obDBCtxt.Refresh(RefreshMode.StoreWins, CaseList); string currentUserId = Session["CurrentUser"].ToString().Trim(); if (oOSSearchHistory.OSREFERINFOes.OrderByDescending(t => t.ID).First().REFERFROM != currentUserId && oOSSearchHistory.EmployeeID != currentUserId) { Int32 CaMelCoUserType = Convert.ToInt32(Enumaretion.SanctionUserType.DeputyCAMELCO); Int32 CaMelCoUserType1 = Convert.ToInt32(Enumaretion.SanctionUserType.CAMELCO); var oReferUserList = obDBCtxt.OSUSERs.Where(t => (t.USERTYPE == CaMelCoUserType || t.USERTYPE == CaMelCoUserType1) && t.ISACTIVE).Distinct().ToList(); oReferUserList.Add(oOSUSERInitiator); UIUtility.FillCombo(ddlReferTo, "DETAILINFO", "EMPLOYEEID", oReferUserList, true, false); ddlRefStatus.Items.RemoveAt(1); ddlRefStatus.SelectedIndex = 1;//to inititate a request in value 1 ddlRefStatus.Enabled = true; } else { Int32 ReferApprvCode = Convert.ToInt32(Enumaretion.ReferStatus.Approve); if (oOSSearchHistory.OSREFERINFOes.OrderByDescending(t => t.ID).First().REFERSTATUS == ReferApprvCode && oOSSearchHistory.EmployeeID == currentUserId && oOSSearchHistory.IsOpen == true) { txtACOpen.Enabled = true; btnSuspSave.Enabled = true; ddlReferTo.Enabled = false; ddlRefStatus.Enabled = false; referStatusVal.Enabled = false; referToVal.Enabled = false; } else { txtACOpen.Enabled = false; btnSuspSave.Enabled = false; ddlReferTo.Enabled = false; ddlRefStatus.Enabled = false; } txtACOpen.Text = (!string.IsNullOrEmpty(oOSSearchHistory.ACOpenBy)) ? oOSSearchHistory.ACOpenBy.Trim() : string.Empty; } } else { Int32 UserType = Convert.ToInt32(Enumaretion.SanctionUserType.BAMELCO); var oReferUserList = obDBCtxt.OSUSERs.Where(t => t.USERTYPE == UserType && t.ISACTIVE).Distinct().ToList(); UIUtility.FillCombo(ddlReferTo, "DETAILINFO", "EMPLOYEEID", oReferUserList, true, false); ddlRefStatus.SelectedIndex = 1;//to inititate a request in value 1 txtACOpen.Text = string.Empty; ddlRefStatus.Enabled = false; ddlReferTo.Enabled = true; } gvCaseInfo.DataSource = CaseList; gvCaseInfo.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (CheckEndSession()) { Response.Redirect("~/LogIn.aspx"); } else { var oSDNListSdnType = obDBCtxt.SDNLISTs.Select(t => t.SDNTYPE).Distinct().ToList(); UIUtility.FillCombo(ddlSdnType, oSDNListSdnType.ToArray(), true, false); var oSDNListCountry = obDBCtxt.SDNLISTs.Where(p => !string.IsNullOrEmpty(p.COUNTRY)).Select(t => t.COUNTRY.Trim()).Distinct().ToList(); UIUtility.FillCombo(ddlCountry, oSDNListCountry.ToArray(), true, false); if ((Request.QueryString["NAME"] != null && !string.IsNullOrEmpty(Request.QueryString["NAME"].ToString().Trim())) || (Request.QueryString["ADRS"] != null && !string.IsNullOrEmpty(Request.QueryString["ADRS"].ToString().Trim())) || (Request.QueryString["SDNTYPE"] != null && !string.IsNullOrEmpty(Request.QueryString["SDNTYPE"].ToString().Trim())) || (Request.QueryString["PURPOSE"] != null && !string.IsNullOrEmpty(Request.QueryString["PURPOSE"].ToString().Trim())) || (Request.QueryString["PERCENTAGE"] != null && !string.IsNullOrEmpty(Request.QueryString["PERCENTAGE"].ToString().Trim())) || (Request.QueryString["DOB"] != null && !string.IsNullOrEmpty(Request.QueryString["DOB"].ToString().Trim())) || (Request.QueryString["COUNTRY"] != null && !string.IsNullOrEmpty(Request.QueryString["COUNTRY"].ToString().Trim()))) { if (Request.QueryString["NAME"] != null && !string.IsNullOrEmpty(Request.QueryString["NAME"].ToString().Trim())) { txtSrchName.Text = (Request.QueryString["NAME"] != null) ? Request.QueryString["NAME"].ToString().Trim() : ""; } if (Request.QueryString["ADRS"] != null && !string.IsNullOrEmpty(Request.QueryString["ADRS"].ToString().Trim())) { txtAddress.Text = (Request.QueryString["ADRS"] != null) ? Request.QueryString["ADRS"].ToString().Trim() : ""; } if (Request.QueryString["SDNTYPE"] != null && !string.IsNullOrEmpty(Request.QueryString["SDNTYPE"].ToString().Trim())) { ddlSdnType.SelectedValue = ddlSdnType.Items.FindByText(Request.QueryString["SDNTYPE"].ToString().Trim()).Value; } if (Request.QueryString["PURPOSE"] != null && !string.IsNullOrEmpty(Request.QueryString["PURPOSE"].ToString().Trim())) { ddlPurpose.SelectedValue = ddlPurpose.Items.FindByText(Request.QueryString["PURPOSE"].ToString().Trim()).Value; } if (Request.QueryString["PERCENTAGE"] != null && !string.IsNullOrEmpty(Request.QueryString["PERCENTAGE"].ToString().Trim())) { txtPercentage.Text = (Request.QueryString["PERCENTAGE"] != null) ? Request.QueryString["PERCENTAGE"].ToString().Trim() : "50"; } if (Request.QueryString["DOB"] != null && !string.IsNullOrEmpty(Request.QueryString["DOB"].ToString().Trim())) { txtDOB.Text = (Request.QueryString["DOB"] != null) ? Request.QueryString["DOB"].ToString().Trim() : ""; } if (Request.QueryString["COUNTRY"] != null && !string.IsNullOrEmpty(Request.QueryString["COUNTRY"].ToString().Trim())) { ddlCountry.SelectedValue = ddlCountry.Items.FindByText(Request.QueryString["COUNTRY"].ToString().Trim()).Value; } LoadGrid(); if (Request.QueryString["SRCHID"] != null && !string.IsNullOrEmpty(Request.QueryString["SRCHID"].ToString().Trim())) { string SrchId = Request.QueryString["SRCHID"].ToString().Trim(); oOSSearchHistory = obDBCtxt.OSSearchHistories.FirstOrDefault(t => t.SearchRefNo == SrchId); lblSearchID.Text = oOSSearchHistory.SearchRefNo; txtACOpen.Text = (oOSSearchHistory.IsSuspicious == true && !string.IsNullOrEmpty(oOSSearchHistory.ACOpenBy)) ? oOSSearchHistory.ACOpenBy : string.Empty; //btnSuspicious.InnerText = (oOSSearchHistory.IsSuspicious == true && !string.IsNullOrEmpty(oOSSearchHistory.ACOpenBy)) ? "Suspicious(+)" : "Suspicious"; SetReferInfo(oOSSearchHistory.SearchRefNo); } else if (Session["SRCHID"] != null && !string.IsNullOrEmpty(Session["SRCHID"].ToString().Trim())) { string SrchId = Request.QueryString["SRCHID"].ToString().Trim(); oOSSearchHistory = obDBCtxt.OSSearchHistories.FirstOrDefault(t => t.SearchRefNo == SrchId); lblSearchID.Text = oOSSearchHistory.SearchRefNo; txtACOpen.Text = (oOSSearchHistory.IsSuspicious == true && !string.IsNullOrEmpty(oOSSearchHistory.ACOpenBy)) ? oOSSearchHistory.ACOpenBy : string.Empty; SetReferInfo(oOSSearchHistory.SearchRefNo); //btnSuspicious.InnerText = (oOSSearchHistory.IsSuspicious == true && !string.IsNullOrEmpty(oOSSearchHistory.ACOpenBy)) ? "Suspicious(+)" : "Suspicious"; } //Session["SText"] = "NAME=" + Request.QueryString["NAME"].ToString().Trim() + "&SDNTYPE=" + Request.QueryString["SDNTYPE"].ToString().Trim(); } else { } } } }