public LeadAppointment UpdateLeadAppointment(LeadAppointment objLeadAppointment) { try { objLeadAppointment.updateDate = DateTime.Now; using (var context = new FitnessCenterEntities()) { context.LeadAppointments.Attach(context.LeadAppointments.Single(varL => varL.ID == objLeadAppointment.ID)); context.LeadAppointments.ApplyCurrentValues(objLeadAppointment); context.SaveChanges(); return(objLeadAppointment); } } catch (Exception ex) { throw ex; } }
public LeadAppointment InsertLeadAppointment(LeadAppointment objLeadAppointment) { try { objLeadAppointment.insertDate = DateTime.Now; objLeadAppointment.isActive = true; objLeadAppointment.isDeleted = false; using (var context = new FitnessCenterEntities()) { context.LeadAppointments.AddObject(objLeadAppointment); context.SaveChanges(); return(objLeadAppointment); } } catch (Exception ex) { throw ex; } }
protected void grdLeadAppointment_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = grdLeadAppointment.Rows[e.RowIndex]; int AppointId = Convert.ToInt32(grdLeadAppointment.DataKeys[e.RowIndex].Values[0]); string remarks = (row.FindControl("txtAppointRemarks") as TextBox).Text; string AppointDate = (row.FindControl("appointDate") as TextBox).Text; using (FitnessCenterEntities entities = new FitnessCenterEntities()) { LeadAppointment leadAppoint = (from c in entities.LeadAppointments where c.ID == AppointId select c).FirstOrDefault(); leadAppoint.reasonForNotAttend = remarks; leadAppoint.appointmentDate = UtillController.ConvertDateTime(AppointDate); leadAppoint.updateDate = DateTime.Now; entities.SaveChanges(); } grdLeadAppointment.EditIndex = -1; this.BindAppoinments(); grdLeadAppointment.Focus(); }