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);
// }
// }
//}
}
