public void Add(Tasks t)
{
using (TaskManEntities tme = new TaskManEntities())
{
tme.Tasks.Add(t);
tme.SaveChanges();
}
}
public void MSD(int SelectedId)
{
using (TaskManEntities tme = new TaskManEntities())
{
Tasks t = tme.Tasks.Where(p => p.id == SelectedId).FirstOrDefault();
t.taskStatus = "Виконано";
tme.SaveChanges();
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
id=crud.getId();
currentDate = DateTime.Now.Date.ToString();
cd = new TaskManEntities();
MyGrid.ItemsSource = (from t in cd.Tasks select new { t.id, t.taskName, t.taskPriority, t.taskStatus, t.taskDate, t.UserID }).Where(p=>p.taskDate==currentDate).Where(p=>p.UserID==id).ToList();
Donebtn.IsEnabled = false;
Editbtn.IsEnabled = false;
Deletebtn.IsEnabled = false;
}
private void okbtn_Click(object sender, RoutedEventArgs e)
{
if (passbx.Password == passbx1.Password && nametbx.Text!=null && logintbx.Text!=null && passbx.Password!=null & passbx1!=null)
{
Users u = new Users();
u.userLogin = logintbx.Text;
u.userName = nametbx.Text;
u.userPass = passbx.Password;
u.userDOB = Dpick1.SelectedDate.ToString();
u.userEmail = emailtbx.Text;
int count = 0;
TaskManEntities tme = new TaskManEntities();
foreach (var v in tme.Users)
{
if (v.userLogin == u.userLogin)
{
count++;
}
}
if (count == 0)
{
try
{
tme.Users.Add(u);
tme.SaveChanges();
Login l = new Login();
MessageBox.Show("Реєстрація пройшла успішно!");
this.Close();
l.ShowDialog();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
MessageBox.Show(validationError.ErrorMessage);
}
}
}
}
else
{
MessageBox.Show("Цей логін уже зайнятий. Виберіть інший.");
}
}
else
{
MessageBox.Show("Ви не заповнили усі поля або введені паролі не співпадають");
}
}
public void Delete(int SelectedId)
{
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Ви впевнені, що хочете видалити завдання?", "Видалення завдання", System.Windows.MessageBoxButton.YesNo);
if (messageBoxResult == MessageBoxResult.Yes)
{
using (TaskManEntities tme = new TaskManEntities())
{
Tasks t = tme.Tasks.Where(p => p.id == SelectedId).FirstOrDefault();
tme.Tasks.Remove(t);
tme.SaveChanges();
}
}
}
private void btnLogin_Click(object sender, RoutedEventArgs e)
{
CRUD c = new CRUD();
String userName = txtBxuserName.Text.ToLower();
string pass = passBxPassword.Password;
lblfrgtPass.Visibility = Visibility.Hidden;
lblLoading.Visibility = Visibility.Visible;
txtBxuserName.IsEnabled = false;
passBxPassword.IsEnabled = false;
btnLogin.IsEnabled = false;
TaskManEntities tme = new TaskManEntities();
var user=tme.Users.Where(p=>p.id==1).FirstOrDefault();
foreach (var v in tme.Users)
{
if (v.userLogin == userName)
{
user = tme.Users.Where(p => p.userLogin == userName).FirstOrDefault();
}
}
if (user.userPass == pass)
{
MainWindow mw = new MainWindow();
c.setID(user.id);
this.Close();
mw.ShowDialog();
}
else
{
lblLoading.Visibility = Visibility.Hidden;
lblfrgtPass.Visibility = Visibility.Visible;
txtBxuserName.IsEnabled = true;
txtBxuserName.BorderBrush = Brushes.Red;
passBxPassword.IsEnabled = true;
passBxPassword.BorderBrush = Brushes.Red;
btnLogin.IsEnabled = true;
Mouse.OverrideCursor = null;
}
}
private void Editbtn_Click(object sender, RoutedEventArgs e)
{
object item = MyGrid.SelectedItem;
string ID = (MyGrid.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text;
SelectedId = Int32.Parse(ID);
using (TaskManEntities tme = new TaskManEntities())
{
Tasks t = tme.Tasks.Where(p => p.id == SelectedId).FirstOrDefault();
if (t.taskStatus == "Виконано")
{
MessageBox.Show("Ви не можете змінити виконане завдання.");
}
else
{
Edit edit = new Edit(SelectedId);
var result = edit.ShowDialog();
}
}
}