public async Task <IActionResult> Edit(int id, [Bind("Id,RoomId,Id,Min,Max")] ItemAssignment itemAssignment)
{
if (id != itemAssignment.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(itemAssignment);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ItemAssignmentExists(itemAssignment.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["Id"] = new SelectList(_context.Items, "Id", "Id", itemAssignment.ItemId);
ViewData["RoomId"] = new SelectList(_context.Rooms, "RoomId", "RoomId", itemAssignment.RoomId);
return(View(itemAssignment));
}
public async Task <IActionResult> Create([Bind("Id,Name")] Room room, string[] selectedItems, string[] selectedMins, string[] selectedMaxs)
{
room.RoomItems = new List <ItemAssignment>();
foreach (var item in selectedItems)
{
var key = int.Parse(item) - 1;
var minVal = int.Parse(selectedMins[key]);
var maxVal = int.Parse(selectedMaxs[key]);
var itemToAdd = new ItemAssignment
{
RoomId = room.Id,
ItemId = int.Parse(item),
Min = minVal,
Max = maxVal
};
room.RoomItems.Add(itemToAdd);
}
if (ModelState.IsValid)
{
_context.Add(room);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(room));
}
public async Task <IActionResult> Create([Bind("Id,RoomId,Id,Min,Max")] ItemAssignment itemAssignment)
{
if (ModelState.IsValid)
{
_context.Add(itemAssignment);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["Id"] = new SelectList(_context.Items, "Id", "Id", itemAssignment.ItemId);
ViewData["RoomId"] = new SelectList(_context.Rooms, "RoomId", "RoomId", itemAssignment.RoomId);
return(View(itemAssignment));
}
public ActionResult AssignmentSave(int[] ItemId)
{
ItemAssignmentRepository itemAssignmentRepo = new ItemAssignmentRepository();
List <ItemAssignment> lstItemAssignment = new List <ItemAssignment>();
foreach (int itemId in ItemId)
{
ItemAssignment itemAssign = new ItemAssignment
{
ItemId = itemId,
CompanyId = Sessions.CompanyId.Value
};
lstItemAssignment.Add(itemAssign);
}
itemAssignmentRepo.Save(lstItemAssignment);
return(RedirectToAction("Index"));
}
static void Main(string[] args)
{
ItemRepository itemRepo = new ItemRepository();
TransactionLogRepository transLogRepo = new TransactionLogRepository();
ItemAssignmentRepository itemAssignementRepo = new ItemAssignmentRepository();
CNGDBContext context = new CNGDBContext();
List <ItemDTO> lstItemDTO = new List <ItemDTO>();
const Int32 BufferSize = 128;
using (var fileStream = File.OpenRead(@"C:\fmt_inventory.csv"))
using (var streamReader = new StreamReader(fileStream, Encoding.UTF8, true, BufferSize))
{
String line;
int lineCnt = 1;
while ((line = streamReader.ReadLine()) != null)
{
//if (lineCnt > 3)
//{
string[] strLine = line.Split(',');
//string itemCode = Convert.ToString(strLine[0]);
string itemDesc = Convert.ToString(strLine[0]);
//int n;
//bool isNumeric = int.TryParse(itemCode, out n);
Item item = new Item();
//item.Code = itemCode.PadLeft(3, '0');
item.Description = Convert.ToString(strLine[0]);
item.TypeId = 2;
item.ClassificationId = 1;
item.Brand = "n/a";
item.UnitCost = Convert.ToDecimal(strLine[2]);
item.Active = true;
ItemDTO itemDTO = new ItemDTO();
itemDTO.item = item;
itemDTO.Quantity = Convert.ToInt32(strLine[1]);
itemDTO.CompanyId = 4;
itemDTO.UnitCost = item.UnitCost;
lstItemDTO.Add(itemDTO);
}
lineCnt++;
//}
}
//foreach (ItemDTO _itemDTO in lstItemDTO)
//{
// int itemid = itemRepo.SaveByEncoder(_itemDTO.item);
// TransactionLog transLog = new TransactionLog
// {
// ItemId = itemid,
// CompanyId = _itemDTO.CompanyId,//cng
// TransactionMethodId = 7, //in
// Date = Convert.ToDateTime("01/01/17"),
// Quantity = _itemDTO.Quantity,
// UserId = 1 //admin
// };
// transLogRepo.Add(transLog);
// Console.WriteLine("Added " + _itemDTO.item.Code + " - " + _itemDTO.item.Description);
//}
List <ItemAssignment> lstItemAssignment = new List <ItemAssignment>();
foreach (ItemDTO item in lstItemDTO)
{
int x = 0;
if (item.item.Id == 0)
{
x = itemRepo.GetItemId(item.item.Description);
}
else
{
x = item.item.Id;
}
ItemAssignment itemAssignment = context.ItemAssignments.FirstOrDefault(p => p.ItemId == x && p.CompanyId == 4);
itemAssignment.UnitCost = item.UnitCost;
context.SaveChanges();
//ItemAssignment itemAssignment = new ItemAssignment
//{
// ItemId = x,
// CompanyId = item.CompanyId,
// UnitCost = item.UnitCost//cng
//};
//lstItemAssignment.Add(itemAssignment);
}
//itemAssignementRepo.Save(lstItemAssignment);
Console.WriteLine("Done!");
Console.ReadLine();
}
