/** * VerseController.ProccessCreate * * <summary>Method called once a form was submited to add a verse</summary> * * <param>Verse - VerseModel: model containing all the properties of a verse</param> * * <returns>Index Page with the updated list of verses</returns> */ public IActionResult ProcessCreate(VerseModel Verse) { MyLogger.GetInstance().Info("Entering VerseController.ProcessCreate: \n With Paramenter: " + Verse.ToString()); VerseService.Insert(Verse); return(View("Index", VerseService.Get())); }
/** * <see>BibleVerseApp.Data.VerseDataInterface.Update</see> */ public VerseModel Update(VerseModel Verse) { MyLogger.GetInstance().Info("Entering VerseDAO.Update \n With Parameter: " + Verse.ToString()); int newIdNumber = -1; //Creates SQL Statment string SqlStatment = "UPDATE dbo.Verse SET TESTAMENT = @Testament, BOOK = @Book, CHAPTER_NUM = @ChapNum, VERSE_NUM = @VerseNum, VERSE_TEXT = @Text WHERE Id = @id"; //Creates connection to the databse using (SqlConnection connection = new SqlConnection(Connection)) { //Creates a command with the statment and connections SqlCommand sqlCommand = new SqlCommand(SqlStatment, connection); //Adds Parameters to the command sqlCommand.Parameters.AddWithValue("@Testament", Verse.Testament); sqlCommand.Parameters.AddWithValue("@Book", Verse.Book); sqlCommand.Parameters.AddWithValue("@ChapNum", Verse.ChapNum); sqlCommand.Parameters.AddWithValue("@VerseNum", Verse.VerseNum); sqlCommand.Parameters.AddWithValue("@Text", Verse.Text); try { //Opens the connection connection.Open(); newIdNumber = Convert.ToInt32(sqlCommand.ExecuteScalar()); } catch (Exception ex) { //If there is an error it will be logged to the lof file and console MyLogger.GetInstance().Error("SQL Error within VerseDAO.Update \n With Error Message: " + ex.Message); Console.WriteLine("SQL Error within ProductsDAO.GetAll(): " + ex.Message); } } MyLogger.GetInstance().Info("Leaving VerseDAO.Update \n With Parameter: " + Verse.ToString()); return(Verse); }
/** * <see>BibleVerseApp.Data.VerseDataInterface.GetById</see> */ public VerseModel GetById(int Id) { MyLogger.GetInstance().Info("Entering VerseDAO.GetById \n With Parameter: " + Id); VerseModel Verse = null; //Create SQL Statment string SqlStatment = "SELECT * FROM dbo.Verse WHERE Id = @Id"; //Create connection to the database using (SqlConnection connection = new SqlConnection(Connection)) { //Create the command with the statment and connection SqlCommand sqlCommand = new SqlCommand(SqlStatment, connection); //Add parameters to the sql statment sqlCommand.Parameters.AddWithValue("@Id", Id); try { //Opends connection connection.Open(); //Runs the command SqlDataReader reader = sqlCommand.ExecuteReader(); //With all the rows returned creates Verse Objects and adds them to a list while (reader.Read()) { Verse = new VerseModel { Id = (int)reader[0], Testament = (string)reader[1], Book = (string)reader[2], ChapNum = (int)reader[3], VerseNum = (int)reader[4], Text = (string)reader[5] }; } } catch (Exception ex) { //If there is an error it will be logged to the log file and console MyLogger.GetInstance().Error("SQL Error within VerseDAO.GetById \n With Error Message: " + ex.Message); Console.WriteLine("SQL Error within ProductsDAO.GetAll(): " + ex.Message); } } //Return the list of Verses MyLogger.GetInstance().Info("Leaving VerseDAO.GetById \n With Parameter: " + Verse.ToString()); return(Verse); }
/** * <see>BibleVerseApp.Data.VerseDataInterface.Insert</see> */ public int Insert(VerseModel Verse) { MyLogger.GetInstance().Info("Entering VerseDAO.Insert \n With Parameter: " + Verse.ToString()); int result = -1; //Creates a SQL Statment string SqlStatment = "INSERT INTO dbo.Verse (TESTAMENT, BOOK, CHAPTER_NUM, VERSE_NUM, VERSE_TEXT) VALUES (@Testament, @Book, @ChapNum, @VerseNum, @Text)"; //Creates a connection to the database using (SqlConnection connection = new SqlConnection(Connection)) { //Create the command to run the sql statment with the conneciton SqlCommand command = new SqlCommand(SqlStatment, connection); //Adds all parameters in to the command command.Parameters.AddWithValue("@Testament", Verse.Testament); command.Parameters.AddWithValue("@Book", Verse.Book); command.Parameters.AddWithValue("@ChapNum", Verse.ChapNum); command.Parameters.AddWithValue("@VerseNum", Verse.VerseNum); command.Parameters.AddWithValue("@Text", Verse.Text); try { //Opens the connection connection.Open(); //Runs the command on the database result = command.ExecuteNonQuery(); } catch (Exception ex) { //If there is an error it will be logged in the log file and the console MyLogger.GetInstance().Error("SQL Error within VerseDAO.Insert \n With Error Message: " + ex.Message); Console.WriteLine("SQL Error within ProductsDAO.GetAll(): " + ex.Message); } } //Return the number of rows affected MyLogger.GetInstance().Info("Leaving VerseDAO.Insert \n With Parameter: " + Verse.ToString()); return(result); }
/** * <see>Busniess.VerseBusinessInterface.Update</see> */ public VerseModel Update(VerseModel Verse) { MyLogger.GetInstance().Info("Entering VerseBusinessService.Update: \n With Parameter: " + Verse.ToString()); return(VerseService.Update(Verse)); }