private void LoadData()
{
try
{
var data = _repo.GetAllSessionSemesters();
if (data != null && data.Count > 0)
{
dataGrid.DataSource = data;
dataGrid.Columns["Id"].Visible = false;
dataGrid.Columns["IsDeleted"].Visible = false;
dataGrid.Columns["Fullname"].Visible = false;
dataGrid.Columns["IsActive"].HeaderText = "Active?";
}
else
{
_noItems = true;
var dt = new DataTable();
dataGrid.Columns.Clear();
dt.Columns.Add("Message", typeof(string));
dt.Rows.Add("No record found");
dataGrid.DataSource = dt;
}
_gridData = data.ConvertToDataTable(); //save records in datatable for searching, export etc
Base.AddLinksToGrid(ref dataGrid, new List <string>
{
"Edit",
"Delete"
}, _noItems); //add edit,delete icon
}
catch (Exception e)
{
MessageBox.Show(this, e.Message, "Error occured", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LoadSessionSemesters()
{
try
{
var data = _semesterRepo.GetAllSessionSemesters();
if (data != null)
{
grdData.DataSource = data;
if (grdData.Rows.Count > 0)
{
grdData.Columns["Id"].Visible = false;
grdData.Columns["IsDeleted"].Visible = false;
}
else
{
//var dt = new DataTable();
//grdData.Columns.Clear();
//dt.Columns.Add("Message", typeof(string));
//dt.Rows.Add("No items found");
//grdData.DataSource = dt;
// MessageBox.Show(this, "No record found", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
repData = data.ConvertToDataTable(); //save records in datatable for searching, export etc
Base.ResizeGrid(ref grdData);
}
}
catch (Exception e)
{
MessageBox.Show(this, e.Message, "Error occured", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static void LoadSessions(ref ComboBox dropDown, bool includeAll = false, bool noSemesters = false)
{
var repo = new SessionSemesterRepo();
var allItems = repo.GetAllSessionSemesters();
var allSessions = new List <SessionSemester>();
if (noSemesters)
{
allSessions = (from x in allItems
select new SessionSemester
{
Id = x.Id,
Session = x.Session
}).ToList();
allSessions.Insert(0, new SessionSemester
{
Session = "Select Session",
Id = Base.IdForSelect
});
}
if (includeAll)
{
allItems.Insert(0, new SessionSemester
{
Session = "Select All",
Id = Base.IdForSelectAll
});
}
else
{
allItems.Insert(0, new SessionSemester
{
Session = "Select Session/Semester",
Id = Base.IdForSelect
});
}
dropDown.DataSource = noSemesters ? allSessions : allItems;
dropDown.DisplayMember = noSemesters ? "Session" : "Fullname";
dropDown.ValueMember = "Id";
dropDown.SelectedIndex = 0;
}
