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();
}
