- task_management.zip
- Task_Management
- 3LayerArchitecture11.JPG
- Database
- TaskManagementSystemDB.mdf
- TaskManagementSystemDB_log.ldf
- TaskManagementSystem
- App_Code
- BLL
- DataLayerClass
- DAO
- Gateway
- App_Data
- App_Themes
- Theme
- Bin
- AjaxControlToolkit.dll
- AjaxControlToolkit.dll.refresh
- AjaxControlToolkit.pdb
- Javascript
- Master
- TaskManagementSystem (4).sln
- TaskManagementSystem (4).suo
- TaskManagementSystem.suo
- UI
- Web.config
|
using System;
using System.Data;
using System.Configuration;
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;
/// <summary>
/// Summary description for AdminGateWay
/// </summary>
public class AdminGateWay
{
DataExecuteClass DEC = null;
public AdminGateWay()
{
//
// TODO: Add constructor logic here
//
}
public DataTable SelectAllEmployeeData()
{
string selectString = "SELECT EmployeeId, EmployeeName, EmployeeAddress, EmployeeContactNo, EmployeeDesignation, EmployeeEmail, EmployeeJoinDate FROM t_Employee where EmployeeRole='Employee'";
DEC = new DataExecuteClass();
DataTable dt = DEC.getDataSet(selectString).Tables[0];
return dt;
}
public DataTable SelectAllUserData()
{
string selectString = "SELECT EmployeeId, EmployeeName, EmployeeAddress, EmployeeContactNo, EmployeeDesignation, EmployeeEmail, EmployeePassword, EmployeeJoinDate FROM t_Employee where EmployeeRole='User'";
DEC = new DataExecuteClass();
DataTable dt = DEC.getDataSet(selectString).Tables[0];
return dt;
}
public DataTable SelectAllAdminData()
{
string selectString = "SELECT EmployeeId, EmployeeName, EmployeeAddress, EmployeeContactNo, EmployeeDesignation, EmployeeEmail, EmployeePassword, EmployeeJoinDate FROM t_Employee where EmployeeRole='Admin'";
DEC = new DataExecuteClass();
DataTable dt = DEC.getDataSet(selectString).Tables[0];
return dt;
}
public DataTable SelectAllProject()
{
string selectString = "SELECT * from t_Project";
DEC = new DataExecuteClass();
DataTable dt = DEC.getDataSet(selectString).Tables[0];
return dt;
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.