public ReturnClass.ReturnDataTable BindOfficerDL(bl_RTI_Request bl) { string str = @"select office_mapping_id,concat( A.Name_en,'/', dg.Designation_Name ,'/',ofc.OfficeName ) as Name_en from employee_table as A inner join emp_office_mapping as B on A.emp_id=B.emp_code inner join designation as dg on dg.Designation_ID = B.designation_id inner join office as ofc on ofc.NewOfficeCode = B.office_id where B.base_department_id= @base_department_id and B.office_level_id= @office_level_id and B.district_id_ofc=@district_id_ofc and B.office_category= @office_category and B.office_id=@office_id and B.Active='Y' and dg.Designation_ID='2' order by Name_en asc"; //string str = "select office_mapping_id, Name_en from employee_table A, emp_office_mapping B where A.emp_id=B.emp_code and " + // " B.base_department_id= @base_department_id and B.office_level_id= @office_level_id " + // " and B.district_id_ofc=@district_id_ofc and B.office_category= @office_category and B.office_id=@office_id and B.Active='Y' order by Name_en asc"; MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("base_department_id", bl.Base_department_id), new MySqlParameter("office_level_id", bl.Office_level_id), new MySqlParameter("district_id_ofc", bl.District_id_ofc), new MySqlParameter("office_category", bl.Office_category), new MySqlParameter("office_id", bl.Office_id) }; ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable(); db_maria_connection db = new db_maria_connection(); rd = db.executeSelectQuery(str, pm); return(rd); }
} // End //ReturnClass.ReturnDataTable GetRtiStatus_detail(bl_RTI_Request bl) //{ // ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable(); // db_maria_connection db = new db_maria_connection(); // string str = "select rti_id, Isvalid from rti_status where rti_id = @rti_id"; // MySqlParameter[] pm = new MySqlParameter[] // { // new MySqlParameter("rti_id",bl.RTI_Request_id) // }; // dt = db.executeSelectQuery(str, pm); // return dt; //} ////end of Get Rti Status ISvalid public ReturnClass.ReturnBool update_Rti_status(bl_RTI_Request bl) { ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool(); db_maria_connection db = new db_maria_connection(); using (TransactionScope ts = new TransactionScope()) { string str = "insert into rti_status_log select * from rti_status WHERE rti_status.rti_id = @regid1"; MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("regid1", bl.RTI_Request_id) }; rb = db.executeInsertQuery(str, pm); if (rb.status == true) { string str1 = "Update rti_status set Isvalid=@isvalid where rti_id = @rtiid "; MySqlParameter[] pm1 = new MySqlParameter[] { new MySqlParameter("isvalid", bl.IsValid), new MySqlParameter("rtiid", bl.RTI_Request_id) }; rb = db.executeUpdateQuery(str1, pm1); if (rb.status == true) { ts.Complete(); } } } return(rb); }
}//end public ReturnClass.ReturnBool Insert_rti_status(bl_RTI_Request ur) { string strQuery = "INSERT INTO rti_status " + "( rti_id, user_id, status, action_id, officer_maping_id, IPAddress, action_date, IsValid, IsNew , client_OS, useragent , client_browser)" + " VALUES ( @rti_ID, @user_id, @status, @action_id, @officer_maping_id, @IPAddress, @action_date, @isValid, @isnew, @client_OS , @useragent, @client_browser )"; MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("rti_ID", ur.RTI_filed_user_id), new MySqlParameter("user_id", ur.RTI_login_userName), new MySqlParameter("status", ur.Rti_Status), new MySqlParameter("action_id", ur.Action_id), new MySqlParameter("officer_maping_id", ur.Office_mapping_id), new MySqlParameter("IPAddress", ur.RTI_ipaddress), new MySqlParameter("action_date", ur.Action_date), new MySqlParameter("isValid", ur.IsValid), new MySqlParameter("isnew", ur.IsNew), new MySqlParameter("client_OS", ur.Client_os), new MySqlParameter("useragent", ur.UserAgent), new MySqlParameter("client_browser", ur.ClientBrowser) }; ReturnClass.ReturnBool dt = null; db_maria_connection objDB = new db_maria_connection(); dt = objDB.executeInsertQuery(strQuery, pm); return(dt); }//end of Insert_rti_filed_user
public ReturnClass.ReturnDataTable GetMobileNumForVerification(bl_RTI_Request bl) { string str = "select User_ID, Mobile_No From rti_detail where rti_id=@RTI_RequestID"; MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("RTI_RequestID", bl.RTI_Request_id) }; ReturnClass.ReturnDataTable rd = null;// new ReturnClass.ReturnDataTable(); db_maria_connection db = new db_maria_connection(); rd = db.executeSelectQuery(str, pm); return(rd); }
public ReturnClass.ReturnDataTable BindState(bl_RTI_Request bl) { string str = "select state_id, state_name_e from state where cid= @cid order by state_name_e asc"; MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("cid", bl.Country) }; ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable(); db_maria_connection db = new db_maria_connection(); rd = db.executeSelectQuery(str, pm); return(rd); }
public ReturnClass.ReturnDataTable BindDistrict(bl_RTI_Request bl) { //string str = "select District_ID,District_Name_En from Districts where StateCode=@state ORDER BY District_Name_En asc "; string str = "select District_ID,District_Name from Districts where StateCode=@state ORDER BY District_Name asc "; MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("state", bl.State) }; ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable(); db_maria_connection db = new db_maria_connection(); rd = db.executeSelectQuery(str, pm); return(rd); }
public ReturnClass.ReturnDataTable GetRtiStatus_detail(bl_RTI_Request bl) { ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable(); db_maria_connection db = new db_maria_connection(); string str = @"select rs.rti_id as rtiid, rs.IsValid as isvalid, rd.securitycode as seqcode from rti_status rs inner join rti_detail rd on rd.rti_id = rs.rti_id where rs.rti_id = @rti_id"; MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("rti_id", bl.RTI_Request_id) }; dt = db.executeSelectQuery(str, pm); return(dt); }
public void bind_district() // user district { bl_RTI_Request bl = new bl_RTI_Request(); dl_RTI_Request dl = new dl_RTI_Request(); ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable(); ddl_district.Items.Clear(); bl.State = DDL_State.SelectedValue; rd = dl.BindDistrict(bl); ddl_district.DataSource = rd.table; ddl_district.DataTextField = "District_Name"; ddl_district.DataValueField = "District_ID"; ddl_district.DataBind(); ddl_district.Items.Add(new ListItem("Choose District", "0")); }
public void bind_state() { bl_RTI_Request objblData = new bl_RTI_Request(); dl_RTI_Request objData = new dl_RTI_Request(); ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable(); DDL_State.Items.Clear(); objblData.Country = ddl_country.SelectedValue; rd = objData.BindState(objblData); DDL_State.DataSource = rd.table; DDL_State.DataTextField = "state_name_e"; DDL_State.DataValueField = "state_id"; DDL_State.DataBind(); DDL_State.Items.Add(new ListItem(" Choose State", "0")); }
public void ShowUserData() { bl_RTI_Request objblData = new bl_RTI_Request(); objblData.RTI_login_userName = userID; dl_RTI_Request objData = new dl_RTI_Request(); ReturnClass.ReturnDataTable dt = objData.GetUserData(objblData); if (dt.status) { ddl_country.SelectedValue = objblData.Country; bind_state(); DDL_State.SelectedValue = objblData.State; bind_district(); txtName.Text = objblData.NameEnglish; txtEmailID.Text = objblData.Email; txtAddress.Text = objblData.Address; txtPinCode.Text = objblData.Pincode; ddl_usertype.SelectedIndex = ddl_usertype.Items.IndexOf(ddl_usertype.Items.FindByValue(objblData.UserType)); txtMobile.Text = objblData.Mobile; H_LoginMobileNo.Value = objblData.Mobile; // Keep user login mobile no. DDL_Gender.SelectedIndex = DDL_Gender.Items.IndexOf(DDL_Gender.Items.FindByValue(objblData.Gender)); ddl_country.SelectedIndex = ddl_country.Items.IndexOf(ddl_country.Items.FindByValue(objblData.Country)); if (objblData.Country == "999") { txtOther.Visible = true; lbl_state.Text = "Country Name"; //rfv_state.Enabled = true; RFV_State.Enabled = false; rfv_district.Enabled = false; REV_PinCode.Enabled = false; //lbl_district.Visible = false; ctc.Visible = false; ddl_district.Visible = false; DDL_State.Visible = false; ddlState.Visible = false; // txtState_Other.Text = ""; txtState_Other.Text = objblData.CountryName; } else { DDL_State.SelectedIndex = DDL_State.Items.IndexOf(DDL_State.Items.FindByValue(objblData.State)); ddl_district.SelectedIndex = ddl_district.Items.IndexOf(ddl_district.Items.FindByValue(objblData.District)); } } // End of If }
public ReturnClass.ReturnBool Insert_RTI_detail(bl_RTI_Request ur) { string strQuery = "INSERT INTO rti_detail " + "( rti_id, applicant_type, Applicant_Name_en, Gender, Email_ID, Address, Country_Code, Country_Name," + " State_Code, District_Code, Pin_Code, Mobile_No, Is_BPL, BPL_Card_No, BPL_Year_Issue, BPL_Issuing_Authority, " + " rti_Subject, rti_Details, User_ID, Client_IP,securitycode , IsRTIFileUpload, Client_OS, ClientBrowser, UserAgent ) " + " VALUES (@rti_id, @applicant_type, @Applicant_Name_en, @Gender, @Email_ID, @Address, @Country_Code, @country_Name, @State_Code, " + " @District_Code, @Pin_Code, @Mobile_No, @Is_BPL, @BPL_Card_No, @BPL_Year_Issue, @BPL_Issuing_Authority, " + " @rti_Subject, @rti_Details, @User_ID, @Client_IP, @securitycode, @is_RTI_FILE_Upload, @ClientOS, @clientBrowser, @userAgent )"; MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("rti_id", ur.RTI_Request_id), new MySqlParameter("applicant_type", ur.UserType), new MySqlParameter("Applicant_Name_en", ur.NameEnglish), new MySqlParameter("Gender", ur.Gender), new MySqlParameter("Email_ID", ur.Email), new MySqlParameter("Address", ur.Address), new MySqlParameter("Country_Code", ur.Country), new MySqlParameter("State_Code", ur.State), new MySqlParameter("District_Code", ur.District), new MySqlParameter("Pin_Code", ur.Pincode), new MySqlParameter("Mobile_No", ur.Mobile), new MySqlParameter("Is_BPL", ur.RTI_Is_bpl), new MySqlParameter("BPL_Card_No", ur.BPL_Card_No), new MySqlParameter("BPL_Year_Issue", ur.BPL_Issue_Year), new MySqlParameter("BPL_Issuing_Authority", ur.BPL_Issuing_Authority), new MySqlParameter("rti_Subject", ur.Rti_Subject), new MySqlParameter("rti_Details", ur.RTI_Text), new MySqlParameter("User_ID", ur.RTI_login_userName), new MySqlParameter("country_Name", ur.CountryName), new MySqlParameter("Client_IP", ur.RTI_ipaddress), new MySqlParameter("securitycode", ur.Securitycode), new MySqlParameter("is_RTI_FILE_Upload", ur.IsRTIFileUpload), new MySqlParameter("userAgent", ur.UserAgent), new MySqlParameter("ClientOS", ur.Client_os), new MySqlParameter("clientBrowser", ur.ClientBrowser) }; ReturnClass.ReturnBool dt = null; db_maria_connection objDB = new db_maria_connection(); dt = objDB.executeInsertQuery(strQuery, pm); return(dt); }//end
public void BindOfficer() { bl_RTI_Request objblData = new bl_RTI_Request(); dl_RTIReAssign objData = new dl_RTIReAssign(); ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable(); //DDL_RTI_Officer.Items.Clear(); objblData.Base_department_id = ddl_department.SelectedValue; objblData.District_id_ofc = ddl_district.SelectedValue; objblData.Office_id = ddl_office.SelectedValue; rd = objData.BindOfficerDL(objblData); ddl_officer.DataSource = rd.table; ddl_officer.DataTextField = "Name_en"; ddl_officer.DataValueField = "office_mapping_id"; ddl_officer.DataBind(); // DDL_RTI_Officer.Items.Add(new ListItem(" select officer", "0")); ddl_officer.Items.Insert(0, new ListItem("--Select Officer--", "0")); }
public ReturnClass.ReturnDataTable BindOfficerDL(bl_RTI_Request bl) { string str = "select office_mapping_id, Name_en from employee_table A, emp_office_mapping B where A.emp_id=B.emp_code and " + " B.base_department_id= @base_department_id and B.office_level_id= @office_level_id " + " and B.district_id_ofc=@district_id_ofc and B.office_category= @office_category and B.office_id=@office_id and B.Active='Y' order by Name_en asc"; MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("base_department_id", bl.Base_department_id), new MySqlParameter("office_level_id", bl.Office_level_id), new MySqlParameter("district_id_ofc", bl.District_id_ofc), new MySqlParameter("office_category", bl.Office_category), new MySqlParameter("office_id", bl.Office_id) }; ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable(); db_maria_connection db = new db_maria_connection(); rd = db.executeSelectQuery(str, pm); return(rd); }
public void bind_grid_officer() { DropDownList ddl_office = (DropDownList)GridView1.Rows[GridView1.EditIndex].FindControl("ddl_office_grid"); DropDownList ddl_district = (DropDownList)GridView1.Rows[GridView1.EditIndex].FindControl("ddl_district_grid"); DropDownList ddl_department = (DropDownList)GridView1.Rows[GridView1.EditIndex].FindControl("ddl_department_grid"); DropDownList ddl_officer = (DropDownList)GridView1.Rows[GridView1.EditIndex].FindControl("ddl_officer_grid"); bl_RTI_Request objblData = new bl_RTI_Request(); dl_RTIReAssign objData = new dl_RTIReAssign(); ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable(); objblData.District_id_ofc = ddl_district.SelectedValue; objblData.Base_department_id = ddl_department.SelectedValue; objblData.Office_id = ddl_office.SelectedValue; rd = objData.BindOfficerDL(objblData); ddl_officer.DataSource = rd.table; ddl_officer.DataTextField = "Name_en"; ddl_officer.DataValueField = "office_mapping_id"; ddl_officer.DataBind(); ddl_officer.Items.Insert(0, new ListItem("--Select Officer--", "0")); }
}// end of get GetGender public ReturnClass.ReturnDataTable GetUserData(bl_RTI_Request ur) { ReturnClass.ReturnDataTable dt = null;// = new ReturnClass.ReturnDataTable(); db_maria_connection db = new db_maria_connection(); try { string qr = "SELECT Name_hi, Name_en, EmailID, Gender, Address, PinCode, Country, StateCode, UserType, " + " MobileNo, DistrictCode, Country_name " + " FROM user_registration WHERE UserID=@userid AND IsValid='Y' "; MySqlParameter[] pr = new MySqlParameter[] { new MySqlParameter("userid", ur.RTI_login_userName) }; dt = db.executeSelectQuery(qr, pr); //dt = db.executeSelectQuery(qr); if (dt.table != null) { ur.NameEnglish = dt.table.Rows[0]["Name_en"].ToString(); ur.NameHindi = dt.table.Rows[0]["Name_hi"].ToString(); ur.Email = dt.table.Rows[0]["EmailID"].ToString(); ur.Gender = dt.table.Rows[0]["Gender"].ToString(); ur.Address = dt.table.Rows[0]["Address"].ToString(); ur.Pincode = dt.table.Rows[0]["PinCode"].ToString(); ur.Country = dt.table.Rows[0]["Country"].ToString(); ur.State = dt.table.Rows[0]["StateCode"].ToString(); ur.UserType = dt.table.Rows[0]["UserType"].ToString(); ur.Mobile = dt.table.Rows[0]["MobileNo"].ToString(); ur.District = dt.table.Rows[0]["DistrictCode"].ToString(); ur.CountryName = dt.table.Rows[0]["Country_name"].ToString(); } dt.status = true; } catch (Exception Ex) { dt.status = false; dt.message = Ex.Message; } return(dt); }// end of get GetUserData
// end of MObile Varification Update public ReturnClass.ReturnBool Insert_RTI_Info(bl_RTI_Request ur, List <bl_RTI_RequestFiles> ur_files) { ReturnClass.ReturnBool dt = new ReturnClass.ReturnBool(); ReturnClass.ReturnBool dt1 = null; ReturnClass.ReturnBool dt2 = null; ReturnClass.ReturnBool dt3 = null; using (TransactionScope transScope = new TransactionScope()) { dt1 = Insert_RTI_detail(ur); //Insert_RTI_Request(objBL); if (dt1.status == true) { dt2 = Insert_rti_status(ur); if (dt2.status == true) { foreach (var ur_file in ur_files) { dt3 = Insert_RTI_files(ur_file); if (dt3.status == false) { break; } } // end of foreach } //if dt1 status } // if dt2 status if ((dt3 == null || dt3.status == true) && dt1.status == true && dt2.status == true) { try { transScope.Complete(); dt.status = true; } catch (Exception ex) { dt.status = false; } } //End of dt3.status } // endof transcope return(dt); }
}// Button2_click End protected void btn_close_Click(object sender, EventArgs e) { string otp_sc = null; if (Session["OTP_SC"] != null) { otp_sc = Session["OTP_SC"].ToString(); } string rti_id = Session["RTI_ID"].ToString(); string payment, due; ReturnClass.ReturnDataTable dtt = new ReturnClass.ReturnDataTable(); bl_RTI_Request blrti = new bl_RTI_Request(); dl_RTI_Request dlrti = new dl_RTI_Request(); ReturnClass.ReturnBool rtbool = new ReturnClass.ReturnBool(); try { bl.RTI_provisional_no = Session["RTI_ID"].ToString(); blrti.RTI_Request_id = bl.RTI_provisional_no; blrti.IsPaymentMade = "Y"; dt = dl.getrecord(bl); if (dt.table.Rows.Count > 0) { dtt = dl.getamount(bl); if (dtt.table.Rows.Count > 0) { payment = dtt.table.Rows[0]["Fees"].ToString(); if (Convert.ToInt32(payment) >= (Convert.ToInt32(amounttobepaid))) { // Update payment status rtbool = dlrti.update_Rti_Payment_status(blrti); if (rtbool.status == true) { if (otp_sc != null) { // Directly go to success page No Need OTP string rti_message = ""; if (Session["language"].ToString() == "en-GB") { rti_message = "RTI Submission successfull your Registration no. is: " + rti_id + " And Your Security Code is: " + otp_sc + " please save details for further Information."; } else { rti_message = "आपका आर. टी. आई. सफलता पूर्वक सबमिट हो गया, आपका रजिस्ट्रेशन न. है " + rti_id + " और सुरक्षा कोड है " + otp_sc + "कृपया विवरण को उपयोग के लिए सुरक्षित रखें|"; } // string rti_message = "RTI Submition successfull your Registration no. is: " + rti_id + " And Your Security Code is: " + otp_sc + " please save details for further Information."; Utilities.MessageBox_UpdatePanel_Redirect(UpdatePanel3, rti_message, "../user/UserWelcome.aspx"); } else { if (Session["language"].ToString() == "en-GB") { Utilities.MessageBox_UpdatePanel_Redirect(UpdatePanel3, "Your RTI Request has been submited Need Mobile Verification for Registeration", "../user/User_Mobile_Varification.aspx"); } else { Utilities.MessageBox_UpdatePanel_Redirect(UpdatePanel3, "आपका आर. टी. आई. सबमिट हो गया, आपको रजिस्ट्रेशन के लिए मोबाईल वेरिफिकेसन की जरुरत है| ", "../user/User_Mobile_Varification.aspx"); } //Utilities.MessageBox_UpdatePanel_Redirect(UpdatePanel3, "Your RTI Request has been submited Need Mobile Verification for Registeration", "../user/User_Mobile_Varification.aspx"); } } else { if (Session["language"].ToString() == "en-GB") { Utilities.MessageBox_UpdatePanel(UpdatePanel3, "Failed to update Payment status ! Try again"); } else { Utilities.MessageBox_UpdatePanel(UpdatePanel3, "भुगतान की स्थिति अपडेट करने में विफल ! पुनः प्रयास करें"); } // Utilities.MessageBox_UpdatePanel(UpdatePanel3, "Failed to update Payment status ! Try again"); } } else { due = ((Convert.ToInt32(amounttobepaid)) - (Convert.ToInt32(payment))).ToString(); if (((Convert.ToInt32(amounttobepaid)) - (Convert.ToInt32(payment))) >= 0) { if (Session["language"].ToString() == "en-GB") { Utilities.MessageBox_UpdatePanel(UpdatePanel3, "Please Pay Due Amount Rs. " + due + " By e-challan than Proceed."); } else { Utilities.MessageBox_UpdatePanel(UpdatePanel3, "कृपया देय राशि का भुगतान करें रु. " + due + " ई-चालान के द्वारा फिर आगे बढ़ें|"); } // Utilities.MessageBox_UpdatePanel(UpdatePanel3, "Please Pay Due Amount " + due + " By e-challan than Proceed"); } } } } else { Button2.Visible = true; if (Session["language"].ToString() == "en-GB") { Utilities.MessageBox_UpdatePanel(UpdatePanel3, "Please Pay Due Amount Rs. " + amounttobepaid + " By e-challan than Proceed."); } else { Utilities.MessageBox_UpdatePanel(UpdatePanel3, "कृपया देय राशि का भुगतान करें रु. " + amounttobepaid + " ई-चालान के द्वारा फिर आगे बढ़ें|"); } // Utilities.MessageBox_UpdatePanel(UpdatePanel3, "Please Pay Due Amount " + amounttobepaid + " By e-challan than Proceed"); } } catch (NullReferenceException) { if (Session["language"].ToString() == "en-GB") { Utilities.MessageBox_UpdatePanel_Redirect(UpdatePanel3, "Your Session is Expired...Please login Again ", "../Logout.aspx"); } else { Utilities.MessageBox_UpdatePanel_Redirect(UpdatePanel3, "आपका सत्र समाप्त हो गया है...कृपया फिर से लॉग इन करें ", "../Logout.aspx"); } // Utilities.MessageBox_UpdatePanel_Redirect(UpdatePanel3, "Your Session is Expire...Please login Again ", "../Logout.aspx"); } } // End of btn_close_Click
protected void btn_Submit_Click1(object sender, EventArgs e) { if (Page.IsValid) { if (Session["CheckRefresh"].ToString() == ViewState["CheckRefresh"].ToString()) { Session["CheckRefresh"] = Server.UrlDecode(System.DateTime.Now.ToString()); bool cptch_expired = false; try { Captcha1.ValidateCaptcha(txtCaptcha.Text.Trim()); } catch { cptch_expired = true; } txtCaptcha.Text = ""; if (!cptch_expired) { if (Captcha1.UserValidated) { Captcha1.DataBind(); dl_RTI_Registration dl = new dl_RTI_Registration(); bl_RTI_Request objBL = new bl_RTI_Request(); dl_RTI_Request objDl = new dl_RTI_Request(); // set data for rti_request objBL.RTI_Request_id = objDl.Get_unique_RtiRequest_code(); //"<NTC>RTI Request ID from DL";//objDl.GetMaxValue("SELECT IFNULL(MAX(rti_request_id),0) as NO FROM rti_detail "); objBL.UserType = ddl_usertype.SelectedItem.Value; objBL.NameEnglish = txtName.Text; objBL.Gender = DDL_Gender.SelectedItem.Value; objBL.Email = txtEmailID.Text; objBL.Address = txtAddress.Text; objBL.Country = ddl_country.SelectedItem.Value; objBL.Securitycode = dl.GenOTPString(4); HttpBrowserCapabilities browse = Request.Browser; objBL.UserAgent = Request.UserAgent.ToString(); objBL.Client_os = Utilities.System_Info(this.Page); objBL.ClientBrowser = browse.Browser; objBL.IsRTIFileUpload = "N"; objBL.IsNew = "Y"; if (objBL.Country == "091") { objBL.State = DDL_State.SelectedItem.Value; objBL.District = ddl_district.SelectedItem.Value; objBL.CountryName = null; } else { objBL.CountryName = txtState_Other.Text; } objBL.Pincode = txtPinCode.Text; objBL.Mobile = txtMobile.Text; objBL.Rti_Subject = txt_subject.Text; objBL.RTI_Text = txt_RequestApplicationText.Text; objBL.RTI_login_userName = userID; //objBL.RTI_request_date = DateTime.Now.ToString("yyyy-MM-dd"); Utilities util = new Utilities(); objBL.RTI_ipaddress = util.GetClientIpAddress(this.Page);//GetIPAddress(); objBL.RTI_Is_bpl = DDL_BPL.SelectedItem.Value; # region check for BPL if (objBL.RTI_Is_bpl == "Y") { if (FU_BPL.PostedFile == null || FU_BPL.PostedFile.ContentLength < 1) { Utilities.MessageBox_UpdatePanel(update1, "Attach one BPL Supporting Document "); return; } objBL.BPL_Card_No = txtBPLNo.Text; int Current_year = Convert.ToInt32(DateTime.Now.Year); int find_year = Convert.ToInt32(txtYearOfIssue.Text); if (find_year > Current_year) { // Utilities.MessageBoxShow("Year should not be greater then current year"); Utilities.MessageBox_UpdatePanel(update1, "Year should not be greater then current year "); return; } else { objBL.BPL_Issue_Year = txtYearOfIssue.Text; } objBL.BPL_Issuing_Authority = txtIssuingAuthority.Text; //objBL.RTI_Fees = "0"; } else { //objBL.RTI_Fees = "10"; } #endregion BPL // set data for rti_filed_user // objBL.RTI_filed_user_id = objDl.GetMaxValueRtiFiledUser();//"<NTC>RTI Filed user ID from DL"; //objDl.GetMaxValue("SELECT IFNULL(MAX(rti_FiledUserID),0) as NO FROM rti_filed_user "); # region file submit problem is generating here objBL.RTI_filed_user_id = objBL.RTI_Request_id; objBL.Rti_Status = "REG"; //Initial status of RTI Filed objBL.Action_id = ""; objBL.IsValid = "N"; objBL.Office_mapping_id = DDL_RTI_Officer.SelectedValue; objBL.Action_date = DateTime.Now.ToString("yyyy-MM-dd"); // Need to ask //objBL.Rti_Status = "registered"; // initial status //set data for rti_file string RTI_fileID = objDl.GetMaxValueRtiFiles();// "<NTC> file iD";//objDl.GetMaxValue("SELECT IFNULL(MAX(rti_fileID),0) as NO FROM rti_files "); List <bl_RTI_RequestFiles> objList = new List <bl_RTI_RequestFiles>(); int maxCountFileID = Convert.ToInt32(RTI_fileID); if (FU_BPL.PostedFile != null && FU_BPL.PostedFile.FileName != "") { if (FU_BPL.PostedFile.ContentLength > 0) { bl_RTI_RequestFiles objBLFile = new bl_RTI_RequestFiles(); HttpPostedFile postedFile = FU_BPL.PostedFile; objBLFile.FileDescription = txt_FU_BPL_Disc.Text; objBLFile.RTI_fileID = maxCountFileID.ToString(); objBLFile.RTI_fileName = Path.GetFileName(postedFile.FileName); objBLFile.RTI_fileType = postedFile.ContentType; objBLFile.BPL_RTI_FileType = "BPL_DOC"; // it is a BPL Supporting Document objBLFile.RTI_Request_id = objBL.RTI_Request_id; Stream fs = postedFile.InputStream; if ((objBLFile.RTI_fileType == "application/pdf" || objBLFile.RTI_fileType == "application/x-pdf" || objBLFile.RTI_fileType == "application/x-unknown") && fs.Length < 2097152) { BinaryReader br = new BinaryReader(fs); byte[] bytes = br.ReadBytes((Int32)fs.Length); objBLFile.RTI_fileData = bytes; maxCountFileID = maxCountFileID + 1; objList.Add(objBLFile); // Add into the list } else { //statusCount = 1; // Utilities.MessageBoxShow("Only Image File and less then 1000 KB is accepted"); //lbl_status.Text = " Only Image File and less then 1000 KB is accepted "; Utilities.MessageBox_UpdatePanel(update1, " Only PDF File and less then 2000 KB is accepted for BPL File"); return; } } else { Utilities.MessageBox_UpdatePanel(update1, " BPL File Size Must be great then Zero"); return; } } // RTI File Insert in data base if (FU_RTI.PostedFile != null && FU_RTI.PostedFile.FileName != "") { if (FU_RTI.PostedFile.ContentLength > 0) { bl_RTI_RequestFiles objBLFile = new bl_RTI_RequestFiles(); HttpPostedFile postedFile = FU_RTI.PostedFile; objBLFile.FileDescription = txt_FU_RTI_Disc.Text; objBLFile.RTI_fileID = maxCountFileID.ToString(); objBLFile.RTI_fileName = Path.GetFileName(postedFile.FileName); objBLFile.RTI_fileType = postedFile.ContentType; objBLFile.BPL_RTI_FileType = "RTI_DOC"; // it is RTI Document objBLFile.RTI_Request_id = objBL.RTI_Request_id; Stream fs = postedFile.InputStream; if ((objBLFile.RTI_fileType == "application/pdf" || objBLFile.RTI_fileType == "application/x-pdf" || objBLFile.RTI_fileType == "application/x-unknown") && fs.Length < 2097152) { BinaryReader br = new BinaryReader(fs); byte[] bytes = br.ReadBytes((Int32)fs.Length); objBLFile.RTI_fileData = bytes; maxCountFileID = maxCountFileID + 1; objList.Add(objBLFile); // Add into the list } else { //statusCount = 1; // Utilities.MessageBoxShow("Only Image File and less then 1000 KB is accepted"); //lbl_status.Text = " Only Image File and less then 1000 KB is accepted "; Utilities.MessageBox_UpdatePanel(update1, " Only PDF File and less then 2000 KB is accepted for RTI File"); return; } } else { Utilities.MessageBox_UpdatePanel(update1, "RTI File Size Must be greater then Zero"); return; } objBL.IsRTIFileUpload = "Y"; } #endregion if (objBL.Mobile == H_LoginMobileNo.Value) { objBL.IsValid = "Y"; } ReturnClass.ReturnBool dt = objDl.Insert_RTI_Info(objBL, objList); if (dt.status == true) { if (objBL.Mobile == H_LoginMobileNo.Value) { // Directly go to success page No Need OTP string rti_message = "RTI Submition successfull your Registration no. is: " + objBL.RTI_Request_id + " And Your Security Code is: " + objBL.Securitycode + " please save details for further Information."; Utilities.MessageBox_UpdatePanel_Redirect(update1, rti_message, "./UserWelcome.aspx"); } else { Session["RTI_ID"] = objBL.RTI_Request_id; Session["VERIFICATION_TYPE"] = "Rti"; Utilities.MessageBox_UpdatePanel_Redirect(update1, "Your RTI Request has been submited Need Mobile Verification for Registeration", "./User_Mobile_Varification.aspx"); } } else { Utilities.MessageBox_UpdatePanel(update1, "RTI Submition Failed"); } }//end of captcha1 validated else { Utilities.MessageBox_UpdatePanel(update1, "Incorrect Security Code"); } } // If ! captch expired } // End of If checkRefresh
protected void RowDataBound(object sender, GridViewRowEventArgs e) { //GridViewRow gvRow = e.Row; //if (gvRow.RowType == DataControlRowType.Header) //{ // GridViewRow gvrow = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Insert); // TableCell cell0 = new TableCell(); // cell0.Text = "RTI Information"; // cell0.HorizontalAlign = HorizontalAlign.Center; // cell0.ColumnSpan = 5; // TableCell cell1 = new TableCell(); // cell1.Text = "Office Information"; // cell1.HorizontalAlign = HorizontalAlign.Center; // cell1.ColumnSpan = 5; // gvrow.Cells.Add(cell0); // gvrow.Cells.Add(cell1); // GridView1.Controls[0].Controls.AddAt(0, gvrow); //} if (e.Row.RowType == DataControlRowType.DataRow) { //if (e.Row.RowType == DataControlRowType.DataRow && GridView1.EditIndex == e.Row.RowIndex) //{ // DropDownList ddl_state = (DropDownList)e.Row.FindControl("ddl_state"); // rd = dl.state_code(); // ddl_state.DataSource = rd.table; // ddl_state.DataTextField = "state_name_e"; // ddl_state.DataValueField = "state_id"; // ddl_state.DataBind(); // ddl_state.Items.Insert(0, new ListItem("Select", "0")); // ddl_state.SelectedValue = GridView1.DataKeys[e.Row.RowIndex].Values["state_id"].ToString(); //} if (e.Row.RowType == DataControlRowType.DataRow && GridView1.EditIndex == e.Row.RowIndex) { DropDownList ddl_district = (DropDownList)e.Row.FindControl("ddl_district_grid"); //DropDownList ddl_state = (DropDownList)e.Row.FindControl("ddl_state"); bl.StateCode = "22"; rd = dl.district_code(bl); ddl_district.DataSource = rd.table; ddl_district.DataTextField = "District_Name"; ddl_district.DataValueField = "District_ID"; ddl_district.DataBind(); ddl_district.Items.Insert(0, new ListItem("--Select--", "0")); ddl_district.SelectedValue = GridView1.DataKeys[e.Row.RowIndex].Values["dist_id"].ToString(); } } if (e.Row.RowType == DataControlRowType.DataRow && GridView1.EditIndex == e.Row.RowIndex) { DropDownList ddl_department = (DropDownList)e.Row.FindControl("ddl_department_grid"); rd = dl.department_id(bl); ddl_department.DataSource = rd.table; ddl_department.DataTextField = "dept_name"; ddl_department.DataValueField = "dept_id"; ddl_department.DataBind(); ddl_department.Items.Insert(0, new ListItem("--Select--", "0")); ddl_department.SelectedValue = GridView1.DataKeys[e.Row.RowIndex].Values["dept_id"].ToString(); } if (e.Row.RowType == DataControlRowType.DataRow && GridView1.EditIndex == e.Row.RowIndex) { DropDownList ddl_office = (DropDownList)e.Row.FindControl("ddl_office_grid"); DropDownList ddl_district = (DropDownList)e.Row.FindControl("ddl_district_grid"); // DropDownList ddl_state = (DropDownList)e.Row.FindControl("ddl_state"); DropDownList ddl_department = (DropDownList)e.Row.FindControl("ddl_department_grid"); bl.StateCode = "22"; bl.DistrictCodeNew = ddl_district.SelectedValue; bl.Department = ddl_department.SelectedValue; rd = dl.office(bl); ddl_office.DataSource = rd.table; ddl_office.DataTextField = "OfficeName"; ddl_office.DataValueField = "NewOfficeCode"; ddl_office.DataBind(); ddl_office.Items.Insert(0, new ListItem("--Select--", "0")); ddl_office.SelectedValue = GridView1.DataKeys[e.Row.RowIndex].Values["ofc_id"].ToString(); } if (e.Row.RowType == DataControlRowType.DataRow && GridView1.EditIndex == e.Row.RowIndex) { DropDownList ddl_office = (DropDownList)e.Row.FindControl("ddl_office_grid"); DropDownList ddl_district = (DropDownList)e.Row.FindControl("ddl_district_grid"); DropDownList ddl_department = (DropDownList)e.Row.FindControl("ddl_department_grid"); DropDownList ddl_officer = (DropDownList)e.Row.FindControl("ddl_officer_grid"); bl_RTI_Request objblData = new bl_RTI_Request(); dl_RTIReAssign objData = new dl_RTIReAssign(); ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable(); objblData.District_id_ofc = ddl_district.SelectedValue; objblData.Base_department_id = ddl_department.SelectedValue; objblData.Office_id = ddl_office.SelectedValue; rd = objData.BindOfficerDL(objblData); ddl_officer.DataSource = rd.table; ddl_officer.DataTextField = "Name_en"; ddl_officer.DataValueField = "office_mapping_id"; ddl_officer.DataBind(); ddl_officer.Items.Insert(0, new ListItem("--Select Officer--", "0")); ddl_officer.SelectedValue = GridView1.DataKeys[e.Row.RowIndex].Values["ofc_map_id"].ToString(); } if (e.Row.RowType == DataControlRowType.DataRow && GridView1.EditIndex == e.Row.RowIndex) { DropDownList ddl_status = (DropDownList)e.Row.FindControl("ddl_dept_status"); dl_RTIReAssign objData = new dl_RTIReAssign(); ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable(); rd = objData.BindRTIStatusDL(); ddl_status.DataSource = rd.table; ddl_status.DataTextField = "name"; ddl_status.DataValueField = "value"; ddl_status.DataBind(); ddl_status.Items.Insert(0, new ListItem("--Select Status--", "0")); } //if (Page.IsPostBack) //{ // if (e.Row.RowType == DataControlRowType.DataRow) // { // DropDownList ddl = e.Row.FindControl("ddl_district_grid") as DropDownList; // if (ddl != null) // { // ddl.AutoPostBack = true; // ddl.SelectedIndexChanged += new EventHandler(ddl_grid_district_SelectedIndexChanged); // } // } //} }