protected void save_Click(object sender, EventArgs e) { var j = new JobEnityManual { Description = this.description.Text, Maximum = Convert.ToByte(this.maximum.Text), Minimum = Convert.ToByte(this.minimum.Text) }; var ctx = new PubsManualContext(); ctx.Jobs.InsertOnSubmit(j); ctx.SubmitChanges(); this.msg.Text = "Data inserted"; this.BindGridView(); }
protected void gv_RowUpdating(object sender, GridViewUpdateEventArgs e) { var jobId = (Int16)e.Keys["ID"]; var ctx = new PubsManualContext(); if (jobId % 2 == 0) { var job = ctx.Jobs.First(x => x.ID == jobId); if (e.NewValues["Description"] != null) { job.Description = (string)e.NewValues["Description"]; } if (e.NewValues["Maximum"] != null) { job.Maximum = Convert.ToByte(e.NewValues["Maximum"]); } if (e.NewValues["Minimum"] != null) { job.Minimum = Convert.ToByte(e.NewValues["Minimum"]); } ctx.SubmitChanges(); } else { var f = new JobEnityManual { ID = jobId, Description = (e.NewValues["Description"] ?? e.OldValues["Description"]).ToString(), Maximum = Convert.ToByte(e.NewValues["Maximum"] ?? e.OldValues["Maximum"]), Minimum = Convert.ToByte(e.NewValues["Minimum"] ?? e.OldValues["Minimum"]) }; ctx.Jobs.Attach(f); ctx.Refresh(System.Data.Linq.RefreshMode.KeepCurrentValues, f); ctx.SubmitChanges(); } this.gv.EditIndex = -1; this.BindGridView(); }