internal static void PushVareDown(Vare v)
{
using (ISession session = NHibernateHelper.OpenSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
var res2= session.CreateQuery("select MAX(Rank) from Vare");
int i = (int)res2.UniqueResult();
int temp;
if (v.Rank != i)
{
temp = v.Rank;
v.Rank++;
var res = session.CreateQuery("from Vare Where Rank = :rank").SetParameter("rank", v.Rank);
Vare vv = (Vare)res.UniqueResult();
vv.Rank = temp;
session.Update(v);
session.Update(v);
transaction.Commit();
}
}
}
}
internal static void LagreSalg(Vare v)
{
using (ISession session = NHibernateHelper.OpenSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
Salg s = new Salg() { Pris = v.Pris, SlagsTid = DateTime.Now, VareId = v.Id};
session.Save(s);
transaction.Commit();
}
}
}
internal static void UpdateVare(Vare v)
{
using (ISession session = NHibernateHelper.OpenSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
session.Update(v);
transaction.Commit();
}
}
}
internal static void Save(Vare vare)
{
using (ISession session = NHibernateHelper.OpenSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
int i = 0;
try
{
var res = session.CreateQuery("select MAX(Rank) from Vare");
i = (int)res.UniqueResult();
i++;
}
catch (Exception e)
{
}
if (i == 0)
{
i = 1;
}
vare.Rank = i;
Console.WriteLine(i);
session.Save(vare);
transaction.Commit();
}
}
}
internal static void PushVareUp(Vare v)
{
using (ISession session = NHibernateHelper.OpenSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
int temp;
if(v.Rank != 1){
temp= v.Rank;
v.Rank--;
var res = session.CreateQuery("from Vare Where Rank = :rank").SetParameter("rank", v.Rank);
Vare vv = (Vare)res.UniqueResult();
vv.Rank = temp;
session.Update(v);
session.Update(v);
transaction.Commit();
}
}
}
}