public OrderDetailViewModel Create(OrderDetailViewModel input)
{
try
{
decimal totalOrderAmount = 0.00M;
var documentNumber = _documentSequenceService.GetDocumentNumber(DocumentType.Order);
var newOrder = new Order()
{
CustomerContactNumber = input.Order.CustomerContactNumber,
CustomerName = input.Order.CustomerName,
OrderAmount = input.Order.OrderAmount,
OrderDate = (input.Order.OrderDate == null ? DateTime.Now : input.Order.OrderDate.GetValueOrDefault()),
OrderId = Guid.NewGuid().ToString(),
OrderNumber = documentNumber,
OrderStatus = OrderStatus.NewOrder,
OrderTakenBy = _userInfo.UserId,
OrderType = input.Order.OrderType,
CreatedBy = _userInfo.UserId,
CreatedOn = DateTime.Now
};
_databaseContext.Orders.Add(newOrder);
foreach (var item in input.OrderLines)
{
var addedItem = _databaseContext.Items.Where(x => x.ItemId == item.ItemId).FirstOrDefault();
if (addedItem != null)
{
totalOrderAmount = totalOrderAmount + (item.OrderQuantity * addedItem.ItemCharge);
}
var newOrderLine = new OrderLine()
{
CreatedBy = _userInfo.UserId,
CreatedOn = DateTime.Now,
ItemId = item.ItemId,
OrderId = newOrder.OrderId,
OrderLineId = Guid.NewGuid().ToString(),
OrderQuantity = item.OrderQuantity
};
_databaseContext.OrderLines.Add(newOrderLine);
}
_databaseContext.SaveChanges();
var order = _databaseContext.Orders.Include(x => x.OrderLines).Where(x => x.OrderId == newOrder.OrderId).FirstOrDefault();
order.OrderAmount = totalOrderAmount;
_databaseContext.Orders.Update(order);
_databaseContext.SaveChanges();
input.Order.OrderNumber = documentNumber;
input.Order.OrderId = newOrder.OrderId;
return(input);
}
catch (Exception ex)
{
throw ex;
}
}
public string Create(ImageViewModel input)
{
try
{
var newImage = new Image()
{
ImageId = Guid.NewGuid().ToString(),
ImageContent = input.ImageContent,
Length = input.Length,
ImageType = input.ImageType,
ParentId = input.ParentId,
CreatedBy = _userInfo.UserId,
CreatedOn = DateTime.Now
};
_databaseContext.Images.Add(newImage);
_databaseContext.SaveChanges();
return(newImage.ImageId);
}
catch (Exception ex)
{
throw ex;
}
}
public ItemViewModel Create(ItemViewModel input)
{
try
{
var newItem = new Item()
{
ItemId = Guid.NewGuid().ToString(),
ItemName = input.ItemName,
ItemCharge = input.ItemCharge,
CreatedBy = _userInfo.UserId,
CreatedOn = DateTime.Now
};
_databaseContext.Items.Add(newItem);
_databaseContext.SaveChanges();
input.ItemId = newItem.ItemId;
return(input);
}
catch (Exception ex)
{
throw ex;
}
}
public UserViewModel Create(UserInputViewModel input)
{
try
{
var newUser = new User()
{
UserId = Guid.NewGuid().ToString(),
FirstName = input.FirstName,
LastName = input.LastName,
UserName = input.UserName,
Password = input.Password,
UserType = input.UserType,
CreatedBy = _userInfo.UserId,
CreatedOn = DateTime.Now
};
_databaseContext.Users.Add(newUser);
_databaseContext.SaveChanges();
return(new UserViewModel()
{
UserId = newUser.UserId,
FirstName = newUser.FirstName,
LastName = newUser.LastName,
UserName = newUser.UserName,
UserType = newUser.UserType
});
}
catch (Exception ex)
{
throw ex;
}
}
public string GetDocumentNumber(DocumentType documentType)
{
DateTime currentDate = DateTime.Now;
var documentSequence = _databaseContext.DocumentSequences.Where(x => x.DocumentType == documentType).FirstOrDefault();
if (documentSequence == null)
{
documentSequence = Initialize(documentType);
}
var runningSequence = documentSequence.CurrentSequenceNumber + 1;
documentSequence.CurrentSequenceNumber = runningSequence;
_databaseContext.DocumentSequences.Update(documentSequence);
_databaseContext.SaveChanges();
string zeroAppender = "D" + documentSequence.SequenceLength;
string monthPrefix = currentDate.Day.ToString("D2") + currentDate.Month.ToString("D2") + currentDate.Year.ToString();
string documentNumber = documentSequence.DocumentPrefix + monthPrefix + "-" + runningSequence.ToString(zeroAppender);
return(documentNumber);
}
public KitchenViewModel Create(KitchenViewModel input)
{
try
{
var newKitchen = new Kitchen()
{
KitchenId = Guid.NewGuid().ToString(),
CounterNumber = input.CounterNumber,
CreatedBy = _userInfo.UserId,
CreatedOn = DateTime.Now
};
_databaseContext.Kitchens.Add(newKitchen);
_databaseContext.SaveChanges();
input.KitchenId = newKitchen.KitchenId;
return(input);
}
catch (Exception ex)
{
throw ex;
}
}
public static void EnsurePopulated(IApplicationBuilder app)
{
var scope = app.ApplicationServices.CreateScope();
KitchenKanbanDB context = scope.ServiceProvider.GetRequiredService <KitchenKanbanDB>();
if (!context.Users.Any())
{
context.Users.AddRange(
new User
{
UserId = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
FirstName = "Kitchen",
LastName = "Administrator",
UserName = "******",
Password = "******",
UserType = UserType.Administrator
}
);
context.SaveChanges();
}
if (!context.DocumentSequences.Any())
{
context.DocumentSequences.AddRange(
new DocumentSequence
{
DocumentSequenceId = Guid.NewGuid().ToString(),
CurrentSequenceNumber = 0,
DocumentPrefix = "",
DocumentType = DocumentType.Order,
SequenceLength = 4,
SequenceNumberLastResetOn = DateTime.Now
});
context.SaveChanges();
}
if (!context.Kitchens.Any())
{
context.Kitchens.AddRange(
new Kitchen
{
KitchenId = Guid.NewGuid().ToString(),
CounterNumber = "Counter 001",
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
}
);
context.SaveChanges();
}
if (!context.Items.Any())
{
string baseDirectory = AppDomain.CurrentDomain.BaseDirectory;
string fileName = Path.Combine(baseDirectory, @"SeederImages\1.jpg");
System.Drawing.Image image1 = System.Drawing.Image.FromFile(fileName);
var originalImage = ImageToByteArray(image1);
var iconResized = ImageToByteArray(ImageResizer.ResizeImage(image1, new Size(50, 50)));
var originalSizeImage = new Models.Image()
{
ImageId = Guid.NewGuid().ToString(),
ImageContent = originalImage,
ImageType = Models.Enums.ImageEnum.ImageType.Original,
Length = originalImage.Length,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
};
context.Images.Add(originalSizeImage);
var iconSizeImage = new Models.Image()
{
ImageId = Guid.NewGuid().ToString(),
ImageContent = iconResized,
ImageType = Models.Enums.ImageEnum.ImageType.Icon,
Length = iconResized.Length,
ParentId = originalSizeImage.ImageId,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
};
context.Images.Add(iconSizeImage);
context.Items.Add(
new Item
{
ItemId = Guid.NewGuid().ToString(),
ItemName = "Beef Short Rib with Pepper and Onion",
ItemCharge = 75.50M,
ImageId = originalSizeImage.ImageId,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
}
);
fileName = Path.Combine(baseDirectory, @"SeederImages\2.jpg");
image1 = System.Drawing.Image.FromFile(fileName);
originalImage = ImageToByteArray(image1);
iconResized = ImageToByteArray(ImageResizer.ResizeImage(image1, new Size(50, 50)));
originalSizeImage = new Models.Image()
{
ImageId = Guid.NewGuid().ToString(),
ImageContent = originalImage,
ImageType = Models.Enums.ImageEnum.ImageType.Original,
Length = originalImage.Length,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
};
context.Images.Add(originalSizeImage);
iconSizeImage = new Models.Image()
{
ImageId = Guid.NewGuid().ToString(),
ImageContent = iconResized,
ImageType = Models.Enums.ImageEnum.ImageType.Icon,
Length = iconResized.Length,
ParentId = originalSizeImage.ImageId,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
};
context.Images.Add(iconSizeImage);
context.Items.Add(
new Item
{
ItemId = Guid.NewGuid().ToString(),
ItemName = "Crispy Skin Barramundi",
ItemCharge = 60.50M,
ImageId = originalSizeImage.ImageId,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
}
);
fileName = Path.Combine(baseDirectory, @"SeederImages\3.jpg");
image1 = System.Drawing.Image.FromFile(fileName);
originalImage = ImageToByteArray(image1);
iconResized = ImageToByteArray(ImageResizer.ResizeImage(image1, new Size(50, 50)));
originalSizeImage = new Models.Image()
{
ImageId = Guid.NewGuid().ToString(),
ImageContent = originalImage,
ImageType = Models.Enums.ImageEnum.ImageType.Original,
Length = originalImage.Length,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
};
context.Images.Add(originalSizeImage);
iconSizeImage = new Models.Image()
{
ImageId = Guid.NewGuid().ToString(),
ImageContent = iconResized,
ImageType = Models.Enums.ImageEnum.ImageType.Icon,
Length = iconResized.Length,
ParentId = originalSizeImage.ImageId,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
};
context.Images.Add(iconSizeImage);
context.Items.Add(
new Item
{
ItemId = Guid.NewGuid().ToString(),
ItemName = "Scallops with Turnips",
ItemCharge = 50.00M,
ImageId = originalSizeImage.ImageId,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
}
);
fileName = Path.Combine(baseDirectory, @"SeederImages\4.jpg");
image1 = System.Drawing.Image.FromFile(fileName);
originalImage = ImageToByteArray(image1);
iconResized = ImageToByteArray(ImageResizer.ResizeImage(image1, new Size(50, 50)));
originalSizeImage = new Models.Image()
{
ImageId = Guid.NewGuid().ToString(),
ImageContent = originalImage,
ImageType = Models.Enums.ImageEnum.ImageType.Original,
Length = originalImage.Length,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
};
context.Images.Add(originalSizeImage);
iconSizeImage = new Models.Image()
{
ImageId = Guid.NewGuid().ToString(),
ImageContent = iconResized,
ImageType = Models.Enums.ImageEnum.ImageType.Icon,
Length = iconResized.Length,
ParentId = originalSizeImage.ImageId,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
};
context.Images.Add(iconSizeImage);
context.Items.Add(
new Item
{
ItemId = Guid.NewGuid().ToString(),
ItemName = "Toffee Apple",
ItemCharge = 10.00M,
ImageId = originalSizeImage.ImageId,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
}
);
fileName = Path.Combine(baseDirectory, @"SeederImages\5.jpg");
image1 = System.Drawing.Image.FromFile(fileName);
originalImage = ImageToByteArray(image1);
iconResized = ImageToByteArray(ImageResizer.ResizeImage(image1, new Size(50, 50)));
originalSizeImage = new Models.Image()
{
ImageId = Guid.NewGuid().ToString(),
ImageContent = originalImage,
ImageType = Models.Enums.ImageEnum.ImageType.Original,
Length = originalImage.Length,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
};
context.Images.Add(originalSizeImage);
iconSizeImage = new Models.Image()
{
ImageId = Guid.NewGuid().ToString(),
ImageContent = iconResized,
ImageType = Models.Enums.ImageEnum.ImageType.Icon,
Length = iconResized.Length,
ParentId = originalSizeImage.ImageId,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
};
context.Images.Add(iconSizeImage);
context.Items.Add(
new Item
{
ItemId = Guid.NewGuid().ToString(),
ItemName = "Lamb, Peas and Mint",
ItemCharge = 10.00M,
ImageId = originalSizeImage.ImageId,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
}
);
fileName = Path.Combine(baseDirectory, @"SeederImages\6.jpg");
image1 = System.Drawing.Image.FromFile(fileName);
originalImage = ImageToByteArray(image1);
iconResized = ImageToByteArray(ImageResizer.ResizeImage(image1, new Size(50, 50)));
originalSizeImage = new Models.Image()
{
ImageId = Guid.NewGuid().ToString(),
ImageContent = originalImage,
ImageType = Models.Enums.ImageEnum.ImageType.Original,
Length = originalImage.Length,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
};
context.Images.Add(originalSizeImage);
iconSizeImage = new Models.Image()
{
ImageId = Guid.NewGuid().ToString(),
ImageContent = iconResized,
ImageType = Models.Enums.ImageEnum.ImageType.Icon,
Length = iconResized.Length,
ParentId = originalSizeImage.ImageId,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
};
context.Images.Add(iconSizeImage);
context.Items.Add(
new Item
{
ItemId = Guid.NewGuid().ToString(),
ItemName = "Bombe Alaska",
ItemCharge = 15.25M,
ImageId = originalSizeImage.ImageId,
CreatedBy = "95632324-a9f8-44ba-9b3d-4c90dd5d9650",
CreatedOn = DateTime.Now
}
);
context.SaveChanges();
}
}