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); }