private void UpdateProjectButton_Click(object sender, RoutedEventArgs e)
{
try
{
// check for empty ness
CheckForEmpty(this.UpdateProjectGrid);
if (this.textboxstatus == false)
{
MessageBox.Show("A field has not been entered");
textboxstatus = false;
return;
}
DB1 = new DBManager();
Container Entity1 = new Container();
Entity1._project.project_id = DB1.GetProjects("SELECT * FROM projects WHERE project_name = '" + this.UpdateProjectProjectNameComboBox.SelectedItem.ToString() + "'").First().project_id;
Entity1._project.project_name = this.UpdateProjectProjectNameTextBox.Text;
Entity1._project.location = this.UpdateProjectLocationTextBox.Text;
Entity1._project.description = this.UpdateProjectDescriptionTextBox.Text;
Entity1._project.end_date = (DateTime)this.UpdateProjectEndDatePicker.SelectedDate;
Entity1._project.start_date = (DateTime)this.UpdateProjectStartDatePicker.SelectedDate;
// get the client
try
{
List<clients> cc = DB1.GetClients("");
var result = from item in cc
where item.client_name.ToLower().Contains(this.RegisterProjectClientTextBox.Text.ToLower())
select item;
if (result != null)
{
Entity1._project.client_id = Convert.ToInt32(((List<clients>)result.ToList()).First().client_id);
}
}
catch { }
if (DB1.UpdateProject(Entity1._project))
{
MessageBox.Show("Project Successfully updated");
EmptyAllfields(this.UpdateProjectGrid);
Initialization();
//this.UpdateProjectProjectNameComboBox = new ComboBox();
//ComboboxPopulating(this.UpdateProjectProjectNameComboBox, null);
}
}
catch { }
}
