private void Btn_delete_Click(object sender, EventArgs e)
{
if (!layerAccess.IsCanDelete(_frmMain.userID))
{
clsWin.WarningMessage("You dont have permition to access this form, please contact your administrator", "Access Denied");
return;
}
UnitModel um;
try
{
if (clsWin.QuestionMessage("Are you sure want to Delete this record?", "Confirm Delete"))
{
{
um = new UnitModel()
{
UnitCD = Txt_Unit_CD.Text,
UnitName = txt_Unit_Name.Text,
Comp = clsWin.GetComputerName(),
UserName = _frmMain.activeuser,
LastUpdate = DateTime.Now,
};
layer.DeleteUnit(um, id);
}
clsWin.SuccessMessage("Unit has been Delete", "Success");
Btn_refresh.PerformClick();
}
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
var exceptionMessage = string.Concat(errorMessages);
clsWin.ClearWindowsObJect(panelEx1);
clsWin.ErrorMessage((exceptionMessage).ToString(), "Oops");
Btn_refresh.PerformClick();
}
}
public bool DeleteUnit(UnitModel model, string id)
{
try
{
ExecuteCommand(cn =>
{
MySqlCommand cmd = new MySqlCommand(@"update unitModel set deleted=1
where uGUID=@id", cn);
cmd.Parameters.AddWithValue("id", id);
rst = cmd.ExecuteNonQuery();
});
if (rst == 1)
return true;
else
return false;
}
catch (Exception)
{
throw;
}
}
private void Btn_Save_Click(object sender, EventArgs e)
{
// BomContext db = new BomContext();
UnitModel um;
try
{
if (layer.GetUnitCD((Txt_Unit_CD.Text),id))
{
var exceptionMessage = "Unit Code already exist";
// clsWin.ClearWindowsObJect(panelEx1);
clsWin.ErrorMessage((exceptionMessage).ToString(), "Oops");
Txt_Unit_CD.Focus();
return;
}
if (clsWin.QuestionMessage("Are you sure want to save", "Save Unit"))
{
if (StatusEdit)
{
um = new UnitModel()
{
UnitCD = Txt_Unit_CD.Text,
UnitName = txt_Unit_Name.Text,
Comp = clsWin.GetComputerName(),
UserName = _frmMain.activeuser,
LastUpdate = DateTime.Now,
};
layer.UpdatetUnit(um,id);
}
else
{
um = new UnitModel()
{
uGUID = Guid.NewGuid().ToString(),
UnitCD = Txt_Unit_CD.Text.ToString(),
UnitName = txt_Unit_Name.Text.ToString(),
Comp = clsWin.GetComputerName(),
UserName = _frmMain.activeuser,
LastUpdate = DateTime.Now
};
//db.Units.Add(um);
layer.InSertUnit(um);
}
//db.SaveChanges();
clsWin.SuccessMessage("Unit has been saved", "Success");
Btn_refresh.PerformClick();
}
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
var exceptionMessage = string.Concat(errorMessages);
clsWin.ClearWindowsObJect(panelEx1);
clsWin.ErrorMessage((exceptionMessage).ToString(),"Oops");
Btn_refresh.PerformClick();
}
}
public bool UpdatetUnit(UnitModel model,string id)
{
try
{
ExecuteCommand(cn =>
{
MySqlCommand cmd = new MySqlCommand(@"update unitModel set UnitCD=@UnitCd,
UnitName=@Unitname,Comp=@Comp,UserName=@username
where uGUID=@id", cn);
cmd.Parameters.AddWithValue("id", id);
cmd.Parameters.AddWithValue("@UnitCd", model.UnitCD);
cmd.Parameters.AddWithValue("@Unitname", model.UnitName);
cmd.Parameters.AddWithValue("@Comp", model.Comp);
cmd.Parameters.AddWithValue("@username", model.UserName);
rst = cmd.ExecuteNonQuery();
});
if (rst == 1)
return true;
else
return false;
}
catch (Exception)
{
throw;
}
}