private void ShouldReturnSuccessForDelete()
{
var operationSecceded = false;
var dataAccessJsonStr = string.Empty;
var formattedJsonStr = string.Empty;
try
{
var model = new BarangModel()
{
id = 11,
};
_services.Delete(model);
operationSecceded = true;
}
catch (DataAccessException ex)
{
operationSecceded = ex.DataAccessStatusInfo.OperationSucceeded;
dataAccessJsonStr = JsonConvert.SerializeObject(ex.DataAccessStatusInfo);
formattedJsonStr = JToken.Parse(dataAccessJsonStr).ToString();
}
try
{
Assert.True(operationSecceded);
_testOutputHelper.WriteLine("Data berhasil dihapus.");
}
finally
{
_testOutputHelper.WriteLine(formattedJsonStr);
}
}
private void OperationButtons_OnSaveButtonClick(object sender, EventArgs e)
{
var model = new BarangModel
{
tipe_id = comboBoxTipe.SelectedItem.id,
nama = textBoxNama.Text,
stok_akhir = int.Parse(textBoxStokAkhir.Text),
keterangan = textBoxKeterangan.Text
};
var modelArgs = new ModelEventArgs <BarangModel>(model);
if (_isNewData)
{
if (Messages.ConfirmSave(_typeName))
{
OnSaveData?.Invoke(this, modelArgs);
}
}
else if (Messages.ConfirmUpdate(_typeName))
{
model.id = _model.id;
OnSaveData?.Invoke(this, modelArgs);
}
}
public BarangModel GetById(int id)
{
BarangModel model = null;
var dataAccessStatus = new DataAccessStatus();
try
{
model = _context.Conn.Get <BarangModel>(id);
}
catch (SQLiteException ex)
{
dataAccessStatus.SetValues(status: "Error", operationSucceeded: false, exceptionMessage: ex.Message,
customMessage: "Tidak dapat mengambil data barang yang sesuai dengan permintaan id.",
helpLink: ex.HelpLink, errorCode: ex.ErrorCode, stackTrace: ex.StackTrace);
throw new DataAccessException(message: ex.Message, innerException: ex.InnerException,
dataAccessStatus: dataAccessStatus);
}
if (model == null)
{
dataAccessStatus.SetValues(status: "Error", operationSucceeded: false, exceptionMessage: "",
customMessage: "Data tidak ditemukan. " +
$"Tidak dapat mengambil data barang yang sesuai dengan permintaan id {id}. " +
$"ID {id} tidak ada di database.",
helpLink: "", errorCode: 0, stackTrace: "");
throw new DataAccessException(dataAccessStatus: dataAccessStatus);
}
return(model);
}
private void ShouldReturnErrorDuplicateNamaInsert()
{
var dataAccessJsonStr = string.Empty;
var formattedJsonStr = string.Empty;
try
{
var model = new BarangModel()
{
id = 1,
tipe_id = 1,
nama = "Nama Barang #2"
};
_services.Insert(model);
}
catch (DataAccessException ex)
{
dataAccessJsonStr = JsonConvert.SerializeObject(ex.DataAccessStatusInfo);
formattedJsonStr = JToken.Parse(dataAccessJsonStr).ToString();
}
finally
{
_testOutputHelper.WriteLine(formattedJsonStr);
}
}
private void OperationButtons_OnSaveButtonClick(object sender, EventArgs e)
{
var model = new BarangModel
{
tipe_id = comboBoxTipe.SelectedItem.id,
sub_tipe_id = comboBoxSubTipe.SelectedItem.id,
supplier_id = comboBoxSupplier.SelectedItem.id,
kode = textBoxKode.Text,
nama = textBoxNama.Text,
hpp = decimal.Parse(textBoxHpp.Text, NumberStyles.Number),
harga_jual = decimal.Parse(textBoxHargaJual.Text, NumberStyles.Number),
harga_lama = decimal.Parse(textBoxHargaLama.Text, NumberStyles.Number),
stok = int.Parse(textBoxStok.Text, NumberStyles.Number),
minimal_stok = int.Parse(textBoxMinStok.Text, NumberStyles.Number),
Satuan = comboBoxSatuan.SelectedItem
};
var modelArgs = new ModelEventArgs <BarangModel>(model);
if (_isNewData)
{
if (Messages.ConfirmSave(_typeName))
{
OnSaveData?.Invoke(this, modelArgs);
}
}
else if (Messages.ConfirmUpdate(_typeName))
{
model.id = _model.id;
OnSaveData?.Invoke(this, modelArgs);
}
}
public ActionResult Update(BarangModel barangModel)
{
if (BarangRepoo.Editbarang(barangModel))
{
return(Json(new { Gantidata = "Berhasil" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Gantidata = "Gagal" }, JsonRequestBehavior.AllowGet));
}
return(View());
}
public ActionResult Save(BarangModel barangModel)
{
if (BarangRepoo.Createbarang(barangModel))
{
return(Json(new { Simpan = "Berhasil" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Simpan = "Gagal" }, JsonRequestBehavior.AllowGet));
}
return(View());
}
public ActionResult SaveEdit(BarangModel editConfirm)
{
BarangRepo saveEdit = new BarangRepo();
editConfirm.updateByDate = DateTime.Now;
editConfirm.updatedBy = Session["name"].ToString();
if (saveEdit.SaveEdit(editConfirm))
{
return(Json(new { status = "berhasil" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = "gagal" }, JsonRequestBehavior.AllowGet));
}
return(View());
}
public ActionResult SaveItem(BarangModel inputBarang)
{
BarangRepo saveData = new BarangRepo();
inputBarang.createdBy = Session["name"].ToString();
inputBarang.created = DateTime.Now;
if (saveData.Save(inputBarang))
{
return(Json(new { status = "berhasil" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = "gagal" }, JsonRequestBehavior.AllowGet));
}
return(View());
}
public bool Save(BarangModel getData)
{
try
{
using (DataContext inputData = new DataContext())
{
inputData.barangModel.Add(getData);
inputData.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
private void ShouldReturnSuccessForInsert()
{
var operationSecceded = false;
var dataAccessJsonStr = string.Empty;
var formattedJsonStr = string.Empty;
try
{
for (int i = 1; i <= 10; i++)
{
var model = new BarangModel
{
tipe_id = (uint)(i % 2 == 0 ? 2 : 1),
sub_tipe_id = (uint)(i % 2 == 0 ? 2 : 1),
supplier_id = (uint)(i % 2 == 0 ? 2 : 1),
satuan_id = (uint)(i % 2 == 0 ? 2 : 1),
kode = $"0000{i}",
nama = $"Nama Barang #{i}",
stok = 0,
hpp = 1000,
harga_jual = 2000,
minimal_stok = 0,
};
_services.Insert(model);
}
operationSecceded = true;
}
catch (DataAccessException ex)
{
operationSecceded = ex.DataAccessStatusInfo.OperationSucceeded;
dataAccessJsonStr = JsonConvert.SerializeObject(ex.DataAccessStatusInfo);
formattedJsonStr = JToken.Parse(dataAccessJsonStr).ToString();
}
try
{
Assert.True(operationSecceded);
_testOutputHelper.WriteLine("Data berhasil ditambahkan.");
}
finally
{
_testOutputHelper.WriteLine(formattedJsonStr);
}
}
public bool SaveEdit(BarangModel getData)
{
try
{
using (DataContext updateData = new DataContext())
{
updateData.Entry(getData).State = System.Data.Entity.EntityState.Modified;
updateData.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
var outputError = ex.ToString();
return(false);
}
}
public static Boolean Createbarang(BarangModel barangModel)
{
try
{
using (DataContext db = new DataContext())
{
db.BarangModel.Add(barangModel);
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
return(true);
}
public static Boolean Editbarang(BarangModel barangModel)
{
try
{
using (DataContext db = new DataContext())
{
db.Entry(barangModel).State = EntityState.Modified;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
// return true;
}
public ActionResult SaveBarang(BarangModel paimin)
{
Session["ID"] = "1";
//menggunakan return JSON
BarangRepo barangRepo = new BarangRepo();
paimin.CreatedBy = this.Session["ID"].ToString();
paimin.CreatedDate = DateTime.Now;
if (barangRepo.Save(paimin))
{
return(Json(new { status = "Berhasil" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = "Gagal" }, JsonRequestBehavior.AllowGet));
}
return(View());
}
public bool Save(BarangModel paijo)
{
try
{
using (DataContext dataContext = new DataContext())
{
dataContext.barangModel.Add(paijo);
dataContext.SaveChanges();
};
return(true);
}
catch (Exception)
{
//throw;
return(false);
}
//return true;
}
public bool SaveEdit(BarangModel terserah)
{
try
{
using (DataContext datacontext = new DataContext())
{
//datacontext.barangModel.
datacontext.Entry(terserah).State = System.Data.Entity.EntityState.Modified;
datacontext.SaveChanges();
}
return(true);
}
catch (Exception)
{
//Console.WriteLine(e);
return(false);
//throw;
}
}
public ActionResult SaveEditBarang(BarangModel terserah)
{
Session["ID"] = "1";
BarangRepo barangRepo = new BarangRepo();
terserah.CreatedBy = this.Session["ID"].ToString();
terserah.CreatedDate = DateTime.Now;
terserah.UpdatedDate = DateTime.Now;
//barangRepo.SaveEdit(terserah);
if (barangRepo.SaveEdit(terserah))
{
return(Json(new { status = "Berhasil" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = "Gagal" }, JsonRequestBehavior.AllowGet));
}
//return View();
}
private void ShouldReturnSuccessForInsert()
{
var operationSucceeded = false;
var dataAccessJsonStr = string.Empty;
var formattedJsonStr = string.Empty;
try
{
for (int i = 1; i <= 10; i++)
{
var model = new BarangModel
{
nama = $"Nama Barang #{i}",
tipe_id = (int)(i % 2 == 0 ? 2 : 1),
stok_akhir = 100,
keterangan = "Test"
};
_services.Insert(model);
}
operationSucceeded = true;
}
catch (DataAccessException ex)
{
operationSucceeded = ex.DataAccessStatusInfo.OperationSucceeded;
dataAccessJsonStr = JsonConvert.SerializeObject(ex.DataAccessStatusInfo);
formattedJsonStr = JToken.Parse(dataAccessJsonStr).ToString();
}
try
{
Assert.True(operationSucceeded);
_testOutputHelper.WriteLine("Data berhasil ditambahkan.");
}
finally
{
_testOutputHelper.WriteLine(formattedJsonStr);
}
}
public void ShouldReturnModelMatchingId()
{
BarangModel model = null;
var idToGet = 1;
try
{
model = (BarangModel)_services.GetById(idToGet);
}
catch (DataAccessException ex)
{
_testOutputHelper.WriteLine(ex.DataAccessStatusInfo.GetFormatedValues());
}
Assert.True(model != null);
Assert.True(model.id == idToGet);
if (model != null)
{
TestsHelper.WriteModel(_testOutputHelper, model);
}
}
private void ShouldReturnSuccessForUpdate()
{
var operationSecceded = false;
var dataAccessJsonStr = string.Empty;
var formattedJsonStr = string.Empty;
try
{
var model = new BarangModel
{
id = 1,
tipe_id = 1,
sub_tipe_id = 1,
supplier_id = 1,
kode = "kode_barang_1_Update_",
nama = "Nama Barang #1 (Update)"
};
_services.Update(model);
operationSecceded = true;
}
catch (DataAccessException ex)
{
operationSecceded = ex.DataAccessStatusInfo.OperationSucceeded;
dataAccessJsonStr = JsonConvert.SerializeObject(ex.DataAccessStatusInfo);
formattedJsonStr = JToken.Parse(dataAccessJsonStr).ToString();
}
try
{
Assert.True(operationSecceded);
_testOutputHelper.WriteLine("Data berhasil diubah.");
}
finally
{
_testOutputHelper.WriteLine(formattedJsonStr);
}
}
private void ShouldReturnSuccessForUpdate()
{
var barangModel = new BarangModel()
{
id = 1,
nama = "Barang #1",
stok = 48,
harga_pokok = 56250,
harga_jual = 75000
};
var operationSecceded = false;
var dataAccessJsonStr = string.Empty;
var formattedJsonStr = string.Empty;
try
{
_barangServices.Update(barangModel);
operationSecceded = true;
}
catch (DataAccessException ex)
{
operationSecceded = ex.DataAccessStatusInfo.OperationSucceeded;
dataAccessJsonStr = JsonConvert.SerializeObject(ex.DataAccessStatusInfo);
formattedJsonStr = JToken.Parse(dataAccessJsonStr).ToString();
}
try
{
Assert.True(operationSecceded);
_testOutputHelper.WriteLine("Data barang berhasil diubah.");
}
finally
{
_testOutputHelper.WriteLine(formattedJsonStr);
}
}
public void ShouldReturnBarangModelMatchingId()
{
BarangModel barangModel = null;
int idToGet = 1;
try
{
barangModel = _barangServices.GetById(idToGet);
}
catch (DataAccessException ex)
{
_testOutputHelper.WriteLine(ex.DataAccessStatusInfo.GetFormatedValues());
}
Assert.True(barangModel != null);
Assert.True(barangModel.id == idToGet);
if (barangModel != null)
{
var barangModelJsonStr = JsonConvert.SerializeObject(barangModel);
var formattedJsonStr = JToken.Parse(barangModelJsonStr).ToString();
_testOutputHelper.WriteLine(formattedJsonStr);
}
}
public PenjualanReturnDetailModel()
{
Barang = new BarangModel();
}
public PenyesuaianStokModel()
{
Barang = new BarangModel();
Satuan = new SatuanModel();
}
public PembelianReturnDetailModel()
{
Barang = new BarangModel();
}
public BarangServicesFixture()
{
Model = new BarangModel();
Services = new BarangServices(null, new ModelDataAnnotationCheck());
}
