using
System;
using
System.Data;
using
System.Configuration;
using
System.Collections;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System.Web.UI.HtmlControls;
public
partial class Transaction_F_EMP_TransferView : System.Web.UI.Page
{
bool page_allow = false;
bool apprv_transfer = false;bool transfer_emp = false;
bool transfer_view = false;bool tran_reqemp = false;
bool tran_reqhod = false;string comma_FnID;long ReqstrID = 0;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
# region Code for checking the permission of the user based on functionality
try
{
btnfilter.Visible = false;
clsEnumFunctionality function = new clsEnumFunctionality();apprv_transfer = function.IsAccessAllowed((int)clsEnumFunctionality.Functionality.ApprovingTransferRequest);
transfer_emp = function.IsAccessAllowed((
int)clsEnumFunctionality.Functionality.TransferringEmployee);transfer_view = function.IsAccessAllowed((int)clsEnumFunctionality.Functionality.ViewingAllTransferRequests);
tran_reqemp = function.IsAccessAllowed((
int)clsEnumFunctionality.Functionality.RequestTransferOfANormalEmployee);tran_reqhod = function.IsAccessAllowed((int)clsEnumFunctionality.Functionality.RequestingTransferOfHOD);
if (apprv_transfer || transfer_emp || transfer_view || tran_reqemp ||tran_reqhod)
page_allow =
true;place_hold_viewtrans.Visible = true;
comma_FnID =
"";if (apprv_transfer)
comma_FnID = comma_FnID + ((
int)clsEnumFunctionality.Functionality.ApprovingTransferRequest).ToString() + ",";if (transfer_emp)
comma_FnID = comma_FnID + ((
int)clsEnumFunctionality.Functionality.TransferringEmployee).ToString() + ",";if (transfer_view)
comma_FnID = comma_FnID + ((
int)clsEnumFunctionality.Functionality.ViewingAllTransferRequests).ToString()+ ",";if (tran_reqemp)
comma_FnID = comma_FnID + ((
int)clsEnumFunctionality.Functionality.RequestTransferOfANormalEmployee).ToString() + ",";if (tran_reqhod)
comma_FnID = comma_FnID + ((
int)clsEnumFunctionality.Functionality.RequestingTransferOfHOD).ToString();if (page_allow == false)
{
place_hold_viewtrans.Visible = false;lblError.Text = "<b> YOU DONT HAVE THE PERMISSION FOR VIEW THIS PAGE </b>";
}
}
catch (Exception ex) { Response.Redirect(ConfigurationSettings.AppSettings["PAGE_HOST"] + "Home.aspx", false); }
# endregion
if (page_allow == true)
{
if (apprv_transfer == true || transfer_emp == true || transfer_view == true || tran_reqemp == true || tran_reqhod == true )btnfilter.Visible = true;
clsSqlDAL_TransferEmployee objdept = new clsSqlDAL_TransferEmployee();
DataTable UserCntxts = new DataTable();long in_UserID = Convert.ToInt64(Session["UserID"].ToString());
UserCntxts = objdept.GetCntxtUsersForFnIDs(in_UserID, comma_FnID);
drop_constsnt.DataSource = UserCntxts;
drop_constsnt.DataValueField = "EmpID";drop_constsnt.DataTextField = "EmpName";
drop_constsnt.DataBind();
long emp_id = Convert.ToInt64(Session["EmpID"].ToString());if (drop_constsnt.Items.Count == 2)
{
if (drop_constsnt.Items[1].Value.Equals(emp_id.ToString()))
drop_constsnt.Visible =
false;Label2.Visible = false;DataSet dsdrop = new DataSet();
dsdrop = objdept.GetRequesterName(emp_id);
drprequestby.DataSource = dsdrop.Tables[0];
drprequestby.DataTextField = "EmpName";drprequestby.DataValueField = "EmpID";
drprequestby.DataBind();
drprequestby.Items.Insert(0, new ListItem("All"));
}
else
{
for (int i = 0; i < drop_constsnt.Items.Count; i++)
{
if (drop_constsnt.Items[i].Value.Equals(Session["EmpID"].ToString()))
{
drop_constsnt.Items[i].Selected = true;
Label2.Visible =
true;DataSet dsdrop = new DataSet();dsdrop = objdept.GetRequesterName(Convert.ToInt64(drop_constsnt.SelectedValue.ToString()));
drprequestby.DataSource = dsdrop.Tables[0];
drprequestby.DataTextField =
"EmpName";drprequestby.DataValueField = "EmpID";
drprequestby.DataBind();
drprequestby.Items.Insert(0, new ListItem("All"));
}
}
}
DateSelector1.CalendarDate = DateTime.Today.AddMonths(-1);DateSelector2.CalendarDate = DateTime.Today;
//clsSqlDAL_TransferEmployee objstatus = new clsSqlDAL_TransferEmployee();DataTable dsall = new DataTable();
DateTime ddd = DateSelector1.CalendarDate;
DateTime eee = DateSelector1.CalendarDate;string abc = "";
if (drop_constsnt.Visible == false)abc = Session["EmpID"].ToString();
else
abc = drop_constsnt.SelectedValue.ToString();
string bbb = drpapprovests.SelectedValue.ToString();
string ccc = drpIstrnsfrd.SelectedValue.ToString();if (ccc.Equals("null"))
{
bbb = "2";ccc = null;
}
objdept.ListRlvtTrnsfrReqs(Convert.ToInt64(Session["EmpID"].ToString()), Convert.ToInt64(abc), Convert.ToInt32(bbb), Convert.ToInt32(ccc), ddd, eee, ReqstrID);
grdstatus.DataSource = dsall;
grdstatus.DataBind();
}
}
}
problem is the data is not binding to gridview..