private void FillArtistsInComboBox()
{
PersonGroupTableAdapter personGroupAdapter = new PersonGroupTableAdapter(dataBase);
PersonGroupDataSet.PersonGroupDataTable personGroupDataTable = personGroupAdapter.GetData();
foreach (PersonGroupDataSet.PersonGroupRow row in personGroupDataTable)
{
ComboBoxName.Items.Add(row.Name);
}
//ComboBoxName.ItemsSource = personGroupDataTable;
//ComboBoxName.DisplayMemberPath = "Name";
//ComboBoxName.SelectedValuePath = "Name";
if (participant.Name != null)
{
ComboBoxName.Text = participant.Name;
}
else
{
ComboBoxName.Text = "";
}
UpdateWindowState();
}
public FormLoanProperties(DataBase dataBase, LoanedCDDataSet.LoanedCDRow loanedCD)
: this()
{
loanedCDRow = loanedCD;
CDTableAdapter cdta = new CDTableAdapter(dataBase);
PersonGroupTableAdapter personGroupta = new PersonGroupTableAdapter(dataBase);
CDDataSet.CDDataTable cd = cdta.GetDataById(loanedCDRow.CDID);
PersonGroupDataSet.PersonGroupDataTable personGroup = personGroupta.GetDataById(cd[0].ArtistID);
textBoxArtist.Text = personGroup[0].Name;
textBoxTitle.Text = cd[0].Title;
comboBoxLoanedTo.Text = loanedCDRow.LoanedTo;
checkBoxActivateBringBack.Checked = !loanedCDRow.IsReturnDateNull();
if (!loanedCDRow.IsReturnDateNull())
{
dateTimePickerBringBack.Value = loanedCDRow.ReturnDate;
}
if (!loanedCDRow.IsLoanedDateNull())
{
dateTimePickerLoaned.Value = loanedCDRow.LoanedDate;
}
textBoxComment.Text = loanedCDRow.Comment;
}
private void FillList()
{
LoanedCDTableAdapter ta = new LoanedCDTableAdapter(dataBase);
LoanedCDDataSet.LoanedCDDataTable dt = ta.GetData();
CDTableAdapter cdta = new CDTableAdapter(dataBase);
PersonGroupTableAdapter personGroupta = new PersonGroupTableAdapter(dataBase);
tableLoanedCDs.TableModel.Rows.Clear();
foreach (LoanedCDDataSet.LoanedCDRow loanedCDRow in dt)
{
string artist;
string title;
CDDataSet.CDDataTable cd = cdta.GetDataById(loanedCDRow.CDID);
if (cd.Count == 0) // CD wurde wohl gelöscht
{
artist = "<" + StringTable.Deleted + ">";
title = "<" + StringTable.Deleted + ">";
}
else
{
PersonGroupDataSet.PersonGroupDataTable personGroup = personGroupta.GetDataById(cd[0].ArtistID);
artist = personGroup[0].Name;
title = cd[0].Title;
}
XPTable.Models.Row newRow = new XPTable.Models.Row();
newRow.Cells.Add(new XPTable.Models.Cell(artist));
newRow.Cells.Add(new XPTable.Models.Cell(title));
newRow.Cells.Add(new XPTable.Models.Cell(loanedCDRow.LoanedTo));
newRow.Cells.Add(new XPTable.Models.Cell(loanedCDRow.LoanedDate.ToShortDateString()));
if (!loanedCDRow.IsReturnDateNull())
{
if (loanedCDRow.ReturnDate <= DateTime.Now)
{
newRow.ForeColor = Color.Red;
}
newRow.Cells.Add(new XPTable.Models.Cell(loanedCDRow.ReturnDate.ToShortDateString()));
}
else
{
newRow.Cells.Add(new XPTable.Models.Cell(""));
}
newRow.Cells.Add(new XPTable.Models.Cell(loanedCDRow.Comment));
newRow.Tag = loanedCDRow;
tableLoanedCDs.TableModel.Rows.Add(newRow);
}
UpdateWindowState();
}
private void FormDeleteExistingArtist_Load(object sender, EventArgs e)
{
PersonGroupTableAdapter ta = new PersonGroupTableAdapter(dataBase);
PersonGroupDataSet.PersonGroupDataTable personGroups = new PersonGroupDataSet.PersonGroupDataTable();
ta.Fill(personGroups);
foreach (PersonGroupDataSet.PersonGroupRow personGroup in personGroups)
{
if (personGroup.Name != personGroupToDelete.Name)
{
comboBoxArtists.Items.Add(personGroup.Name);
}
}
label1.Text = string.Format(label1.Text, personGroupToDelete.Name);
}
private void FillArtistsInComboBox()
{
Cursor.Current = Cursors.WaitCursor;
PersonGroupTableAdapter personGroupAdapter = new PersonGroupTableAdapter(dataBase);
PersonGroupDataSet.PersonGroupDataTable personGroupDataTable = personGroupAdapter.GetData();
comboBoxName.DataSource = personGroupDataTable;
comboBoxName.DisplayMember = "Name";
comboBoxName.ValueMember = "Name";
Cursor.Current = Cursors.Default;
if (participant.Name != null)
{
comboBoxName.Text = participant.Name;
}
else
{
comboBoxName.Text = "";
}
UpdateWindowState();
}
/// <summary>
/// Speichert die Person/Gruppe.
/// </summary>
/// <param name="db"></param>
public void Save(DataBase dataBase)
{
SqlCeTransaction trans = dataBase.Connection.BeginTransaction(IsolationLevel.ReadCommitted);
Big3.Hitbase.DataBaseEngine.PersonGroupDataSetTableAdapters.PersonGroupTableAdapter pgta = new Big3.Hitbase.DataBaseEngine.PersonGroupDataSetTableAdapters.PersonGroupTableAdapter(dataBase);
pgta.Transaction = trans;
PersonGroupDataSet.PersonGroupDataTable dt = pgta.GetDataById(id);
PersonGroupDataSet.PersonGroupRow row = null;
bool isNew = false;
int personGroupId = 0;
if (dt.Rows.Count == 1)
{
row = dt[0];
personGroupId = dt[0].PersonGroupID;
}
else
{
row = dt.NewPersonGroupRow();
isNew = true;
}
row.Name = Name;
row.SaveAs = SaveAs;
row.Type = (int)Type;
row.Sex = (int)Sex;
row.Country = Country;
row.BirthDay = Birthday;
row.DayOfDeath = DayOfDeath;
row.ImageFilename = ImageFilename;
row.URL = Homepage;
row.Comment = Comment;
if (isNew)
{
dt.AddPersonGroupRow(row);
}
pgta.Update(dt);
if (isNew)
{
personGroupId = (int)(decimal)dataBase.ExecuteScalar("SELECT @@IDENTITY", trans);
}
// Urls speichern
string sql = string.Format("DELETE FROM Url Where ReferenceID = {0}", personGroupId);
dataBase.ExecuteScalar(sql);
UrlDataSetTableAdapters.UrlTableAdapter urlta = new UrlDataSetTableAdapters.UrlTableAdapter(dataBase);
urlta.Transaction = trans;
UrlDataSet.UrlDataTable urlDataTable = new UrlDataSet.UrlDataTable();
foreach (Url url in Urls)
{
urlDataTable.AddUrlRow(personGroupId, 0, url.UrlType, url.Link);
}
urlta.Update(urlDataTable);
// Jetzt noch die Mitwirkenden der Gruppe
sql = string.Format("DELETE FROM GroupParticipant Where PersonGroupID = {0}", personGroupId);
dataBase.ExecuteScalar(sql);
GroupParticipantDataSetTableAdapters.GroupParticipantTableAdapter participantTableAdapter = new GroupParticipantDataSetTableAdapters.GroupParticipantTableAdapter(dataBase);
participantTableAdapter.Transaction = trans;
GroupParticipantDataSet.GroupParticipantDataTable participantsDataTable = new GroupParticipantDataSet.GroupParticipantDataTable();
foreach (GroupParticipant gp in this.Participants)
{
if (!string.IsNullOrEmpty(gp.Name))
{
int participantId = dataBase.GetPersonGroupByName(gp.Name, true).ID;
int roleId = dataBase.GetRoleByName(gp.Role, true).RoleID;
participantsDataTable.AddGroupParticipantRow(personGroupId, participantId, roleId, gp.Begin == null ? "" : gp.Begin, gp.End == null ? "" : gp.End);
}
}
participantTableAdapter.Update(participantsDataTable);
trans.Commit();
}
