public HandlerCode FindHandlerCode(string Code)
{
string findSQL = listSQL + " Where Code = '" + Code + "'";
HandlerCode handlerCode = _db.QuerySingle <HandlerCode>(findSQL);
return(handlerCode);
}
public HandlerCode DeleteHandlerCode(HandlerCode entity)
{
string mySQL = "DELETE[dbo].[TM_HANDLERS_CODE] " +
$" WHERE[CODE] = @{nameof(entity.Code)}";
int rowsAffected = _db.Execute(mySQL, entity);
return(entity);
}
public HandlerCode EditHandlerCode(HandlerCode entity)
{
string mySQL = "UPDATE[dbo].[TM_HANDLERS_CODE] SET[CODE] = '" + entity.Code + "'" +
",[DESCR] = '" + entity.Descr + "'" +
$" WHERE[CODE] = @{nameof(entity.Code)}";
int rowsAffected = _db.Execute(mySQL, entity);
return(entity);
}
public CreateHandlerCodeVM InsertHandlerCode(CreateHandlerCodeVM ThisHandlerCode)
{
var insertHandlerCode = new HandlerCode()
{
Code = ThisHandlerCode.Code,
Descr = ThisHandlerCode.Descr
};
_handlerCodesRepo.InsertHandlerCode(insertHandlerCode);
return(ThisHandlerCode);
}
public DeleteHandlerCodeVM DeleteHandlerCode(DeleteHandlerCodeVM ThisHandlerCode)
{
var deleteHandlerCode = new HandlerCode()
{
Code = ThisHandlerCode.Code,
Descr = ThisHandlerCode.Descr
};
_handlerCodesRepo.DeleteHandlerCode(deleteHandlerCode);
return(ThisHandlerCode);
}
public EditHandlerCodeVM EditHandlerCode(EditHandlerCodeVM ThisHandlerCode)
{
var updateHandlerCode = new HandlerCode()
{
Code = ThisHandlerCode.Code,
Descr = ThisHandlerCode.Descr
};
_handlerCodesRepo.EditHandlerCode(updateHandlerCode);
return(ThisHandlerCode);
}
public HandlerCode InsertHandlerCode(HandlerCode entity)
{
string mySQL = "INSERT INTO [TM_HANDLERS_CODE] ([CODE],[DESCR]) VALUES " +
"('" + entity.Code + "','" + entity.Descr.ToString() + "')";
int rowsAffected = _db.Execute(mySQL);
if (rowsAffected == 0)
{
throw new Exception($"Record Not Inserted: {entity.Code}");
}
return(entity);
}
public HandlerCode SaveType(HandlerCode entity)
{
throw new NotImplementedException();
}
