private void addButton_Click(object sender, EventArgs e)
{
string name = contNameTextBox.Text;
string email = contEmailTextBox.Text;
string password = contPasswordTextBox.Text;
int type = 0;
if (adminRadioButton.Checked) type = 0;
else if (leaderRadioButton.Checked) type = 1;
else if (memberRadioButton.Checked) type = 2;
int teamId = (contTeamComboBox.SelectedItem as Team).Id;
if ((name != String.Empty) && (email != String.Empty) && (password != String.Empty))
{
User usr = new User(name, email, password, new DateTime(), type, teamId, 0, 0, false, false);
if (connection.AddUser(usr))
{
ShowNotifyMessage("Utilizatorul a fost adăugat cu succes!", true);
contNameTextBox.Text = String.Empty;
contEmailTextBox.Text = String.Empty;
contPasswordTextBox.Text = String.Empty;
contNameTextBox.Focus();
}
else
{
ShowNotifyMessage("Exista deja un utilizator cu același email!", false);
contEmailTextBox.Focus();
contEmailTextBox.SelectAll();
}
}
else
{
ShowNotifyMessage("Trebuie să completezi toate câmpurile!", false);
contNameTextBox.Focus();
}
}
public EmployeesWindow(User user, Conexiune connection)
{
InitializeComponent();
this.connection = connection;
this.user = user;
unknown = DowMediaApplication.Properties.Resources.unknown as Image;
}
public WorkWindow(User user, LoginWindow logWin, Conexiune conn)
{
InitializeComponent();
SetColors();
this.connection = conn;
this.loginWindow = logWin;
this.user = user;
toolTip = new ToolTip();
toolTip.IsBalloon = true;
manageLabel.Visible = (user.Type == (int)UserType.Admin);
myActButton.FlatAppearance.BorderColor = Color.FromArgb(0, 255, 255, 255);
teamActButton.FlatAppearance.BorderColor = Color.FromArgb(0, 255, 255, 255);
projectsButton.FlatAppearance.BorderColor = Color.FromArgb(0, 255, 255, 255);
taskButton.FlatAppearance.BorderColor = Color.FromArgb(0, 255, 255, 255);
InitializePanelNo1();//activitatile mele
InitializePanelNo2();//activitatile echipei
InitializePanelNo3();//proiecte
InitializePanelNo4();//task-uri
InitializePanelNo5();//profil
ChangeColorShowPanel(1);//selectez primul panel cand se deschide forma
/*-----preluare setari-----*/
int inactiv = 300;//default
bool show = true;//default
if (File.Exists("settings.ini"))
{
StreamReader fin = new StreamReader("settings.ini");
string line;
while ((line = fin.ReadLine()) != null)
{
int poz = line.IndexOf('=');
if (line.Contains(settings[0]))
inactiv = Convert.ToInt32(line.Substring(poz + 1));
else if (line.Contains(settings[1]))
show = Convert.ToBoolean(line.Substring(poz + 1));
}
fin.Close();
}
empWindow = new EmployeesWindow(user, connection);
empWindow.Show();
showEmpWindowCheckBox.Checked = show;
inactivTimeValue = inactiv;
this.BringToFront();
this.Focus();
}
private void timer_Tick(object sender, EventArgs e)
{
loading++;
loadingPictureBox.BackgroundImage = img[loading % 8];
//this.Icon = Icon.ExtractAssociatedIcon(@"D:\Rotation\Rotate" + (loading % 8) + ".ico");
if (loading == 24)
{
timer.Stop();
loading = -1;
loadingPictureBox.Visible = false;
try
{
string email = emailTextBox.Text;
string parola = parolaTextBox.Text;
user = conexiune.Login(email, parola);
if (user != null)
{
this.Hide();
WorkWindow ww = new WorkWindow(user, this, conexiune);
ww.Show();
}
else
{
string text = "Ai greșit adresa de email sau parola. Incearcă din nou!";
string caption = "EROARE";
MessageBox.Show(text, caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
emailTextBox.Focus();
}
}
catch
{
MessageBox.Show("A apărut o eroare! Te rugăm să încerci mai târziu!");
}
finally
{
this.Enabled = true;
}
}
}
public void Logout(User user, bool started)
{
string query = "UPDATE user SET worktime = @worktime, pausetime = @pausetime, status = @status WHERE email = @email";
MySqlCommand command = new MySqlCommand(query, connection);
command.Parameters.AddWithValue("@worktime", user.Worktime);
command.Parameters.AddWithValue("@pausetime", user.Pausetime);
command.Parameters.AddWithValue("@status", user.Status);
command.Parameters.AddWithValue("@email", user.Email);
command.ExecuteNonQuery();
if (started)
{
//updatez ultima activitate
query = "SELECT * FROM activity WHERE user_id = @user_id ORDER BY id DESC LIMIT 1";
command = new MySqlCommand(query, connection);
command.Parameters.AddWithValue("@user_id", user.Id);
DataSet dataset = new DataSet();
MySqlDataAdapter adapter = new MySqlDataAdapter(command);
adapter.Fill(dataset);
if (dataset.Tables[0].Rows.Count > 0)
{
DataRow row = dataset.Tables[0].Rows[0];
/*----- preiau datele pentru update -----*/
int id = Convert.ToInt32(row["id"].ToString());
DateTime startTime = Convert.ToDateTime(row["start_time"].ToString());
long duration = Convert.ToInt64(row["duration"].ToString());
long newDuration = (long)((TimeSpan)(DateTime.Now - startTime)).TotalSeconds;
/*----- fac update-ul -----*/
query = "UPDATE activity SET duration = @newDuration WHERE id = @id";
command = new MySqlCommand(query, connection);
command.Parameters.AddWithValue("@newDuration", newDuration);
command.Parameters.AddWithValue("@id", id);
command.ExecuteNonQuery();
}
}
command.Dispose();
}
public bool IsEqualTo(User A)
{
return ((this.Id == A.Id) && (this.Email == A.Email));
}
public void ProfileUpdate(User user, ProfileUpdateType type)
{
string query;
MySqlParameter parameter;
if (type == ProfileUpdateType.NameUpdate)
{
query = "UPDATE user SET name = @name WHERE id = @id";
parameter = new MySqlParameter("@name", user.Name);
}
else if (type == ProfileUpdateType.PasswordUpdate)
{
query = "UPDATE user SET password = @password WHERE id = @id";
parameter = new MySqlParameter("@password", user.Password);
}
else// if(type == ProfileUpdateType.PhotoUpdate)
{
query = "UPDATE user SET image = @image WHERE id = @id";
parameter = new MySqlParameter("@image", user.Image);
}
MySqlCommand command = new MySqlCommand(query, connection);
command.Parameters.Add(parameter);
command.Parameters.AddWithValue("@id", user.Id);
command.ExecuteNonQuery();
command.Dispose();
}
public List<User> TeamMembers(User user)
{
List<User> L = new List<User>();
string query = "SELECT * FROM user WHERE team_id = @team_id ORDER BY name ASC";
MySqlCommand command = new MySqlCommand(query, connection);
command.Parameters.AddWithValue("@team_id", user.Team_id);
DataSet dataset = new DataSet();
MySqlDataAdapter adapter = new MySqlDataAdapter(command);
adapter.Fill(dataset);
foreach (DataRow row in dataset.Tables[0].Rows)
{
int id = Convert.ToInt32(row["id"].ToString());
string name = Convert.ToString(row["name"]);
string email = Convert.ToString(row["email"]);
string password = Convert.ToString(row["password"]);
DateTime login = Convert.ToDateTime(row["last_login"]);
int type = Convert.ToInt32(row["type"].ToString());
int team_id = Convert.ToInt32(row["team_id"].ToString());
long worktime = Convert.ToInt64(row["worktime"].ToString());
long pausetime = Convert.ToInt64(row["pausetime"].ToString());
bool status = Convert.ToBoolean(row["status"].ToString());
bool image = Convert.ToBoolean(row["image"].ToString());
L.Add(new User(id, name, email, password, login, type, team_id, worktime, pausetime, status, image));
}
command.Dispose();
adapter.Dispose();
dataset.Dispose();
return L;
}
public bool AddUser(User user)
{
if (UserAlreadyExists(user.Email))
return false;
string query = "INSERT INTO user(name, email, password, last_login, type, team_id, worktime, pausetime, status, image) VALUES (@name, @email, @password, @last_login, @type, @team_id, @worktime, @pausetime, @status, @image)";
MySqlCommand command = new MySqlCommand(query, connection);
command.Parameters.AddWithValue("@name", user.Name);
command.Parameters.AddWithValue("@email", user.Email);
command.Parameters.AddWithValue("@password", user.Password);
command.Parameters.AddWithValue("@last_login", user.LoginTime);
command.Parameters.AddWithValue("@type", user.Type);
command.Parameters.AddWithValue("@team_id", user.Team_id);
command.Parameters.AddWithValue("@worktime", 0);
command.Parameters.AddWithValue("@pausetime", 0);
command.Parameters.AddWithValue("@status", false);
command.Parameters.AddWithValue("@image", false);
command.ExecuteNonQuery();
command.Dispose();
return true;
}
