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