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(); } } } } }
private void btnDelete_Click(object sender, System.EventArgs e) { if (BusinessLayer.Message.MsgDelete()) { Scheduler.BusinessLayer.Course objCourse = new Scheduler.BusinessLayer.Course(); objCourse.CourseId = _courseid; if (!objCourse.DeleteData()) { BusinessLayer.Message.MsgWarning("Class cannot be deleted"); return; } else { deleted = true; btnDelete.Enabled = false; this.Text = "Adding Class..."; _mode = "Add"; _courseid = 0; foreach (Control c in tbpCourse.Controls) { if (c.GetType().ToString() == "System.Windows.Forms.TextBox") { if (c.Tag == null) c.Text = ""; else if (c.Tag.ToString() == "N") c.Text = "0"; } if (c.GetType().ToString() == "System.Windows.Forms.LinkLabel") { c.Text = "None"; } if (c.GetType().ToString() == "System.Windows.Forms.ComboBox") { c.Text = ""; } } foreach (Control c in tbpCurriculam.Controls) { if (c.GetType().ToString() == "System.Windows.Forms.TextBox") { if (c.Tag == null) c.Text = ""; else if (c.Tag.ToString() == "N") c.Text = "0"; } if (c.GetType().ToString() == "System.Windows.Forms.ComboBox") { c.Text = ""; } } foreach (Control c in tbpDescription.Controls) { if (c.GetType().ToString() == "System.Windows.Forms.TextBox") { if (c.Tag == null) c.Text = ""; else if (c.Tag.ToString() == "N") c.Text = "0"; } if (c.GetType().ToString() == "System.Windows.Forms.ComboBox") { c.Text = ""; } } foreach (Control c in tbpSpecialRemarks.Controls) { if (c.GetType().ToString() == "System.Windows.Forms.TextBox") { if (c.Tag == null) c.Text = ""; else if (c.Tag.ToString() == "N") c.Text = "0"; } if (c.GetType().ToString() == "System.Windows.Forms.ComboBox") { c.Text = ""; } } this.DialogResult = DialogResult.OK; Close(); } } }