private void iDelete_Click(object sender, EventArgs e)
{
if (schedulerControl1.SelectedAppointments.Count > 0) {
Appointment apt = schedulerControl1.SelectedAppointments[0];
bool IsRecur = false;
controller = new AppointmentFormController(schedulerControl1, apt);
//int intCalID = Convert.ToInt32(apt.GetValue(schedulerControl1.Storage,"CEID"));
int intCalID = Convert.ToInt32(controller.LabelId.ToString());
int intEventID = Common.GetID("select EventID from CalendarEvent where CalendarEventID=" + intCalID.ToString());
string strRecurrenceText = Common.GetString("select RecurrenceText from Event where EventID=" + intEventID.ToString());
if (strRecurrenceText != "")
IsRecur = true;
if (IsRecur) {
frmDeleteEvents frmDelEvt = new frmDeleteEvents(intEventID, intCalID);
if (frmDelEvt.ShowDialog() == DialogResult.OK) {
schedulerStorage1.Appointments.DataSource = FetchGridData();
}
frmDelEvt.Close();
frmDelEvt.Dispose();
} else {
if (Message.MsgDelete()) {
string strMess;
Events evt = new Events();
evt.EventID = intEventID;
strMess = evt.CheckClassEvent();
if (strMess == "") strMess = evt.CheckProgramEvent();
if (strMess != "") {
Message.MsgWarning("This Event is linked with" + strMess + ".\n\nEvent cannot be deleted.");
return;
}
evt.DeleteData(true);
schedulerStorage1.Appointments.DataSource = FetchGridData();
}
}
}
}
private void Delete()
{
if (strMenuOption == "User...")
{
int Row = fUser.gvwUser.FocusedRowHandle;
if (Row >= 0)
{
int intUserID =
Convert.ToInt32(fUser.gvwUser.GetRowCellValue(fUser.gvwUser.FocusedRowHandle, fUser.gcolUserID).ToString());
int intContactID =
Convert.ToInt32(fUser.gvwUser.GetRowCellValue(fUser.gvwUser.FocusedRowHandle, fUser.gcolContactID).ToString());
if (Message.MsgDelete())
{
User objUser = new User();
objUser.UserID = intUserID;
objUser.ContactID = intContactID;
if (!objUser.DeleteData())
{
Message.MsgWarning("User cannot be deleted");
fUser.grdUser.Focus();
return;
}
fUser.LoadUser();
fUser.grdUser.Focus();
fUser.gvwUser.FocusedRowHandle = Row - 1;
if (fUser.gvwUser.RowCount > 0)
{
if (fUser.gvwUser.FocusedRowHandle < 0)
{
fUser.gvwUser.FocusedRowHandle = 0;
}
}
}
}
}
else if ((strMenuOption == "Contact...") || (strMenuOption == "Instructor...") || (strMenuOption == "Client..."))
{
string strtemp = "";
int Row = fContact.gvwContact.FocusedRowHandle;
if (Row >= 0)
{
int intID =
Convert.ToInt32(
fContact.gvwContact.GetRowCellValue(fContact.gvwContact.FocusedRowHandle, fContact.gcolContactID).ToString());
strtemp = strMenuOption;
strtemp = strtemp.Replace("...", "");
if (Message.MsgDelete())
{
Contact objContact = new Contact();
objContact.ContactID = intID;
//objContact.DeleteData();
if (!objContact.DeleteData())
{
Message.MsgWarning(strtemp + " cannot be deleted");
fContact.grdContact.Focus();
return;
}
fContact.LoadContact(strtemp);
fContact.grdContact.Focus();
fContact.gvwContact.FocusedRowHandle = Row - 1;
if (fContact.gvwContact.RowCount > 0)
{
if (fContact.gvwContact.FocusedRowHandle < 0)
{
fContact.gvwContact.FocusedRowHandle = 0;
}
}
}
}
}
else if (strMenuOption == "Department...")
{
int Row = fDept.gvwDept.FocusedRowHandle;
if (Row >= 0)
{
int intDeptID =
Convert.ToInt32(fDept.gvwDept.GetRowCellValue(fDept.gvwDept.FocusedRowHandle, fDept.gColDeptID).ToString());
int intContactID =
Convert.ToInt32(fDept.gvwDept.GetRowCellValue(fDept.gvwDept.FocusedRowHandle, fDept.gColContactID).ToString());
if (Message.MsgDelete())
{
Department objDept = new Department();
objDept.DeptID = intDeptID;
objDept.ContactID = intContactID;
//objDept.DeleteData();
if (!objDept.DeleteData())
{
Message.MsgWarning("Department cannot be deleted");
fDept.grdDept.Focus();
return;
}
fDept.LoadDepartment();
fDept.grdDept.Focus();
fDept.gvwDept.FocusedRowHandle = Row - 1;
if (fDept.gvwDept.RowCount > 0)
{
if (fDept.gvwDept.FocusedRowHandle < 0)
{
fDept.gvwDept.FocusedRowHandle = 0;
}
}
}
}
}
else if (strMenuOption == "Program...")
{
int Row = fProgram.gvwProgram.FocusedRowHandle;
if (Row >= 0)
{
int intID =
Convert.ToInt32(
fProgram.gvwProgram.GetRowCellValue(fProgram.gvwProgram.FocusedRowHandle, fProgram.gcolProgID).ToString());
if (Message.MsgDelete())
{
Program objProg = new Program();
objProg.ProgramID = intID;
//objProg.DeleteData();
if (!objProg.DeleteData())
{
Message.MsgWarning("Program cannot be deleted");
fProgram.grdProgram.Focus();
return;
}
fProgram.LoadProgram();
fProgram.grdProgram.Focus();
fProgram.gvwProgram.FocusedRowHandle = Row - 1;
if (fProgram.gvwProgram.RowCount > 0)
{
if (fProgram.gvwProgram.FocusedRowHandle < 0)
{
fProgram.gvwProgram.FocusedRowHandle = 0;
}
}
}
}
}
else if (strMenuOption == "Class...")
{
int Row = fCourse.gvwCourse.FocusedRowHandle;
if (Row >= 0)
{
int intID =
Convert.ToInt32(
fCourse.gvwCourse.GetRowCellValue(fCourse.gvwCourse.FocusedRowHandle, fCourse.gcolCourseId).ToString());
if (Message.MsgDelete())
{
Course objCourse = new Course();
objCourse.CourseId = intID;
//objCourse.DeleteData();
if (!objCourse.DeleteData())
{
Message.MsgWarning("Class cannot be deleted");
fCourse.grdCourse.Focus();
return;
}
fCourse.LoadCourse();
fCourse.grdCourse.Focus();
fCourse.gvwCourse.FocusedRowHandle = Row - 1;
if (fCourse.gvwCourse.RowCount > 0)
{
if (fCourse.gvwCourse.FocusedRowHandle < 0)
{
fCourse.gvwCourse.FocusedRowHandle = 0;
}
}
}
}
}
else if (strMenuOption == "Event...")
{
int Row = fEvt.gvwEvent.FocusedRowHandle;
bool IsRecur = false;
if (Row >= 0)
{
int intID =
Convert.ToInt32(fEvt.gvwEvent.GetRowCellValue(fEvt.gvwEvent.FocusedRowHandle, fEvt.gcolEventID).ToString());
int intCalID =
Convert.ToInt32(fEvt.gvwEvent.GetRowCellValue(fEvt.gvwEvent.FocusedRowHandle, fEvt.colCalendarEventID).ToString());
int CourseId = Convert.ToInt32(fEvt.gvwEvent.GetRowCellValue(fEvt.gvwEvent.FocusedRowHandle, fEvt.gcolCourseId).ToString());
if (fEvt.gvwEvent.GetRowCellValue(fEvt.gvwEvent.FocusedRowHandle, fEvt.gcolIsRecur).ToString() != "")
IsRecur = true;
if (IsRecur)
{
frmDeleteEvents frmDelEvt = new frmDeleteEvents(intID, intCalID);
if (frmDelEvt.ShowDialog() == DialogResult.OK)
{
fEvt.LoadEvent();
fEvt.grdEvent.Focus();
fEvt.gvwEvent.FocusedRowHandle = Row - 1;
if (fEvt.gvwEvent.RowCount > 0)
{
if (fEvt.gvwEvent.FocusedRowHandle < 0)
fEvt.gvwEvent.FocusedRowHandle = 0;
}
}
frmDelEvt.Close();
frmDelEvt.Dispose();
frmDelEvt = null;
}
else
{
if (Message.MsgDelete())
{
string strMess = "";
Events evt = new Events();
evt.EventID = intID;
strMess = evt.CheckClassEvent();
if (strMess == "") strMess = evt.CheckProgramEvent();
if (strMess != "")
{
Message.MsgWarning("This Event is linked with" + strMess + ".\n\nEvent cannot be deleted.");
return;
}
//evt.DeleteData(true);
if (evt.EventType=="Extra Class")
evt.DeleteSingleCalendarEvent();
else
evt.DeleteTestEvent("Course", CourseId);
fEvt.LoadEvent();
fEvt.grdEvent.Focus();
fEvt.gvwEvent.FocusedRowHandle = Row - 1;
if (fEvt.gvwEvent.RowCount > 0)
if (fEvt.gvwEvent.FocusedRowHandle < 0)
fEvt.gvwEvent.FocusedRowHandle = 0;
}
}
}
}
else if (strMenuOption == "Calendar...")
{
if (fCalendar.schedulerControl1.SelectedAppointments.Count > 0)
{
Appointment apt = fCalendar.schedulerControl1.SelectedAppointments[0];
bool IsRecur = false;
controller = new AppointmentFormController(fCalendar.schedulerControl1, apt);
int intCalID = Convert.ToInt32(controller.LabelId.ToString());
int intEventID = Common.GetID("select EventID from CalendarEvent where CalendarEventID=" + intCalID.ToString());
string strRecurrenceText =
Common.GetString("select RecurrenceText from Event where EventID=" + intEventID.ToString());
if (strRecurrenceText != "")
IsRecur = true;
if (IsRecur)
{
frmDeleteEvents frmDelEvt = new frmDeleteEvents(intEventID, intCalID);
if (frmDelEvt.ShowDialog() == DialogResult.OK)
{
fCalendar.LoadCalendar();
}
frmDelEvt.Close();
frmDelEvt.Dispose();
frmDelEvt = null;
}
else
{
if (Message.MsgDelete())
{
string strMess = "";
Events evt = new Events();
evt.EventID = intEventID;
strMess = evt.CheckClassEvent();
if (strMess == "") strMess = evt.CheckProgramEvent();
if (strMess != "")
{
Message.MsgWarning("This Event is linked with" + strMess + ".\n\nEvent cannot be deleted.");
return;
}
evt.DeleteData(true);
fCalendar.LoadCalendar();
}
}
}
}
}
void DeleteEvent()
{
System.Data.DataRow eventRow = null;
if (gvwEvent.SelectedRowsCount > 0)
eventRow = gvwEvent.GetDataRow(gvwEvent.FocusedRowHandle);
if (eventRow != null)
{
bool isRecur = false;
int calEventID = Convert.ToInt32(eventRow["CalendarEventID"]);
int eventID = Convert.ToInt32(eventRow["EventID"]);
string strRecurrenceText = Common.GetString("select RecurrenceText from Event where EventID=" + eventID.ToString());
if (strRecurrenceText != "")
isRecur = true;
if (isRecur)
{
#region Delete Recurrence
frmDeleteEvents frmDelEvt = new frmDeleteEvents(eventID, calEventID);
if (frmDelEvt.ShowDialog() == DialogResult.OK)
{
LoadEvent();
}
frmDelEvt.Close();
frmDelEvt.Dispose();
#endregion
}
else
{
#region DeleteEvent
if (Message.MsgDelete())
{
string strMess;
Events evt = new Events();
evt.EventID = eventID;
strMess = evt.CheckClassEvent();
if (strMess == "") strMess = evt.CheckProgramEvent();
if (strMess != "") {
Message.MsgWarning("This Event is linked with" + strMess + ".\n\nEvent cannot be deleted.");
return;
}
evt.DeleteData(true);
if (!evt.CheckEventExists(eventID))
{
string module = string.Empty;
int _uid = 0;
int _eventtypeindex = 0;
Events objEvent = new Events();
//Returns Course/Program ID
_uid = objEvent.GetEvent(eventID, ref module, ref _eventtypeindex);
objEvent.EventID = 0;
objEvent.UpdateClassEvent(_uid, "EventId");
}
LoadEvent();
}
#endregion
}
}
}
