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);
}
public OrderFullViewModel(Entities.Order order, Entities.District district, Entities.Ward ward, List <OrderDetailViewModel> lstOrderDetail)
{
OrderId = order.order_id;
Code = order.code;
CustomerName = order.customer_name;
CityCode = order.city_code;
DistrictId = order.district_id;
if (district != null)
{
DistrictName = district.district_name;
}
WardId = order.ward_id;
if (ward != null)
{
WardName = ward.ward_name;
}
DeliveryAddress = order.delivery_address;
CustomerPhone = order.customer_phone;
CustomerNote = order.customer_note;
OrderType = order.order_type;
OrderTypeName = Utils.GetEnumDescription((OrderTypeEnum)order.order_type);
SourceType = order.source_type;
SourceTypeName = Utils.GetEnumDescription((SourceTypeEnum)order.source_type);
RequestType = order.request_type;
RequestTypeName = Utils.GetEnumDescription((RequestTypeEnum)order.request_type);
OrderPrice = order.price;
OrderOriginPrice = order.origin_price;
OrderPriceStr = StringUtils.ConvertNumberToCurrency(OrderPrice);
OrderOriginPriceStr = StringUtils.ConvertNumberToCurrency(OrderOriginPrice);
DeliveryStatusStr = Utils.GetEnumDescription((DeliveryStatus)(order.delivery_status));
CreatedBy = order.created_by;
ModifiedBy = order.modified_by;
ReasonNote = order.reason_note;
Status = order.status;
StatusStr = Utils.GetEnumDescription((OrderStatusEnum)(order.status));
ShipFee = order.ship_fee;
ShipFeeStr = StringUtils.ConvertNumberToCurrency(ShipFee);
CreatedDateStr = order.created_date.ToString("dd/MM/yyyy HH:mm:ss");
ModifiedDateStr = order.modified_date.ToString("dd/MM/yyyy HH:mm:ss");
CashierReceive = order.cashier_receive;
CashierRefund = order.cashier_refund;
//if (lstOrderDetail != null && lstOrderDetail.Count > 0)
// this.lstOrderDetailViewModel = lstOrderDetail;
if (order.delivery_date != DateTime.MinValue && order.delivery_date != null)
{
DeliverDate = order.delivery_date.Value;
DeliveryDateStr = order.delivery_date.Value.ToString("dd/MM/yyyy HH:mm:ss");
}
else
{
DeliveryDateStr = "Giao ngay";
}
this.ListSourceType = EnumHelper.Instance.ConvertEnumToList <SourceTypeEnum>().ToList();
this.ListOrderType = EnumHelper.Instance.ConvertEnumToList <OrderTypeEnum>().ToList();
this.Discount = DVG.WIS.Utilities.AppSettings.Instance.GetString("DiscountValuePercent").ToInt() / 100 * this.OrderOriginPrice;
this.DiscountStr = StringUtils.ConvertNumberToCurrency(this.Discount);
}
public Entities.Ward GetById(int id)
{
Entities.Ward ward = new Entities.Ward();
List <Entities.Ward> list = new List <Entities.Ward>();
try
{
list = (List <Entities.Ward>)_wardDal.GetAll();
ward = (Entities.Ward)list.Select(m => m.ward_id == id);
}
catch (Exception ex)
{
Logger.WriteLog(Logger.LogType.Error, ex.ToString());
}
return(ward);
}
