public async Task <APIResult> SavePlansPosition(PlansPositionDto param)
{
try
{
string spName = @"up_RMMT_TOU_PlansPosition_S";
DynamicParameters dp = new DynamicParameters();
dp.Add("@Id", param.Id, DbType.Int64);
dp.Add("@Batch", param.Batch, DbType.Int64);
dp.Add("@DisId", param.DisId, DbType.Int64);
dp.Add("@SalesConsultant", param.SalesConsultant, DbType.String);
dp.Add("@SalesManager", param.SalesManager, DbType.String);
dp.Add("@SalesInside", param.SalesInside, DbType.String);
dp.Add("@UserId", param.InUserid, DbType.String);
using (var conn = new SqlConnection(DapperContext.Current.SqlConnection))
{
conn.Open();
using (var tran = conn.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
{
await conn.ExecuteAsync(spName, dp, tran, null, CommandType.StoredProcedure);
tran.Commit();
}
}
return(new APIResult {
Body = "", ResultCode = ResultType.Success, Msg = ""
});
}
catch (Exception ex)
{
return(new APIResult {
Body = "", ResultCode = ResultType.Failure, Msg = ex.Message
});
}
}
public Task <APIResult> SavePlansPosition([FromBody] PlansPositionDto param)
{
return(_tourService.SavePlansPosition(param));
}
