public List <BOCategories> LoadCategories(int userid, string hostCode)
{
DACategories pDAL = new DACategories();
try
{
var dtCategories = pDAL.LoadCategories(userid, hostCode);
var categories = new List <BOCategories>();
BOCategories cat = null;
foreach (DataRow item in dtCategories.Rows)
{
cat = new BOCategories();
cat.CategoryCode = item["Code"].ToString();
cat.CategoryName = item["Name"].ToString();
cat.Id = Convert.ToInt32(item["Id"]);
categories.Add(cat);
}
return(categories);
}
catch
{
throw;
}
finally
{
pDAL = null;
}
}
public List <BOUser> LoadUsers(int userid, string hostCode)
{
DACategories pDAL = new DACategories();
try
{
var dtStudents = pDAL.LoadUsers(userid, hostCode);
var users = new List <BOUser>();
BOUser std = null;
foreach (DataRow item in dtStudents.Rows)
{
std = new BOUser();
std.FirstName = item["FirstName"].ToString();
std.DepartmentName = item["DepartmentName"].ToString();
std.userid = item["UserId"].ToString();
std.Id = item["Id"].ToString();
users.Add(std);
}
return(users);
}
catch
{
throw;
}
finally
{
pDAL = null;
}
}
public int ValidateUser(string username, string password, out string parentname, out string roleCode)
{
DACategories pDAL = new DACategories();
try
{
return(pDAL.ValidateUser(username, password, out parentname, out roleCode));
}
catch
{
throw;
}
finally
{
pDAL = null;
}
}
public int DeleteSubCategories(int id)
{
DACategories pDAL = new DACategories();
try
{
return(pDAL.DeleteSubCategories(id));
}
catch
{
throw;
}
finally
{
pDAL = null;
}
}
public int InsertSubCategory(BOCategories categories)
{
DACategories pDAL = new DACategories();
try
{
return(pDAL.InsertSubCategory(categories));
}
catch
{
throw;
}
finally
{
pDAL = null;
}
}
public int InsertUser(BOUser user, out string id)
{
DACategories pDAL = new DACategories();
id = "";
try
{
return(pDAL.InsertUser(user, out id));
}
catch
{
throw;
}
finally
{
pDAL = null;
}
}
public int InsertStudent(string data, string id, out string admissionId)
{
DACategories pDAL = new DACategories();
admissionId = "";
try
{
return(pDAL.InsertStudent(data, id, out admissionId));
}
catch
{
throw;
}
finally
{
pDAL = null;
}
}
public List <BOCategories> LoadSubCategories(int userid, string hostCode)
{
DACategories pDAL = new DACategories();
try
{
var dtSubCategories = pDAL.LoadSubCategories(userid, hostCode);
var subCategories = new List <BOCategories>();
BOCategories cat = null;
foreach (DataRow item in dtSubCategories.Rows)
{
cat = new BOCategories();
cat.CategoryCode = item["CategoryCode"].ToString();
cat.SubCategoryCode = item["SubCategoryCode"].ToString();
cat.SubCategoryName = item["SubCategoryName"].ToString();
if (item["ParentSubCategoryId"] != null && item["ParentSubCategoryId"] != DBNull.Value)
{
cat.ParentSubCategoryId = Convert.ToInt32(item["ParentSubCategoryId"].ToString());
}
cat.ParentSubCategoryName = item["ParentSubCategoryName"].ToString();
cat.SubCategoryId = Convert.ToInt32(item["Id"]);
cat.Id = Convert.ToInt32(item["CategoryId"]);
cat.CategoryName = item["CategoryName"].ToString();
subCategories.Add(cat);
}
return(subCategories);
}
catch
{
throw;
}
finally
{
pDAL = null;
}
}
public List <BOStudents> LoadStudents(int userid, string hostCode)
{
DACategories pDAL = new DACategories();
try
{
var dtStudents = pDAL.LoadStudents(userid, hostCode);
var students = new List <BOStudents>();
BOStudents std = null;
foreach (DataRow item in dtStudents.Rows)
{
std = new BOStudents();
std.AdmissionId = item["AdmissionId"].ToString();
std.Class = Convert.ToInt32(item["StudentClass"].ToString());
std.Section = Convert.ToInt32(item["StudentSection"].ToString());
std.ClassName = item["StudentClassDesc"].ToString();
std.SectionName = item["StudentSectionDesc"].ToString();
std.Id = Convert.ToInt32(item["StudentId"]);
std.FirstName = item["FirstName"].ToString();
std.SurName = item["LastName"].ToString();
std.DOB = item["DOB"].ToString();
std.ResAddress = item["Address"].ToString();
std.TeleNumber = item["ContactNo"].ToString();
std.MotherName = item["MotherName"].ToString();
std.FatherName = item["FatherName"].ToString();
students.Add(std);
}
return(students);
}
catch
{
throw;
}
finally
{
pDAL = null;
}
}
