public async Task <APIResult> SaveDealerList(ParamDealerDto paramDto)
{
if (paramDto.DisList != null)
{
paramDto.DisList = paramDto.DisList.Where(a => a.DisCode != null).ToList <DealerDto>();
}
string spName = @"up_RMMT_BAS_SaveDealers_C";
string xmlDisList = CommonHelper.Serializer(typeof(List <DealerDto>), paramDto.DisList);
DynamicParameters dp = new DynamicParameters();
dp.Add("@InUserId", paramDto.InUserId, DbType.Int32);
dp.Add("@XmlData", xmlDisList, DbType.Xml);
dp.Add("@XmlRootName", "/ArrayOfDealerDto/DealerDto", DbType.String);
using (var conn = new SqlConnection(DapperContext.Current.SqlConnection))
{
conn.Open();
IEnumerable <DisInfoDto> list;
using (var tran = conn.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
{
try
{
list = await conn.QueryAsync <DisInfoDto>(spName, dp, tran, null, CommandType.StoredProcedure);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
return(new APIResult {
Body = "", ResultCode = ResultType.Failure, Msg = ex.Message
});
}
finally
{
tran.Dispose();
}
}
return(new APIResult {
Body = CommonHelper.EncodeDto <DisInfoDto>(list), ResultCode = ResultType.Success, Msg = ""
});
}
}
public Task <APIResult> SaveDealerList([FromBody] ParamDealerDto paramDto)
{
return(_usersService.SaveDealerList(paramDto));
}