public ActionResult Edit(DistrictVM viewModel)
{
try
{
// TODO: Add update logic here
if (ModelState.IsValid)
{
Entities.District entity = new Entities.District();
entity.DistrictId = viewModel.DistrictId;
entity.StateId = viewModel.StateId;
entity.DistrictName = viewModel.DistrictName;
entity.Status = viewModel.Status;
entity.Remark = viewModel.Remark;
DistrictBAL balObject = new DistrictBAL();
balObject.Edit(entity);
return(RedirectToAction("Index"));
}
else
{
// AcademicYearBAL academicYearBAL = new AcademicYearBAL();
// viewModel.AcademicYears = from obj in academicYearBAL.GetAll() select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() };
return(View(viewModel));
}
}
catch
{
// AcademicYearBAL academicYearBAL = new AcademicYearBAL();
// viewModel.AcademicYears = from obj in academicYearBAL.GetAll() select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() };
return(View());
}
}
public IEnumerable <Entities.District> GetAll()
{
List <Entities.District> listDistrict = new List <Entities.District>();
string storeName = "admin_district_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.District();
EntityBase.SetObjectValue(reader, ref obj);
listDistrict.Add(obj);
}
}
}
}
}
}
catch (Exception ex)
{
throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
}
return(listDistrict);
}
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.District GetById(int id)
{
Entities.District district = new Entities.District();
List <Entities.District> list = new List <Entities.District>();
try
{
list = (List <Entities.District>)_districtDal.GetAll();
district = (Entities.District)list.Select(m => m.district_id == id);
}
catch (Exception ex)
{
Logger.WriteLog(Logger.LogType.Error, ex.ToString());
}
return(district);
}
//
// GET: /SysAdmin/District/Details/5
public ActionResult Details(int id)
{
DistrictVM viewModel = new DistrictVM();
DistrictBAL balObject = new DistrictBAL();
IQueryable <Entities.District> entites = balObject.FindBy(a => a.DistrictId == id);
if (entites != null && entites.Count() > 0)
{
Entities.District entity = entites.FirstOrDefault();
viewModel.DistrictId = entity.DistrictId;
viewModel.DistrictName = entity.DistrictName;
StateBAL stateBAL = new StateBAL();
IQueryable <Entities.State> states = stateBAL.GetAll();
viewModel.StateName = stateBAL.FindBy(c => c.StateId == entity.StateId).FirstOrDefault().StateName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
}
return(View(viewModel));
}
//
// GET: /SysAdmin/District/Edit/5
public ActionResult Edit(int id)
{
DistrictVM viewModel = new DistrictVM();
DistrictBAL balObject = new DistrictBAL();
IQueryable <Entities.District> entites = balObject.FindBy(a => a.DistrictId == id);
if (entites != null && entites.Count() > 0)
{
Entities.District entity = entites.FirstOrDefault();
viewModel.DistrictId = entity.DistrictId;
viewModel.DistrictName = entity.DistrictName;
viewModel.StateId = entity.StateId;
viewModel.StateName = entity.StateName;
viewModel.CountryName = entity.CountryName;
viewModel.CountryId = entity.CountryId;
viewModel.StateName = entity.StateName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
}
return(View(viewModel));
}
