public void LoadAllStudent()
{
DataTable dt = new DataTable();
dt.Columns.Add("SN");
dt.Columns.Add("ID");
dt.Columns.Add("Name");
dt.Columns.Add("Email");
dt.Columns.Add("Address");
dt.Columns.Add("students");
dt.Columns.Add("Status");
var student = DropDownManager.GetAllSchools();
if (student != null)
{
int sn = 0;
foreach (var item in student)
{
string id = item.Id.ToString();
string status = GetStatus(item.Id);
string Name = item.Name;
string Email = item.Email.ToString();
string students = stat.GetStudentCount(item.Id);
string Address = item.Address;
sn++;
dt.Rows.Add(sn, id, Name, Email, Address, students, status);
}
gvSchools.DataSource = dt;
gvSchools.DataBind();
foreach (GridViewRow row in gvSchools.Rows)
{
Label lblStatus = (Label)row.FindControl("lblStatus");
if (lblStatus.Text == "Registered")
{
lblStatus.CssClass = "btn btn-success";
}
else
{
lblStatus.CssClass = "btn btn-danger";
}
}
}
}
public void PopulateTable()
{
var dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("SN");
dt.Columns.Add("Name");
dt.Columns.Add("Email");
dt.Columns.Add("Address");
dt.Columns.Add("LocalGovt");
dt.Columns.Add("Inspector");
IEnumerable <Models.School> schools;
if (User.IsInRole("Inspector"))
{
schools = DropDownManager.GetAllSchools(SessionUser.LgaId);
}
else
{
schools = DropDownManager.GetAllSchools();
}
if (schools != null)
{
int sn = 0;
foreach (var item in schools)
{
sn++;
string id = item.Id.ToString();
string Name = item.Name.ToString();
string Email = item.Email.ToString();
string Addreess = item.Address.ToString();
string principal = item.LocalGovernment.LocalGovernment1;
var nofstudent = item.LocalGovernment.Inspectors.FirstOrDefault()?.CIEName; // statManager.GetStudentCount(item.Id);
dt.Rows.Add(id, sn, Name, Email, Addreess, principal, nofstudent);
}
gvSchool.DataSource = dt;
gvSchool.DataBind();
gvSchool.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
private void PopulateTable(int selectValue)
{
DataTable dataTable = new DataTable();
dataTable.Columns.Add("ID");
dataTable.Columns.Add("SN");
dataTable.Columns.Add("Name");
dataTable.Columns.Add("Inspector");
int counter = 0;
var schools = DropDownManager.GetAllSchools(selectValue, GeneralUtility.SessionUser.SchoolType, null);
foreach (var item in schools)
{
++counter;
string id = item.Id.ToString();
string name = item.Name.ToString();
string inspector = item.LocalGovernment.Inspectors.FirstOrDefault()?.CIEName;
dataTable.Rows.Add(id, counter, name, inspector);
}
gvAllQuota.DataSource = dataTable;
gvAllQuota.DataBind();
gvAllQuota.HeaderRow.TableSection = TableRowSection.TableHeader;
}
public IHttpActionResult GetAllSchool(int?id)
{
return(Ok(DropDownManager.GetAllSchools()));
}
public void PopulatePrimaryTable()
{
var dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("SN");
dt.Columns.Add("Name");
dt.Columns.Add("Email");
dt.Columns.Add("Address");
dt.Columns.Add("Principal");
dt.Columns.Add("Student");
dt.Columns.Add("Type");
var inspector = inspectorServices.GetInspectorByName();
var schools = DropDownManager.GetAllSchools(inspector.LocalGovernmentId, primary);
if (schools != null && schools.Count() > 0)
{
int sn = 0;
foreach (var item in schools)
{
sn++;
string id = item.Id.ToString();
string Name = item.Name.ToString();
string Email = item.Email.ToString();
string Addreess = item.Address.ToString();
var nofstudent = statManager.GetStudentCount(item.Id);
string principal = item.NameOfPrincipal;
string type = item.SchoolType.SchoolType1;
dt.Rows.Add(id, sn, Name, Email, Addreess, principal, nofstudent, type);
}
gvPrimary.DataSource = dt;
gvPrimary.DataBind();
gvPrimary.HeaderRow.TableSection = TableRowSection.TableHeader;
foreach (GridViewRow row in gvPrimary.Rows)
{
Label type = (Label)row.FindControl("type");
if (type.Text == "Public")
{
type.CssClass = "btn btn-primary";
}
else
{
type.CssClass = "btn btn-warning";
}
}
}
else
{
dt.Rows.Add("", "", "No School Registered under your Local Government", "", "", "", "", "");
gvPrimary.DataSource = dt;
gvPrimary.DataBind();
gvPrimary.HeaderRow.TableSection = TableRowSection.TableHeader;
foreach (GridViewRow row in gvPrimary.Rows)
{
Button type = (Button)row.FindControl("btnview");
type.Visible = false;
}
}
}