public ActionResult ModeratorDetails(int id)
{
ActionResult response = null;
try
{
ModeratorDO moderatorDO = _moderatorDAO.ObtainModeratorByID(id);
if (moderatorDO != null)
{
_logger.LogMessage("Info", "Moderator Details", MethodBase.GetCurrentMethod().ToString(),
"User request to view details of moderator with ID #" + id + " is valid.");
ModeratorPO moderatorPO = Mapping.Mapper.ModeratorDOtoPO(moderatorDO);
response = View(moderatorPO);
}
else
{
_logger.LogMessage("Warning", "Page not found", MethodBase.GetCurrentMethod().ToString(),
"User attempted to navigate to ModeratorDetails on null ID #" + id + ". " +
"Redirecting to Index.");
TempData["idNotFound"] = "The page you were looking for could not be found." +
"You have been returned to the moderator list.";
response = RedirectToAction("Index");
}
}
catch (Exception ex)
{
_logger.LogMessage(ex, "Fatal");
}
finally { }
return(response);
}
public ActionResult UpdateModerator(ModeratorPO form)
{
ActionResult response = null;
try
{
_logger.LogMessage("Info", "Update Moderator Post", MethodBase.GetCurrentMethod().ToString(),
"Request to update information for moderator with ID #" + form.ModeratorID + " received.");
if (ModelState.IsValid)
{
_logger.LogMessage("Info", "Model State check passed", MethodBase.GetCurrentMethod().ToString(),
"ModeratorPO form model state is valid.");
form = CalculationHandler(form);
_logger.LogMessage("Attempting to map Moderator PO to DO.");
ModeratorDO moderatorDO = Mapping.Mapper.ModeratorPOtoDO(form);
_moderatorDAO.UpdateModerator(moderatorDO);
TempData["updateModerator"] = "Moderator information updated.";
response = RedirectToAction("ModeratorDetails", "Moderator", new { id = form.ModeratorID });
}
else
{
_logger.LogMessage("Warning", "Model State check failed", MethodBase.GetCurrentMethod().ToString(),
"ModeratorPO form model state was not valid. Returning user to View.");
response = View(form);
}
}
catch (Exception ex)
{
_logger.LogMessage(ex, "Fatal");
}
finally { }
return(response);
}
public void AddParameterValues(SqlCommand storedProcedure, ModeratorDO moderatorDO)
{
storedProcedure.Parameters.AddWithValue("@Name", moderatorDO.Name);
storedProcedure.Parameters.AddWithValue("@ChemicalFormula", (object)moderatorDO.ChemicalFormula ?? DBNull.Value);
storedProcedure.Parameters.AddWithValue("@Nucleus", moderatorDO.Nucleus);
storedProcedure.Parameters.AddWithValue("@AtomicMass", moderatorDO.AtomicMass);
storedProcedure.Parameters.AddWithValue("@EnergyDecrement", (moderatorDO.EnergyDecrement != 0) ? (object)moderatorDO.EnergyDecrement : DBNull.Value);
storedProcedure.Parameters.AddWithValue("@NumberOfCollisions", (moderatorDO.Collisions != 0) ? (object)moderatorDO.Collisions : DBNull.Value);
storedProcedure.Parameters.AddWithValue("@ScatteringXS", (moderatorDO.ScatteringXS != 0) ? (object)moderatorDO.ScatteringXS : DBNull.Value);
storedProcedure.Parameters.AddWithValue("@AbsorptionXS", (moderatorDO.AbsorptionXS != 0) ? (object)moderatorDO.AbsorptionXS : DBNull.Value);
storedProcedure.Parameters.AddWithValue("@Efficiency", (moderatorDO.ModerationEfficiency != 0) ? (object)moderatorDO.ModerationEfficiency : DBNull.Value);
}
public ModeratorDO ObtainModeratorByID(int id)
{
ModeratorDO moderatorDO = null;
SqlConnection connectionToSql = null;
SqlCommand obtainModeratorInfo = null;
SqlDataAdapter adapter = null;
DataTable moderatorInfo = new DataTable();
try
{
connectionToSql = new SqlConnection(_connectionString);
obtainModeratorInfo = new SqlCommand("OBTAIN_MODERATOR_BY_ID", connectionToSql);
obtainModeratorInfo.CommandType = CommandType.StoredProcedure;
obtainModeratorInfo.Parameters.AddWithValue("@ModeratorID", id);
connectionToSql.Open();
adapter = new SqlDataAdapter(obtainModeratorInfo);
adapter.Fill(moderatorInfo);
if (moderatorInfo.Rows.Count > 0)
{
DataRow row = moderatorInfo.Rows[0];
moderatorDO = Mapping.Mapper.ModeratorTableRowToDO(row);
}
else
{
_logger.LogMessage("Warning",
"Queried ID not found",
MethodBase.GetCurrentMethod().ToString(),
"Did not create moderatorDO. No rows found in moderatorInfo table.");
}
}
catch (Exception ex)
{
_logger.LogMessage(ex, "Fatal");
throw ex;
}
finally
{
if (connectionToSql != null)
{
connectionToSql.Close();
connectionToSql.Dispose();
}
if (adapter != null)
{
adapter.Dispose();
}
}
return(moderatorDO);
}
public ActionResult AddModerator(ModeratorPO form)
{
ActionResult response = null;
int rowsAffected;
try
{
_logger.LogMessage("Info", "Add Moderator Post request", MethodBase.GetCurrentMethod().ToString(),
"Request to add Moderator information received.");
if (ModelState.IsValid)
{
_logger.LogMessage("Info", "Model State check passed", MethodBase.GetCurrentMethod().ToString(),
"ModeratorPO form model state is valid.");
form = CalculationHandler(form);
_logger.LogMessage("Attempting to map Moderator PO to DO.");
ModeratorDO moderatorDO = Mapping.Mapper.ModeratorPOtoDO(form);
rowsAffected = _moderatorDAO.AddNewModerator(moderatorDO);
if (rowsAffected > 0)
{
_logger.LogMessage("Info", "New moderator information added", MethodBase.GetCurrentMethod().ToString(),
form.Name + " moderator was added to database.");
TempData["addNew"] = "Moderator added to database successfully.";
}
else
{
_logger.LogMessage("Warning", "Add Moderator attempt failed", MethodBase.GetCurrentMethod().ToString(),
"Attempt to add new moderator ("
+ form.Name + ") showed no database rows affected.");
TempData["addNew"] = "Failed to add new moderator to the database.";
}
response = RedirectToAction("Index");
}
else
{
_logger.LogMessage("Warning", "Model State check failed", MethodBase.GetCurrentMethod().ToString(),
"ModeratorPO form model state was not valid. Returning user to View.");
response = View(form);
}
}
catch (Exception ex)
{
_logger.LogMessage(ex, "Fatal");
}
finally { }
return(response);
}
public void UpdateModerator(ModeratorDO moderatorDO)
{
int rowsAffected = 0;
SqlConnection connectionToSql = null;
SqlCommand updateModerator = null;
try
{
_logger.LogMessage("Info", "Update Moderator start", MethodBase.GetCurrentMethod().ToString(),
"Request to update moderator with ID #" + moderatorDO.ModeratorID + " received.");
_logger.LogMessage("Instantiating SQL connection from connection string.");
connectionToSql = new SqlConnection(_connectionString);
_logger.LogMessage("Instantiating SQL command for stored procedure.");
updateModerator = new SqlCommand("UPDATE_MODERATOR", connectionToSql);
updateModerator.CommandType = CommandType.StoredProcedure;
_logger.LogMessage("Adding parameters to stored procedure.");
updateModerator.Parameters.AddWithValue("@ModeratorID", moderatorDO.ModeratorID);
AddParameterValues(updateModerator, moderatorDO);
_logger.LogMessage("Opening SQL connection.");
connectionToSql.Open();
rowsAffected = updateModerator.ExecuteNonQuery();
if (rowsAffected > 0)
{
_logger.LogMessage("Info", "Nonquery completed", MethodBase.GetCurrentMethod().ToString(),
"Moderator information was updated.");
}
else
{
_logger.LogMessage("Warning", "No rows affected in nonquery", MethodBase.GetCurrentMethod().ToString(),
"Moderator information was not updated.");
}
}
catch (Exception ex)
{
_logger.LogMessage(ex, "Fatal");
throw ex;
}
finally
{
if (connectionToSql != null)
{
connectionToSql.Close();
connectionToSql.Dispose();
}
}
}
public int AddNewModerator(ModeratorDO moderatorDO)
{
int rowsAffected = 0;
SqlConnection connectionToSql = null;
SqlCommand addModerator = null;
try
{
_logger.LogMessage("Info", "Add New Moderator start", MethodBase.GetCurrentMethod().ToString(),
"Request to add new moderator to database received.");
_logger.LogMessage("Instantiating SQL connection from connection string.");
connectionToSql = new SqlConnection(_connectionString);
_logger.LogMessage("Instantiating SQL command for stored procedure.");
addModerator = new SqlCommand("ADD_NEW_MODERATOR", connectionToSql);
addModerator.CommandType = CommandType.StoredProcedure;
_logger.LogMessage("Adding parameters to stored procedure.");
AddParameterValues(addModerator, moderatorDO);
_logger.LogMessage("Opening SQL connection.");
connectionToSql.Open();
rowsAffected = addModerator.ExecuteNonQuery();
if (rowsAffected > 0)
{
_logger.LogMessage("Info", "Nonquery completed", MethodBase.GetCurrentMethod().ToString(),
"New moderator information was added to the database.");
}
else
{
_logger.LogMessage("Warning", "No rows affected in nonquery", MethodBase.GetCurrentMethod().ToString(),
"Moderator information was not added to the database.");
}
}
catch (Exception ex)
{
_logger.LogMessage(ex, "Fatal");
throw ex;
}
finally
{
if (connectionToSql != null)
{
connectionToSql.Close();
connectionToSql.Dispose();
}
}
return(rowsAffected);
}
public static ModeratorPO ModeratorDOtoPO(ModeratorDO from)
{
ModeratorPO to = new ModeratorPO();
to.ModeratorID = from.ModeratorID;
to.Name = from.Name;
to.ChemicalFormula = from.ChemicalFormula;
to.Nucleus = from.Nucleus;
to.AtomicMass = from.AtomicMass;
to.EnergyDecrement = from.EnergyDecrement;
to.Collisions = from.Collisions;
to.ScatteringXS = from.ScatteringXS;
to.AbsorptionXS = from.AbsorptionXS;
to.ModerationEfficiency = from.ModerationEfficiency;
return(to);
}
public static ModeratorDO ModeratorTableRowToDO(DataRow row)
{
ModeratorDO moderatorDO = new ModeratorDO();
moderatorDO.ModeratorID = int.Parse(row["ModeratorID"].ToString());
moderatorDO.Name = row["Name"].ToString().Trim();
moderatorDO.ChemicalFormula = row["ChemicalFormula"].ToString().Trim();
moderatorDO.Nucleus = row["Nucleus"].ToString().Trim();
moderatorDO.AtomicMass = (int.TryParse(row["AtomicMass"].ToString(), out int atomicMass) ? atomicMass : default(int));
moderatorDO.EnergyDecrement = (float.TryParse(row["EnergyDecrement"].ToString(), out float energyDecrement) ? energyDecrement : default(float));
moderatorDO.Collisions = (int.TryParse(row["NumberOfCollisions"].ToString(), out int collisions) ? collisions : default(int));
moderatorDO.ScatteringXS = (float.TryParse(row["ScatteringXS"].ToString(), out float sigmaS) ? sigmaS : default(float));
moderatorDO.AbsorptionXS = (float.TryParse(row["AbsorptionXS"].ToString(), out float sigmaA) ? sigmaA : default(float));
moderatorDO.ModerationEfficiency = (float.TryParse(row["Efficiency"].ToString(), out float efficiency) ? efficiency : default(float));
return(moderatorDO);
}
public ActionResult UpdateModerator(int id)
{
ModeratorPO form = new ModeratorPO();
try
{
_logger.LogMessage("Info", "Update Moderator Get request", MethodBase.GetCurrentMethod().ToString(),
"Request for update form for moderator with ID#" + id + " received.");
ModeratorDO moderatorDO = _moderatorDAO.ObtainModeratorByID(id);
form = Mapping.Mapper.ModeratorDOtoPO(moderatorDO);
}
catch (Exception ex)
{
_logger.LogMessage(ex, "Fatal");
}
finally { }
return(View(form));
}
public List <ModeratorDO> ObtainAllModerators()
{
List <ModeratorDO> moderatorList = new List <ModeratorDO>();
SqlConnection connectionToSql = null;
SqlCommand obtainModerators = null;
SqlDataAdapter adapter = null;
DataTable moderatorsTable = new DataTable();
try
{
connectionToSql = new SqlConnection(_connectionString);
obtainModerators = new SqlCommand("OBTAIN_MODERATORS", connectionToSql);
obtainModerators.CommandType = CommandType.StoredProcedure;
connectionToSql.Open();
adapter = new SqlDataAdapter(obtainModerators);
adapter.Fill(moderatorsTable);
foreach (DataRow row in moderatorsTable.Rows)
{
ModeratorDO moderatorDO = Mapping.Mapper.ModeratorTableRowToDO(row);
moderatorList.Add(moderatorDO);
}
}
catch (Exception ex)
{
_logger.LogMessage(ex, "Fatal");
throw ex;
}
finally
{
if (connectionToSql != null)
{
connectionToSql.Close();
connectionToSql.Dispose();
}
if (adapter != null)
{
adapter.Dispose();
}
}
return(moderatorList);
}
