protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
// GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
// string state = (GridView1.Rows[e.RowIndex].FindControl("ddl_state") as DropDownList).SelectedItem.Value;
//GridView1.DataKeys[e.RowIndex].Values["ofc_map_id"].ToString();
bl_employee_action bl_emp_action = new bl_employee_action();
dl_RTIReAssign dl_rti = new dl_RTIReAssign();
bl_emp_action.Rti_status = "PEN";
bl_emp_action.Dept_Status = (GridView1.Rows[e.RowIndex].FindControl("ddl_dept_status") as DropDownList).SelectedItem.Value;
bl_emp_action.R_office_map_id = (GridView1.Rows[e.RowIndex].FindControl("ddl_officer_grid") as DropDownList).SelectedItem.Value;
bl_emp_action.Ipaddress = ul.GetClientIpAddress(this.Page);
HttpBrowserCapabilities browse = Request.Browser;
bl_emp_action.User_browser = browse.Browser;
bl_emp_action.Useros = Utilities.System_Info(this.Page);
bl_emp_action.Useragent = Request.UserAgent.ToString();
bl_emp_action.Isnew = "Y";
bl_emp_action.Userid = Session["username"].ToString();
bl_emp_action.Rti_id = GridView1.DataKeys[e.RowIndex].Values["rti_id"].ToString();;
DateTime today = DateTime.Today;
bl_emp_action.Action_date = today.ToString("yyyy/MM/dd");
rb = dl_rti.Update_RTIstatus(bl_emp_action);
if (rb.status == true)
{
if (Session["language"].ToString() == "en-GB")
{
Utilities.MessageBox_UpdatePanel(UpdatePanel1, "Update Successsfully");
}
else
{
Utilities.MessageBox_UpdatePanel(UpdatePanel1, "अपडेट सफल हुआ");
}
// Utilities.MessageBox_UpdatePanel(UpdatePanel1, "Update Successsfully");
}
else
{
if (Session["language"].ToString() == "en-GB")
{
Utilities.MessageBox_UpdatePanel(UpdatePanel1, "Update UnSuccesssfully");
}
else
{
Utilities.MessageBox_UpdatePanel(UpdatePanel1, "अपडेट असफल हुआ");
}
//Utilities.MessageBox_UpdatePanel(UpdatePanel1, "update Unsuccessful");
}
GridView1.EditIndex = -1;
BindGridView();
bind_office();
bind_district_code();
bind_department_id();
}
public void BindRTIStatus()
{
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"));
}
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 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"));
}
protected void BindGridView()
{
dl_RTIReAssign dl_rti = new dl_RTIReAssign();
bl.State_id = "22"; // ddl_state.SelectedValue;
bl.District_id = ddl_district.SelectedValue;
bl.Department = ddl_department.SelectedValue;
bl.Office_id = ddl_office.SelectedValue;
bl.Office_mapping_id = ddl_officer.SelectedValue;
bl.RTI_dept_status = ddl_status.SelectedValue;
rd = dl_rti.Bind_grid(bl);
int row = rd.table.Rows.Count;
int page;
if (row % 20 == 0)
{
page = row / 20;
}
else
{
page = row / 20;
page = page + 1;
}
if (Session["language"].ToString() == "en-GB")
{
lbl_count.Text = "Total RTI = " + row.ToString() + " and Total page = " + page.ToString() + "";
}
else
{
lbl_count.Text = "कुल आर.टी.आई. = " + row.ToString() + " और कुल पेज = " + page.ToString() + "";
}
//lbl_count.Text = "Total Rows = " + row.ToString() + " and Total page = " + page.ToString() + "";
GridView1.DataSource = rd.table;
GridView1.DataBind();
}
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);
// }
// }
//}
}
