public void InsertVolunteerAvailability(ISchedulerInfo shedulerInfo, Appointment appointmentToInsert, sp_Availablity_DM cAvail) { using (VolTeerEntities context = new VolTeerEntities()) { try { var cVolAvail = new tblAvailability { VolID = cAvail.VolID, AddrID = cAvail.AddrID, AvailStart = appointmentToInsert.Start, AvailEnd = appointmentToInsert.End, Description = appointmentToInsert.Description, RecurrenceParentID = (int?)(appointmentToInsert.RecurrenceParentID), RecurrenceRule = appointmentToInsert.RecurrenceRule, Subject = appointmentToInsert.Subject }; context.tblAvailabilities.Add(cVolAvail); context.SaveChanges(); } catch (Exception ex) { } } }
protected void RadScheduler1_AppointmentCreated(object sender, AppointmentCreatedEventArgs e) { sp_Availablity_DM cAvail = new sp_Availablity_DM(); string strVolID = "6CD40064-CF05-4B55-93C0-6E4D7F9CCE34"; Guid VolID = new Guid(strVolID); cAvail.VolID = VolID; cAvail.AddrID = 1; }
public override void Insert(ISchedulerInfo shedulerInfo, Appointment appointmentToInsert) { sp_Availablity_DM cAvail = new sp_Availablity_DM(); cAvail.VolID = new Guid(appointmentToInsert.Attributes["VolID"]); cAvail.AddrID = Convert.ToInt32(appointmentToInsert.Attributes["AddrID"]); DAL.InsertVolunteerAvailability(shedulerInfo, appointmentToInsert, cAvail); }
public override void Delete(ISchedulerInfo shedulerInfo, Appointment appointmentToDelete) { if (!PersistChanges) { return; } sp_Availablity_DM cAvail = new sp_Availablity_DM(); cAvail.VolID = new Guid(appointmentToDelete.Attributes["VolID"]); cAvail.AddrID = Convert.ToInt32(appointmentToDelete.Attributes["AddrID"]); cAvail.AvailID = Convert.ToInt32(appointmentToDelete.Attributes["AvailID"]); DAL.DeleteVolunteerAvailability(shedulerInfo, appointmentToDelete, cAvail); }
public void DeleteVolunteerAvailability(ISchedulerInfo shedulerInfo, Appointment appointmentToDelete, sp_Availablity_DM cAvail) { using (VolTeerEntities context = new VolTeerEntities()) { var cVolAvail = new tblAvailability { VolID = cAvail.VolID, AddrID = cAvail.AddrID, AvailID = cAvail.AvailID }; context.tblAvailabilities.Remove(cVolAvail); context.SaveChanges(); } }
public void DeleteVolunteerAvailability(sp_Availablity_DM _cVolAvail) { using (VolTeerEntities context = new VolTeerEntities()) { var cVolAvail = new tblAvailablity { VolID = _cVolAvail.VolID, AddrID = _cVolAvail.AddrID, AvailDateID = _cVolAvail.AvailDateID }; context.tblAvailablities.Remove(cVolAvail); context.SaveChanges(); } }
public void UpdateVolunteerAvailability(sp_Availablity_DM _cVolAvail) { using (VolTeerEntities context = new VolTeerEntities()) { var cVolAvail = new tblAvailablity { VolID = _cVolAvail.VolID, AddrID = _cVolAvail.AddrID, AvailDateID = _cVolAvail.AvailDateID, AvailStartDate = _cVolAvail.AvailStartDate, AvailEndDate = _cVolAvail.AvailEndDate, DayID = _cVolAvail.DayID, StartTime = _cVolAvail.StartTime, EndTime = _cVolAvail.EndTime }; context.SaveChanges(); } }
protected void rGridAvailability_UpdIns(object sender, GridCommandEventArgs e, int iAction) { GridEditableItem eeditedItem = e.Item as GridEditableItem; //int iAddrID = 0; //if (iAction == (int)RecordAction.Update) //{ // iAddrID = Convert.ToInt32(eeditedItem.OwnerTableView.DataKeyValues[eeditedItem.ItemIndex]["AddrID"]); //} RadCalendar rCalRangeSelectUpd = (eeditedItem.FindControl("rCalRangeSelectUpd") as RadCalendar); RadCalendar rCalDaysAvailableUpd = (eeditedItem.FindControl("rCalDaysAvailableUpd") as RadCalendar); RadTimePicker rTimeBeginUpd = (eeditedItem.FindControl("rTimeBeginUpd") as RadTimePicker); RadTimePicker rTimeEndUpd = (eeditedItem.FindControl("rTimeEndUpd") as RadTimePicker); RadNumericTextBox tNTTotalHours = (eeditedItem.FindControl("tNTTotalHours") as RadNumericTextBox); sp_Availablity_DM AvailDM = new sp_Availablity_DM(); AvailDM.AvailStartDate = rCalRangeSelectUpd.RangeMinDate; AvailDM.AvailEndDate = rCalRangeSelectUpd.RangeMaxDate; AvailDM.StartTime = rTimeBeginUpd.SelectedTime.Value; AvailDM.EndTime = rTimeEndUpd.SelectedTime.Value; }
public void UpdateSampleAddressContext(sp_Availablity_DM _cVolAvail) { DAL.UpdateVolunteerAvailability(_cVolAvail); }
public void InsertVolunteerContext(sp_Availablity_DM _cVolAvail) { DAL.InsertVolunteerAvailability(_cVolAvail); }
public void DeleteVolunteerContext(sp_Availablity_DM _cVolAvail) { DAL.DeleteVolunteerAvailability(_cVolAvail); }
public void UpdateVolunteerAvailability(ISchedulerInfo shedulerInfo, Appointment appointmentToUpdate, sp_Availablity_DM cAvail) { using (VolTeerEntities context = new VolTeerEntities()) { var cVolAvail = new tblAvailability { VolID = cAvail.VolID, AddrID = cAvail.AddrID, AvailID = cAvail.AvailID, AvailStart = appointmentToUpdate.Start, AvailEnd = appointmentToUpdate.End, Description = appointmentToUpdate.Description, RecurrenceParentID = (int?)(appointmentToUpdate.RecurrenceParentID), RecurrenceRule = appointmentToUpdate.RecurrenceRule, Subject = appointmentToUpdate.Subject }; context.SaveChanges(); } }