public async Task <IActionResult> Edit(int id, GoodsReceivedNote goodsReceivedNote)
{
if (id != goodsReceivedNote.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
goodsReceivedNote.UpdateAt = DateTime.Now;
_context.Update(goodsReceivedNote);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!GoodsReceivedNoteExists(goodsReceivedNote.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
var supplier = _context.Suppliers.Select(i => i.Name).ToList();
ViewData["IdSupplier"] = new SelectList(_context.Suppliers, "Id", "Name", supplier);
return(View(goodsReceivedNote));
}
public IHttpActionResult PostGoodsReceivedNote(GoodsReceivedNote goodsReceivedNote)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.GoodsReceivedNotes.Add(goodsReceivedNote);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (GoodsReceivedNoteExists(goodsReceivedNote.RecNoteID))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = goodsReceivedNote.RecNoteID }, goodsReceivedNote));
}
public async Task <HttpResult <bool> > AddGoodsReceivedNote(GoodsReceivedNote note, CancellationToken token = default(CancellationToken))
{
var result = new HttpResult <bool>();
var model = new WebApiServer.Controllers.Note.ViewModel.AddGoodsReceivedNote
{
DocumentId = note.DocumentId,
InvoiceId = note.InvoiceId,
IssueDate = note.IssueDate,
NoteEntry = note
.NoteEntry
.Select(ne => new WebApiServer.Controllers.Note.ViewModel.NoteEntry
{
Location = new Common.DTO.Location
{
Id = ne.Location.Id,
Name = ne.Location.Name
},
Name = ne.Name
})
.ToList(),
ReceiveDate = note.ReceiveDate
};
await _unitOfWork.AddGoodsReceivedNote(model);
return(result);
}
public IHttpActionResult PutGoodsReceivedNote(string id, GoodsReceivedNote goodsReceivedNote)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != goodsReceivedNote.RecNoteID)
{
return(BadRequest());
}
db.Entry(goodsReceivedNote).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!GoodsReceivedNoteExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IActionResult Update([FromBody] CrudViewModel <GoodsReceivedNote> payload)
{
GoodsReceivedNote goodsReceivedNote = payload.value;
_context.GoodsReceivedNote.Update(goodsReceivedNote);
_context.SaveChanges();
return(Ok(goodsReceivedNote));
}
public IActionResult Insert([FromBody] CrudViewModel <GoodsReceivedNote> payload)
{
GoodsReceivedNote goodsReceivedNote = payload.value;
goodsReceivedNote.GoodsReceivedNoteName = _numberSequence.GetNumberSequence("GRN");
_context.GoodsReceivedNote.Add(goodsReceivedNote);
_context.SaveChanges();
return(Ok(goodsReceivedNote));
}
public IActionResult Remove([FromBody] CrudViewModel <GoodsReceivedNote> payload)
{
GoodsReceivedNote goodsReceivedNote = _context.GoodsReceivedNote
.Where(x => x.GoodsReceivedNoteId == (int)payload.key)
.FirstOrDefault();
_context.GoodsReceivedNote.Remove(goodsReceivedNote);
_context.SaveChanges();
return(Ok(goodsReceivedNote));
}
public IActionResult Insert([FromBody] CrudViewModel <GoodsReceivedNote> payload)
{
GoodsReceivedNote value = payload.value;
value.GoodsReceivedNoteName = _numberSequence.GetNumberSequence("GRN");
var result = _functionalService.Insert <GoodsReceivedNote>(value);
value = (GoodsReceivedNote)result.Data;
return(Ok(value));
}
public bool SaveGRN(GoodsReceivedNote GRNEntity)
{
using (var dbContext = new SCMSEntities())
{
using (TransactionScope scope = new TransactionScope())
{
try
{
dbContext.GoodsReceivedNotes.Add(GRNEntity);
foreach (POItemsView item in GRNEntity.POItemz)
{
var newEntity = new GoodsReceivedNoteItem()
{
Id = Guid.NewGuid(),
GoodsReceivedNoteId = GRNEntity.Id,
PurchaseOrderItemId = item.POItemId,
QuantityDelivered = item.QtyDelivered,
QuantityDamaged = item.QtyDamaged,
Comments = item.comments,
IsInventory = item.IsInventory
};
dbContext.GoodsReceivedNoteItems.Add(newEntity);
}
if ((dbContext.SaveChanges() > 0))
{
scope.Complete();
SessionData.CurrentSession.GoodsReceivedNoteList = null;
SessionData.CurrentSession.GoodsReceivedNoteItemList = null;
SessionData.CurrentSession.PurchaseOrderList = null;
SessionData.CurrentSession.ProcurementPlanList = null;
return(true);
}
else
{
scope.Dispose(); return(false);
}
}
//catch (DbEntityValidationException e)
//{
// foreach (var eve in e.EntityValidationErrors)
// {
// Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
// eve.Entry.Entity.GetType().Name, eve.Entry.State);
// foreach (var ve in eve.ValidationErrors)
// {
// Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
// ve.PropertyName, ve.ErrorMessage);
// }
// }
// throw;
//}
catch (Exception ex) { scope.Dispose(); throw ex; }
}
}
}
public async Task <GoodsReceivedNote> AddGoodsReceivedNoteAsync(GoodsReceivedNote goodsReceivedNote)
{
_context.Create(goodsReceivedNote);
await _context.CommitAsync();
return(await _context.GoodsReceivedNotes
.Include(p => p.PaymentType)
.Include(p => p.PurchaseOrder)
.Include(p => p.ReceivedUser)
.FirstAsync(e => e.Id == goodsReceivedNote.Id));
}
public IHttpActionResult GetGoodsReceivedNote(string id)
{
GoodsReceivedNote goodsReceivedNote = db.GoodsReceivedNotes.Find(id);
if (goodsReceivedNote == null)
{
return(NotFound());
}
return(Ok(goodsReceivedNote));
}
public void UpdateGRN(GoodsReceivedNote grn)
{
using (var context = new SCMSEntities())
{
var existing = context.GoodsReceivedNotes.FirstOrDefault(p => p.Id == grn.Id);
context.Entry(existing).CurrentValues.SetValues(grn);
context.SaveChanges();
SessionData.CurrentSession.PurchaseOrderList = null;
SessionData.CurrentSession.GoodsReceivedNoteList = null;
SessionData.CurrentSession.GoodsReceivedNoteItemList = null;
}
}
public bool IsGRNVerified(GoodsReceivedNote GRNentity)
{
using (var context = new SCMSEntities())
{
using (TransactionScope scope = new TransactionScope())
{
foreach (GoodsReceivedNoteItem item in GRNentity.ItemColl)
{
GoodsReceivedNoteItem grit = context.GoodsReceivedNoteItems.FirstOrDefault(p => p.Id == item.Id);
if (context.Inventories.Count(p => p.ItemId == grit.PurchaseOrderItem.Item.Id && p.WareHouseId == grit.GoodsReceivedNote.WareHouseId) > 0)
{
if (grit.PurchaseOrderItem.Item.ItemCategory.CategoryCode == "C")
{
Model.Inventory invt = context.Inventories.FirstOrDefault(p => p.ItemId == grit.PurchaseOrderItem.Item.Id && p.WareHouseId == grit.GoodsReceivedNote.WareHouseId);
invt.Quantity += (long)item.QuantityDelivered;
((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(invt, System.Data.EntityState.Modified);
}
}
else
{
long qty = 0;
if (grit.PurchaseOrderItem.Item.ItemCategory.CategoryCode == "C")
{
qty = (long)item.QuantityDelivered;
}
Model.Inventory newinvetoryEntity =
new Model.Inventory()
{
Id = Guid.NewGuid(), ItemId = grit.PurchaseOrderItem.Item.Id, Quantity = qty, CountryProgrammeId = GRNentity.CountryProgrammeId, WareHouseId = (Guid)grit.GoodsReceivedNote.WareHouseId
};
context.Inventories.Add(newinvetoryEntity);
}
Model.GoodsReceivedNoteItem grnitm = context.GoodsReceivedNoteItems.FirstOrDefault(p => p.Id == item.Id);
grnitm.QuantityDamaged = item.QuantityDamaged; grnitm.QuantityDelivered = item.QuantityDelivered;
((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(grnitm, System.Data.EntityState.Modified);
context.SaveChanges();
}
Model.GoodsReceivedNote grn = context.GoodsReceivedNotes.FirstOrDefault(p => p.Id == GRNentity.Id);
grn.Verified = true;
grn.ApprovedOn = DateTime.Now;
grn.ReceptionApprovedBy = GRNentity.ReceptionApprovedBy;
((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(grn, System.Data.EntityState.Modified);
if (context.SaveChanges() > 0)
{
scope.Complete(); return(true);
}
else
{
scope.Dispose(); return(false);
}
}
}
}
private void PopulateModel(GoodsReceivedNote model, IDictionary values)
{
string GOODS_RECEIVED_NOTE_ID = nameof(GoodsReceivedNote.GoodsReceivedNoteId);
string GRNDATE = nameof(GoodsReceivedNote.GRNDate);
string GOODS_RECEIVED_NOTE_NAME = nameof(GoodsReceivedNote.GoodsReceivedNoteName);
string IS_FULL_RECEIVE = nameof(GoodsReceivedNote.IsFullReceive);
string PURCHASE_ORDER_ID = nameof(GoodsReceivedNote.PurchaseOrderId);
string VENDOR_DONUMBER = nameof(GoodsReceivedNote.VendorDONumber);
string VENDOR_INVOICE_NUMBER = nameof(GoodsReceivedNote.VendorInvoiceNumber);
string WAREHOUSE_ID = nameof(GoodsReceivedNote.WarehouseId);
if (values.Contains(GOODS_RECEIVED_NOTE_ID))
{
model.GoodsReceivedNoteId = Convert.ToInt32(values[GOODS_RECEIVED_NOTE_ID]);
}
if (values.Contains(GRNDATE))
{
model.GRNDate = (System.DateTimeOffset)Convert.ChangeType(values[GRNDATE], typeof(System.DateTimeOffset));
}
if (values.Contains(GOODS_RECEIVED_NOTE_NAME))
{
model.GoodsReceivedNoteName = Convert.ToString(values[GOODS_RECEIVED_NOTE_NAME]);
}
if (values.Contains(IS_FULL_RECEIVE))
{
model.IsFullReceive = Convert.ToBoolean(values[IS_FULL_RECEIVE]);
}
if (values.Contains(PURCHASE_ORDER_ID))
{
model.PurchaseOrderId = Convert.ToInt32(values[PURCHASE_ORDER_ID]);
}
if (values.Contains(VENDOR_DONUMBER))
{
model.VendorDONumber = Convert.ToString(values[VENDOR_DONUMBER]);
}
if (values.Contains(VENDOR_INVOICE_NUMBER))
{
model.VendorInvoiceNumber = Convert.ToString(values[VENDOR_INVOICE_NUMBER]);
}
if (values.Contains(WAREHOUSE_ID))
{
model.WarehouseId = Convert.ToInt32(values[WAREHOUSE_ID]);
}
}
public async Task <IActionResult> Create(GoodsReceivedNote goodsReceivedNote)
{
if (ModelState.IsValid)
{
_context.Add(goodsReceivedNote);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
var supplier = _context.Suppliers.Select(i => i.Name).ToList();
ViewData["IdSupplier"] = new SelectList(_context.Suppliers, "Id", "Name", supplier);
return(View(goodsReceivedNote));
}
public IHttpActionResult DeleteGoodsReceivedNote(string id)
{
GoodsReceivedNote goodsReceivedNote = db.GoodsReceivedNotes.Find(id);
if (goodsReceivedNote == null)
{
return(NotFound());
}
db.GoodsReceivedNotes.Remove(goodsReceivedNote);
db.SaveChanges();
return(Ok(goodsReceivedNote));
}
public void DeleteGRNById(Guid id)
{
using (var context = new SCMSEntities())
{
var grn = new GoodsReceivedNote {
Id = id
};
context.GoodsReceivedNotes.Attach(grn);
((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(grn, System.Data.EntityState.Deleted);
context.SaveChanges();
SessionData.CurrentSession.PurchaseOrderList = null;
SessionData.CurrentSession.GoodsReceivedNoteList = null;
SessionData.CurrentSession.GoodsReceivedNoteItemList = null;
}
}
public override void BindItemToViewHolder(GoodsReceivedNote item, GoodsReceivedNotesViewHolder viewHolder)
{
viewHolder.GoodsReceivedNoteRowItemDocumentId.Text = item.DocumentId;
viewHolder.GoodsReceivedNoteRowItemInvoiceId.Text = item.Invoice.DocumentId;
_styleProvider
.Execute(item.LastModifiedAt,
viewHolder.GoodsReceivedNoteRowItemDocumentId);
viewHolder.GoodsReceivedNoteRowItemInfo.SetOnClickListener(IOnClickListener);
viewHolder.GoodsReceivedNoteRowItemDelete.SetOnClickListener(IOnClickListener);
viewHolder.GoodsReceivedNoteRowItemInfo.Visibility = ReadVisibility;
viewHolder.GoodsReceivedNoteRowItemDelete.Visibility = DeleteVisibility;
}
private ActionResult LGRN(string viewname)
{
var model = new GoodsReceivedNote()
{
staffs = new SelectList(SessionData.CurrentSession.StaffList, "Id", "StaffName"),
//ReceivedBy = currentStaff.Id,
PurchaseOrders = new SelectList(gRNService.GetGRNPurchaseOrders(), "Id", "RefNumber"),
SubOffices = new SelectList(SessionData.CurrentSession.CountrySubOfficeList, "Id", "Name"),
Warehouses = new SelectList(SessionData.CurrentSession.WarehouseList, "Id", "Name"),
ApproversList = new SelectList(staffService.GetStaffByApprovalDoc(NotificationHelper.grnCode, countryProg.Id), "Id", "StaffName"),
RefNumber = string.Format("--{0}--", Resources.GoodsReceivedNote_LoadGRN_NewGRN),
POItemz = new List <POItemsView>()
};
return(View(viewname, model));
}
public async Task GetGoodsReceivedNoteFreeItemAsync_Returns_GoodsReceivedNoteFreeItem()
{
//Arrange
var id = 1;
var service = new GoodsReceivedNoteFreeItemService(_myRestaurantContext);
//Act
var result = await service.GetGoodsReceivedNoteFreeItemAsync(d => d.Id == id);
//Assert
result.Should().BeAssignableTo <GoodsReceivedNoteFreeItem>();
result !.GoodsReceivedNote.Should().BeAssignableTo <GoodsReceivedNote>();
result.Id.Should().Be(id);
result.Item.Name.Should().Be("Chips");
result.Discount.Should().Be(0.1m);
}
public ActionResult LoadGRAssetItems(GoodsReceivedNote model)
{
model.ReceptionApprovedBy = currentStaff.Id;
model.CountryProgrammeId = countryProg.Id;
if (gRNService.IsGRNVerified(model))
{
SessionData.CurrentSession.GoodsReceivedNoteList = null;
}
GoodsReceivedNote grn = gRNService.GetGRNById(model.Id);
//send notification to preparer that GRN has been verified
string notificationMsg = string.Format(NotificationHelper.grnApprovedMsgBody, grn.Staff1.Person.FirstName, grn.RefNumber);
notificationService.SendNotification(grn.Staff1.Person.OfficialEmail, notificationMsg, NotificationHelper.grnsubject);
//Notify RFP Prep Incharge
notificationService.SendAuthorizedMsgToDocPreparers(NotificationHelper.grnCode, grn.Id);
return(ViewGRNs());
}
public HttpResponseMessage Post(FormDataCollection form)
{
var model = new GoodsReceivedNote();
var values = JsonConvert.DeserializeObject <IDictionary>(form.Get("values"));
PopulateModel(model, values);
Validate(model);
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, GetFullErrorMessage(ModelState)));
}
var result = _context.GoodsReceivedNotes.Add(model);
_context.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, result.GoodsReceivedNoteId));
}
public IActionResult GetAmount([FromRoute] int id)
{
var Amount = 0.0;
Bill bill = _functionalService.GetById <Bill>(id);
if (bill != null)
{
GoodsReceivedNote grn = _functionalService.GetById <GoodsReceivedNote>(bill.GoodsReceivedNoteId);
if (grn != null)
{
PurchaseOrder purchaseOrder = _functionalService.GetById <PurchaseOrder>(grn.PurchaseOrderId);
if (purchaseOrder != null)
{
Amount = purchaseOrder.Total;
}
}
}
return(Ok(new { Amount }));
}
/// <summary>
///
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public string GenerateUniquNumber(CodeType type)
{
long count = 1;
string code = string.Empty; // shd be generate not hard coded as in the switch loop
using (var dbContext = new SCMSEntities())
{
switch (type)
{
case CodeType.GoodsReceivedNote:
default:
code = "GRN/DRC/UG/";
GoodsReceivedNote grn = dbContext.GoodsReceivedNotes.OrderByDescending(x => x.Index).FirstOrDefault();
if (grn != null)
{
count = grn.Index + 1;
}
break;
}
if (count < 10000)
{
if (count < 10)
{
return(code + "0000" + count);
}
if (count < 100 & count > 10)
{
return(code + "000" + count);
}
if (count < 1000 & count > 100)
{
return(code + "00" + count);
}
if (count < 10000 & count > 1000)
{
return(code + "0" + count);
}
}
return(code + count);
}
}
public ActionResult LoadGRNItemDetais(Guid PoId, string viewName)
{
var model = new GoodsReceivedNote()
{
PurchaseOrderId = PoId,
ReceivedBy = currentStaff.Id,
Supplier = gRNService.GetPO(PoId).Supplier,
SupplierId = gRNService.GetPO(PoId).Supplier.Id,
staffs = new SelectList(SessionData.CurrentSession.StaffList, "Id", "StaffName"),
PurchaseOrders = new SelectList(gRNService.GetGRNPurchaseOrders(), "Id", "RefNumber"),
SubOffices = new SelectList(SessionData.CurrentSession.CountrySubOfficeList, "Id", "Name"),
Warehouses = new SelectList(gRNService.GetSubOfficeWareHouses(Guid.Empty), "Id", "Name"),
ApproversList = new SelectList(staffService.GetStaffByApprovalDoc(NotificationHelper.grnCode, countryProg.Id), "Id", "StaffName"),
RefNumber = string.Format("--{0}--", Resources.GoodsReceivedNote_LoadGRN_NewGRN),
POItemz = gRNService.GetPOItemsDetails(PoId),
SupplierName = gRNService.GetPO(PoId).Supplier.Name
};
return(View(viewName, model));
}
public void Migrate()
{
DropTables();
CreateTables();
if (UserRepository.Any())
{
return;
}
var currentDate = DateTime.Now;
var roleClaims = ClaimsRepository
.GetClaims();
var role = new Role
{
Name = "Administrator"
};
RoleRepository.Add(role);
var role1 = new Role
{
Name = "Pracownik"
};
RoleRepository.Add(role1);
var role2 = new Role
{
Name = "Księgowy"
};
RoleRepository.Add(role2);
var role3 = new Role
{
Name = "Kierownik"
};
RoleRepository.Add(role3);
var adminRoleClaims = roleClaims
.Select(cl => new RoleClaim
{
RoleId = role.Id,
ClaimType = cl.Type,
ClaimValue = cl.Value
});
var kierownikRoleClaims = roleClaims
.Skip(4)
.Select(cl => new RoleClaim
{
RoleId = role3.Id,
ClaimType = cl.Type,
ClaimValue = cl.Value
});
var ksiegowyRoleClaims = roleClaims
.Skip(8)
.Select(cl => new RoleClaim
{
RoleId = role2.Id,
ClaimType = cl.Type,
ClaimValue = cl.Value
});
var pracownikRoleClaims = roleClaims
.Skip(12)
.Select(cl => new RoleClaim
{
RoleId = role1.Id,
ClaimType = cl.Type,
ClaimValue = cl.Value
});
RoleClaimRepository.AddRange(adminRoleClaims);
RoleClaimRepository.AddRange(kierownikRoleClaims);
RoleClaimRepository.AddRange(ksiegowyRoleClaims);
RoleClaimRepository.AddRange(pracownikRoleClaims);
var user = new User
{
UserName = "******",
FirstName = "Jan",
LastName = "Kocur",
Email = "*****@*****.**",
PasswordHash = _passwordManager.GetHash("123")
};
UserRepository.Add(user);
var user1 = new User
{
UserName = "******",
FirstName = "Władysław",
LastName = "Kocioł",
Email = "*****@*****.**",
PasswordHash = _passwordManager.GetHash("123")
};
UserRepository.Add(user1);
var user2 = new User
{
UserName = "******",
FirstName = "Michał",
LastName = "Zbożny",
Email = "*****@*****.**",
PasswordHash = _passwordManager.GetHash("123")
};
UserRepository.Add(user2);
var user3 = new User
{
UserName = "******",
FirstName = "Heniek",
LastName = "Luwer",
Email = "*****@*****.**",
PasswordHash = _passwordManager.GetHash("123")
};
UserRepository.Add(user3);
var userRole = new UserRole
{
RoleId = role.Id,
UserId = user.Id
};
var userRole1 = new UserRole
{
RoleId = role2.Id,
UserId = user1.Id
};
var userRole2 = new UserRole
{
RoleId = role1.Id,
UserId = user2.Id
};
var userRole3 = new UserRole
{
RoleId = role3.Id,
UserId = user3.Id
};
UserRoleRepository.Add(userRole);
UserRoleRepository.Add(userRole1);
UserRoleRepository.Add(userRole2);
UserRoleRepository.Add(userRole3);
var city = new City
{
Name = "Olsztyn"
};
CityRepository.Add(city);
var city2 = new City
{
Name = "Warszawa"
};
CityRepository.Add(city2);
var city3 = new City
{
Name = "Barczewo"
};
CityRepository.Add(city3);
var city4 = new City
{
Name = "Gdańsk"
};
CityRepository.Add(city4);
var city5 = new City
{
Name = "Kraków"
};
CityRepository.Add(city5);
var counterparty = new Counterparty
{
Name = "Firma sprzedajaca buty",
NIP = "1122334455",
PhoneNumber = "1122334455666",
Street = "Lubelska 432",
PostalCode = "11-341",
CityId = city.Id
};
CounterpartyRepository.Add(counterparty);
var counterparty1 = new Counterparty
{
Name = "Firma sprzedajaca ubrania",
NIP = "2126337425",
PhoneNumber = "1122334455666",
Street = "Lubelska 432",
PostalCode = "11-341",
CityId = city.Id
};
CounterpartyRepository.Add(counterparty1);
var location = new Location
{
Name = "Półka X"
};
LocationRepository.Add(location);
var location1 = new Location
{
Name = "Półka Y"
};
LocationRepository.Add(location1);
var location2 = new Location
{
Name = "Półka Z"
};
LocationRepository.Add(location2);
var location3 = new Location
{
Name = "Półka K"
};
LocationRepository.Add(location3);
var invoice = new Invoice
{
DocumentId = string.Format("FAK/{0:yyyyMMddhhmmssfff}", currentDate),
CounterpartyId = counterparty.Id,
CityId = city.Id,
InvoiceType = Common.InvoiceType.Purchase,
PaymentMethod = Common.PaymentMethod.Card,
IssueDate = currentDate,
CompletionDate = currentDate
};
InvoiceRepository.Add(invoice);
var entries = new List <Entry>()
{
new Entry
{
Name = "Buty Halwin Meain XL",
InvoiceId = invoice.Id,
Price = 22.22m,
Count = 1000,
VAT = 0.01m
}
};
EntryRepository.AddRange(entries);
invoice.Total = entries[0].Count * entries[0].Price;
invoice.VAT = invoice.Total * entries[0].VAT;
InvoiceRepository.Update(invoice);
currentDate = DateTime.Now;
var invoice1 = new Invoice
{
DocumentId = string.Format("FAK/{0:yyyyMMddhhmmssfff}", currentDate),
CounterpartyId = counterparty.Id,
CityId = city.Id,
InvoiceType = Common.InvoiceType.Sales,
PaymentMethod = Common.PaymentMethod.Card,
IssueDate = currentDate,
CompletionDate = currentDate
};
InvoiceRepository.Add(invoice1);
var entries1 = new List <Entry>()
{
new Entry
{
Name = "Buty Halwin Meain XL",
InvoiceId = invoice1.Id,
Price = 22.22m,
Count = 100,
VAT = 0.01m
}
};
EntryRepository.AddRange(entries1);
invoice1.Total = entries1[0].Count * entries1[0].Price;
invoice1.VAT = invoice1.Total * entries1[0].VAT;
InvoiceRepository.Update(invoice1);
currentDate = DateTime.Now;
var invoice2 = new Invoice
{
DocumentId = string.Format("FAK/{0:yyyyMMddhhmmssfff}", currentDate),
CounterpartyId = counterparty.Id,
CityId = city.Id,
InvoiceType = Common.InvoiceType.Purchase,
PaymentMethod = Common.PaymentMethod.Card,
IssueDate = currentDate,
CompletionDate = currentDate
};
InvoiceRepository.Add(invoice2);
var entries2 = new List <Entry>()
{
new Entry
{
Name = "Czapka Xiaming",
InvoiceId = invoice2.Id,
Price = 70.22m,
Count = 400,
VAT = 0.10m
}
};
EntryRepository.AddRange(entries2);
invoice2.Total = entries2[0].Count * entries2[0].Price;
invoice2.VAT = invoice2.Total * entries2[0].VAT;
InvoiceRepository.Update(invoice2);
currentDate = DateTime.Now;
var invoice3 = new Invoice
{
DocumentId = string.Format("FAK/{0:yyyyMMddhhmmssfff}", currentDate),
CounterpartyId = counterparty.Id,
CityId = city.Id,
InvoiceType = Common.InvoiceType.Purchase,
PaymentMethod = Common.PaymentMethod.Card,
IssueDate = currentDate,
CompletionDate = currentDate
};
InvoiceRepository.Add(invoice3);
var entries3 = new List <Entry>()
{
new Entry
{
Name = "Spodnie Jeans Amba M",
InvoiceId = invoice3.Id,
Price = 51.74m,
Count = 300,
VAT = 0.12m
}
};
EntryRepository.AddRange(entries3);
invoice3.Total = entries3[0].Count * entries3[0].Price;
invoice3.VAT = invoice3.Total * entries3[0].VAT;
InvoiceRepository.Update(invoice3);
var attribute = new Attribute
{
Name = "Firma"
};
AttributeRepository.Add(attribute);
var attribute1 = new Attribute
{
Name = "Rodzaj"
};
AttributeRepository.Add(attribute1);
var product = new Product
{
Name = "Buty Halwin Meain XL",
Barcode = "Buty Halwin Meain XL",
};
var product1 = new Product
{
Name = "Spodnie Jeans Amba M",
Barcode = "Spodnie Jeans Amba M"
};
var product2 = new Product
{
Name = "Koszula Meadow L",
Barcode = "Koszula Meadow L"
};
var product3 = new Product
{
Name = "Czapka Xiaming",
Barcode = "Czapka Xiaming"
};
ProductRepository.Add(product);
ProductRepository.Add(product1);
ProductRepository.Add(product2);
ProductRepository.Add(product3);
var productAttributes = new List <ProductAttribute>()
{
new ProductAttribute
{
ProductId = product.Id,
AttributeId = attribute.Id,
Value = "Xinmex"
},
new ProductAttribute
{
ProductId = product.Id,
AttributeId = attribute1.Id,
Value = "Obuwie skórzane"
},
new ProductAttribute
{
ProductId = product1.Id,
AttributeId = attribute.Id,
Value = "Abibas"
},
new ProductAttribute
{
ProductId = product1.Id,
AttributeId = attribute1.Id,
Value = "Spodnie"
},
new ProductAttribute
{
ProductId = product2.Id,
AttributeId = attribute.Id,
Value = "Pomba"
},
new ProductAttribute
{
ProductId = product2.Id,
AttributeId = attribute1.Id,
Value = "Koszula bawelniana"
}
};
ProductAttributeRepository.AddRange(productAttributes);
var productDetails = new List <ProductDetail>()
{
new ProductDetail
{
LocationId = location.Id,
ProductId = product.Id,
Count = 300
},
new ProductDetail
{
LocationId = location1.Id,
ProductId = product.Id,
Count = 150
},
new ProductDetail
{
LocationId = location.Id,
ProductId = product1.Id,
Count = 200
},
new ProductDetail
{
LocationId = location1.Id,
ProductId = product1.Id,
Count = 150
},
new ProductDetail
{
LocationId = location.Id,
ProductId = product2.Id,
Count = 600
},
new ProductDetail
{
LocationId = location1.Id,
ProductId = product2.Id,
Count = 350
},
new ProductDetail
{
LocationId = location.Id,
ProductId = product3.Id,
Count = 400
},
new ProductDetail
{
LocationId = location1.Id,
ProductId = product3.Id,
Count = 250
}
};
ProductDetailsRepository.AddRange(productDetails);
var goodsDispatchedNote = new GoodsDispatchedNote
{
DocumentId = string.Format("PZ/{0:yyyyMMddhhmmss}", currentDate),
Remarks = "Testowy opis...",
InvoiceId = invoice1.Id,
IssueDate = currentDate,
DispatchDate = currentDate
};
GoodsDispatchedNoteRepository.Add(goodsDispatchedNote);
var goodsReceivedNote = new GoodsReceivedNote
{
DocumentId = string.Format("WZ/{0:yyyyMMddhhmmss}", currentDate),
Remarks = "Testowy opis...",
InvoiceId = invoice.Id,
IssueDate = currentDate,
ReceiveDate = currentDate
};
GoodsReceivedNoteRepository.Add(goodsReceivedNote);
}
public async Task DeleteGoodsReceivedNoteAsync(GoodsReceivedNote goodsReceivedNote)
{
_context.Delete(goodsReceivedNote);
await _context.CommitAsync();
}
public async Task UpdateGoodsReceivedNoteAsync(GoodsReceivedNote goodsReceivedNote)
{
_context.Modify(goodsReceivedNote);
await _context.CommitAsync();
}
public void GoToGoodsReceivedNoteDetails(GoodsReceivedNote model)
{
GoTo <Fragments.Details.GoodsReceivedNote>(model);
}
