//Get By Id
public static BarangViewModel ById(int id)
{
BarangViewModel result = new BarangViewModel();
using (var db = new Context())
{
result = (from c in db.Barangs
//join d in db.Barangs on c.kode_barang equals d.kode_barang
//join e in db.Penjualans on c.no_nota equals e.no_nota
where c.barang_id == id
select new BarangViewModel
{
barang_id = c.barang_id,
kode_barang = c.kode_barang,
nama_barang = c.nama_barang,
satuan = c.satuan,
stock = c.stock,
harga = c.harga,
created_at = c.created_at,
created_by = c.created_by,
modified_at = c.modified_at,
modified_by = c.modified_by,
is_delete = c.is_delete,
deleted_at = c.deleted_at,
deleted_by = c.deleted_by
}).FirstOrDefault();
}
return(result != null ? result : new BarangViewModel());
}
// GET: Barang/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var barang = _db.Barangs.Find(id);
if (barang == null)
{
return(HttpNotFound());
}
var model = new BarangViewModel
{
Kode = barang.Kode,
Harga = barang.Harga,
Nama = barang.Nama,
KodeTipeCuci = barang.KodeTipeCuci
};
ViewBag.KodeTipeCuci = new SelectList(_db.TipeCucis, "Kode", "Tipe", barang.KodeTipeCuci);
return(View(model));
}
public ActionResult Edit(int id)
{
ViewBag.SupplierList = new SelectList(SupplierRepo.GetAll(), "Id", "Nama");
BarangViewModel model = BarangRepo.GetById(id);
return(PartialView(model));
}
public ActionResult Index(string nama = null)
{
var viewModel = new BarangViewModel();
var AllBarangs = barangProvider.GetListBarangViewModel(nama);
return(View(AllBarangs));
}
public BarangForm(BarangViewModel vm)
{
InitializeComponent();
if (vm.ModelBarang == null)
{
vm.ModelBarang = new Barang();
}
DataContext = vm;
}
public BarangResponse()
{
ListModel = new List <BarangViewModel>();
Model = new BarangViewModel();
LowestAsks = new List <Car>();
HighestBids = new List <Car>();
ListNormal = new List <Car>();
CarDetail = new CarDetail();
RelatedProducts = new List <Car>();
}
public TampilBarangPage()
{
InitializeComponent();
barangViewModel = new BarangViewModel();
BindingContext = barangViewModel;
btnTambah.Clicked += BtnTambah_Clicked;
listBarang.ItemTapped += ListBarang_ItemTapped;
}
//Create dan Edit
public static bool Update(BarangViewModel model)
{
bool result = true;
try
{
using (var db = new PosContext())
{
if (model.Id == 0)
{
Barang barang = new Barang();
barang.Id = model.Id;
barang.Code = model.Code;
//barang.IdSupplier = model.IdSupplier;
barang.Deskripsi = model.Deskripsi;
//barang.Harga = model.Harga;
//barang.Stok = model.Stok;
barang.IsActivated = model.IsActivated;
barang.CreatedBy = "Arief";
barang.CreatedDate = DateTime.Now;
db.Mst_Barangs.Add(barang);
db.SaveChanges();
}
else
{
Barang barang = db.Mst_Barangs.Where(d => d.Id == model.Id).FirstOrDefault();
if (barang != null)
{
barang.Code = model.Code;
//barang.IdSupplier = model.IdSupplier;
barang.Deskripsi = model.Deskripsi;
//barang.Harga = model.Harga;
//barang.Stok = model.Stok;
barang.IsActivated = model.IsActivated;
barang.ModifiedBy = "Arief";
barang.ModifiedDate = DateTime.Now;
db.SaveChanges();
}
}
}
}
catch (Exception ex)
{
result = false;
Message = ex.Message;
}
return(result);
}
public BarangViewModel GetBarangViewModel(int ID)
{
var selectedBarang = GetBarang(ID);
var viewModel = new BarangViewModel()
{
ID = selectedBarang.ID,
Nama = selectedBarang.Nama,
Lokasi = "Rak " + selectedBarang.Lokasi.NomorRak + ", Bay " + selectedBarang.Lokasi.NomorBay,
HargaBeli = selectedBarang.HargaBeli,
HargaJual = selectedBarang.HargaJual
};
return(viewModel);
}
public BarangView()
{
InitializeComponent();
vm = new BarangViewModel();
vm.OnReload += () =>
{
LstData.ItemsSource = null;
LstData.ItemsSource = vm.DataBarang;
if (form != null)
{
form.Close();
}
vm.ModelBarang = null;
};
DataContext = vm;
}
public ActionResult Edit(BarangViewModel model)
{
if (ModelState.IsValid)
{
if (BarangRepo.Update(model))
{
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = BarangRepo.Message }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { success = false, message = "Invalid" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Create(BarangViewModel model)
{
if (!ModelState.IsValid)
{
ViewBag.KodeTipeCuci = new SelectList(_db.TipeCucis, "Kode", "Tipe", model.KodeTipeCuci);
return(View(model));
}
var barang = new Barang
{
Harga = model.Harga,
Nama = model.Nama,
KodeTipeCuci = model.KodeTipeCuci
};
_db.Barangs.Add(barang);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public static BarangViewModel GetById(int id)
{
BarangViewModel result = new BarangViewModel();
using (var db = new PosContext())
{
result = (from brg in db.Mst_Barangs
//join sup in db.Mst_Suppliers
//on brg.IdSupplier equals sup.Id
select new BarangViewModel
{
Id = brg.Id,
Code = brg.Code,
//IdSupplier=brg.IdSupplier,
//NamaSupplier = sup.Nama,
Deskripsi = brg.Deskripsi,
//Harga=brg.Harga,
//Stok=brg.Stok,
IsActivated = brg.IsActivated
}).FirstOrDefault();
}
return(result);
}
public ActionResult Edit(BarangViewModel model)
{
if (!ModelState.IsValid)
{
ViewBag.KodeTipeCuci = new SelectList(_db.TipeCucis, "Kode", "Tipe", model.KodeTipeCuci);
return(View(model));
}
var barang = new Barang
{
Kode = model.Kode,
Harga = model.Harga,
Nama = model.Nama,
KodeTipeCuci = model.KodeTipeCuci
};
_db.Entry(barang).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index"));
}
//Create New & Edit
public static ResponseResult Update(BarangViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new Context())
{
#region Create New / Insert
if (entity.barang_id == 0)
{
Barang barang = new Barang();
barang.barang_id = entity.barang_id;
barang.kode_barang = entity.kode_barang;
barang.nama_barang = entity.nama_barang;
barang.satuan = entity.satuan;
barang.stock = entity.stock;
barang.harga = entity.harga;
barang.created_at = DateTime.Now;
barang.created_by = 123;
db.Barangs.Add(barang);
db.SaveChanges();
result.Entity = entity;
}
#endregion
//Edit
//Create New / Insert
#region Edit
else
{
Barang barang = db.Barangs
.Where(o => o.barang_id == entity.barang_id).FirstOrDefault();
if (barang != null)
{
barang.barang_id = entity.barang_id;
barang.kode_barang = entity.kode_barang;
barang.nama_barang = entity.nama_barang;
barang.satuan = entity.satuan;
barang.stock = entity.stock;
barang.harga = entity.harga;
barang.modified_at = DateTime.Now;
barang.modified_by = 123;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Data not found!";
}
}
#endregion
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
