public static bool IsAc6(string costcentre)
{
string query = string.Format("select count(*) from TB_DEPARTMENT where d_costcentre = '{0}' and d_ac6 = 'Yes'", costcentre);
int result = (int)DataServiceMaster.GetInstance().ExecuteScalar(query);
return(result > 0 ? true : false);
}
public static string CostCentre()
{
string query = string.Format("select top 1 d_costcentre from TB_DEPARTMENT, TB_USER where u_name = N'{0}' and u_division = d_division and u_section = d_section", GlobalService.User);
try
{
return(DataServiceMaster.GetInstance().ExecuteScalar(query).ToString().Trim());
}
catch
{
return("");
}
}
public static string Department()
{
string query = string.Format("select u_department from TB_USER where u_name = N'{0}'", GlobalService.User);
return(DataServiceMaster.GetInstance().ExecuteScalar(query).ToString().Trim());
}
public static string GetDepartmentHead(string department)
{
string query = string.Format("select d_incharge from TB_DEPARTMENT where d_dept = N'{0}' and d_division = '---'", department);
return(DataServiceMaster.GetInstance().ExecuteScalar(query).ToString().Trim());
}
public static string GetSectionHead(string section)
{
string query = string.Format("select d_incharge from TB_DEPARTMENT where d_section = N'{0}'", section);
return(DataServiceMaster.GetInstance().ExecuteScalar(query).ToString().Trim());
}
public static string GetDiv(string name)
{
string query = string.Format("select u_division from TB_USER where u_name = N'{0}'", name);
return(DataServiceMaster.GetInstance().ExecuteScalar(query).ToString().Trim());
}
public static string GetHead(string staff)
{
string query = string.Format("select s_head from TB_C_STAFF where s_name = N'{0}'", staff.Trim());
return(DataServiceMaster.GetInstance().ExecuteScalar(query).ToString());
}