public IActionResult Delete(int employeeId)
{
Employee emplToDel = repository.GetEmployee(employeeId);
try
{
repository.DeleteEmployee(employeeId);
}
catch (DbUpdateException ex)
{
MySql.Data.MySqlClient.MySqlException innerException = ex.InnerException.InnerException as MySql.Data.MySqlClient.MySqlException;
if (innerException != null && innerException.Number == 1451)
{
TempData["Error"] = $"Не удалось удалить сотрудника <b>{emplToDel.FullName}</b>: на него есть ссылки в других объектах";
return(RedirectToAction(nameof(List)));
}
else
{
throw;
}
}
catch
{
throw;
}
TempData["message"] = $"Сотрудник <b>{emplToDel.FullName}</b> успешно удалён.";
return(RedirectToAction(nameof(List)));
}
public IActionResult Delete(int resourceId)
{
Resource resourceToDel = repository.GetResource(resourceId);
try
{
repository.DeleteResource(resourceId);
}
catch (DbUpdateException ex)
{
MySql.Data.MySqlClient.MySqlException innerException = ex.InnerException.InnerException as MySql.Data.MySqlClient.MySqlException;
if (innerException != null && innerException.Number == 1451)
{
TempData["Error"] = $"Не удалось удалить ресурс <b>{resourceToDel.Name}</b>: на него есть ссылки в других объектах";
return(RedirectToAction(nameof(List)));
}
else
{
throw;
}
}
catch
{
throw;
}
TempData["message"] = $"<b>{resourceToDel.Name}</b> успешно удалён";
return(RedirectToAction("List"));
}
public static async void MySqlException(Window parent, MySql.Data.MySqlClient.MySqlException ex)
{
Logging.Exception(ex);
switch ((MySql.Data.MySqlClient.MySqlErrorCode)ex.Number)
{
case MySql.Data.MySqlClient.MySqlErrorCode.DuplicateKeyEntry:
var prompt = string.Format("An extension with the value '{0}' already exists in the database.", ((Extension)parent.DataContext).Number);
UserPrompts.PopupMessage(parent, prompt, "Duplicates Not Allowed");
break;
case MySql.Data.MySqlClient.MySqlErrorCode.NoDefaultForField:
UserPrompts.PopupMessage(parent, ex.Message, "Required Field Empty");
break;
case MySql.Data.MySqlClient.MySqlErrorCode.DataTooLong:
UserPrompts.PopupMessage(parent, ex.Message, "Data Too Long");
break;
case MySql.Data.MySqlClient.MySqlErrorCode.UnableToConnectToHost:
await UserPrompts.PopupDialog(parent, "Could not connect to the server.", "Connection Lost", DialogButtons.Default);
parent.Close();
break;
default:
UserPrompts.PopupMessage(parent, ex.Message, "Unexpected Database Error!");
break;
}
}
internal static string ErrorHandle(MySql.Data.MySqlClient.MySqlException ex)
{
string result = string.Empty;
if (ex.Number == 1062)
{
result = "Data Sudah Ada";
}
return(result);
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try{
EliminarCorredor();
}
catch (Exception excep)
{
if (excep.InnerException != null)
{
if (excep.InnerException.InnerException != null)
{
MySql.Data.MySqlClient.MySqlException exceptionMysql = (MySql.Data.MySqlClient.MySqlException)excep.InnerException.InnerException;
if (exceptionMysql.Number == 1451)
{
MessageBox.Show("No se puede eliminar el corredor porque ya tiene registros de carreras", "Atención");
}
}
}
}
}
internal static string MySqlErrorHandle(MySql.Data.MySqlClient.MySqlException ex)
{
string result = string.Empty;
switch (ex.Number)
{
case 1062:
result = "Data Is Exists ! / Duplicate";
break;
case 1451:
result = "Can't Change , Have Relation Data";
break;
default:
result = ex.Message;
break;
}
return(result);
}
internal static string MySqlErrorHandle(MySql.Data.MySqlClient.MySqlException ex)
{
string result = string.Empty;
switch (ex.Number)
{
case 1062:
result = "Data Duplikat";
break;
case 1451:
result = "Data Ini Memiliki Relasi Dengan Data Lain";
break;
default:
result = ex.Message;
break;
}
return(result);
}
internal static string ErrorHandle(MySql.Data.MySqlClient.MySqlException ex)
{
string result = string.Empty;
switch (ex.Number)
{
case 1062:
result = "Maaf, Data Sudah Ada";
break;
case 1451:
result = "Ada Relasi Dengan Table Lain";
break;
default:
result = ex.Message;
break;
}
return(result);
}
public MySqlEXP(string message, MySql.Data.MySqlClient.MySqlException mySqlEx)
: base(message)
{
_message = message;
_errorCode = mySqlEx.Number;
}
