public DataTable GetAvailableJobsForSubCategory(String strMainCode) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("JobCode")); DataRow dtrow; SqlDataReader dataReader; dtrow = dt.NewRow(); dataReader = SQLHelperGL.ExecuteReader("SELECT JobCode FROM dbo.AccountMaster inner join MadulsimaCheckrollDB.dbo.JobMaster on JobCode=MadulsimaCheckrollDB.dbo.JobMaster.JobShortName WHERE (SubCategoryCode like '" + strMainCode + "') AND (dbo.AccountMaster.AccountType = 'Labour') group by JobCode", CommandType.Text); while (dataReader.Read()) { dtrow = dt.NewRow(); if (!dataReader.IsDBNull(0)) { dtrow[0] = dataReader.GetString(0).Trim(); } dt.Rows.Add(dtrow); } dataReader.Close(); return(dt); }
public DataTable GetAvailableAccountsForJob(String strMainCode, String strJob) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("AccountCode")); dt.Columns.Add(new DataColumn("AccountName")); DataRow dtrow; SqlDataReader dataReader; dtrow = dt.NewRow(); dataReader = SQLHelperGL.ExecuteReader("SELECT AccountCode, AccountName FROM dbo.AccountMaster WHERE (SubCategoryCode = '" + strMainCode + "') AND (JobCode = '" + strJob + "')", CommandType.Text); while (dataReader.Read()) { dtrow = dt.NewRow(); if (!dataReader.IsDBNull(0)) { dtrow[0] = dataReader.GetString(0).Trim(); } if (!dataReader.IsDBNull(1)) { dtrow[1] = dataReader.GetString(1).Trim(); } dt.Rows.Add(dtrow); } dataReader.Close(); return(dt); }
public DataTable GetAvailableSubCategoriesForJob(String strJob) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("MainCode")); dt.Columns.Add(new DataColumn("Name")); DataRow dtrow; SqlDataReader dataReader; dtrow = dt.NewRow(); dataReader = SQLHelperGL.ExecuteReader("SELECT dbo.AccountMaster.SubCategoryCode, dbo.AccountSubCategory.SubCategoryName FROM dbo.AccountMaster INNER JOIN dbo.AccountSubCategory ON dbo.AccountMaster.SubCategoryCode = dbo.AccountSubCategory.SubCategoryCode WHERE (dbo.AccountMaster.JobCode = '" + strJob + "') GROUP BY dbo.AccountMaster.SubCategoryCode, dbo.AccountSubCategory.SubCategoryName", CommandType.Text); while (dataReader.Read()) { dtrow = dt.NewRow(); if (!dataReader.IsDBNull(0)) { dtrow[0] = dataReader.GetString(0).Trim(); } if (!dataReader.IsDBNull(1)) { dtrow[1] = dataReader.GetString(1).Trim(); } dt.Rows.Add(dtrow); } dataReader.Close(); return(dt); }
public DataTable GetAccountSubCategories() { //DataSet ds = SQLHelperGL.FillDataSet("SELECT dbo.AccountCategory.CategoryCode, dbo.AccountCategory.CategoryName, dbo.AccountSubCategory.SubCategoryCode, dbo.AccountSubCategory.SubCategoryName FROM dbo.AccountSubCategory INNER JOIN dbo.AccountCategory ON dbo.AccountSubCategory.CategoryCode = dbo.AccountCategory.CategoryCode", CommandType.Text); //return ds; DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("CategoryCode")); dt.Columns.Add(new DataColumn("CategoryName")); dt.Columns.Add(new DataColumn("SubCategoryCode")); dt.Columns.Add(new DataColumn("SubCategoryName")); DataRow dtrow; SqlDataReader dataReader; dtrow = dt.NewRow(); dataReader = SQLHelperGL.ExecuteReader("SELECT dbo.AccountCategory.CategoryCode, dbo.AccountCategory.CategoryName, dbo.AccountSubCategory.SubCategoryCode, dbo.AccountSubCategory.SubCategoryName FROM dbo.AccountSubCategory INNER JOIN dbo.AccountCategory ON dbo.AccountSubCategory.CategoryCode = dbo.AccountCategory.CategoryCode", CommandType.Text); while (dataReader.Read()) { dtrow = dt.NewRow(); if (!dataReader.IsDBNull(0)) { dtrow[0] = dataReader.GetString(0).Trim(); } if (!dataReader.IsDBNull(1)) { dtrow[1] = dataReader.GetString(1).Trim(); } if (!dataReader.IsDBNull(2)) { dtrow[2] = dataReader.GetString(2).Trim(); } if (!dataReader.IsDBNull(3)) { dtrow[3] = dataReader.GetString(3).Trim(); } dt.Rows.Add(dtrow); } dataReader.Close(); return(dt); }