private void btnAssignUser_Click(object sender, EventArgs e)
{
string sqlString = null;
String username = comboUsers.Text;
sqlString = string.Format(@"INSERT INTO t_team (username, project) values( '{0}', '{1}');", username, glob.ProjectName);
db.SendQueryToDb(sqlString);
listProjectTeam.Items.Clear();
sqlString = string.Format(@"SELECT username FROM t_team WHERE project like'{0}';", glob.ProjectName);
db.LoadTextList(listProjectTeam, "username", sqlString);
}
private void FormProjectSettings_Load(object sender, EventArgs e)
{
this.Text = "Project settings";
string sqlString = null;
Baza db = new Baza();
labRepozName.Text = db.GetRepozName();
labLoggedUser.Text = glob.loggedUser;
labProjName.Text = glob.ProjectName;
sqlString = @"SELECT username FROM t_members;";
db.LoadCombo(comboUsers, "username", sqlString);
listProjectTeam.Items.Clear();
sqlString = string.Format(@"SELECT username FROM t_team WHERE project like'{0}';", glob.ProjectName);
db.LoadTextList(listProjectTeam, "username", sqlString);
sqlString = string.Format(@"SELECT filename FROM t_doc WHERE project like'{0}';", glob.ProjectName);
db.LoadTextList(listBoxDoc, "filename", sqlString);
}
private void btnOpenProject_Click_1(object sender, EventArgs e) //Opens(activates) selected project, and enables project setting button
{
if (listBoxWorkDoc.Items.Count < 1)
{
if (!String.IsNullOrEmpty(comboProjects.Text))
{
string sqlString = null;
string TempFolderPath = null;
glob.ProjectName = comboProjects.SelectedValue.ToString();
labProjName.Text = glob.ProjectName;
btnProjSet.Enabled = true; //Enable button for project settings form open
listViewProjDoc.Items.Clear(); //Clear list, and load all file names from db (Query is hardcoded)
db.LoadVeiwListProjectDocuments(listViewProjDoc);
listBoxWorkDoc.Items.Clear(); //Load working docs
sqlString = string.Format(@"SELECT * FROM t_workingdoc WHERE workinguser LIKE '{0}';", glob.loggedUser); //Load listBox - working folder
db.LoadTextList(listBoxWorkDoc, "filename", sqlString);
TempFolderPath = db.GetRepozPath() + @"\\" + db.GetRepozName() + @"\\Temp"; //Delete repository temp folder
sy.ClearFolder(TempFolderPath);
listViewSupport.Items.Clear(); //Load suport requests
db.LoadVeiwListSupportRequests(listViewSupport);
//Load comboMsg with message subjects and sent-timestamp
comboMsgSubject.Text = null;
textBoxMsgFrom.Text = null;
textBoxMessageBody.Text = null;
sqlString = string.Format(@"SELECT * FROM t_msg WHERE project LIKE '{0}' AND receiver LIKE '{1}' AND deleted = 0;", glob.ProjectName, glob.loggedUser);
db.LoadComboMsgTopicTimesamp(comboMsgSubject, sqlString);
}
else
{
MessageBox.Show("No project selected");
}
}
else
{
MessageBox.Show("There are documents to be commited before exiting active project");
}
}