public override List <Model> SelectAll()
{
List <Model> result = new List <Model>();
using (var c = ConnetionFactory.GetOracleConnection())
{
using (var cmd = c.CreateCommand())
{
try
{
cmd.CommandText = SELECT_ALL;
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int i = -1;
Oddeleni oddeleni = new Oddeleni
{
Id = reader.GetString(++i),
IdLesniHospodarskyCelek = reader.GetString(++i),
Kod = reader.GetString(++i),
};
result.Add(oddeleni);
}
return(result);
}
catch (OracleException oe)
{
Log(oe.Message);
return(null);
}
}
}
}
public override bool Update(Model obj)
{
Oddeleni ins = (Oddeleni)obj;
using (var c = ConnetionFactory.GetOracleConnection())
{
using (var cmd = c.CreateCommand())
{
try
{
cmd.CommandText = UPDATE;
cmd.Parameters.Add(":id_lhc", ins.IdLesniHospodarskyCelek);
cmd.Parameters.Add(":kod", ins.Kod);
cmd.Parameters.Add(":id", ins.Id);
cmd.ExecuteNonQuery();
return(true);
}
catch (OracleException oe)
{
Log(oe.Message);
return(false);
}
}
}
}
public ActionResult EditOddeleni(int id, Oddeleni collection)
{
try
{
var dao = new OddeleniDao();
var puvodniCollection = dao.GetById(id);
if (ModelState.IsValid)
{
if (collection.UsekId != 0) //pokud není nula, byla provedena změna úseku a musíme dotáhnout objekt
{
puvodniCollection.Usek = new UsekDao().GetById(collection.UsekId);
}
if (!puvodniCollection.Nazev.Equals(collection.Nazev))
{
puvodniCollection.Nazev = collection.Nazev;
}
dao.Update(puvodniCollection); //bude potřeba dotáhnout seznam oddělení??
return(RedirectToAction("DetailOddeleni", new { id = id }));
}
TempData[MessagesHelper.Warning] = Resources.LopTexts.ZkontrolujteZadaneUdaje;
}
catch
{
TempData[MessagesHelper.Danger] = Resources.LopTexts.DosloKNeocekavaneChybe;
}
return(View(collection));
}
public IList <Uzivatel> GetAllNotVedouciOddeleni(Oddeleni oddeleni)
{
Uzivatel alias = null;
return(Session.QueryOver <Uzivatel>(() => alias)
.WithSubquery.WhereNotExists(QueryOver.Of <VedouciOdeleni>()
.Where(c => c.WindowsId == alias.WindowsId)
.And(c => c.Oddeleni.Id == oddeleni.Id)
.Select(c => c.WindowsId))
.List <Uzivatel>());
//nebo-li
//select * from Uzivatel where Uzivatel.WindowsId NOT IN (SELECT WindowsId from VedouciOddeleni Where Oddeleni == oddeleni.Id)
}
public override bool Delete(Model obj)
{
Oddeleni del = (Oddeleni)obj;
using (var c = ConnetionFactory.GetOracleConnection())
{
using (var cmd = c.CreateCommand())
{
try
{
cmd.CommandText = DELETE;
cmd.Parameters.Add(":id", del.Id);
cmd.ExecuteNonQuery();
return(true);
}
catch (OracleException oe)
{
Log(oe.Message);
return(false);
}
}
}
}
public List <Dilec> LoadDilce(Oddeleni odd)
{
return(db.DilecTableGateway.SelectByOddeleni(odd).Cast <Dilec>().ToList());
}