public async Task <Tuple <bool, string> > CreateCourse(CourseModel courseModel) { Tuple <bool, string> result = null; int insertStatus = -1; try { var parameters = new DynamicParameters(); using (SqlConnection cxn = new SqlConnection(_dcDb)) { if (courseModel.CourseID > 0) { parameters.Add("@CourseID", courseModel.CourseID, DbType.Int32); } parameters.Add("@CourseMasterID", courseModel.CourseMasterID, DbType.Int32); parameters.Add("@CourseName", courseModel.CourseName, DbType.String); parameters.Add("@CourseDescription", courseModel.CourseDescription, DbType.String); parameters.Add("@CreatedBy", UserID, DbType.Int32); cxn.Open(); insertStatus = await cxn.ExecuteScalarAsync <int>("dbo.Insert_CreateCourse", parameters, commandType : CommandType.StoredProcedure); cxn.Close(); } if (insertStatus == 0) { if (courseModel.CourseID == 0) { result = Tuple.Create(true, "Course details created successfully"); } else if (courseModel.CourseID > 0) { result = Tuple.Create(true, "Course details updated successfully"); } } else { result = Tuple.Create(false, "Course details created failed"); } } catch (Exception ex) { ErrorLog.Write(ex); result = Tuple.Create(false, ex.Message); } return(result); }
public async Task <Tuple <bool, string> > CreateCourse(CourseModel courseModel) { Tuple <bool, string> result = null; try { result = await _repo.CreateCourse(courseModel); } catch (Exception ex) { ErrorLog.Write(ex); } return(result); }