public static List <DUP> UzmiSveDup()
{
ISession session = SessionManager.GetSession();
List <DUP> dups = new List <DUP>();
if (session == null)
{
return(null);
}
var dupData = session.Execute("select * from \"Dnevni_unos_pica\"");
foreach (var row in dupData)
{
DUP dup = new DUP();
dup.datum = row["datum"] != null ? row["datum"].ToString() : string.Empty;
dup.jmbg = row["jmbg"] != null ? row["jmbg"].ToString() : string.Empty;
dup.kalorijska_vrednost = row["kalorijska_vrednost"] != null ? row["kalorijska_vrednost"].ToString() : string.Empty;
dup.vrsta_pica = row["vrsta_pica"] != null ? row["vrsta_pica"].ToString() : string.Empty;
dups.Add(dup);
}
return(dups);
}
public static void DodajDup(DUP k)
{
ISession session = SessionManager.GetSession();
if (session == null)
{
return;
}
RowSet dupData = session.Execute("insert into \"Dnevni_unos_pica\" (jmbg,datum,vrsta_pica,kalorijska_vrednost) values ('" + k.jmbg + "','" + k.datum + "','" + k.vrsta_pica + "','" + k.kalorijska_vrednost + "')");
}
public static void ObrisiDup(string jmbg)
{
ISession session = SessionManager.GetSession();
DUP dup = new DUP();
if (session == null)
{
return;
}
RowSet DUPData = session.Execute("delete from \"Dnevni_unos_pica\" where jmbg = '" + jmbg + "'");
}
private void dodajbtn_Click(object sender, EventArgs e)
{
{
DUP d = new DUP();
d.jmbg = jmbgtb.Text;
d.datum = datum.Text;
d.vrsta_pica = vrstapcb.Text;
d.kalorijska_vrednost = kalorijepicatb.Text;
DataProvider.DodajDup(d);
}
MessageBox.Show("Dnevni unos pica je uspesno dodat u bazu!");
this.DialogResult = DialogResult.OK;
}
public static DUP UcitajDUP(string jmbg)
{
ISession session = SessionManager.GetSession();
DUP dup = new DUP();
if (session == null)
{
return(null);
}
Row dupData = session.Execute("select * from \"Dnevni_unos_pica\" where \"jmbg\"='1407997735060'").FirstOrDefault();
if (dupData != null)
{
dup.jmbg = dupData["jmbg"] != null ? dupData["jmbg"].ToString() : string.Empty;
dup.datum = dupData["prezime"] != null ? dupData["datum"].ToString() : string.Empty;
dup.vrsta_pica = dupData["vrsta_pica"] != null ? dupData["vrsta_pica"].ToString() : string.Empty;
dup.kalorijska_vrednost = dupData["kalorijska_vrednost"] != null ? dupData["kalorijska_vrednost"].ToString() : string.Empty;
}
return(dup);
}
//Method that takes the tuples from the inqueue and processes them.
public void process_inQueue()
{
FILTER filter = new FILTER();
CUSTOM custom = new CUSTOM();
UNIQ uniq = new UNIQ();
DUP dup = new DUP();
COUNT count = new COUNT();
while (true)
{
Monitor.Enter(tLock);
try
{
if (in_queue.Count > 0)
{
string[] words = op_spec.Split(',');
remoting_interfaces.Tuple outTuple;
if (in_queue[0].getID() != 0)
{
Console.WriteLine(" ");
Console.WriteLine("ID: " + in_queue[0].getID());
Console.WriteLine("User: "******"URL: " + in_queue[0].getURL());
}
if (words[0] == "FILTER")
{
//get the tuple after computation of Filter
outTuple = filter.doTweeters(in_queue[0], Int32.Parse(words[1]), words[2], words[3]);
out_queue.Add(outTuple);
in_queue.Remove(in_queue[0]);
Console.WriteLine("Output from Operator:");
Console.WriteLine(outTuple.getID());
Console.WriteLine(outTuple.getUser());
Console.WriteLine(outTuple.getURL());
}
if (words[0] == "CUSTOM")
{
List <string> Followers = new List <string>();
//get the list of followers
Followers = custom.getoutput(words[1], words[3], in_queue[0]);
foreach (string follower in Followers)
{
Console.WriteLine("follower: " + follower);
remoting_interfaces.Tuple Tuple = new remoting_interfaces.Tuple(0, follower, "");
out_queue.Add(Tuple);
}
in_queue.Remove(in_queue[0]);
}
if (words[0] == "UNIQ")
{
outTuple = uniq.uniqTuple(in_queue[0], Int32.Parse(words[1]));
//only put the tuple in the out_queue if don't exists another equal to that tuple
if (outTuple.getUser() != "")
{
out_queue.Add(outTuple);
Console.WriteLine("Output from Operator:");
Console.WriteLine(outTuple.getUser());
}
in_queue.Remove(in_queue[0]);
}
if (words[0] == "DUP")
{
List <remoting_interfaces.Tuple> duplicatedTuple = dup.duplicate(in_queue[0]);
foreach (remoting_interfaces.Tuple tuplo in duplicatedTuple)
{
out_queue.Add(tuplo);
Console.WriteLine("Output from Operator:");
Console.WriteLine(tuplo.getID());
Console.WriteLine(tuplo.getUser());
Console.WriteLine(tuplo.getURL());
}
duplicatedTuple.Remove(in_queue[0]);
duplicatedTuple.Remove(in_queue[0]);
in_queue.Remove(in_queue[0]);
}
if (words[0] == "COUNT")
{
outTuple = count.countMethod(in_queue[0]);
out_queue.Add(outTuple);
Console.WriteLine("Output from Operator:");
Console.WriteLine(outTuple.getUser());
Console.WriteLine("Tuples count until now: " + count.getCount());
Console.WriteLine(" ");
in_queue.Remove(in_queue[0]);
}
}
}
finally
{
Monitor.Exit(tLock);
}
}
}
private void prikazibtn_Click(object sender, EventArgs e)
{
DUP d = DataProvider.UcitajDUP("3001998756011");
MessageBox.Show("Podaci o dnevnom unosu:" + " " + d.vrsta_pica + " " + d.kalorijska_vrednost + " ");
}
