private TableReturn SavePickList(PickListResponseDto pickListInsert, string transcationType)
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = PickListStoredProcedure.StoredProcedureParameters[0].ToString(), Value = pickListInsert.PickListNo.AsDbValue()
},
new SqlParameter {
ParameterName = PickListStoredProcedure.StoredProcedureParameters[1].ToString(), Value = transcationType.AsDbValue()
},
new SqlParameter {
ParameterName = PickListStoredProcedure.StoredProcedureParameters[2].ToString(), Value = pickListInsert.AssignedUserId.AsDbValue()
},
new SqlParameter {
ParameterName = PickListStoredProcedure.StoredProcedureParameters[3].ToString(), Value = pickListInsert.LastSentDeviceId.AsDbValue()
},
new SqlParameter
{
ParameterName = PickListStoredProcedure.StoredProcedureParameters[4].ToString(),
TypeName = PickListStoredProcedure.StoredProcedureTypeNames[0].ToString(),
SqlDbType = SqlDbType.Structured,
Value = pickListInsert.PickListDetail.ToList().ToDataTable()
},
};
return(_tcContext.Set <TableReturn>().FromSqlRaw(PickListStoredProcedure.Sql, parms.ToArray()).AsEnumerable().FirstOrDefault());
}
public ActionResult DeletePickList(PickListResponseDto pickList)
{
var request = _pickListRepository.DeletePickList(pickList);
if (request.Reason == "OK")
{
return(new JsonErrorResult(new { Message = request.OutValue }, HttpStatusCode.OK));
}
else
{
return(new JsonErrorResult(new { Message = request.OutValue }, HttpStatusCode.BadRequest));
}
}
public bool AddPickList(PickListResponseDto pickListInsert)
{
var result = SavePickList(pickListInsert, TransactionTypes.Insert.ToString());
if (result.OutValue == "NOK")
{
throw new ServiceException(new ErrorMessage[]
{
new ErrorMessage()
{
Code = string.Empty,
Message = $"Unable to create picklist"
}
});
}
else
{
return(true);
}
}
public TableReturn UpdatePickList(PickListResponseDto pickListUpdate)
{
pickListUpdate.PickListDetail = new List <PickListResponseDetailDto>();
return(SavePickList(pickListUpdate, TransactionTypes.Update.ToString()));
}
public TableReturn DeletePickList(PickListResponseDto pickListDelete)
{
return(SavePickList(pickListDelete, TransactionTypes.Delete.ToString()));
}
public async Task <ActionResult> AddPickList(PickListResponseDto pickList)
{
return(Ok(_pickListRepository.AddPickList(pickList)));
}
