public bool AlreadyContainsMapping(DetailMachine dm) { using (var con = new MySqlConnection(connection)) { return(con.Query <int>("select 1 from detailmachine where MachineId=@m AND DetailId=@d", new { m = dm.MachineId, d = dm.DetailId }).Any()); } }
public void Insert(DetailMachine dm) { using (var con = new MySqlConnection(connection)) { con.Execute("INSERT INTO detailmachine (MachineId,DetailId,Qty) VALUES(@m,@d,@q)", new { m = dm.MachineId, d = dm.DetailId, q = dm.Qty }); } }
private void btnAdd_Click(object sender, EventArgs e) { if (SelectedMachine == null) { MessageHelper.DisplayError("Machine is not selected!"); return; } if (Details != null && Details.Any()) { _detailMachineRepo.Insert(SelectedMachine.Id, Details); this.TryCloseFrom(); return; } if (SelectedDetail == null) { MessageHelper.DisplayError("Detail is not selected"); return; } var model = new DetailMachine { Qty = (int)nupQty.Value, MachineId = SelectedMachine.Id, DetailId = SelectedDetail.Id }; if (_detailMachineRepo.AlreadyContainsMapping(model)) { MessageHelper.DisplayError("This detail is already mapped for this machine"); return; } _detailMachineRepo.Insert(model); this.TryCloseFrom(); }