Esempio n. 1
0
        public List <SODetailsDB> GetJobListFromDriver(RequestJobListFromDriver data)
        {
            List <SODetailsDB> ResultSet = new List <SODetailsDB>();

            using (IDbConnection connection = GetOpenConnection())
            {
                try
                {
                    var param = new DynamicParameters();
                    param.Add("@UserID", data.UserID);
                    ResultSet = connection.Query <SODetailsDB>("SP_GetJobListFromDriver", param, commandType: CommandType.StoredProcedure).ToList();
                }
                catch (Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    if (connection != null)
                    {
                        connection.Close();
                    }
                }
            }

            return(ResultSet);
        }
Esempio n. 2
0
        public ResponseInfo <ResponseSODetails> GetJobListFromDriver(RequestJobListFromDriver data)
        {
            ResponseInfo <ResponseSODetails> response = new ResponseInfo <ResponseSODetails>();

            try
            {
                response.ResponseData = new ResponseSODetails();
                var listData = EPODDAL.GetJobListFromDriver(data);

                response.ResponseData.sODetails = HelperUtil.GenerateSoDetailBase64String(listData);
            }
            catch (Exception ex)

            {
                throw ex;
            }
            return(response);
        }