//Get one single AR
public async Task <AR> ARSingle(int id)
{
AR ar = new AR();
var parameters = new DynamicParameters();
parameters.Add("Ar_id", id, DbType.Int32);
using (var conn = new SqlConnection(_configuration.Value))
{
ar = await conn.QueryFirstOrDefaultAsync <AR>("spAR_GetOne", parameters, commandType : CommandType.StoredProcedure);
}
return(ar);
}
public async Task <bool> ARDelete(int id)
{
AR ar = new AR();
using (var conn = new SqlConnection(_configuration.Value))
{
var parameters = new DynamicParameters();
parameters.Add("Ar_id", id, DbType.Int32);
await conn.ExecuteAsync("spAR_DeleteOne", parameters, commandType : CommandType.StoredProcedure);
}
return(true);
}
//Update AR
public async Task <bool> ARUpdate(AR ar)
{
using (var conn = new SqlConnection(_configuration.Value))
{
var parameters = new DynamicParameters();
parameters.Add("Ar_id", ar.Ar_id, DbType.Int32);
parameters.Add("DataEmissao", ar.DataEmissao, DbType.Date);
parameters.Add("Prioridade", ar.Prioridade, DbType.Int16);
parameters.Add("Objetivo", ar.Objetivo, DbType.String);
parameters.Add("Status", ar.Status, DbType.Boolean);
await conn.ExecuteAsync("spAR_Update", parameters, commandType : CommandType.StoredProcedure);
}
return(true);
}
//Add (Create Row) (Sql Insert)
public async Task <bool> ARInsert(AR ar)
{
using (var conn = new SqlConnection(_configuration.Value))
{
var parameters = new DynamicParameters();
parameters.Add("DataEmissao", ar.DataEmissao, DbType.Date);
parameters.Add("Prioridade", ar.Prioridade, DbType.Int16);
parameters.Add("Objetivo", ar.Objetivo, DbType.String);
parameters.Add("Status", ar.Status, DbType.Boolean);
//Storage Procedure Method
await conn.ExecuteAsync("spAR_Insert", parameters, commandType : CommandType.StoredProcedure);
//Raw SQl Method
//const string sql = @"INSERT INTO dbo.AR (DataEmissao, Prioridade, Objetivo, Status) VALUES (@DataEmissao, @Prioridade, @Objetivo, @Status)";
//await conn.ExecuteAsync(sql, new { ar.DataEmissao, ar.Prioridade, ar.Objetivo, ar.Status }, commandType: CommandType.Text);
}
return(true);
}