public GapPickingNoteResponse GetGapPickingNote(GapPickingNoteRequest request) { GapPickingNoteResponse response = new GapPickingNoteResponse(); string sql = "SELECT * FROM dbo.User_Code_Mapping WHERE [User] = '" + request.User + "'"; DataTable dt = this.ExecuteDataTableBySqlString(sql, null); response.Code = dt.ConvertToEntity <UserCode>(); return(response); }
public Response <GapPickingNoteResponse> AddGapPickingNote(GapPickingNoteRequest request) { Response <GapPickingNoteResponse> response = new Response <GapPickingNoteResponse>() { Result = new GapPickingNoteResponse() }; try { GapPickingNoteAccessor accessor = new GapPickingNoteAccessor(); response.SuccessMessage = accessor.AddGapPickingNote(request.GapPickingNote); } catch (Exception ex) { LogError(ex); response.IsSuccess = false; response.Exception = ex; response.ErrorCode = ErrorCode.Technical; } return(response); }