public DataTable getLocations()
{
DataTable dt = new DataTable();
string sQuery = "select Distinct T_Location from RTM_Team_List order by T_Location";
dt = objDB.DBExecDataTable(sQuery);
return(dt);
}
private void BindOrderStatus()
{
dt = new DataTable();
SQlQuery = "select STL_ID, TL_Task+'-'+STL_SubTask as STL_SubTask from RTM_SubTask_List left join rtm_task_list on STL_Task_Id = TL_ID where TL_TeamId = 1 and STL_Status != ''";
dt = objDB.DBExecDataTable(SQlQuery);
if (dt.Rows.Count > 0)
{
ddlOrderStatus.DataSource = dt;
ddlOrderStatus.DataTextField = "STL_SubTask";
ddlOrderStatus.DataValueField = "STL_ID";
ddlOrderStatus.DataBind();
ddlOrderStatus.Items.Insert(0, "All");
ddlOrderStatus.SelectedIndex = 0;
}
}
private void BindEmp()
{
dt = new DataTable();
SQlQuery = "select * from RTM_User_List where UL_Team_Id = 1 and UL_User_Status =1 order by UL_User_Name";
dt = objDB.DBExecDataTable(SQlQuery);
if (dt.Rows.Count > 0)
{
ddlEmp.DataSource = dt;
ddlEmp.DataTextField = "UL_User_Name";
ddlEmp.DataValueField = "UL_ID";
ddlEmp.DataBind();
ddlEmp.Items.Insert(0, "All");
ddlEmp.SelectedIndex = 0;
}
}
public DataTable GetManagers()
{
dt = new DataTable();
sQuery = "select Distinct U2.UL_User_Name, U2.UL_Employee_Id from RTM_User_List U1 left outer join RTM_User_List U2 on U1.UL_RepMgrId = U2.UL_Employee_Id " +
"Where U2.UL_User_Name is not null ";
dt = objDB.DBExecDataTable(sQuery);
return(dt);
}
public DataTable GetTicketType()
{
DataTable dt = new DataTable();
SqlDBHelper objDB = new SqlDBHelper();
string sQuery = "select * from RTM_TicketType WITH (NOLOCK) order by TP_Order";
dt = objDB.DBExecDataTable(sQuery);
return(dt);
}
public DataTable getRTMSupportTeam()
{
DataTable dt = new DataTable();
SqlDBHelper objDB = new SqlDBHelper();
string sQuery = "select * from RTM_Support_Team WITH (NOLOCK) where Status=1";
dt = objDB.DBExecDataTable(sQuery);
return(dt);
}
public DataTable getRTMTeam()
{
DataTable dt = new DataTable();
SqlDBHelper objDB = new SqlDBHelper();
string sQuery = "select * from RTM_User_List where UL_Team_Id='4'";
dt = objDB.DBExecDataTable(sQuery);
return(dt);
}
public DataTable getClients(string _team)
{
DataTable dt = new DataTable();
string sQuery;
if (_team == "IP")
{
sQuery = "select * from EMSDB_Clients";
}
else if (_team == "QC")
{
sQuery = "select C_Code, C_Name from EMSDB_Clients, EMSDB_FileInfo, EMSDB_InvDetails where C_Code = FI_ClientCode and FI_ID = IND_FI and IND_Status = 'QC_Idle' and IND_QC_Assigned_By is null Group By C_Code, C_Name Order By C_Name";
}
else
{
sQuery = "select * from EMSDB_Clients";
}
dt = objDB.DBExecDataTable(sQuery);
return(dt);
}
public DataTable SearchClosedTickets()
{
DataTable dt = new DataTable();
SqlDBHelper objDB = new SqlDBHelper();
string sQuery = "";
sQuery = "select T_ID, UL_User_Name, T_Ticket_Type, T_Issued_Date_Time, T_Assigned_To, T_Status, T_ETA_Date_Time, T_Summary from RTM_Tickets WITH (NOLOCK) left join RTM_User_List WITH (NOLOCK) on T_Employee_Id = UL_Employee_Id left join RTM_TicketStatus WITH (NOLOCK) on T_Status = TS_Name where T_Status = 'Closed' order by TS_Order ASC,T_ID DESC";
dt = objDB.DBExecDataTable(sQuery);
return(dt);
}
public DataTable LoadCorePlatform()
{
sQuery = "select DISTINCT CL_Product from RTM_Client_List where (CL_Product is not null or CL_Product <> '') order BY CL_Product";
dt = objDB.DBExecDataTable(sQuery);
return(dt);
}