public InvoiceManagement()
{
InitializeComponent();
Column staffIDCol = DB.Tables.Where(t => t.Name == "Dog").First().Columns[1];
tbxClientID = (ValidatedTextbox)UIMethods.GenAppropriateElement(staffIDCol, out _);
tbxClientID.AddTextChangedEvent(TbxClientID_TextChanged);
tbxClientID.Text = "0";
tbxClientID.Margin = new Thickness(110, 5, 0, 0);
grd.Children.Add(tbxClientID);
}
public static FrameworkElement GenAppropriateElement(Column c, out string title, bool isPKeyEditable = false, bool containsSuggestedValue = false)
{
FrameworkElement elem;
title = c.Name;
// If the item displays a primary key, it is not editable by the user, so a label is used to display the data without it being editable
if (c.Constraints.IsPrimaryKey && !isPKeyEditable)
{
elem = new Label()
{
Content = "",
Margin = new Thickness(0, -5, 0, 0)
};
}
// An SQL bit is a boolean value, so a checkbox can be used to help prevent insertion of invalid data
else if (c.Constraints.Type == "bit")
{
elem = new CheckBox()
{
Margin = new Thickness(5, 0, 0, 0),
RenderTransform = new ScaleTransform(2, 2)
};
if (containsSuggestedValue)
{
((CheckBox)elem).IsChecked = (bool)GetSuggestedValue(c);
}
}
else if (c.Constraints.Type == "date")
{
elem = new ValidatedDatePicker(c)
{
Margin = new Thickness(5, 0, 0, 0),
FontSize = 16,
HorizontalAlignment = HorizontalAlignment.Left,
VerticalAlignment = VerticalAlignment.Top
};
}
else if (c.Name == "Appointment Type ID" && !c.Constraints.IsPrimaryKey)
{
elem = new ComboBox()
{
ItemsSource = DBMethods.MetaRequests.GetAllFromTable("Appointment Type").Select(x => x[3]),
Margin = new Thickness(5, 0, 0, 0)
};
title = "Appointment Type";
}
else if (c.Name == "Staff ID" && !c.Constraints.IsPrimaryKey)
{
elem = new ComboBox()
{
ItemsSource = DBMethods.MetaRequests.GetAllFromTable("Staff").Select(x => x[1]),
Margin = new Thickness(5, 0, 0, 0)
};
title = "Staff Member";
}
else if (c.Name == "Grooming Room ID" && !c.Constraints.IsPrimaryKey)
{
elem = new ComboBox()
{
ItemsSource = DBMethods.MetaRequests.GetAllFromTable("Grooming Room").Select(x => x[1]),
Margin = new Thickness(5, 0, 0, 0)
};
title = "Grooming Room";
}
// Otherwise, a text box is used to allow the user to enter data
else
{
elem = new ValidatedTextbox(c)
{
Margin = new Thickness(5, 0, 0, 0),
HorizontalAlignment = HorizontalAlignment.Left,
VerticalAlignment = VerticalAlignment.Top
};
// If the text box has the potential of containing a lot of data, double its height to allow the text it contains to be easier to read.
if (c.Constraints.Type == "varchar")
{
if (Convert.ToInt32(c.Constraints.MaxSize) > 50)
{
((ValidatedTextbox)elem).SetHeight(elem.Height * 2);
}
}
}
if (elem is ComboBox cmb && containsSuggestedValue)
{
cmb.SelectedIndex = 0;
}
if (elem is ValidatedItem item && containsSuggestedValue)
{
item.Text = GetSuggestedValue(c).ToString();
}
return(elem);
}
