public async Task <bool> AddNoteBookAsync(NoteBookModel noteBook) { using (SqlConnection conn = GetConnection()) { conn.Open(); var transaction = conn.BeginTransaction(); try { var list = new List <ProjectTaskModel>(); DynamicParameters param = new DynamicParameters(); if (noteBook.NoteBookId > 0) { param.Add("@NoteBookId", noteBook.NoteBookId); } param.Add("@Title", noteBook.Title); param.Add("@Description", noteBook.Description); param.Add("@CreatedBy", noteBook.CreatedBy); int TaskId = await transaction.Connection.ExecuteScalarAsync <int>("sp_AddNoteBook", param, transaction : transaction, commandType : CommandType.StoredProcedure); transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); return(false); } } }
public async Task <IActionResult> AddNoteBook(NoteBookModel noteBookModel) { noteBookModel.CreatedBy = this.UserId; if (await this._repository.AddNoteBookAsync(noteBookModel)) { ViewBag.Success = "NoteBook has been added"; ModelState.Clear(); noteBookModel = new NoteBookModel(); } else { ViewBag.Error = "There are error while saving"; } return(View(noteBookModel)); }
public async Task <IActionResult> AddNoteBook() { NoteBookModel noteBookModel = new NoteBookModel(); return(View(noteBookModel)); }