protected void myCustomGridView_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { if (this.myCustomGridView.EditIndex != -1) { var cbl = e.Row.FindControl("employeesList") as CheckBoxList; if (cbl != null) { var jobID = (Int16)this.myCustomGridView.DataKeys[e.Row.RowIndex].Value; var job = new PubsEntities().jobs.Include("employees").FirstOrDefault(x => x.job_id == jobID); if (job != null) { var currentJobEmployees = job.employees; foreach (var item in cbl.Items.OfType<ListItem>()) { item.Selected = currentJobEmployees.Any(x => x.emp_id == item.Value); } } } } } }
protected void fv_ItemUpdating(object sender, FormViewUpdateEventArgs e) { if (this.fv.CurrentMode == FormViewMode.Edit) { var employeesListControl = this.fv.FindControl("employeesList") as CheckBoxList; if (employeesListControl != null) { var ctx = new PubsEntities(); var jobID = Convert.ToInt16(this.fv.DataKey["job_id"]); var currentJob = ctx.jobs.First(x => x.job_id == jobID); foreach (var item in employeesListControl.Items.OfType<ListItem>()) { var employee = ctx.employees.First(x => x.emp_id == item.Value); if (item.Selected) { employee.job_id = jobID; } } ctx.SaveChanges(); } } }
public ObjectDataSourceProvider() { //var wrapper = new ContextWrapper(new HttpContextWrapper(HttpContext.Current)); var wrapper = ServiceLocator.Current.GetInstance<IContextWrapper>(); this.context = wrapper.GetEFContext(); }
public int GetJobsCount() { var ctx = new PubsEntities(); var q = ctx.jobs.AsEnumerable(); return q.Count(); }
public void DeleteJob(Int16 ID) { var ctx = new PubsEntities(); var job = ctx.jobs.First(x => x.job_id == ID); ctx.jobs.Remove(job); ctx.SaveChanges(); }
protected void employeesList_DataBound(object sender, EventArgs e) { var ctx = new PubsEntities(); var employeesCheckBoxListControl = sender as CheckBoxList; var jobID = Convert.ToInt16(this.fv.DataKey["job_id"]); var currentJob = ctx.jobs.Include("employees").First(x => x.job_id == jobID); foreach (var item in employeesCheckBoxListControl.Items.OfType<ListItem>()) { item.Selected = currentJob.employees.Any(x => x.emp_id == item.Value); } }
public void UpdateJob(Int16 ID, string Description, byte Minimum, byte Maximum) { var ctx = new PubsEntities(); var job = new job(); job.job_id = ID; job.job_desc = Description; job.min_lvl = Minimum; job.max_lvl = Maximum; ctx.jobs.Attach(job); ctx.Entry(job).State = System.Data.EntityState.Modified; ctx.ChangeTracker.DetectChanges(); ctx.SaveChanges(); }
public IEnumerable<JobDTO> GetJobs(int startRow, int maximumRows) { var ctx = new PubsEntities(); var q = ctx.jobs.AsEnumerable(); q = q.Skip(startRow).Take(maximumRows); return q.Select(x => new JobDTO { Description = x.job_desc, ID = x.job_id, Maximum = x.max_lvl, Minimum = x.min_lvl }); }
protected void addNew_Click(object sender, EventArgs e) { var j = new job { job_desc = this.description.Text, max_lvl = Convert.ToByte(this.maximum.Text), min_lvl = Convert.ToByte(this.minimum.Text) }; var ctx = new PubsEntities(); ctx.jobs.Add(j); ctx.SaveChanges(); this.status.Text = "Job added"; this.gv.DataBind(); }
protected void myCustomGridView_RowUpdating(object sender, GridViewUpdateEventArgs e) { var row = this.myCustomGridView.Rows[e.RowIndex]; var cbl = row.FindControl("employeesList") as CheckBoxList; var employees = cbl.Items.OfType<ListItem>().Where(x => x.Selected); var ctx = new PubsEntities(); var jobID = (Int16)e.Keys[0]; foreach (var item in employees) { var employee = ctx.employees.First(x => x.emp_id.Equals(item.Value)); if (!employee.job_id.Equals(jobID)) { employee.job_id = jobID; } } ctx.ChangeTracker.DetectChanges(); ctx.SaveChanges(); }
protected void dv_DataBound(object sender, EventArgs e) { if (this.dv.CurrentMode == DetailsViewMode.Edit) { var employeesListControl = this.dv.FindControl("employeesList") as ListBox; if (employeesListControl != null) { var ctx = new PubsEntities(); var jobID = Convert.ToInt16(this.dv.DataKey[0]); var currentJob = ctx.jobs.Include("employees").FirstOrDefault(x => x.job_id == jobID); if (currentJob != null) { foreach (var item in employeesListControl.Items.OfType<ListItem>()) { item.Selected = currentJob.employees.Any(x => x.emp_id == item.Value); } } } } }
protected void dv_ItemUpdating(object sender, DetailsViewUpdateEventArgs e) { if (this.dv.CurrentMode == DetailsViewMode.Edit) { var employeesListControl = this.dv.FindControl("employeesList") as ListBox; if (employeesListControl != null) { var ctx = new PubsEntities(); var jobID = Convert.ToInt16(this.dv.DataKey[0]); var currentJob = ctx.jobs.Include("employees").FirstOrDefault(x => x.job_id == jobID); if (currentJob != null) { foreach (var item in employeesListControl.Items.OfType<ListItem>()) { var emp = ctx.employees.First(x => x.emp_id == item.Value); if (item.Selected) { emp.job_id = jobID; } else { if (emp.job_id == jobID) { // here i would normally remove it } } } ctx.SaveChanges(); } } } }
protected void eds_ContextCreating(object sender, EntityDataSourceContextCreatingEventArgs e) { var pubs = new PubsEntities(); e.Context = ((IObjectContextAdapter)pubs).ObjectContext; }
public ContextWrapperNoHttpContext() { this.context = new PubsEntities(); this.logger = LogManager.GetLogger(this.GetType()); }