I have a simple database over a hotel, this is for a cleaning service so I have a column named "status", this column has type int and are defined as 0 when a new room is added to database.
Problem is I would like the output of this column's value to be "Not cleaned" instead of "0". And "Cleaned" if the value is "1".
Any idea of how I can do this in the easiest way possible? I'm using Visual Studio 2015.
Thanks!
Assuming the database is storing these as a bit not an int you can do the following:
string Cleaned = row["status"]?"Cleaned":"Not Cleaned"
Then use the string as you wish.
If you want to actually change the DB, that takes more work, you'd have to create a new column (or change the existing one, even harder) for the string value as a VARCHAR(15) (only really need 11 but I pad to be safe) then update that based on the bit in your old column.
UPDATE {Table} SET {NewColumn}=IIF(status=1,'Cleaned','Not Cleaned')
Easiest Way, not the most correct design but the easiest
public enum RoomStatus : int
{
NotCleaned = 0,
Cleaned = 1
}
static void Main(string[] args)
{
var e1 = (RoomStatus)0;
var e2 = (RoomStatus)1;
}
I assume you are using entity framework and you are referencing storing an enum.
If this is correct, check this link: How to save enum in database as string
You need to use OLEDB connection after this you have to use SQL UPDATE command. This will look like this :
UPDATE your table name SET status='Cleaned' WHERE status=1;
