public bool Save()
{
ClearFeedback();
if (!User.IsSuperAdmin)
{
ShowFeedback("Only Admin can Save Changes to lecturers.", FeedbackType.Error);
return(false);
}
bool result;
try
{
if (FormContext == FormContext.Create)
{
//Create New
result = User.AddNewLecturer(SelectedLecturer, UnitOfWork);
SelectedLecturer = SelectedLecturer;
if (result)
{
UpdateLecturersList(SearchTxt, rowsToReturn);
ShowFeedback($"Created lecturer: {SelectedLecturer.Id}.", FeedbackType.Success);
}
else
{
ShowFeedback($"Failed to create lecturer.", FeedbackType.Error);
}
}
else
{
//Update
result = SelectedLecturer.Validate();
if (result)
{
result = (UnitOfWork.Complete() > 0) ? true : false;
if (result)
{
ShowFeedback($"Updated lecturer: {SelectedLecturer.Id}.", FeedbackType.Success);
}
else
{
ShowFeedback($"lecturer not updated: {SelectedLecturer.Id}.", FeedbackType.Error);
result = false;
}
}
}
return(result);
}
catch (Exception ex)
{
ShowFeedback(ex.GetBaseException().Message, FeedbackType.Error);
return(false);
}
}
//When a module is selected find the ID + lecturer
protected void DropDownModule_SelectedIndexChanged(object sender, EventArgs e)
{
//Module ID from list:
string modID = DropDownModule.SelectedValue;
string connectionString5 = WebConfigurationManager.ConnectionStrings["dbconnect"].ConnectionString;
SqlConnection myConnection5 = new SqlConnection(connectionString5);
myConnection5.Open();
string query5 = "SELECT * FROM SIS_MODULES WHERE moduleID=@selectedMod";
SqlCommand myCommand5 = new SqlCommand(query5, myConnection5);
myCommand5.Parameters.AddWithValue("@selectedMod", modID);
SqlDataReader rdr = myCommand5.ExecuteReader();
while (rdr.Read())
{
string lecturer = rdr["lecturerID"].ToString();
SelectedLecturer.Text = lecturer;
}
rdr.Close();
SelectedLecturer.DataBind();
string lecturerID = SelectedLecturer.Text;
string query6 = "SELECT * FROM SIS_LECTURER WHERE lecturerID=@lecturer";
SqlCommand myCommand6 = new SqlCommand(query6, myConnection5);
myCommand6.Parameters.AddWithValue("@lecturer", lecturerID);
SqlDataReader rdr2 = myCommand6.ExecuteReader();
while (rdr2.Read())
{
string user = rdr2["userID"].ToString();
SelectedUser.Text = user;
}
rdr2.Close();
SelectedUser.DataBind();
}
private void PoolingUpdate(object obj)
{
App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
{
Lecturer tempLecturer = new Lecturer();
tempLecturer.ShallowCopy(SelectedLecturer);
//get new and deleted changes from the database
UpdateLecturersList(SearchTxt, rowsToReturn);
foreach (BaseEntity l in Lecturers)
{//a slow but safe way to get record updates from the pooling
if (l.Id != tempLecturer.Id)
{
UnitOfWork.Reload(l);
}
}
SelectedLecturer.ShallowCopy(tempLecturer);
});
}
public bool GenerateNewPasswordHash(string optionalNewPassword)
{
ClearFeedback();
if (!User.IsSuperAdmin)
{
ShowFeedback("Only Admin can generate new passwords.", FeedbackType.Error);
return(false);
}
bool result = false;
try
{
//Confirmation Check
Mediator.NotifyColleagues(MediatorChannels.LecturerPageGeneratePasswordCheck.ToString(), null);
if (IsConfirmed)
{
//randomly generate
result = SelectedLecturer.GenerateNewPasswordHash(ref optionalNewPassword, null);
OnPropertyChanged(nameof(SelectedLecturer));
if (result)
{
ShowFeedback("Password hash generated: \nRemember to save changes.", FeedbackType.Info);
}
else
{
ShowFeedback("Failed to generate new password hash.", FeedbackType.Error);
}
//Temporary display new password
Mediator.NotifyColleagues(MediatorChannels.LecturerPageNewPasswordDisplay.ToString(), optionalNewPassword);
return(true);
}
else
{
ShowFeedback("Generation of new password Canceled.", FeedbackType.Error);
return(false);
}
}
catch (Exception ex)
{
ShowFeedback(ex.Message, FeedbackType.Error);
return(false);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//Inserting initial event details:
string connectionString = WebConfigurationManager.ConnectionStrings["dbconnect"].ConnectionString;
SqlConnection myConnection = new SqlConnection(connectionString);
// myConnection.ConnectionString is now set to connectionString.
myConnection.Open();
int dropdownmodule = Convert.ToInt16(DropDownModule.SelectedValue);
string eventname = Name.Text;
string eventstart = startDate.Text;
string eventend = endDate.Text;
string eventdesc = desc.Text;
DateTime startDateSelected = Calendar1.SelectedDate;
DateTime endDateSelected = Calendar2.SelectedDate;
int weeks = Convert.ToInt32(NumOfWeeks.SelectedValue);
int i;
SelectedLecturer.DataBind();
int lectID = Convert.ToInt32(SelectedUser.Text);
if (dropdownmodule == 0)
{
string query = "INSERT INTO SIS_EVENT (title, description, event_start, event_end, all_day, userID) OUTPUT INSERTED.eventID VALUES (@title, @description, @event_start, @event_end, @all_day, @userID)";
SqlCommand myCommand = new SqlCommand(query, myConnection);
myCommand.Parameters.AddWithValue("@userID", 0);
myCommand.Parameters.AddWithValue("@title", eventname);
myCommand.Parameters.AddWithValue("@description", eventdesc);
myCommand.Parameters.AddWithValue("@event_start", eventstart);
myCommand.Parameters.AddWithValue("@event_end", eventend);
myCommand.Parameters.AddWithValue("@all_day", "");
//Executes query and takes the id of the newly inserted row
Int32 newEventID = (Int32)myCommand.ExecuteScalar();
myConnection.Close();
done.Text = "Event Added";
//Inserting event into event module link table:
string connectionString2 = WebConfigurationManager.ConnectionStrings["dbconnect"].ConnectionString;
SqlConnection myConnection2 = new SqlConnection(connectionString2);
myConnection2.Open();
string query2 = "INSERT INTO [SIS_EVENT_MODULE] (eventID, moduleID) VALUES (@newEventID, @newModuleID)";
SqlCommand myCommand2 = new SqlCommand(query2, myConnection2);
myCommand2.Parameters.AddWithValue("@newEventID", newEventID);
myCommand2.Parameters.AddWithValue("@newModuleID", dropdownmodule);
myCommand2.ExecuteNonQuery();
myConnection2.Close();
//If more than one week is chosen, add multiple events (calculates dates)
if (weeks > 1)
{
int DayInterval = 7;
DateTime fullend = startDateSelected.AddMonths(3);
DateTime fullend2 = endDateSelected.AddMonths(3);
//Start dates array:
List <DateTime> startDateList = new List <DateTime>();
while (startDateSelected.AddDays(DayInterval) <= fullend)
{
startDateSelected = startDateSelected.AddDays(DayInterval);
startDateList.Add(startDateSelected);
}
//End dates array:
List <DateTime> endDateList = new List <DateTime>();
while (endDateSelected.AddDays(DayInterval) <= fullend2)
{
endDateSelected = endDateSelected.AddDays(DayInterval);
endDateList.Add(endDateSelected);
}
DateTime nextweekstart;
DateTime nextweekend;
for (i = 0; i < weeks; i++)
{
if (i > weeks)
{
break;
}
nextweekstart = startDateList[i];
nextweekend = endDateList[i];
week2.Text = nextweekstart.ToString();
week3.Text = nextweekstart.ToString();
week2.DataBind();
week3.DataBind();
DateTime newStart = Convert.ToDateTime(week2.Text);
DateTime newEnd = Convert.ToDateTime(week3.Text);
string connectionString3 = WebConfigurationManager.ConnectionStrings["dbconnect"].ConnectionString;
SqlConnection myConnection3 = new SqlConnection(connectionString);
// myConnection.ConnectionString is now set to connectionString.
myConnection3.Open();
string query3 = "INSERT INTO SIS_EVENT (title, description, event_start, event_end, all_day, userID) OUTPUT INSERTED.eventID VALUES (@title2, @description2, @event_start2, @event_end2, @all_day2, @userID2)";
SqlCommand myCommand3 = new SqlCommand(query3, myConnection3);
//create a parameterised object
myCommand3.Parameters.AddWithValue("@userID2", 0);
myCommand3.Parameters.AddWithValue("@title2", eventname);
myCommand3.Parameters.AddWithValue("@description2", eventdesc);
myCommand3.Parameters.AddWithValue("@event_start2", newStart);
myCommand3.Parameters.AddWithValue("@event_end2", newEnd);
myCommand3.Parameters.AddWithValue("@all_day2", "");
//Executes query and takes the id of the newly inserted row
newEventID = (Int32)myCommand3.ExecuteScalar();
myConnection3.Close();
done.Text = "Event Added";
string connectionString4 = WebConfigurationManager.ConnectionStrings["dbconnect"].ConnectionString;
SqlConnection myConnection4 = new SqlConnection(connectionString2);
myConnection4.Open();
string query4 = "INSERT INTO [SIS_EVENT_MODULE] (eventID, moduleID) VALUES (@newEventID2, @newModuleID2)";
SqlCommand myCommand4 = new SqlCommand(query4, myConnection4);
myCommand4.Parameters.AddWithValue("@newEventID2", newEventID);
myCommand4.Parameters.AddWithValue("@newModuleID2", dropdownmodule);
myCommand4.ExecuteNonQuery();
myConnection4.Close();
}
}
}
else
{
string query = "INSERT INTO SIS_EVENT (title, description, event_start, event_end, all_day, userID) OUTPUT INSERTED.eventID VALUES (@title, @description, @event_start, @event_end, @all_day, @userID)";
SqlCommand myCommand = new SqlCommand(query, myConnection);
myCommand.Parameters.AddWithValue("@userID", lectID);
myCommand.Parameters.AddWithValue("@title", eventname);
myCommand.Parameters.AddWithValue("@description", eventdesc);
myCommand.Parameters.AddWithValue("@event_start", eventstart);
myCommand.Parameters.AddWithValue("@event_end", eventend);
myCommand.Parameters.AddWithValue("@all_day", "");
//Executes query and takes the id of the newly inserted row
Int32 newEventID = (Int32)myCommand.ExecuteScalar();
myConnection.Close();
done.Text = "Event Added";
//Inserting event into event module link table:
string connectionString2 = WebConfigurationManager.ConnectionStrings["dbconnect"].ConnectionString;
SqlConnection myConnection2 = new SqlConnection(connectionString2);
myConnection2.Open();
string query2 = "INSERT INTO [SIS_EVENT_MODULE] (eventID, moduleID) VALUES (@newEventID, @newModuleID)";
SqlCommand myCommand2 = new SqlCommand(query2, myConnection2);
myCommand2.Parameters.AddWithValue("@newEventID", newEventID);
myCommand2.Parameters.AddWithValue("@newModuleID", dropdownmodule);
myCommand2.ExecuteNonQuery();
myConnection2.Close();
//If more than one week is chosen, add multiple events (calculates dates)
if (weeks > 1)
{
int DayInterval = 7;
DateTime fullend = startDateSelected.AddMonths(3);
DateTime fullend2 = endDateSelected.AddMonths(3);
//Start dates array:
List <DateTime> startDateList = new List <DateTime>();
while (startDateSelected.AddDays(DayInterval) <= fullend)
{
startDateSelected = startDateSelected.AddDays(DayInterval);
startDateList.Add(startDateSelected);
}
//End dates array:
List <DateTime> endDateList = new List <DateTime>();
while (endDateSelected.AddDays(DayInterval) <= fullend2)
{
endDateSelected = endDateSelected.AddDays(DayInterval);
endDateList.Add(endDateSelected);
}
DateTime nextweekstart;
DateTime nextweekend;
for (i = 0; i < weeks; i++)
{
if (i > weeks)
{
break;
}
nextweekstart = startDateList[i];
nextweekend = endDateList[i];
week2.Text = nextweekstart.ToString();
week3.Text = nextweekstart.ToString();
week2.DataBind();
week3.DataBind();
DateTime newStart = Convert.ToDateTime(week2.Text);
DateTime newEnd = Convert.ToDateTime(week3.Text);
string connectionString3 = WebConfigurationManager.ConnectionStrings["dbconnect"].ConnectionString;
SqlConnection myConnection3 = new SqlConnection(connectionString);
// myConnection.ConnectionString is now set to connectionString.
myConnection3.Open();
string query3 = "INSERT INTO SIS_EVENT (title, description, event_start, event_end, all_day, userID) OUTPUT INSERTED.eventID VALUES (@title2, @description2, @event_start2, @event_end2, @all_day2, @userID2)";
SqlCommand myCommand3 = new SqlCommand(query3, myConnection3);
//create a parameterised object
myCommand3.Parameters.AddWithValue("@userID2", lectID);
myCommand3.Parameters.AddWithValue("@title2", eventname);
myCommand3.Parameters.AddWithValue("@description2", eventdesc);
myCommand3.Parameters.AddWithValue("@event_start2", newStart);
myCommand3.Parameters.AddWithValue("@event_end2", newEnd);
myCommand3.Parameters.AddWithValue("@all_day2", "");
//Executes query and takes the id of the newly inserted row
newEventID = (Int32)myCommand3.ExecuteScalar();
myConnection3.Close();
done.Text = "Event Added";
string connectionString4 = WebConfigurationManager.ConnectionStrings["dbconnect"].ConnectionString;
SqlConnection myConnection4 = new SqlConnection(connectionString2);
myConnection4.Open();
string query4 = "INSERT INTO [SIS_EVENT_MODULE] (eventID, moduleID) VALUES (@newEventID2, @newModuleID2)";
SqlCommand myCommand4 = new SqlCommand(query4, myConnection4);
myCommand4.Parameters.AddWithValue("@newEventID2", newEventID);
myCommand4.Parameters.AddWithValue("@newModuleID2", dropdownmodule);
myCommand4.ExecuteNonQuery();
myConnection4.Close();
}
}
}
}
