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();
}
