public bool CreateObject(StavkaProforme objekat)
{
try
{
_broker.OpenConnection();
_broker.BeginTransaction();
objekat.Lajsna = _broker.ReturnByCriteria($"WHERE NazivLajsne LIKE '{objekat.Lajsna.NazivLajsne}'", objekat.Lajsna).OfType <Lajsna>().ToList().FirstOrDefault();
_broker.InsertObject(objekat);
_broker.Commit();
return(true);
}
catch (SqlException ex)
{
Debug.Write(">>>>>>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
catch (Exception ex)
{
Debug.WriteLine(">>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
finally
{
_broker.CloseConnection();
}
}
public List <Drzava> GetCountries()
{
try
{
_broker.OpenConnection();
_broker.BeginTransaction();
List <Drzava> list = _broker.SelectAll(new Drzava()).OfType <Drzava>().ToList();
_broker.Commit();
return(list);
}
catch (SqlException ex)
{
Debug.Write(">>>>>>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
catch (Exception ex)
{
Debug.WriteLine(">>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
finally
{
_broker.CloseConnection();
}
}
public Lajsna GetLajsna(string name)
{
try
{
_broker.OpenConnection();
_broker.BeginTransaction();
Lajsna lajsna = _broker.ReturnByCriteria($"WHERE NazivLajsne LIKE '{name}'", new Lajsna()).OfType <Lajsna>().ToList().FirstOrDefault();
_broker.Commit();
return(lajsna);
}
catch (SqlException ex)
{
Debug.Write(">>>>>>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
catch (Exception ex)
{
Debug.WriteLine(">>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
finally
{
_broker.CloseConnection();
}
}
public bool CreateObject(TipLajsne objekat)
{
try
{
_broker.OpenConnection();
_broker.BeginTransaction();
_broker.InsertObject(objekat);
_broker.Commit();
return(true);
}
catch (SqlException ex)
{
Debug.Write(">>>>>>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
catch (Exception ex)
{
Debug.WriteLine(">>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
finally
{
_broker.CloseConnection();
}
}
public bool CreateObject(NalogZaUtovar objekat)
{
try
{
_broker.OpenConnection();
_broker.BeginTransaction();
objekat.Prevoznik = _broker.ReturnByCriteriaJoin($" WHERE NazivKompanije LIKE '{objekat.Prevoznik.NazivKompanije}'", objekat.Prevoznik).OfType <Prevoznik>().ToList().FirstOrDefault();
objekat.CarinikIzvoz = _broker.ReturnByCriteriaJoin($" WHERE NazivKompanije LIKE '{objekat.CarinikIzvoz.NazivKompanije}'", objekat.CarinikIzvoz).OfType <Carinik>().ToList().FirstOrDefault();
objekat.CarinikUvoz = _broker.ReturnByCriteriaJoin($" WHERE NazivKompanije LIKE '{objekat.CarinikUvoz.NazivKompanije}'", objekat.CarinikUvoz).OfType <Carinik>().ToList().FirstOrDefault();
_broker.InsertObject(objekat);
_broker.Commit();
return(true);
}
catch (SqlException ex)
{
Debug.Write(">>>>>>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
catch (Exception ex)
{
Debug.WriteLine(">>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
finally
{
_broker.CloseConnection();
}
}
public object ExecuteSO(DomenskiObjekat domenskiObjekat)
{
object res = null;
try
{
Validate(domenskiObjekat);
broker.OpenConnection();
broker.BeginTransaction();
res = Execute(domenskiObjekat);
broker.Commit();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
broker.Rollback();
}
finally
{
broker.CloseConnection();
}
return(res);
}
public object ExecuteSO(IDomainObject entity)
{
object res = null;
try
{
Validate(entity);
broker.OpenConnection();
broker.BeginTransaction();
res = Execute(entity);
broker.CommitTransaction();
}
catch (Exception)
{
broker.RollbackTransaction();
}
finally
{
broker.CloseConnection();
}
return(res);
}
public void ExecuteTemplate(IEntity entity = null, List <IEntity> entities = null)
{
try
{
broker.OpenConnection();
broker.BeginTransaction();
if (entities != null)
{
foreach (IEntity e in entities)
{
ExecuteOperation(e);
}
}
if (entity != null)
{
ExecuteOperation(entity);
}
broker.Commit();
Successful = true;
}
catch (Exception)
{
Successful = false;
broker.Rollback();
}
finally
{
broker.CloseConnection();
}
}
static void monitorPaymentQueue()
{
using (var broker = new Broker(ConfigurationManager.AppSettings["connectionString"]))
{
while (!stopping)
{
string message, messageType;
Guid dialogHandle, serviceInstance;
broker.BeginTransaction();
broker.Receive("PrintTargetQueue", out messageType, out message, out serviceInstance, out dialogHandle);
if (message != null)
{
switch (messageType)
{
case "PrintRequest":
{
var xml = new XmlDocument();
xml.LoadXml(message);
int BookingId = int.Parse(xml.DocumentElement.InnerText);
Console.Write(string.Format("Printing Tickets For Order : {0}... ", BookingId));
Thread.Sleep(3000); /******CODE TO PRINT WOULD GO HERE*****/
Console.Write("Printed\n");
broker.Send(dialogHandle, "<Print><BookingId>" + BookingId + "</BookingId><PrintStatus>2</PrintStatus></Print>", "PrintResponse");
broker.EndDialog(dialogHandle);
break;
}
}
}
broker.Commit();
}
}
}
public void SaveMoreDijagnoze(List <Dijagnoza> dijagnoze)
{
broker.OpenConnection();
broker.BeginTransaction();
try
{
int brojac = 0;
foreach (Dijagnoza dijagnoza in dijagnoze)
{
if (brojac == dijagnoze.Count)
{
break;
}
broker.InsertDijagnoza(dijagnoza);
}
broker.Commit();
}
catch
{
broker.Rollback();
}
finally
{
broker.CloseConnection();
}
}
public void Delete(IEntity entity, int id)
{
try
{
broker.OpenConnection();
broker.BeginTransaction();
broker.Delete(entity, id);
broker.Commit();
}
catch (Exception)
{
broker.Rollback();
throw;
}
finally
{
broker.CloseConnection();
}
}
public bool CreateObject(Porudzbina objekat)
{
try
{
_broker.OpenConnection();
_broker.BeginTransaction();
objekat.Datum = DateTime.Now;
objekat.Katalog = _broker.ReturnByCriteria($"WHERE Godina={DateTime.Today.Year}", new Katalog()).OfType <Katalog>().ToList().FirstOrDefault();
objekat.Klijent = _broker.ReturnByCriteriaJoin($" WHERE NazivKompanije LIKE '{objekat.Klijent.NazivKompanije}'", objekat.Klijent).OfType <Klijent>().ToList().FirstOrDefault();
objekat.NacinIsporuke = _broker.ReturnByCriteria($" WHERE NazivIsporuke LIKE '{objekat.NacinIsporuke.NazivIsporuke}'", objekat.NacinIsporuke).OfType <NacinIsporuke>().ToList().FirstOrDefault();
objekat.NacinPlacanja = _broker.ReturnByCriteria($" WHERE NazivPlacanja LIKE '{objekat.NacinPlacanja.NazivPlacanja}'", objekat.NacinPlacanja).OfType <NacinPlacanja>().ToList().FirstOrDefault();
long id = _broker.InsertObject(objekat);
foreach (var item in objekat.Stavke)
{
item.Porudzbina = new Porudzbina()
{
Id = id
};
item.Lajsna = _broker.ReturnByCriteria($"WHERE NazivLajsne LIKE '{item.Lajsna.NazivLajsne}'", new Lajsna()).OfType <Lajsna>().ToList().FirstOrDefault();
_broker.InsertObject(item);
}
_broker.Commit();
return(true);
}
catch (SqlException ex)
{
Debug.Write(">>>>>>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
catch (Exception ex)
{
Debug.WriteLine(">>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
finally
{
_broker.CloseConnection();
}
}
public bool CreateObject(Adresa objekat)
{
try
{
_broker.OpenConnection();
_broker.BeginTransaction();
objekat.Kompanija = _broker.ReturnByCriteria($"WHERE NazivKompanije LIKE '{objekat.Kompanija.NazivKompanije}'", objekat.Kompanija).OfType <Kompanija>().ToList().FirstOrDefault();
objekat.Grad = _broker.ReturnByCriteriaJoin($"WHERE NazivGrada LIKE '{objekat.Grad.NazivGrada}'", objekat.Grad).OfType <Grad>().ToList().FirstOrDefault();
_broker.InsertObject(objekat);
_broker.Commit();
return(true);
}
catch (SqlException ex)
{
Debug.Write(">>>>>>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
catch (Exception ex)
{
Debug.WriteLine(">>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
finally
{
_broker.CloseConnection();
}
}
public object ExecuteSO(DomenskiObjekat domenskiObjekat)
{
object rezultat = null;
try
{
Validate(domenskiObjekat);
broker.OtvoriKonekciju();
broker.BeginTransaction();
rezultat = Execute(domenskiObjekat);
broker.Commit();
}
catch (Exception)
{
broker.RollBack();
}
finally
{
broker.ZatvoriKonekciju();
}
return(rezultat);
}
public object ExecuteTemplate(IEntity entity)
{
try
{
broker.OpenConnection();
broker.BeginTransaction();
result = ExecuteSO(entity);
broker.Commit();
}
catch (Exception)
{
broker.RollBack();
}
finally
{
broker.CloseConnection();
}
return(result);
}
public void LetsDoIt(IDomainObject obj)
{
try
{
Validation(obj);
broker.OpenConnection();
broker.BeginTransaction();
DoOperation(obj);
broker.CommitTransaction();
}
catch (Exception)
{
broker.RollbackTransaction();
throw;
}
finally
{
broker.CloseConnection();
}
}
public int DeleteObject(Lajsna objekat)
{
try
{
_broker.OpenConnection();
_broker.BeginTransaction();
Lajsna lajsna = _broker.SelectObject(objekat) as Lajsna;
List <Cena> cene = _broker.ReturnByCriteria($"WHERE SifraLajsne={lajsna.Id}", new Cena()).OfType <Cena>().ToList();
foreach (var cena in cene)
{
_broker.DeleteObject(new Cena()
{
Lajsna = new Lajsna()
{
Id = objekat.Id
}, DatumOd = cena.DatumOd
});
}
_broker.DeleteObject(objekat);
_broker.Commit();
return(1);
}
catch (SqlException ex)
{
Debug.Write(">>>>>>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
catch (Exception ex)
{
//_broker.Rollback();
Debug.WriteLine(">>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
finally
{
_broker.CloseConnection();
}
}
public object ExecuteSO(IGenericObject odo)
{
object result;
_broker.OpenConnection();
_broker.BeginTransaction();
try
{
result = Execute(odo, _broker);
_broker.Save();
}
catch (Exception ex)
{
_broker.Rollback();
throw ex;
}
finally
{
_broker.CloseConnection();
}
return(result);
}
//public List<DateTime> GetVremeTermina(Lekar lekar)
//{
// try
// {
// broker.OpenConnection();
// return broker.GetWhere(lekar);
// }
// finally
// {
// broker.CloseConnection();
// }
//}
public void SaveMore(List <Termin> termini)
{
broker.OpenConnection();
broker.BeginTransaction();
try
{
foreach (Termin termin in termini)
{
broker.SaveTermin(termin);
}
broker.Commit();
}
catch (Exception ex)
{
broker.Rollback();
MessageBox.Show(ex.Message);
}
finally
{
broker.CloseConnection();
}
}
public void BeginTransaction()
{
broker.BeginTransaction();
}