public async Task <string> AddRestaurant(RestaurantTables table)
{
try
{
RestaurantTables res = new RestaurantTables();
res.Idrestaurant = table.Idrestaurant;
res.FloorName = table.FloorName;
res.CoordenateX = table.CoordenateX;
res.CoordenateY = table.CoordenateY;
res.AvarageUse = 0;
res.Type = table.Type;
res.Seats = table.Seats;
res.FloorIndex = table.FloorIndex;
res.TableName = table.TableName;
res.IsJoin = false;
_context.RestaurantTables.Add(res);
await _context.SaveChangesAsync();
return("Base de datos actualizada");
}
catch
{
return("Error. Hubo un error al actualizar la base de datos");
}
}
public static RestaurantTablesDTO Convert(RestaurantTables obj)
{
return(new RestaurantTablesDTO(obj.Id)
{
NoOfSeats = obj.NoOfSeats,
TableNumber = obj.TableNumber
});
}
public ActionResult GetRestaurantTableImage(int restaurantTableId)
{
CustomJsonResult result = new CustomJsonResult();
try
{
RestaurantTables restaurantTableImage = db.RestaurantTables.Where(r => r.Id == restaurantTableId).FirstOrDefault();
result.Data = restaurantTableImage;
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult UploadRestaurantTableImage(int restaurantTableId)
{
CustomJsonResult result = new CustomJsonResult();
try
{
string fileName = string.Empty;
string filePath = string.Empty;
string fileExtension = string.Empty;
string fileBase64 = string.Empty;
if (Request.Files.Count > 0)
{
fileName = Path.GetFileName(Request.Files[0].FileName);
filePath = Path.GetFullPath(Request.Files[0].FileName);
fileExtension = Path.GetExtension(Request.Files[0].FileName);
BinaryReader br = new BinaryReader(Request.Files[0].InputStream);
byte[] bytes = br.ReadBytes((int)Request.Files[0].InputStream.Length);
//Convert the Byte Array to Base64 Encoded string.
fileBase64 = Convert.ToBase64String(bytes, 0, bytes.Length);
result.Data = new { FileName = fileName, FileExtension = fileExtension, FileBase64 = fileBase64 };
}
RestaurantTables restaurantTableImage = db.RestaurantTables.Where(r => r.Id == restaurantTableId).FirstOrDefault();
if (restaurantTableImage != null)
{
restaurantTableImage.ImageName = fileName;
restaurantTableImage.ImageBase64 = fileBase64;
restaurantTableImage.ImageExtension = fileExtension;
db.SaveChanges();
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <string> UpdateRestaurant(RestaurantTables table)
{
try
{
var res = await _context.RestaurantTables
.Where(i => i.Idtables == table.Idtables).FirstAsync();
res.CoordenateX = table.CoordenateX;
res.CoordenateY = table.CoordenateY;
res.Seats = table.Seats;
res.TableName = table.TableName;
await _context.SaveChangesAsync();
return("Base de datos actualizada");
}
catch
{
return("Error. Hubo un error al actualizar la base de datos");
}
}
