public Boolean IsJobAccountAvaialbleInACMaster(String strJob, String strSubCode, String strAcCode)
{
Boolean boolIsJobAvail = false;
DataSet ds = new DataSet();
ds = SQLHelperGL.FillDataSet("SELECT AccountCode FROM dbo.AccountMaster WHERE (JobCode = '" + strJob + "') AND (SubCategoryCode = '" + strSubCode + "') AND (AccountCode = '" + strAcCode + "')", CommandType.Text);
if (ds.Tables[0].Rows.Count > 0)
{
boolIsJobAvail = true;
}
return(boolIsJobAvail);
}
public Boolean IsAvailableSubCategory(String strACCode)
{
Boolean boolIsACAvail = false;
DataSet ds = new DataSet();
ds = SQLHelperGL.FillDataSet("SELECT SubCategoryCode, SubCategoryName FROM dbo.AccountSubCategory WHERE (SubCategoryCode = '" + strACCode + "')", CommandType.Text);
if (ds.Tables[0].Rows.Count > 0)
{
boolIsACAvail = true;
}
return(boolIsACAvail);
}
public String GETSubCategoryNameByCode(String strACCode)
{
String strName = "";
DataSet ds = new DataSet();
ds = SQLHelperGL.FillDataSet("SELECT SubCategoryCode, SubCategoryName FROM dbo.AccountSubCategory WHERE (SubCategoryCode = '" + strACCode + "')", CommandType.Text);
if (ds.Tables[0].Rows.Count > 0)
{
strName = ds.Tables[0].Rows[0][1].ToString();
}
else
{
strName = "NA";
}
return(strName);
}