public RespuestaAccion REGISTER_PURCHASE_DETAIL(GENERIC_VALUE cabecera, SV_SYSTEM sistema, bool depreciar, bool con_credito)
{
var res = new RespuestaAccion();
try
{
TRANSACTION_DETAIL nuevo_det = new TRANSACTION_DETAIL();
nuevo_det.trx_head_id = cabecera.id;
nuevo_det.system_id = sistema.id;
nuevo_det.validity_id = Vigencias.VIGENTE().id;
nuevo_det.depreciate = depreciar;
nuevo_det.allow_credit = con_credito;
_context.TRANSACTIONS_DETAILS.AddObject(nuevo_det);
_context.SaveChanges();
res.result_objs.Add((SV_TRANSACTION_DETAIL)nuevo_det);
res.set_ok();
}
catch (Exception ex)
{
res.set(-1, ex.StackTrace);
}
return(res);
}
public RespuestaAccion REGISTER_DOWNS_DETAIL(int trxHeadId, int systemId, SV_VALIDATY downValid)
{
var res = new RespuestaAccion();
try
{
TRANSACTION_DETAIL DownDetail = new TRANSACTION_DETAIL();
DownDetail.trx_head_id = trxHeadId;
DownDetail.system_id = systemId;
DownDetail.validity_id = downValid.id;
DownDetail.depreciate = false;
DownDetail.allow_credit = false;
_context.TRANSACTIONS_DETAILS.AddObject(DownDetail);
_context.SaveChanges();
res.set_ok();
}
catch (Exception ex)
{
res.set(-1, ex.StackTrace);
}
return(res);
}
public RespuestaAccion REGISTER_CHANGE_DETAIL(int trxHeadId, SV_TRANSACTION_DETAIL prevDetail)
{
var res = new RespuestaAccion();
try
{
TRANSACTION_DETAIL ChangeDetail = new TRANSACTION_DETAIL();
ChangeDetail.trx_head_id = trxHeadId;
ChangeDetail.system_id = prevDetail.system_id;
ChangeDetail.validity_id = prevDetail.validity_id;
ChangeDetail.depreciate = prevDetail.depreciate;
ChangeDetail.allow_credit = prevDetail.allow_credit;
_context.TRANSACTIONS_DETAILS.AddObject(ChangeDetail);
_context.SaveChanges();
res.set_ok();
}
catch (Exception ex)
{
res.set(-1, ex.StackTrace);
}
return(res);
}
private void btnTambahTransaksi_Click(object sender, RoutedEventArgs e)
{
try
{
TRANSACTION transaksi = new TRANSACTION()
{
PATIENT_ID = Convert.ToInt32(txtIdPasienTransaksi.Text),
TRANSACTION_DATE = Convert.ToDateTime(dtTanggalTransaksi.Text),
};
et.TRANSACTIONs.Add(transaksi);
et.SaveChanges();
PATIENT pasien = SearchByIdPasienTransaksi(Convert.ToInt32(txtIdPasienTransaksi.Text));
pasien.STATUS = 1;
et.Entry(pasien).State = System.Data.Entity.EntityState.Modified;
et.SaveChanges();
ROOM ruangan = SearchByIdRoomTransaksi(Convert.ToInt32(cmbNamaRuanganTransaksi.SelectedValue));
MEDICINE obat = SearchByIdObatTransaksi(Convert.ToInt32(cmbNamaObatTransaksi.SelectedValue));
DOCTOR dokter = SearchByIdDokterTransaksi(Convert.ToInt32(cmbNamaDokterTransaksi.SelectedValue));
NURSE perawat = SearchByIdPerawatTransaksi(Convert.ToInt32(cmbNamaPerawatTransaksi.SelectedValue));
TRANSACTION_DETAIL detil_transaksi = new TRANSACTION_DETAIL()
{
ARRIVAL_DATE = Convert.ToDateTime(dtKedatanganTransaksi.Text),
LEAVING_DATE = Convert.ToDateTime(dtKepergianTransaksi.Text),
ROOM_ID = Convert.ToInt32(cmbNamaRuanganTransaksi.SelectedValue),
TRANSACTION_ID = Convert.ToInt32(transaksi.TRANSACTION_ID),
PRICE_ROOM = Convert.ToDouble(ruangan.TYPE_ROOM.PRICE),
QTY_MEDICINE = Convert.ToInt32(txtQtyObat.Text),
TOTAL_PRICE = totalPrice()
};
et.TRANSACTION_DETAIL.Add(detil_transaksi);
/*detil_transaksi.MEDICINEs.Add(new MEDICINE { MEDICINE_ID = SearchByIdObatTransaksi(Convert.ToInt32(cmbNamaObatTransaksi.SelectedValue)).MEDICINE_ID });
* detil_transaksi.DOCTORs.Add(new DOCTOR { DOCTOR_ID = SearchByIdDokterTransaksi(Convert.ToInt32(cmbNamaDokterTransaksi.SelectedValue)).DOCTOR_ID });
* detil_transaksi.NURSEs.Add(new NURSE { NURSE_ID = SearchByIdPerawatTransaksi(Convert.ToInt32(cmbNamaPerawatTransaksi.SelectedValue)).NURSE_ID });*/
TRANSACTION_DETAIL detil_transaksi1 = new TRANSACTION_DETAIL {
TRANSACTION_DETAIL_ID = detil_transaksi.TRANSACTION_DETAIL_ID
};
et.TRANSACTION_DETAIL.Add(detil_transaksi1);
et.TRANSACTION_DETAIL.Attach(detil_transaksi1);
MEDICINE obat1 = new MEDICINE {
MEDICINE_ID = obat.MEDICINE_ID
};
et.MEDICINEs.Add(obat1);
//et.MEDICINEs.Attach(obat1);
DOCTOR dokter1 = new DOCTOR {
DOCTOR_ID = dokter.DOCTOR_ID
};
et.DOCTORs.Add(dokter1);
//et.DOCTORs.Attach(dokter1);
NURSE perawat1 = new NURSE {
NURSE_ID = perawat.NURSE_ID
};
et.NURSEs.Add(perawat1);
//et.NURSEs.Attach(perawat1);
detil_transaksi1.MEDICINEs.Add(obat1);
detil_transaksi1.DOCTORs.Add(dokter1);
detil_transaksi1.NURSEs.Add(perawat1);
et.SaveChanges();
MEDICINE mEDICINE = SearchByIdObatTransaksi(Convert.ToInt32(cmbNamaObatTransaksi.SelectedValue));
mEDICINE.STOCK = obat.STOCK - detil_transaksi.QTY_MEDICINE;
et.Entry(mEDICINE).State = System.Data.Entity.EntityState.Modified;
et.SaveChanges();
clearTextTransaksi();
this.viewBlmTransaksiPasien(dgTransaksiPasien);
MessageBox.Show("Transaksi Berhasil !", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception ex)
{
}
//TRANSACTION_DETAIL detil_transaksi1 = new TRANSACTION_DETAIL { TRANSACTION_DETAIL_ID = detil_transaksi.TRANSACTION_DETAIL_ID };
//detil_transaksi1.MEDICINEs.Add(new MEDICINE { MEDICINE_ID = obat.MEDICINE_ID });
//et.TRANSACTION_DETAIL.Add(detil_transaksi1);
//et.SaveChanges();
}
public RespuestaAccion CREATE_NEW_PART_FROM(int batch_id, int source_part_id, int quantity, DateTime movement_date)
{
var res = new RespuestaAccion();
try
{
var source_part = Partes.ById(source_part_id);
int current_max_index = Partes.ByLote(batch_id).Max(p => p.part_index);
//creo nueva parte
var nueva_parte = new PART();
nueva_parte.article_id = batch_id;
nueva_parte.part_index = current_max_index + 1;
nueva_parte.quantity = quantity;
nueva_parte.first_date = movement_date;
_context.PARTS.AddObject(nueva_parte);
//actualizo cantidad parte antigua
var busca = _context.PARTS.Where(p => p.id == source_part_id).FirstOrDefault();
busca.quantity = source_part.quantity - quantity;
//copio transacciones a la nueva parte y sus relacionados desde la parte origen
//copio cabeceras de transacciones
var source_trx_heads = cabeceras.ByParte(source_part_id);
foreach (SV_TRANSACTION_HEADER s_trx_head in source_trx_heads)
{
TRANSACTION_HEADER nueva_head = new TRANSACTION_HEADER();
nueva_head.PART = nueva_parte; //con este relacionamos a la nueva parte
nueva_head.head_index = s_trx_head.head_index;
nueva_head.trx_ini = s_trx_head.trx_ini;
nueva_head.trx_end = s_trx_head.trx_end;
nueva_head.ref_source = s_trx_head.ref_source;
nueva_head.zone_id = s_trx_head.zone_id;
nueva_head.subzone_id = s_trx_head.subzone_id;
nueva_head.kind_id = s_trx_head.kind_id;
nueva_head.subkind_id = s_trx_head.subkind_id;
nueva_head.category_id = s_trx_head.category_id;
nueva_head.user_own = s_trx_head.user_own;
nueva_head.manage_id = s_trx_head.manage_id;
nueva_head.method_revalue_id = s_trx_head.method_revalue_id;
_context.TRANSACTIONS_HEADERS.AddObject(nueva_head);
//copio detalles de transacciones
var source_trx_details = detalles.GetByHead(s_trx_head.id);
foreach (SV_TRANSACTION_DETAIL s_trx_detail in source_trx_details)
{
TRANSACTION_DETAIL nuevo_detail = new TRANSACTION_DETAIL();
nuevo_detail.TRANSACTION_HEADER = nueva_head; //con este relacionamos a la nueva cabecera
nuevo_detail.system_id = s_trx_detail.system_id;
nuevo_detail.validity_id = s_trx_detail.validity_id;
nuevo_detail.depreciate = s_trx_detail.depreciate;
nuevo_detail.allow_credit = s_trx_detail.allow_credit;
_context.TRANSACTIONS_DETAILS.AddObject(nuevo_detail);
}
//copio detalle de parametros de transaccion
var source_trx_params = DetallesParametros.ByHead(s_trx_head.id);
foreach (SV_TRANSACTION_PARAMETER_DETAIL s_trx_param in source_trx_params)
{
TRANSACTION_PARAMETER_DETAIL nuevo_param = new TRANSACTION_PARAMETER_DETAIL();
nuevo_param.TRANSACTION_HEADER = nueva_head; //con este relacionamos a la nueva cabecera
nuevo_param.system_id = s_trx_param.system_id;
nuevo_param.paratemer_id = s_trx_param.paratemer_id;
nuevo_param.parameter_value = s_trx_param.parameter_value;
_context.TRANSACTIONS_PARAMETERS_DETAILS.AddObject(nuevo_param);
}
}
_context.SaveChanges();
_load_parts();
_load_transactions_headers();
_load_transactions_details();
_load_transactions_param_details();
res.result_objs.Add((SV_PART)nueva_parte);
res.set_ok();
}
catch (Exception ex)
{
res.set(-1, ex.StackTrace);
}
return(res);
}
