protected void rgIndustries_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
using (var hrsgEntities = new HRSG_DatabaseEntities())
{
rgIndustries.DataSource = hrsgEntities.Industries.Where(a => a.Active).ToList();
}
}
public User CheckLogin(string username, string password)
{
using (var hrsgEntites = new HRSG_DatabaseEntities()) {
//TODO: convert the password to HASHED or encrypted version
return hrsgEntites.Users.FirstOrDefault(a => a.Username == username && a.Password == password && a.Active);
}
}
protected void Page_Load(object sender, EventArgs e) {
if (IsPostBack) return;
using (var hrsgEntities = new HRSG_DatabaseEntities()) {
var section = hrsgEntities.Sections.FirstOrDefault(a => a.ID == SectionID && a.Active);
if (section != null) {
txtbxSectionName.Text = section.Description;
txtbxSectionValue.Text = section.Value;
}
}
}
private Globals()
{
if (!_initialized)
{
using (var hrsgEntities = new HRSG_DatabaseEntities())
{
//store all the activate industries
Industries = hrsgEntities.Industries.Where(i => i.Active).ToList();
EmployeeRanges = hrsgEntities.EmployeeRanges.Where(e => e.Active).ToList();
}
}
}
protected void btnSave_OnClick(object sender, EventArgs e) {
using (var hrsgEntities = new HRSG_DatabaseEntities()) {
var industry = hrsgEntities.Industries.Create();
industry.Created = DateTime.Now;
industry.Modified = DateTime.Now;
industry.Active = true;
industry.Name = txtbxIndustryName.Text;
hrsgEntities.Industries.Add(industry);
hrsgEntities.SaveChanges();
ClientScript.RegisterStartupScript(Page.GetType(), "mykey", "CloseAndSave();", true);
}
}
protected void btnSave_OnClick(object sender, EventArgs e) {
using (var hrsgEntities = new HRSG_DatabaseEntities()) {
var section = hrsgEntities.Sections.FirstOrDefault(a => a.ID == SectionID && a.Active);
if (section != null) {
section.Modified = DateTime.Now;
section.Description = txtbxSectionName.Text;
section.Value = txtbxSectionValue.Text;
hrsgEntities.SaveChanges();
}
ClientScript.RegisterStartupScript(Page.GetType(), "mykey", "CloseAndSave();", true);
}
}
protected void btnSave_OnClick(object sender, EventArgs e) {
using (var hrsgEntities = new HRSG_DatabaseEntities()) {
var section = hrsgEntities.Sections.Create();
section.Created = DateTime.Now;
section.Modified = DateTime.Now;
section.Active = true;
section.Description = txtbxSectionName.Text;
section.Value = txtbxSectionValue.Text;
hrsgEntities.Sections.Add(section);
hrsgEntities.SaveChanges();
ClientScript.RegisterStartupScript(Page.GetType(), "mykey", "CloseAndSave();", true);
}
}
protected void rgIndustries_OnItemCommand(object sender, GridCommandEventArgs e)
{
using (var hrsgEntities = new HRSG_DatabaseEntities()) {
switch (e.CommandName) {
case "Edit":
break;
case "Delete":
var id = Convert.ToInt32(e.CommandArgument); //LINQ does not understand Convert.ToInt(), convert it before passing to the expression
var industry = hrsgEntities.Industries.FirstOrDefault(a => a.ID == id && a.Active);
if (industry != null) {
industry.Active = false;
hrsgEntities.SaveChanges();
}
break;
}
}
}
protected void rgClients_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
using (var hrsgEntities = new HRSG_DatabaseEntities())
{
var results = hrsgEntities.Clients.Where(c => c.Active).ToList();
//convert the results into a custom listing object
var clientListing = results.Select(a => new ClientListingItem()
{
ID = a.ID,
Modified = a.Modified,
Created = a.Created,
EmployeeRange = Globals.Instance.EmployeeRanges.FirstOrDefault(b => b.ID == a.EmployeeRange).Description,
IndustryID = a.IndustryID,
IndustryName = hrsgEntities.Industries.FirstOrDefault(b => b.ID == a.IndustryID).Name,
Name = a.Name
}).ToList();
rgClients.DataSource = clientListing;
}
}
protected void rgSubsections_OnItemCommand(object sender, GridCommandEventArgs e) {
using (var hrsgEntities = new HRSG_DatabaseEntities()) {
switch (e.CommandName) {
case "Edit":
var item = e.Item as GridDataItem;
var itemID = item["ID"].Text;
ClientScript.RegisterStartupScript(Page.GetType(), "mykey", $"OpenEditSubSection({itemID});", true);
break;
case "Delete":
var id = Convert.ToInt32(e.CommandArgument); //LINQ does not understand Convert.ToInt(), convert it before passing to the expression
var subsection = hrsgEntities.SubSections.FirstOrDefault(a => a.ID == id && a.Active);
if (subsection != null) {
subsection.Active = false;
hrsgEntities.SaveChanges();
}
break;
}
}
}
protected void rgSubsections_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e) {
using (var hrsgEntities = new HRSG_DatabaseEntities()) {
rgSubsections.DataSource = hrsgEntities.SubSections.Where(c => c.Active).ToList();
}
}