protected void RadDataForm1_NeedDataSource(object sender, Telerik.Web.UI.RadDataFormNeedDataSourceEventArgs e)
{
(sender as RadDataForm).DataSource = SourceDataTable;
DataTable sourceDataTable2;
try
{
using (SqlConnection sqlConnection11 = new SqlConnection(constsql))
{
sourceDataTable2 = new DataTable();
selectQuery2 = "SELECT USERS.USERID,USERS.USER_NAME,FIRSTNAME,LASTNAME,EMAIL,BRANCH.BranchName,USERS.BRANCHID,DEPARTMENT.DepartmentName,USERS.DEPARTMENTID,IsActionOwner FROM USERS INNER JOIN DEPARTMENT ON USERS.BRANCHID = DEPARTMENT.DepartmentID INNER JOIN BRANCH ON USERS.BRANCHID = BRANCH.BranchID Where USERS.USER_NAME='" + Session["Userid"].ToString() + "'";
using (SqlDataAdapter sqlDataAdapter2 = new SqlDataAdapter())
{
sqlDataAdapter2.SelectCommand = new SqlCommand(selectQuery2, sqlConnection11);
sqlDataAdapter2.Fill(sourceDataTable2);
}
}
}
catch (Exception ex)
{
con.insertError(ex.Message);
Response.Redirect("logout.aspx");
}
RadDataForm1.DataSource = SourceDataTable2;
}
protected void RadDataForm1_NeedDataSource(object sender, Telerik.Web.UI.RadDataFormNeedDataSourceEventArgs e)
{
(sender as RadDataForm).DataSource = SourceDataTable;
if (RadGrid1.SelectedItems.Count > 0)
{
Session["USER_NAME"] = null;
Session["USER_NAME"] = RadGrid1.SelectedValue.ToString();
DataTable sourceDataTable2;
using (SqlConnection sqlConnection11 = new SqlConnection(constsql))
{
sourceDataTable2 = new DataTable();
selectQuery2 = "SELECT USERS.USERID,USERS.USER_NAME,FIRSTNAME,LASTNAME,EMAIL,BRANCH.BranchName,USERS.BRANCHID,DEPARTMENT.DepartmentName,USERS.DEPARTMENTID,IsActionOwner FROM USERS INNER JOIN DEPARTMENT ON USERS.BRANCHID = DEPARTMENT.DepartmentID INNER JOIN BRANCH ON USERS.BRANCHID = BRANCH.BranchID Where USERS.USER_NAME='" + Session["USER_NAME"].ToString() + "'";
using (SqlDataAdapter sqlDataAdapter2 = new SqlDataAdapter())
{
sqlDataAdapter2.SelectCommand = new SqlCommand(selectQuery2, sqlConnection11);
sqlDataAdapter2.Fill(sourceDataTable2);
}
}
}
RadDataForm1.DataSource = SourceDataTable2;
}
protected void RadDataFormUser_NeedDataSource(object sender, Telerik.Web.UI.RadDataFormNeedDataSourceEventArgs e)
{
RadDataFormUser.DataSource = _db.Users.Where(u => u.userId == userId);
}
protected void RadDataForm_NeedDataSource(object sender, Telerik.Web.UI.RadDataFormNeedDataSourceEventArgs e)
{
RadDataForm.DataSource = dh.GetNoticeDetailsByDepartment(account.Department_ID, Config.NoticeRelationStatus.Active, 0, 5);
}
