public LogIn()
{
InitializeComponent();
try
{
db = new WFPL_Db();
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
try
{
if (db.getLastUser() != null)
{
textBoxUser.Text = db.getLastUser().name;
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
monthCalendar1.MaxDate = DateTime.Now;
//var user = new Subject { name = "oop", surname = "", ID = 1, isLast = 1 };// e sad vidji samo sta ti je islast i id i prezime :) jer ovo bi puklo, users je set User klase, tako da si pokusao dodati subject
//db.Users.Add(user);
//db.SaveChanges();
currentTableListState = new TableList();
//currentTableListState.getCurrentList();
api = new Api(this);
string res = api.apiTest1();
MessageBox.Show(res, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
//
// Korisnik je izabrao jedan od ponudjenih naloga
//
private void LinkedLabelClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
var person = sender.ToString().Substring(38).Split(' ');
var personName = person[0];
var personSurname = person[1];
db.getLastUser().isLast = 0;
var query = from user in db.Users
where user.name == personName
select user;
foreach (var item in query)
{
item.isLast = 1;
}
db.SaveChanges();
Choose.Show();
currentUser = db.getLastUser();
}
/*
* Dodavanje predmeta. Predmet se dodaje u lokalnom vremenu, a pri sakupljanju podataka
* sa Raspberry-a treba konvertovati njegova vremena u lokalna
*/
private void addSub_Click(object sender, EventArgs e)
{
string name = textBox1.Text;
DateTime startDate = monthCalendar1.SelectionStart;
DateTime endDate = monthCalendar1.SelectionEnd;
int startTime = (int)numericStart.Value;
int endTime = (int)numericEnd.Value;
object dayOfWeek = domainUpDown1.SelectedItem;
int userID = db.getLastUser().ID;
try
{
if (name == "")
{
throw new Exception("Ime predmeta nije uneto.");
}
if (dayOfWeek == null)
{
throw new Exception("Dan u nedelji odrzavanja predmeta nije unet.");
}
string dayOfWeekStr = dayOfWeek.ToString();
if (startTime >= endTime)
{
throw new Exception("Predavanje mora da pocne pre nego sto se zavrsi.");
}
var overlapQuery =
from subject in db.Subjects
where
subject.userID == userID &&
subject.dayOfWeek == dayOfWeekStr
select subject;
foreach (Subject subject in overlapQuery)
{
int itStartTime = Convert.ToInt32(subject.startTime);
int itEndTime = itStartTime + subject.durationTime;
if (itStartTime <= startTime && startTime < itEndTime)
{
throw new Exception("Predmet se preklapa u intervalu ["
+ startTime + " - " + (itEndTime < endTime ? itEndTime : endTime)
+ "] sa predmetom " + subject.name);
}
if (itStartTime < endTime && endTime <= itEndTime)
{
throw new Exception("Predmet se preklapa u intervalu ["
+ (itStartTime > startTime ? itStartTime : startTime) + " - " + endTime
+ "] sa predmetom " + subject.name);
}
if (startTime <= itStartTime && itStartTime < endTime)
{
throw new Exception("Predmet se preklapa u intervalu ["
+ itStartTime + " - " + itEndTime
+ "] sa predmetom " + subject.name);
}
}
Subject newSubject = new Subject
{
// ID = ???,
name = name,
userID = userID,
startTime = startTime.ToString(),
durationTime = endTime - startTime,
dayOfWeek = dayOfWeekStr,
startDate = startDate.ToString(),
endDate = endDate.ToString()
};
db.Subjects.Add(newSubject);
db.SaveChanges();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
