public static void LoadComboBoxByCabinet(ComboBox cmbBox, Cabinet cabinet, DataBaseDataContext connection) { IQueryable <MemberCabinet> myQuery = connection.MemberCabinets. Where(a => a.Cabinet == cabinet); cmbBox.Items.Clear(); foreach (var item in myQuery) { cmbBox.Items.Add(item); } if (!myQuery.Any()) { cmbBox.Items.Add("یک آیتم به ثبت برسانید"); cmbBox.SelectedIndex = 0; return; } cmbBox.SelectedIndex = 0; }
public static void Delete(Cabinet cabinet, DataBaseDataContext connection) { connection.Cabinets.DeleteOnSubmit(cabinet); connection.SubmitChanges(); }