I am working with C# and I need to obtain the information of the manufacturer of the hard drives.
More specifically the name of the hard drive (or if possible if it is a hdd or m.2) as in the image.
I have already tried these two methods but none shows me that info.
Thank you
I am creating an api in PHP Laravel, I already come from C# and Entity Framework but there are things that I still don't understand how they work in Laravel.
I have this query:
People::with('user','rol','state','tower','apartament')->get()
and it brings me this information:
[
{
"id": 1,
"name": "User1",
"last_name": "lnUser1",
"phone": 3132835875,
"img_profile": null,
"floor": 4,
"user": {
"id": 1,
"email": "[email protected]",
"email_verified_at": null,
"created_at": null,
"updated_at": "2022-04-26T03:12:03.000000Z"
},
"rol": {
"id": 1,
"name": "Administrador"
},
"state": {
"id": 1,
"name": "Activo"
},
"tower": {
"id": 1,
"name": "A"
},
"apartament": {
"id": 116,
"name": "1206"
}
},
{
"id": 2,
"name": "User2",
"last_name": "lnUser2",
"phone": 3132835875,
"img_profile": null,
"floor": 2,
"user": {
"id": 2,
"email": "[email protected]",
"email_verified_at": null,
"created_at": null,
"updated_at": null
},
"rol": {
"id": 2,
"name": "Moderador"
},
"state": {
"id": 2,
"name": "Inactivo"
},
"tower": {
"id": 1,
"name": "A"
},
"apartament": {
"id": 116,
"name": "1206"
}
}
]
a list of users. but I need to show only a couple of data not everything. so build this query like this:
People::with('user','rol','state','tower','apartament')->select(DB::raw('CONCAT(name, " ", last_name) as name, phone, img_profile, floor'))->get()
and it brings me this response:
[
{
"name": "User1 lnUser1",
"phone": 3132835875,
"img_profile": null,
"floor": 4,
"user": null,
"rol": null,
"state": null,
"tower": null,
"apartament": null
},
{
"name": "User2 lnUser2",
"phone": 3132835875,
"img_profile": null,
"floor": 2,
"user": null,
"rol": null,
"state": null,
"tower": null,
"apartament": null
}
]
I have searched and found out but on all occasions it generates an error or problems with the query.
So I don't know how to select only the specific field(s) from the related tables (user, role, state, tower and apartment). I need an answer that comes like this:
[
{
"name": "User1 lnUser1",
"phone": 3132835875,
"img_profile": null,
"floor": 4,
"user_email": "[email protected]",
"rol_name": "Administrador",
"state_name": "Activo",
"tower_name": "A",
"apartament_number": "1206"
},
{
"name": "User2 lnUser2",
"phone": 3132835875,
"img_profile": null,
"floor": 2,
"user_email": "[email protected]",
"rol_name": "Moderador",
"state_name": "Inactivo",
"tower_name": "A",
"apartament_number": "1206"
}
]
I've been a couple of days and I can't find a way to generate a jwt token with Passport and I've tried everything, since this library doesn't work, it only works up to version 8: tymon/jwt-auth
I have been following a tutorial ( YouTube video ) but when creating the jwt I get a full object and not a token.
Code of the Login method in the AuthController
public function login(Request $request)
{
$loginData = $request->validate([
'email' => 'email|required',
'password' => 'required'
]);
if(!auth()->attempt($request->only('email','password'))){
return response()->json([
'status' => false,
'data' => [
'message'=>'No autorizado'
]
], 401);
}
$user = User::where('email', $request['email'])->FirstOrFail();
$token = $user->createToken('Token Name')->accessToken;
return response()->json([
'status' => true,
'data' => [
'message'=>$token
]
]);
}
and when I call it, it returns this response:
{
"status": true,
"data": {
"message": {
"name": "Token Name",
"abilities": [
"*"
],
"tokenable_id": 1,
"tokenable_type": "App\\Models\\User",
"updated_at": "2022-03-22T14:13:41.000000Z",
"created_at": "2022-03-22T14:13:41.000000Z",
"id": 6
}
}
}
My question is: is this line at the time of creating the token okay?
$token = $user->createToken('Token Name')->accessToken;
With what method can I generate a jwt bearer using passport?
I have a doubt with adding a custom field that is done in SQL but I don't know in linq.
In itself it is a select where I filter a user and group by Keyword... but I need to bring the keyword that is repeated the most, hence the count.
SELECT
UserID,
KeywordID,
COUNT(KeywordID) as count
FROM
LogKeywords lk
WHERE
UserID = 83
GROUP BY
KeywordID ;
That query brings me this:
I already have that in C#, but I don't know how to nail the count inside .Select().
My code in C# is like this:
var keyword = _context.LogKeywords
.Where(x => x.UserID == employee.UserID)
.Select(x => new
{
x.UserID,
x.Keyword.Name,
count = x.KeywordID.Count() //<--- aqui me aparece un error
})
.GroupBy(x => x.KeywordID);
Any ideas?
I am creating an API with php laravel and MySql; and I'm creating migrations and seeders. I have this table:
Schema::create('schedules', function (Blueprint $table) {
$table->engine='InnoDB';
$table->increments('schedule_id');
$table->date('time_to_open'); //<----- esta
$table->date('time_to_close'); //<----- y esta
$table->boolean('is_active');
$table->string('created_by');
$table->timestamps();
});
And I have two fields time_to_openand time_to_close, in those I am only interested in saving a time example: 22:00o 14:30o 07:40but I don't know how to put those fields only TIME because when I leave them DateTime or Date it brings me the information of the dates and that doesn't interest me here.
and be able to load the data from a seeder.
Thank you
I am creating an Api Rest cpn php Laravel, but I have a concern. I have 2 tables already related in MySql:
Model:
and in the controllers when consuming the method getof each one it goes like this:
return response()->json(Cliente::all(),200);
and the response in json is this:
[
{
"id": 1,
"nombre": "Prof. Kaitlin Kuhic",
"nit": "389531851",
"estado": 1
},
{
"id": 2,
"nombre": "Rosalinda Durgan",
"nit": "512817602",
"estado": 1
},
{
"id": 3,
"nombre": "Loren Tillman",
"nit": "11167177",
"estado": 2
}
]
And if I consume the getcontroller method of the status table I output this json:
return response()->json(Estado::all(),200);
Response in json:
[
{
"id": 1,
"nombre": "Activo"
},
{
"id": 2,
"nombre": "Inactivo"
}
]
What I want is for the json to come out like this:
[
{
"id": 1,
"nombre": "Prof. Kaitlin Kuhic",
"nit": "389531851",
"estado": [
{
"id": 1,
"nombre": "Activo"
}
]
},
{
"id": 2,
"nombre": "Rosalinda Durgan",
"nit": "512817602",
"estado": [
{
"id": 1,
"nombre": "Activo"
}
]
},
{
"id": 3,
"nombre": "Loren Tillman",
"nit": "11167177",
"estado": [
{
"id": 2,
"nombre": "Inactivo"
}
]
}
]
What I want is that when calling getpeople, the controller makes me a subquery in the status field and brings me the status of that Client.
I am using one IFinside a stored procedure :
CREATE PROCEDURE SP_Registro_Crear (IN paramero1 VARCHAR(50), IN Parametro2 INT)
BEGIN
IF (1 = 0) THEN
END IF;
END;
But I get the following error:
consulta SQL:
CREATE PROCEDURE SP_Registro_Crear (IN paramero1 VARCHAR(50), IN Parametro2 INT)
BEGIN
IF (1 = 0) THEN
END IF
MySQL ha dicho: Documentación
#1064 - Algo está equivocado en su sintax cerca 'END IF' en la linea 5
It's that I'm learning to make an api in phpLaravel but in the connections section in the file .envit asks me for the connection credentials to the DB and I don't know where to get the fields DB_HOSTand DB_PORTthe database from cpanel, the others yes I know how to get them out.
I have seen tutorials and documentation but I still don't know how to access that info from cpanel.
It's that I have a code for a page in PHP and it has many windows, and well, it has a menu, but it's not generic, it's that the menu is seen in window 1 and well, normal, but that same menu has to be seen in window 2 and 3. so I have to write again all the lines of code for the menu, and they are like 300 does not make sense... to that add that there are 30 windows.
So what I want is to create a single menu, and each time I create a window, consume it, with that, if I make any changes, I don't have to do it to all 30 windows, but to just 1 file.
I don't know if I made myself understand
I have this gallery of icons that I downloaded for my UWP project
https://www.nuget.org/packages/FontAwesome.UWP/
I need to Bind the Icon property so the xaml calls it like this:
xmlns:fa="using:FontAwesome.UWP"
and in the grid or in a stackpanel I call it like this:
<StackPanel>
<Viewbox>
<fa:FontAwesome Icon="Industry"/>
</Viewbox>
</StackPanel>
How can I make it bind, I thought that sending a string would work directly but not
I have an image serialized in an array of Bytes in C# - UWP, here is the post: How to serialize an image (bitmap) in bytes[ ] C# UWP?
but now I have to save it in a Database in SQL and I don't know what field to use for that.
Thank you
What happens is that I have an image captured from a PC folder
//Capturar imagen
//https://docs.microsoft.com/es-es/windows/uwp/files/quickstart-using-file-and-folder-pickers
var picker = new Windows.Storage.Pickers.FileOpenPicker();
picker.ViewMode = Windows.Storage.Pickers.PickerViewMode.Thumbnail;
picker.SuggestedStartLocation = Windows.Storage.Pickers.PickerLocationId.PicturesLibrary;
picker.FileTypeFilter.Add(".jpg");
picker.FileTypeFilter.Add(".jpeg");
picker.FileTypeFilter.Add(".png");
Windows.Storage.StorageFile file = await picker.PickSingleFileAsync();
if (file == null)
return;
After capturing it I show it in one <Image/>by means of Binding to the ViewModel from the XAML
<Image Source="{Binding CurrentImage, Mode=TwoWay}" Width="150" Height="150" HorizontalAlignment="Left"/>
and this is the code of the View Model, I create the property to which I am going to Bind:
public ImageSource CurrentImage { get { return currentImage; } set { Set(ref currentImage, value); } }
private ImageSource currentImage;
and inside the method it goes like this:
//Mostrar en <Image/>
//https://stackoverflow.com/questions/34214553/binding-image-source-to-page
var bitmap = new BitmapImage();
await bitmap.SetSourceAsync(await file.OpenReadAsync());
this.CurrentImage = bitmap;
Now what I need is to Serialize it in bytes to save it in the database and I have not been able to
I saw this video and it doesn't work for me, the Image property generates an error, it doesn't appear, I don't know if I have to import a library: https://www.youtube.com/watch?v=NUTdln165aw
I also looked at this Blog and it doesn't work for me, it won't let me import System.Drawing.Image: https://stackoverflow.com/questions/3801275/how-to-convert-image-to-byte-array
and I don't know how I could do the serialization in UWP with C#
I have a UWP app and I want to display images, but those images have to be saved in the database, I don't want to use a storage URL, I want to not de-serialize them, upload them serialized to the database and fetch and de-serialize them. I just don't know what type of field to use and what can be serialized.
I want to create a Datagrid to load a database query, using this example https://github.com/RSuter/MyToolkit/wiki/DataGrid but I don't understand exactly how to load the list.
but i found this code
<controls: DataGrid x:Name = "DataGrid" ItemsSource = "{Binding Plactas}" SelectedItem = "{Binding PlactaSelected, Mode = TwoWay}" DefaultOrderIndex = "0" SelectionMode = "Extended">
In the ViewModel I already have the list called Plactasand it shows the information, but I need only certain columns to appear.
The other thing is that I don't know what other option I have to create DataGrids
What happens is that I have a request, I have a Json but I need to capture the value, but I have to do it without using a Model, I have seen examples but they all handle models.
is it possible to deserialize without a model?
At the moment I am doing it like this:
Step 1:
I create the Json from PostMan
{
"CAMPO_EN_LA_TABLA": "valor que quiero capturar"
}
Step 2:
Create a Private model in the class, so you can serialize:
private class Parametros
{
[Key]
public int Empid { get; set; }
public string Codigo { get; set; }
[Column(TypeName = "sql_variant")]
public object Valor { get; set; }
}
Step 3:
I deserialize it like this in a Dictionary:
var listParametros = JsonConvert.DeserializeObject<Parametros>(valor.ToString());
Step 4:
And the last thing is to capture the value and save it in some parameter:
object ValorCapturado = listParametros.Valor;
Console.WriteLine("Este es el valor impreso: " + listParametros.Valor);
As you can see, I know how to deserialize, but in the requirements they ask me to do it without the Model, but I don't know how to map it like that
I have a table called City:
CREATE TABLE dbo.Ciudad(
Id varchar(36) NOT NULL,
DptId varchar(36) NOT NULL,
Nombre varchar(40) NOT NULL,
Version Timestamp NULL,
CreatedAt datetimeoffset NULL DEFAULT getdate(),
UpdatedAt datetimeoffset NULL,
Deleted bit NOT NUll DEFAULT(0),
CONSTRAINT [PK_Ciudad] PRIMARY KEY CLUSTERED (Id),
CONSTRAINT [FK_Ciudad_DptId] FOREIGN KEY (DptId) REFERENCES dbo.Dpto(Id)
)
The field UpdatedAthas to be updated every time an UPDATE is done on the record. How can I do it with a Trigger?
At the moment I only have this:
UPDATE:
CREATE TRIGGER dbo.tr_Ciudad_Update ON dbo.Ciudad AFTER UPDATE
AS
DECLARE @id as VARCHAR
BEGIN
RAISERROR(@id ,16,-1)
UPDATE Ciudad SET UpdatedAt = getdate() WHERE Id = @id;
END
DELETE
CREATE TRIGGER dbo.tr_Ciudad_Eliminar ON dbo.Ciudad INSTEAD OF DELETE
AS
DECLARE @id as VARCHAR
BEGIN
UPDATE Ciudad SET UpdatedAt = getdate(), Deleted = 1 WHERE Id = @id;
RAISERROR('CAMPO DELETED ACTUALIZADO A TRUE',16,-1)
ROLLBACK TRANSACTION
END
The idea is that the delete does not delete the record but it updates the field Deletedbut the Triggers do not work for me
is that I have a PUT and I want to capture the value of the field that I am going to update, but in the database in a SQL_Variantso to do so I have to send an object when sending it to the database, this is my PUT
[HttpPut("{empid}/{codigo}/{valor}")]
public async Task<IActionResult> Put(int empid, string codigo, [FromRoute]object valor)
{
try
{
return Ok(await repository.UpdateAsync(empid, codigo, valor));
}
catch (Exception e)
{
return BadRequest(e.ToString());
}
}
If I [FromRoute]object valorchange it to string or int here, it receives it correctly, but if I leave it in type Objectit will get Null and it doesn't work for me, how do I capture an object from the Controller route?
Hi, I have a table in SQL:
CREATE TABLE Parametros(
Empid int NOT NULL CONSTRAINT [FK_Parametros_Empid] REFERENCES Empresa(id),
Codigo varchar(25) NOT NULL,
Valor sql_variant NULL,
CONSTRAINT [PK_Parametros] PRIMARY KEY (Empid,Codigo))
And then I have to create the model of that table to work, and I don't know how to declare the 'value' column in the model.
Thank you
Hi, I have this property.
[Display(Name = "Codigo EAN-UCC", Description = "Codigo EAN-UCC para recaudos por codigo de barras", GroupName = "Tesoreria")]
public string TESORERIA_CODEANUCC
{ get { return (Get() == null ? "" : (string)Get()); } set { Set(value); RaisePropertyChanged(); } }
How can I capture the 'Description', 'GroupName', or 'Name' labels to save them in a field or display them on the screen in a message?
I don't know if the question is well formulated, I accept modifications
I have a ComboBox, which already has some items assigned, loaded by means of an enumeration (Enum):
public enum TERCERO_TIPOID : byte {
[Display(Name = "Nit")]NIT,
[Display(Name = "Cedula Cuidadania")]CC,
[Display(Name = "Cedula Extranjeria")]CE,
[Display(Name = "Pasaporte")]PASAPORTE,
[Display(Name = "Tarjeta Extranjeria")]TAR_EXT,
[Display(Name = "Doc. Id Extranjeria")]DOCID_EXT,
[Display(Name = "Tarjeta Identidad")]TAR_IDEN,
[Display(Name = "Nuip")]NUIP,
[Display(Name = "Codigo")]COD,
[Display(Name = "Otros")]OTRO = 9 }
In the comboBox it already shows me the DataAnotation of the name, so far so good, but in the database when I query the People table there is a field called "TipoDoc" which by requirements is a bit field, therefore when loading TipoDoc brings me a number from 1 to 9 no more, but I need the comboBox to load the type of document it has when loading a user.
If I do it, for example with a Combo_Tipo.SelectedIndex = 3;the comboBox will select the third in the "Passport" enumeration, but I need the ComboBox to be selected with the value, instead of using the SelectedIndex use the SelectedValue. That when giving it, for example Combo_Tipo.SelectedValue = "Nit";, I leave the type of NIT document selected.
But when I do it, he doesn't let me do it. How do I do it? What am I doing wrong?
The SelectedIndex captures me and assigns me the value in the combo.
The SelectedValue only captures the Combo data but does not assign it to me when I need it.
Combo:
<ComboBox Header="Tipo Documento:" Width="150" HorizontalAlignment="Center" VerticalAlignment="Top" x:Name="Combo_TipoDoc" SelectedItem="{Binding Tipoid, Mode=TwoWay}" />
and this is the Object in the field in the VM:
public TERCERO_TIPOID Tipoid { get => tipoid; set { tipoid = value; RaisePropertyChanged(); } }
private TERCERO_TIPOID tipoid;
and so I load it in the codeBehind of the XAML window, that isTerceroPage.xaml.cs
this.Combo_TipoDoc.ItemsSource = Enum.GetValues(typeof(TERCERO_TIPOID)).Cast<TERCERO_TIPOID>();