private void DataBaseLogging()
{
var login = LogintextBox1.Text;
var password = PasswordTextBox.Text;
using (LearningPlannerDataBaseEntities x = new LearningPlannerDataBaseEntities())
{
var user = x.Users.FirstOrDefault(e => e.Login == login);
if (user != null)
{
if (user.Haslo == password)
{
MessageBox.Show("Zalogowano");
UserID = user.IDosoby;
panel1.Hide();
panel1.Enabled = false;
ShowLeftMenu();
RememberCredentials();
}
else
{
MessageBox.Show("Złe hasło");
}
}
else
{
MessageBox.Show($"Nie znaleziono użytkownika '{login}' ");
}
}
}
private void SaveButton_Click(object sender, EventArgs e)
{
taskModel.Nazwa = TaskNameTextBox.Text.Trim();
taskModel.Kategoria = CategoryTextBox.Text.Trim();
taskModel.Opis = DescriptionTextBox.Text.Trim();
taskModel.DataUtworzenia = DateTime.Now;
taskModel.CzyZakonczone = false;
taskModel.IDUzytkownika = (short)IDUser;
if (TaskNameTextBox.Text == string.Empty || CategoryTextBox.Text == string.Empty ||
DescriptionTextBox.Text == string.Empty)
{
MessageBox.Show("Uzupełnij wszystkiego pola!");
}
else
{
using (LearningPlannerDataBaseEntities dbmodel = new LearningPlannerDataBaseEntities())
{
if (taskModel.IDZadania == 0)
{
dbmodel.Tasks.Add(taskModel);
}
else
{
dbmodel.Entry(taskModel).State = System.Data.Entity.EntityState.Modified;
}
dbmodel.SaveChanges();
}
FillGrid();
ClearTextBoxes();
MessageBox.Show("Pomyślnie dodano zadanie");
}
}
private void QuotationControl_Load(object sender, EventArgs e)
{
using (LearningPlannerDataBaseEntities context = new LearningPlannerDataBaseEntities())
{
int quotationSum = context.Quotations.Count();
Random rand = new Random();
int randomQuotation = rand.Next(quotationSum) + 1;
var tmp = context.Quotations.Single(p => p.IDCytatu == randomQuotation);
QuotationLabel.Text = tmp.Tresc;
}
}
private void findButton_Click(object sender, EventArgs e)
{
twitterTweetsTextBox.Clear();
this.Invalidate();
var user = User.GetUserFromScreenName(findTextBox.Text);
if (twitterComboBox.SelectedItem == null)
{
twitterComboBox.SelectedIndex = 3;
}
try
{
var userTimeLine = Timeline.GetUserTimeline(user, twitterComboBox.SelectedIndex + 1);
followersLabel.Text = user.Name + Environment.NewLine + "Obserwujących: " + Environment.NewLine
+ user.FollowersCount;
var image = user.ProfileImageUrl400x400;
foundPersonPicture.ImageLocation = image;
foreach (var item in userTimeLine)
{
twitterTweetsTextBox.AppendText("--- " + item.FullText + " - " + item.CreatedAt
+ Environment.NewLine + Environment.NewLine);
}
followersLabel.Visible = true;
using (LearningPlannerDataBaseEntities model = new LearningPlannerDataBaseEntities())
{
var historyRecord = new TweetsHistory()
{
IDosoby = IDUser,
TwitterUser = user.Name
};
model.TweetsHistory.Add(historyRecord);
model.SaveChanges();
}
}
catch
{
twitterTweetsTextBox.Text = "Nie wpisano żadnej nazwy lub użytkownik o podanym nicku nie istnieje!";
twitterComboBox.SelectedIndex = default;
}
}
private void EditTask_Click(object sender, EventArgs e)
{
DescriptionInfoRichTextBox.ReadOnly = false;
using (LearningPlannerDataBaseEntities mod = new LearningPlannerDataBaseEntities())
{
DescriptionInfoRichTextBox.TextChanged += DescriptionInfoRichTextBox_TextChanged;
var selectedRowId = mod.Tasks.Single(u => u.IDZadania == CompletedTasksForm.Id);
selectedRowId.Opis = DescriptionInfoRichTextBox.Text;
mod.SaveChanges();
}
EditTaskButton.Click += EditTask_Click1;
Text = ("Szczególy Zadania [Tryb edytowania]");
}
private void TaskDataGridView_Click(object sender, EventArgs e)
{
try
{
if (TaskDataGridView.CurrentRow.Index != -1)
{
taskModel.IDZadania = Convert.ToInt32(TaskDataGridView.CurrentRow.Cells["IDZadania"].Value);
using (LearningPlannerDataBaseEntities model = new LearningPlannerDataBaseEntities())
{
taskModel = model.Tasks.Where(x => x.IDZadania == taskModel.IDZadania).FirstOrDefault();
TaskNameTextBox.Text = taskModel.Nazwa;
CategoryTextBox.Text = taskModel.Kategoria;
DescriptionTextBox.Text = taskModel.Opis;
}
}
SaveButton.Text = "Zaaktualizuj";
}
catch (NullReferenceException) { }
}
private void FinishTask_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Czy napewno chcesz zakończyć to zadanie?", "Koniec Zadania", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
var selectedRowId = TaskForm.Id;
using (LearningPlannerDataBaseEntities mod = new LearningPlannerDataBaseEntities())
{
var selectedTask = mod.Tasks.Single(z => z.IDZadania == selectedRowId);
selectedTask.CzyZakonczone = true;
mod.SaveChanges();
}
GetFinishData = DateTime.Now.ToString();
currentForm.FillGrid();
Close();
}
}
private void TwitterForm_Load(object sender, EventArgs e)
{
using (LearningPlannerDataBaseEntities model = new LearningPlannerDataBaseEntities())
{
var top1 = model.Top3Users.Select(a => a.TwitterUser).Take(1);
foreach (var item in top1)
{
MostlySearchedLabel2.Text = "1. " + item;
}
var top2 = model.Top3Users.Select(a => a.TwitterUser).Take(2);
foreach (var item in top2)
{
MostlySearchedLabel3.Text = "2. " + item;
}
var top3 = model.Top3Users.Select(a => a.TwitterUser).Take(3);
foreach (var item in top3)
{
MostlySearchedLabel4.Text = "3. " + item;
}
}
}
private void AddUserToDataBase()
{
Users model = new Users
{
Login = Login,
Haslo = Password
};
using (LearningPlannerDataBaseEntities LearningPlannerDataBaseEntities = new LearningPlannerDataBaseEntities())
{
if (LearningPlannerDataBaseEntities.Users.Where(u => u.Login == Login).Any())
{
MessageBox.Show("Podana nazwa uzytkownika jest juz zajęta");
}
else
{
LearningPlannerDataBaseEntities.Users.Add(model);
LearningPlannerDataBaseEntities.SaveChanges();
MessageBox.Show("Utworzono konto!");
Close();
}
}
}
private void DeleteButton_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Czy jesteś pewien, że chcesz usunąć to zadanie?", "USUWANIE REKORDU", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{
using (LearningPlannerDataBaseEntities dbmodel = new LearningPlannerDataBaseEntities())
{
var entry = dbmodel.Entry(taskModel);
if (entry.State == System.Data.Entity.EntityState.Detached)
{
dbmodel.Tasks.Attach(taskModel);
}
dbmodel.Tasks.Remove(taskModel);
dbmodel.SaveChanges();
MessageBox.Show("Pomyślnie usunięto zadanie");
}
FillGrid();
ClearTextBoxes();
}
catch
{
string errorDelete = "Błąd: Nie zaznaczono żadnego rekordu";
errorLabel.Visible = true;
errorLabel.Text = errorDelete;
Timer exceptionTimer = new Timer
{
Interval = 7000
};
exceptionTimer.Tick += ExceptionTimer_Tick;
exceptionTimer.Start();
}
}
}
