public void BindOrders()
{
string query = @" select cl.emp_id,(select empname from employee where emp_id=cl.emp_id)[Employee Name],
(select company_name from company where company_id=cl.client)[Client Name],--cl.client,
(select ProjectName from empprojects where projid=cl.project)[Project Name],--cl.project,
(select DeliveryModel from Delivery_Model where deliverymodelid=cl.DeliveryModel)[Delivery Model],--cl.DeliveryModel,
(select SC_NAME from Delivery_Model_SubCla where sc_id=cl.SubClass)[Sub Classification],--cl.SubClass,
Case when ((select TOP 1 Revenue_Currency from RM_CtcRevMaster where emp_id=cl.EMP_ID order by EDateRev desc)=0) THEN 'INR'
ELSE (Case when ((select TOP 1 Revenue_Currency from RM_CtcRevMaster where emp_id=cl.EMP_ID order by EDateRev desc)=1) THEN 'USD' ELSE 'NULL' end) END as
RevenueCurrency,
(select TOP 1 Revenue from RM_CtcRevMaster where emp_id=cl.EMP_ID order by EDateRev desc)Revenue,
CASE WHEN (select TOP 1 Revenue_Currency from RM_CtcRevMaster where emp_id=cl.EMP_ID order by EDateRev desc)=0 then
((select TOP 1 Revenue from RM_CtcRevMaster where emp_id=cl.EMP_ID order by EDateRev desc)) else
((select TOP 1 Revenue from RM_CtcRevMaster where emp_id=cl.EMP_ID order by EDateRev desc)*65) end as [Revenue INR],
CASE WHEN (select TOP 1 Revenue_Currency from RM_CtcRevMaster where emp_id=cl.EMP_ID order by EDateRev desc)=1 then
((select TOP 1 Revenue from RM_CtcRevMaster where emp_id=cl.EMP_ID order by EDateRev desc))
else ((select TOP 1 Revenue from RM_CtcRevMaster where emp_id=cl.EMP_ID order by EDateRev desc)/65) end as [Revenue USD],
(select o.PONO from OB_POSOWMSA o where o.emp_id=cl.EMP_ID) [PONO],(select o.PO_StartDate from OB_POSOWMSA o where o.emp_id=cl.EMP_ID) [PO_StartDate], (select o.PO_EndDate from OB_POSOWMSA o where o.emp_id=cl.EMP_ID) [PO_EndDate],
(select o.SOW from OB_POSOWMSA o where o.emp_id=cl.EMP_ID) [SOW],(select o.SOW_StartDate from OB_POSOWMSA o where o.emp_id=cl.EMP_ID) [SOW_StartDate], (select o.SOW_EndDate from OB_POSOWMSA o where o.emp_id=cl.EMP_ID) [SOW_EndDate],
(select o.MSA from OB_POSOWMSA o where o.emp_id=cl.EMP_ID) [MSA],(select o.MSA_StartDate from OB_POSOWMSA o where o.emp_id=cl.EMP_ID) [MSA_StartDate],(select o.MSA_EndDate from OB_POSOWMSA o where o.emp_id=cl.EMP_ID) [MSA_EndDate],
(select o.Status from OB_POSOWMSA o where o.emp_id=cl.EMP_ID) [Status]
from clntass cl where cl.RtnFrmClnt is null and cl.status in (0,1) and cl.FinanceStatus=1 and cl.SubClass<>4 order by [Employee Name]";
DataTable dt = sqlDB.AdapterGetData(query, CommandType.Text, _sqlParameter);
_sqlParameter = null;
RadGridaccount.DataSource = dt;
}