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