/// <summary>
/// Open new view with drug detail
/// </summary>
/// <param name="liecivo"></param>
/// <returns></returns>
public IResult OnGetDrugDetail(Liecivo liecivo)
{
if (liecivo != null)
{
DetailDrugViewModel detailDrugviewModel = _serviceLocator.GetInstance<DetailDrugViewModel>();
detailDrugviewModel.DrugName = liecivo.Nazov_lieciva.nazov_lieciva1;
detailDrugviewModel.BarCode = liecivo.ciarovy_kod;
detailDrugviewModel.SuklCode = liecivo.sukl_kod;
detailDrugviewModel.Forma = liecivo.Forma.forma1;
detailDrugviewModel.ActiveSubstance = liecivo.Ucinna_latka.nazov;
detailDrugviewModel.Prescription = (liecivo.na_predpis == "0") ? "Nie" : "Áno";
detailDrugviewModel.Price = liecivo.jednotkova_cena.ToString();
detailDrugviewModel.DistributorName = liecivo.Distributor.nazov_distributora;
detailDrugviewModel.RegNumber = liecivo.Distributor.registracne_cislo;
detailDrugviewModel.CorpName = liecivo.Distributor.nazov_firmy;
detailDrugviewModel.StreetAddress = liecivo.Distributor.ulica;
detailDrugviewModel.CityAddress = liecivo.Distributor.Cis_Obec.Nazov;
detailDrugviewModel.PatientInfoLeaf = liecivo.pribalovy_letak;
return Show.Child(detailDrugviewModel).In<IShellViewModel>();
}
else
{
MessageBox.Show("Pre náhľad je potrebné vybrať konkrétne liečivo z tabuľky!");
}
return null;
}
private bool FilterLiecivo(Liecivo entity)
{
return (entity.registracne_cislo == this.registracne_cislo);
}
private void DetachLiecivo(Liecivo entity)
{
entity.Distributor = null;
}
private void AttachLiecivo(Liecivo entity)
{
entity.Distributor = this;
}
private bool FilterLiecivo(Liecivo entity)
{
return (entity.id_ucinna_latka == this.id_ucinna_latka);
}
/// <summary>
/// Add drug into database
/// </summary>
public void OnAddDrugAction()
{
if (DrugNameSelected == string.Empty || SuklCode == string.Empty || BarCode == string.Empty ||
ActiveSubstanceSelected == string.Empty || CorporationDistributorSelected == string.Empty ||
DrugFormSelected == string.Empty || PrescriptionIndex == string.Empty || DrugPrice == string.Empty)
{
MessageBox.Show("Niektoré údaje neboli správne alebo vôbec vyplnené!");
}
else
{
//overim, ci sa tam take liecivo uz nenachadza
bool barCodeExists = _pharmacyDomainContext.Liecivos.Where(a => a.ciarovy_kod == BarCode).Any();
bool suklCodeExists = _pharmacyDomainContext.Liecivos.Where(a => a.sukl_kod == SuklCode).Any();
if (barCodeExists || suklCodeExists)
{
MessageBox.Show("Dané liečivo sa už v databáze nachádza! - zhoda čiarového alebo ŠUKL kódu");
}
else
{
Liecivo liecivo = new Liecivo();
liecivo.id_nazov_lieciva = Int32.Parse(DrugNameSelected);
liecivo.sukl_kod = SuklCode;
liecivo.ciarovy_kod = BarCode;
liecivo.id_ucinna_latka = Int32.Parse(ActiveSubstanceSelected);
liecivo.registracne_cislo = CorporationDistributorSelected;
liecivo.id_forma = Int32.Parse(DrugFormSelected);
liecivo.na_predpis = PrescriptionIndex;
liecivo.jednotkova_cena = float.Parse(DrugPrice);
liecivo.pribalovy_letak = PatientInfoLeaf;
_pharmacyDomainContext.Liecivos.Add(liecivo);
_pharmacyDomainContext.SubmitChanges();
MessageBox.Show("Liečivo bolo úspešne pridané do centrálnej databázy!");
}
}
}
public void DeleteLiecivo(Liecivo liecivo)
{
if ((liecivo.EntityState != EntityState.Detached))
{
this.ObjectContext.ObjectStateManager.ChangeObjectState(liecivo, EntityState.Deleted);
}
else
{
this.ObjectContext.Liecivo.Attach(liecivo);
this.ObjectContext.Liecivo.DeleteObject(liecivo);
}
}
public void InsertLiecivo(Liecivo liecivo)
{
if ((liecivo.EntityState != EntityState.Detached))
{
this.ObjectContext.ObjectStateManager.ChangeObjectState(liecivo, EntityState.Added);
}
else
{
this.ObjectContext.Liecivo.AddObject(liecivo);
}
}
private void DetachLiecivo(Liecivo entity)
{
entity.Nazov_lieciva = null;
}
private void AttachLiecivo(Liecivo entity)
{
entity.Nazov_lieciva = this;
}
private bool FilterLiecivo(Liecivo entity)
{
return (entity.ciarovy_kod == this.ciarovy_kod);
}
private bool FilterLiecivo(Liecivo entity)
{
return (entity.id_forma == this.id_forma);
}
private void DetachLiecivo(Liecivo entity)
{
entity.Forma = null;
}
private void AttachLiecivo(Liecivo entity)
{
entity.Forma = this;
}
/// <summary>
/// Create a new Liecivo object.
/// </summary>
/// <param name="ciarovy_kod">Initial value of the ciarovy_kod property.</param>
/// <param name="id_forma">Initial value of the id_forma property.</param>
/// <param name="id_nazov_lieciva">Initial value of the id_nazov_lieciva property.</param>
/// <param name="id_ucinna_latka">Initial value of the id_ucinna_latka property.</param>
/// <param name="sukl_kod">Initial value of the sukl_kod property.</param>
/// <param name="na_predpis">Initial value of the na_predpis property.</param>
/// <param name="jednotkova_cena">Initial value of the jednotkova_cena property.</param>
public static Liecivo CreateLiecivo(global::System.String ciarovy_kod, global::System.Int32 id_forma, global::System.Int32 id_nazov_lieciva, global::System.Int32 id_ucinna_latka, global::System.String sukl_kod, global::System.String na_predpis, global::System.Single jednotkova_cena)
{
Liecivo liecivo = new Liecivo();
liecivo.ciarovy_kod = ciarovy_kod;
liecivo.id_forma = id_forma;
liecivo.id_nazov_lieciva = id_nazov_lieciva;
liecivo.id_ucinna_latka = id_ucinna_latka;
liecivo.sukl_kod = sukl_kod;
liecivo.na_predpis = na_predpis;
liecivo.jednotkova_cena = jednotkova_cena;
return liecivo;
}
/// <summary>
/// Deprecated Method for adding a new object to the Liecivo EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToLiecivo(Liecivo liecivo)
{
base.AddObject("Liecivo", liecivo);
}
private bool FilterLiecivo(Liecivo entity)
{
return (entity.id_nazov_lieciva == this.id_nazov_lieciva);
}
public void UpdateLiecivo(Liecivo currentLiecivo)
{
this.ObjectContext.Liecivo.AttachAsModified(currentLiecivo, this.ChangeSet.GetOriginal(currentLiecivo));
}
private void AttachLiecivo(Liecivo entity)
{
entity.Ucinna_latka = this;
}
/// <summary>
/// Change price of drug
/// </summary>
/// <param name="liecivo"></param>
public void OnChangePriceAction(Liecivo liecivo)
{
if (liecivo != null)
{
_pharmacyDomainContext.Load(_pharmacyDomainContext.GetLiecivo_na_recepteQuery(), true).Completed +=
(args, events) =>
{
var drugsInRecipe = from lnr in _pharmacyDomainContext.Liecivo_na_receptes
where lnr.id_recept == Int32.Parse(RecipeID) && lnr.ciarovy_kod == liecivo.ciarovy_kod
select lnr;
foreach (var drug in drugsInRecipe)
{
drug.cena_lieciva = float.Parse(NewPrice);
}
_pharmacyDomainContext.SubmitChanges().Completed += (a, e) =>
{
MessageBox.Show("Cena bola úspešne zmenená!");
};
};
}
else
{
MessageBox.Show("Nebolo zvolené liečivo z tabuľky");
}
}
private void DetachLiecivo(Liecivo entity)
{
entity.Ucinna_latka = null;
}