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));
}
