//protected void GridViewHistory_RowCommand(Object sender, GridViewCommandEventArgs e) //{ // if (e.CommandName == "Delete") // { // GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer; // //int id = Convert.ToInt32(e.CommandSource); // Label lblId = gvr.FindControl("lblId") as Label; // if (lblId != null) // { // using (ProjectTrackerContainer context = new ProjectTrackerContainer()) // { // int id = Convert.ToInt32(lblId.Text); // PubHistory ph = context.PubHistories.First(t => t.Id == id); // context.PubHistories.Remove(ph); // context.SaveChanges(); // GridViewHistory.DeleteRow(gvr.RowIndex); // } // } // } //} protected void GridViewHistory_RowDeleting(object sender, GridViewDeleteEventArgs e) { GridViewRow row = GridViewHistory.Rows[e.RowIndex]; Label lblId = row.FindControl("lblId") as Label; if (lblId != null) { using (ProjectTrackerContainer context = new ProjectTrackerContainer()) { int id = Convert.ToInt32(lblId.Text); PubHistory hist = context.PubHistories.First(t => t.Id == id); context.PubHistories.Remove(hist); context.SaveChanges(); var pubHist = context.PubHistories .Join(context.Publications, h => h.PublicationId, p => p.Id, (h, p) => new { h }) //.Join(context.PublishStatus, ph => ph.h.Status, ps => ps.Id, (ph, ps) => new { ph.h.Id, ps.Name, ph.h.StartDate, ph.h.EndDate, ph.h.Creator, ph.h.PublicationId }) .Where(i => i.h.PublicationId == hist.PublicationId) .ToList(); GridViewHistory.DataSource = pubHist; GridViewHistory.DataBind(); } if (GridViewHistory.Rows.Count > 0) { GridViewHistory.SelectRow(GridViewHistory.Rows.Count - 1); GridViewHistory.SelectedRow.Focus(); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (ValidateControl()) { using (ProjectTrackerContainer context = new ProjectTrackerContainer()) { int pubId = Convert.ToInt32(ddlPublication.SelectedValue); PubHistory newHist = new PubHistory() { PublicationId = pubId, StatusId = PubStatus, PaperDate = Convert.ToDateTime(TextBoxStartDate.Text), Creator = Page.User.Identity.Name, CreateDate = Convert.ToDateTime(HiddenFieldCurrentDate.Value) }; context.PubHistories.Add(newHist); context.SaveChanges(); Response.Write("<script>alert('Publication History Saved.');</script>"); var pubHist = context.PubHistories .Join(context.Publications, h => h.PublicationId, p => p.Id, (h, p) => new { h }) //.Join(context.PublishStatus, ph => ph.h.StatusId, ps => ps.Id, (ph, ps) => new { ph.h.Id, ps.Name, ph.h.PaperDate, ph.h.Creator, ph.h.PublicationId }) .Where(i => i.h.PublicationId == pubId) .ToList(); GridViewHistory.DataSource = pubHist; GridViewHistory.DataBind(); } } else { Response.Write("<script>alert('Please check the data entered.');</script>"); } }