Example #1
0
        public IEnumerable <Entities.Product> GetList(string keyword, int status, out int totalRows, int?pageIndex = 1, int?pageSize = 15)
        {
            List <Entities.Product> list = new List <Entities.Product>();

            totalRows = 0;
            string storeName      = "admin_product_getlist";
            string storeNameCount = "admin_product_getlist_count";

            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeNameCount, true))
                    {
                        command.Parameters.Add(new Npgsql.NpgsqlParameter("_keyword", keyword + ""));
                        command.Parameters.Add(new Npgsql.NpgsqlParameter("_status", status));
                        totalRows = (int)command.ExecuteScalar();
                    }

                    if (totalRows > 0)
                    {
                        using (var command = db.CreateCommand(storeName, true))
                        {
                            command.Parameters.Add(new Npgsql.NpgsqlParameter("_keyword", keyword + ""));
                            command.Parameters.Add(new Npgsql.NpgsqlParameter("_status", status));
                            command.Parameters.Add(new Npgsql.NpgsqlParameter("_pageindex", pageIndex));
                            command.Parameters.Add(new Npgsql.NpgsqlParameter("_pagesize", pageSize));
                            using (var reader = command.ExecuteReader())
                            {
                                if (reader.HasRows)
                                {
                                    while (reader.Read())
                                    {
                                        var obj = new Entities.Product();
                                        EntityBase.SetObjectValue(reader, ref obj);
                                        list.Add(obj);
                                    }
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
            return(list);
        }
Example #2
0
        /// <summary>
        /// The get by delivery order identifier
        /// Author: ThanhDT
        /// Created date: 8/11/2020 12:21 AM
        /// </summary>
        /// <param name="deliveryOrderId">The delivery order identifier.</param>
        /// <returns></returns>
        /// <exception cref="System.Exception"></exception>
        public Entities.Order GetByDeliveryOrderId(string deliveryOrderId)
        {
            string storeName = "admin_order_getbydeliveryorderid";

            Entities.Order result;
            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeName, true))
                    {
                        command.Parameters.Add(NpgsqlParameter("@_delivery_order_id", deliveryOrderId, NpgsqlDbType.Varchar));
                        using (var reader = command.ExecuteReader())
                        {
                            if (reader.HasRows)
                            {
                                result = new Entities.Order();
                                reader.Read();
                                EntityBase.SetObjectValue(reader, ref result);
                            }
                            else
                            {
                                result = null;
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
            return(result);
        }
Example #3
0
        /// <summary>
        /// The change to delivery
        /// Author: ThanhDT
        /// Created date: 8/11/2020 5:06 PM
        /// </summary>
        /// <param name="order">The order.</param>
        /// <returns></returns>
        /// <exception cref="System.Exception"></exception>
        public int ChangeToDelivery(Entities.Order order)
        {
            string storeName = "admin_order_change_to_delivery";

            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeName, true))
                    {
                        command.Parameters.Add(NpgsqlParameter("@_order_id", order.order_id));
                        //command.Parameters.Add(NpgsqlParameter("@_status", order.status));
                        command.Parameters.Add(NpgsqlParameter("@_delivery_status", order.delivery_status));
                        command.Parameters.Add(NpgsqlParameter("@_delivery_order_id", order.delivery_order_id, NpgsqlDbType.Varchar));
                        command.Parameters.Add(NpgsqlParameter("@_delivery_price", order.delivery_price));
                        command.Parameters.Add(NpgsqlParameter("@_delivery_estimate_time", order.delivery_estimate_time));
                        command.Parameters.Add(NpgsqlParameter("@_reason_note", order.reason_note, NpgsqlDbType.Varchar));
                        return((int)command.ExecuteScalar());
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
        }
Example #4
0
        public IEnumerable <Entities.Order> GetListToDelivery(short status, int limit)
        {
            string storeName = "service_order_get_list_to_delivery";
            var    lisOrders = new List <Entities.Order>();

            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeName, true))
                    {
                        command.Parameters.Add(NpgsqlParameter("@_status", status));
                        command.Parameters.Add(NpgsqlParameter("@_limit", limit));
                        using (var reader = command.ExecuteReader())
                        {
                            if (reader.HasRows)
                            {
                                while (reader.Read())
                                {
                                    var obj = new Entities.Order();
                                    EntityBase.SetObjectValue(reader, ref obj);
                                    lisOrders.Add(obj);
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
            return(lisOrders);
        }
Example #5
0
        public IEnumerable <Entities.OrderCount> CountOrder()
        {
            string storeName = "admin_order_count";
            var    lisOrders = new List <Entities.OrderCount>();

            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeName, true))
                    {
                        using (var reader = command.ExecuteReader())
                        {
                            if (reader.HasRows)
                            {
                                while (reader.Read())
                                {
                                    var obj = new Entities.OrderCount();
                                    EntityBase.SetObjectValue(reader, ref obj);
                                    lisOrders.Add(obj);
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
            return(lisOrders);
        }
Example #6
0
        public IEnumerable <CustomerAddress> SearchCustomerByPhone(string keyword)
        {
            string storeName    = "admin_customer_addres_getbykeyword";
            var    lisCustomers = new List <Entities.CustomerAddress>();

            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeName, true))
                    {
                        command.Parameters.Add(NpgsqlParameter("@_keyword", keyword));
                        using (var reader = command.ExecuteReader())
                        {
                            if (reader.HasRows)
                            {
                                while (reader.Read())
                                {
                                    var obj = new Entities.CustomerAddress();
                                    EntityBase.SetObjectValue(reader, ref obj);
                                    lisCustomers.Add(obj);
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
            return(lisCustomers);
        }
Example #7
0
        public IEnumerable <Entities.Ward> GetAll()
        {
            List <Entities.Ward> listWard = new List <Entities.Ward>();
            string storeName = "admin_ward_getall";

            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeName, true))
                    {
                        using (var reader = command.ExecuteReader())
                        {
                            if (reader.HasRows)
                            {
                                while (reader.Read())
                                {
                                    var obj = new Entities.Ward();
                                    EntityBase.SetObjectValue(reader, ref obj);
                                    listWard.Add(obj);
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
            return(listWard);
        }
Example #8
0
        public IEnumerable <OrderDetailViewModel> GetAllByOrderId(int id)
        {
            string storeName      = "admin_orderdetail_getallbyorderid";
            var    lisOrderDetail = new List <OrderDetailViewModel>();

            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeName, true))
                    {
                        command.Parameters.Add(NpgsqlParameter("@_id", id));

                        using (var reader = command.ExecuteReader())
                        {
                            if (reader.HasRows)
                            {
                                while (reader.Read())
                                {
                                    var obj = new OrderDetailViewModel();
                                    EntityBase.SetObjectValue(reader, ref obj);
                                    lisOrderDetail.Add(obj);
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
            return(lisOrderDetail);
        }
Example #9
0
        public IEnumerable <Entities.OrderDetail> GetList(short status, DateTime fromCreatedDate, DateTime toCreatedDate)
        {
            string storeName = "admin_orderdetail_getlist_statistic";
            var    lisOrders = new List <Entities.OrderDetail>();

            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeName, true))
                    {
                        command.Parameters.Add(NpgsqlParameter("@_status", status));
                        command.Parameters.Add(NpgsqlParameter("@_fromcreateddate", fromCreatedDate));
                        command.Parameters.Add(NpgsqlParameter("@_tocreateddate", toCreatedDate));
                        using (var reader = command.ExecuteReader())
                        {
                            if (reader.HasRows)
                            {
                                while (reader.Read())
                                {
                                    var obj = new Entities.OrderDetail();
                                    EntityBase.SetObjectValue(reader, ref obj);
                                    lisOrders.Add(obj);
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
            return(lisOrders);
        }
Example #10
0
        public Entities.Account GetByEmail(string email)
        {
            string storeName = "Admin_Account_GetByEmail";

            Entities.Account result = new Entities.Account();
            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeName, true))
                    {
                        command.Parameters.Add(NpgsqlParameter("@_email", email));
                        using (var reader = command.ExecuteReader())
                        {
                            if (reader.HasRows)
                            {
                                reader.Read();
                                EntityBase.SetObjectValue(reader, ref result);
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
            return(result);
        }
Example #11
0
        public int Insert(Entities.OrderHistory obj)
        {
            string storeName = "admin_order_histories_insert";

            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeName, true))
                    {
                        command.Parameters.Add(NpgsqlParameter("@_order_id", obj.order_id));
                        command.Parameters.Add(NpgsqlParameter("@_created_by", obj.created_by));
                        command.Parameters.Add(NpgsqlParameter("@_change_log", obj.change_log));
                        command.Parameters.Add(NpgsqlParameter("@_status", obj.status));
                        command.Parameters.Add(NpgsqlParameter("@_delivery_status", obj.delivery_status));
                        command.Parameters.Add(NpgsqlParameter("@_request_type", obj.request_type));
                        return((int)command.ExecuteScalar());
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
        }
Example #12
0
        public int UpdateStatus(int order_id, short status, short requestType, string updatedBy, string reasonNote, string cashierReceive = "", string cashierRefund = "")
        {
            string storeName = "admin_order_updatestatus";

            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeName, true))
                    {
                        command.Parameters.Add(NpgsqlParameter("@_order_id", order_id));
                        command.Parameters.Add(NpgsqlParameter("@_status", status));
                        command.Parameters.Add(NpgsqlParameter("@_request_type", requestType));
                        command.Parameters.Add(NpgsqlParameter("@_reason_note", reasonNote));
                        command.Parameters.Add(NpgsqlParameter("@_cashier_receive", cashierReceive));
                        command.Parameters.Add(NpgsqlParameter("@_cashier_refund", cashierRefund));
                        command.Parameters.Add(NpgsqlParameter("@_modified_by", updatedBy));
                        return((int)command.ExecuteScalar());
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
        }
Example #13
0
        public IEnumerable <Entities.Account> GetList(string keyword, out int totalRows, int UserType = 0, int?pageIndex = 1, int?pageSize = 15)
        {
            totalRows = 0;
            string storeName      = "Admin_Account_GetList";
            string storeNameCount = "Admin_Account_GetList_Count";
            var    lst            = new List <Entities.Account>();

            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeName, true))
                    {
                        command.Parameters.Add(NpgsqlParameter("@_keyword", keyword));
                        command.Parameters.Add(NpgsqlParameter("@_userType", UserType));
                        command.Parameters.Add(NpgsqlParameter("@_pageindex", pageIndex));
                        command.Parameters.Add(NpgsqlParameter("@_pagesize", pageSize));
                        using (var reader = command.ExecuteReader())
                        {
                            if (reader.HasRows)
                            {
                                while (reader.Read())
                                {
                                    var obj = new Entities.Account();
                                    EntityBase.SetObjectValue(reader, ref obj);
                                    lst.Add(obj);
                                }
                            }
                        }
                    }

                    using (var command = db.CreateCommand(storeNameCount, true))
                    {
                        command.Parameters.Add(NpgsqlParameter("@_keyword", keyword));
                        command.Parameters.Add(NpgsqlParameter("@_userType", UserType));
                        totalRows = (int)command.ExecuteScalar();
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
            return(lst);
        }
Example #14
0
        public int Insert(Entities.Account obj)
        {
            string storeName = "Admin_Account_Insert";

            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeName, true))
                    {
                        var now = DateTime.Now;
                        command.Parameters.Add(NpgsqlParameter("@_username", obj.UserName));
                        command.Parameters.Add(NpgsqlParameter("@_displayname", obj.DisplayName));
                        command.Parameters.Add(NpgsqlParameter("@_fullname", obj.FullName));
                        command.Parameters.Add(NpgsqlParameter("@_email", obj.Email));
                        command.Parameters.Add(NpgsqlParameter("@_phone", obj.Phone));
                        command.Parameters.Add(NpgsqlParameter("@_birthday", obj.Birthday));
                        command.Parameters.Add(NpgsqlParameter("@_gender", obj.Gender));
                        command.Parameters.Add(NpgsqlParameter("@_address", obj.Address));
                        command.Parameters.Add(NpgsqlParameter("@_desciption", obj.Desciption));
                        command.Parameters.Add(NpgsqlParameter("@_avatar", obj.Avatar));
                        command.Parameters.Add(NpgsqlParameter("@_createddate", now));
                        command.Parameters.Add(NpgsqlParameter("@_lastmodifieddate", now));
                        command.Parameters.Add(NpgsqlParameter("@_lastlogin", now));
                        command.Parameters.Add(NpgsqlParameter("@_lastpasswordchange", now));
                        command.Parameters.Add(NpgsqlParameter("@_status", obj.Status));
                        command.Parameters.Add(NpgsqlParameter("@_createdby", obj.CreatedBy));
                        command.Parameters.Add(NpgsqlParameter("@_lastmodifiedby", obj.LastModifiedBy));
                        command.Parameters.Add(NpgsqlParameter("@_password", obj.Password));
                        command.Parameters.Add(NpgsqlParameter("@_passwordquestion", obj.PasswordQuestion));
                        command.Parameters.Add(NpgsqlParameter("@_passwordanswer", obj.PasswordAnswer));
                        command.Parameters.Add(NpgsqlParameter("@_userType", obj.UserType));
                        return((int)command.ExecuteScalar());
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
        }
Example #15
0
        public int UpdateDeliveryPrice(int orderId, string user, int deliveryPrice, short deliveryStatus)
        {
            string storeName = "admin_order_update_delivery_price";

            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeName, true))
                    {
                        command.Parameters.Add(NpgsqlParameter("@_order_id", orderId));
                        command.Parameters.Add(NpgsqlParameter("@_modified_by", user));
                        command.Parameters.Add(NpgsqlParameter("@_delivery_price", deliveryPrice));
                        command.Parameters.Add(NpgsqlParameter("@_delivery_status", deliveryStatus));
                        return((int)command.ExecuteScalar());
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
        }
Example #16
0
        public int CreateOrder(OrderFullViewModel order)
        {
            string storeName            = "admin_order_insert_v1";
            string storeNameOrderDetail = "admin_orderdetail_insert";
            int    order_id             = 0;

            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    db.BeginTransaction();

                    try
                    {
                        using (var command = db.CreateCommand(storeName, true))
                        {
                            command.Parameters.Add(NpgsqlParameter("@_code", order.Code));
                            command.Parameters.Add(NpgsqlParameter("@_order_code", order.OrderCode));
                            command.Parameters.Add(NpgsqlParameter("@_customer_name", order.CustomerName));
                            command.Parameters.Add(NpgsqlParameter("@_city_code", order.CityCode));
                            command.Parameters.Add(NpgsqlParameter("@_district_id", order.DistrictId));
                            command.Parameters.Add(NpgsqlParameter("@_ward_id", order.WardId));
                            command.Parameters.Add(NpgsqlParameter("@_delivery_address", order.DeliveryAddress));
                            command.Parameters.Add(NpgsqlParameter("@_customer_phone", order.CustomerPhone));
                            command.Parameters.Add(NpgsqlParameter("@_customer_note", order.CustomerNote));
                            command.Parameters.Add(NpgsqlParameter("@_created_date", DateTime.Now));
                            command.Parameters.Add(NpgsqlParameter("@_modified_date", DateTime.Now));
                            command.Parameters.Add(NpgsqlParameter("@_created_by", order.CreatedBy));
                            command.Parameters.Add(NpgsqlParameter("@_modified_by", order.ModifiedBy));
                            command.Parameters.Add(NpgsqlParameter("@_reason_note", string.Empty));
                            command.Parameters.Add(NpgsqlParameter("@_origin_price", order.OrderOriginPrice));
                            command.Parameters.Add(NpgsqlParameter("@_price", order.OrderPrice));
                            command.Parameters.Add(NpgsqlParameter("@_status", order.Status));
                            command.Parameters.Add(NpgsqlParameter("@_ship_fee", order.ShipFee));
                            command.Parameters.Add(NpgsqlParameter("@_request_type", order.RequestType));
                            command.Parameters.Add(NpgsqlParameter("@_order_type", order.OrderType));
                            if (order.DeliverDate <= DateTime.Now)
                            {
                                command.Parameters.Add(NpgsqlParameter("@_delivery_date", DBNull.Value));
                            }
                            else
                            {
                                command.Parameters.Add(NpgsqlParameter("@_delivery_date", order.DeliverDate));
                            }
                            command.Parameters.Add(NpgsqlParameter("@_source_type", order.SourceType));

                            order_id = (int)command.ExecuteScalar();
                        }

                        if (order_id > 0)
                        {
                            foreach (OrderDetailViewModel item in order.ListProductViewModel)
                            {
                                using (var command = db.CreateCommand(storeNameOrderDetail, true))
                                {
                                    command.Parameters.Add(NpgsqlParameter("@_order_id", order_id));
                                    command.Parameters.Add(NpgsqlParameter("@_product_id", item.ProductId));
                                    command.Parameters.Add(NpgsqlParameter("@_quantity", item.Quantity));
                                    command.Parameters.Add(NpgsqlParameter("@_origin_price", item.OriginPrice));
                                    command.Parameters.Add(NpgsqlParameter("@_price", item.Price));
                                    command.Parameters.Add(NpgsqlParameter("@_created_date", DateTime.Now));
                                    command.Parameters.Add(NpgsqlParameter("@_created_by", order.CreatedBy));
                                    command.Parameters.Add(NpgsqlParameter("@_note", item.Note));
                                    command.ExecuteScalar();
                                }
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        db.RollbackTransaction();
                        throw ex;
                    }

                    if (order_id > 0)
                    {
                        db.CommitTransaction();
                    }
                    else
                    {
                        db.RollbackTransaction();
                    }

                    return(order_id);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
        }
Example #17
0
        public IEnumerable <Entities.Order> GetList(string keyword, short status, short sourceType, short deliveryStatus, short orderType, DateTime?fromCreatedDate, DateTime?toCreatedDate, short requestType, out int totalRows, int?pageIndex = 1, int?pageSize = 15)
        {
            totalRows = 0;
            string storeName      = "admin_order_getlist_20200824";
            string storeNameCount = "admin_order_getlist_count_v1";
            var    lisOrders      = new List <Entities.Order>();

            try
            {
                using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
                {
                    using (var command = db.CreateCommand(storeNameCount, true))
                    {
                        command.Parameters.Add(NpgsqlParameter("@_keyword", keyword + ""));
                        command.Parameters.Add(NpgsqlParameter("@_status", status));
                        command.Parameters.Add(NpgsqlParameter("@_sourcetype", sourceType));
                        command.Parameters.Add(NpgsqlParameter("@_deliverystatus", deliveryStatus));
                        command.Parameters.Add(NpgsqlParameter("@_ordertype", orderType));
                        command.Parameters.Add(NpgsqlParameter("@_requesttype", requestType));
                        if (fromCreatedDate == null)
                        {
                            command.Parameters.Add(new NpgsqlParameter("@_fromcreateddate", DBNull.Value));
                        }
                        else
                        {
                            command.Parameters.Add(new NpgsqlParameter("@_fromcreateddate", fromCreatedDate.Value));
                        }
                        if (toCreatedDate == null)
                        {
                            command.Parameters.Add(new NpgsqlParameter("@_tocreateddate", DBNull.Value));
                        }
                        else
                        {
                            command.Parameters.Add(new NpgsqlParameter("@_tocreateddate", toCreatedDate.Value));
                        }
                        totalRows = (int)command.ExecuteScalar();
                    }

                    if (totalRows > 0)
                    {
                        using (var command = db.CreateCommand(storeName, true))
                        {
                            command.Parameters.Add(NpgsqlParameter("@_keyword", keyword + ""));
                            command.Parameters.Add(NpgsqlParameter("@_status", status));
                            command.Parameters.Add(NpgsqlParameter("@_sourcetype", sourceType));
                            command.Parameters.Add(NpgsqlParameter("@_deliverystatus", deliveryStatus));
                            command.Parameters.Add(NpgsqlParameter("@_ordertype", orderType));
                            command.Parameters.Add(NpgsqlParameter("@_requesttype", requestType));
                            if (fromCreatedDate == null)
                            {
                                command.Parameters.Add(new NpgsqlParameter("@_fromcreateddate", DBNull.Value));
                            }
                            else
                            {
                                command.Parameters.Add(new NpgsqlParameter("@_fromcreateddate", fromCreatedDate.Value));
                            }
                            if (toCreatedDate == null)
                            {
                                command.Parameters.Add(new NpgsqlParameter("@_tocreateddate", DBNull.Value));
                            }
                            else
                            {
                                command.Parameters.Add(new NpgsqlParameter("@_tocreateddate", toCreatedDate.Value));
                            }
                            command.Parameters.Add(NpgsqlParameter("@_pageindex", pageIndex));
                            command.Parameters.Add(NpgsqlParameter("@_pagesize", pageSize));
                            using (var reader = command.ExecuteReader())
                            {
                                if (reader.HasRows)
                                {
                                    while (reader.Read())
                                    {
                                        var obj = new Entities.Order();
                                        EntityBase.SetObjectValue(reader, ref obj);
                                        lisOrders.Add(obj);
                                    }
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
            }
            return(lisOrders);
        }