public InvoiceModel(PurchaseInvoice invoice)
{
var session = invoice.Strategy.Session;
this.Title = invoice.PurchaseInvoiceType.Equals(new PurchaseInvoiceTypes(session).PurchaseReturn) ? "PURCHASE RETURN" : "PURCHASE INVOICE";
this.Description = invoice.Description?.Split('\n');
this.Number = invoice.InvoiceNumber;
this.Date = invoice.InvoiceDate.ToString("yyyy-MM-dd");
this.CustomerReference = invoice.CustomerReference;
this.SubTotal = invoice.TotalBasePrice.ToString("N2", new CultureInfo("nl-BE"));
this.TotalExVat = invoice.TotalExVat.ToString("N2", new CultureInfo("nl-BE"));
this.VatRate = invoice.DerivedVatRate?.Rate.ToString("n2");
this.TotalVat = invoice.TotalVat.ToString("N2", new CultureInfo("nl-BE"));
this.IrpfRate = invoice.DerivedIrpfRate?.Rate.ToString("n2");
// IRPF is subtracted for total amount to pay
var totalIrpf = invoice.TotalIrpf * -1;
this.TotalIrpf = totalIrpf.ToString("N2", new CultureInfo("nl-BE"));
this.PrintIrpf = invoice.TotalIrpf != 0;
this.TotalIncVat = invoice.TotalIncVat.ToString("N2", new CultureInfo("nl-BE"));
var currencyIsoCode = invoice.DerivedCurrency.IsoCode;
this.GrandTotal = currencyIsoCode + " " + invoice.GrandTotal.ToString("N2", new CultureInfo("nl-BE"));
}
public int Update(PurchaseInvoice purchaseInvoice)
{
UpdateCommand.Parameters["@ID"].Value = purchaseInvoice.ID;
UpdateCommand.Parameters["@PurchaseInvoiceNo"].Value = purchaseInvoice.PurchaseInvoiceNo;
UpdateCommand.Parameters["@ItemCategoryID"].Value = purchaseInvoice.ItemCategoryID;
UpdateCommand.Parameters["@ItemTypeID"].Value = purchaseInvoice.ItemTypeID;
UpdateCommand.Parameters["@Description"].Value = purchaseInvoice.Description;
UpdateCommand.Parameters["@UnitCost"].Value = purchaseInvoice.UnitCost;
UpdateCommand.Parameters["@Qty"].Value = purchaseInvoice.Qty;
UpdateCommand.Parameters["@UnitType"].Value = purchaseInvoice.UnitType;
UpdateCommand.Parameters["@AmountCost"].Value = purchaseInvoice.AmountCost;
UpdateCommand.Parameters["@InventoryLocationID"].Value = purchaseInvoice.InventoryLocationID;
UpdateCommand.Parameters["@InventoryLocationName"].Value = purchaseInvoice.InventoryLocationName;
UpdateCommand.Parameters["@Status"].Value = purchaseInvoice.Status;
int returnValue = -1;
try
{
UpdateCommand.Connection.Open();
returnValue = UpdateCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
Logger.Write(ex);
}
finally
{
UpdateCommand.Connection.Close();
}
return(returnValue);
}
//{
// new PurchaseInvoice {Broker = new BrokerRepository().GetAll()[0], Products = new ProductRepository().GetAll().Take(2).ToList(),Id= 1,InvoiceNo = 12 },
// new PurchaseInvoice {Broker = new BrokerRepository().GetAll()[1], Products = new ProductRepository().GetAll().Take(3).ToList(),Id= 2 ,InvoiceNo = 977},
// new PurchaseInvoice {Broker = new BrokerRepository().GetAll()[2], Products = new ProductRepository().GetAll().Take(4).ToList(),Id= 3,InvoiceNo =768 },
// new PurchaseInvoice {Broker = new BrokerRepository().GetAll()[3], Products = new ProductRepository().GetAll().Take(5).ToList(),Id= 4 },
//};
public void Add(PurchaseInvoice purchaseInvoice)
{
_DataBase.Add(purchaseInvoice);
purchaseInvoice.Products.ForEach(p => productRepo.AddQuantity(p));
}
public IActionResult AddPurchaseInvoice([FromBody] PurchaseInvoice model)
{
model.CreatedAt = DateTime.Now;
model.InvoiceNumber = GenIN();
invoice_repo.Add(model);
return(new OkObjectResult(new { PurchaseInvoiceID = model.PurchaseInvoiceId }));
}
public PurchaseInvoice VCreateObject(PurchaseInvoice purchaseInvoice, IPurchaseReceivalService _purchaseReceivalService)
{
VHasPurchaseReceival(purchaseInvoice, _purchaseReceivalService);
if (!isValid(purchaseInvoice))
{
return(purchaseInvoice);
}
VPurchaseReceivalHasNotBeenInvoiceCompleted(purchaseInvoice, _purchaseReceivalService);
if (!isValid(purchaseInvoice))
{
return(purchaseInvoice);
}
VHasInvoiceDate(purchaseInvoice);
if (!isValid(purchaseInvoice))
{
return(purchaseInvoice);
}
VHasDueDate(purchaseInvoice);
if (!isValid(purchaseInvoice))
{
return(purchaseInvoice);
}
VHasDiscountBetweenZeroAndHundred(purchaseInvoice);
return(purchaseInvoice);
}
public ActionResult getInvoiceDetails(PurchaseInvoice obj)
{
string status;
tbl_purchaseInvoice purchaseInvoice = new tbl_purchaseInvoice();
purchaseInvoice.invoice_id = obj.id;
purchaseInvoice.code = obj.code;
purchaseInvoice.product_name = obj.product_name;
purchaseInvoice.quantity = obj.quantity;
purchaseInvoice.amount = obj.amount;
purchaseInvoice.spl_per = obj.spl_per;
purchaseInvoice.spl_disc = obj.spl_disc;
purchaseInvoice.addl_disc = obj.addl_disc;
purchaseInvoice.total_tax = obj.total_tax;
purchaseInvoice.net_amt = obj.net_amt;
purchaseInvoice.gst_per = obj.gst_per;
purchaseInvoice.discount = obj.discount;
purchaseInvoice.gst = obj.gst;
purchaseInvoice.mrp = obj.mrp;
purchaseInvoice.imeno = obj.imeno;
entityOBJ.tbl_purchaseInvoice.Add(purchaseInvoice);
if (entityOBJ.SaveChanges() > 0)
{
status = "true";
}
else
{
status = "true";
}
return(Json(status, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteConfirmEdit(int id)
{
Session["err"] = "Error, Please Check Input Fields";
Session["msg"] = "";
PurchaseInvoiceDetail purchaseinvoicedetail = db.PurchaseInvoiceDetails.Find(id);
try
{
db.PurchaseInvoiceDetails.Remove(purchaseinvoicedetail);
db.SaveChanges();
try
{
decimal totalamt = db.PurchaseInvoiceDetails.Where(u => u.PurchaseInvoiceID == purchaseinvoicedetail.PurchaseInvoiceID && purchaseinvoicedetail.Flag == true).Sum(u => (decimal)u.NetValue);
PurchaseInvoice purchaseinvoice = db.PurchaseInvoices.Find(purchaseinvoicedetail.PurchaseInvoiceID);
purchaseinvoice.GrossTotalAmount = decimal.Round(Convert.ToDecimal(totalamt.ToString("#.##")), 2, MidpointRounding.AwayFromZero);
db.Entry(purchaseinvoice).State = EntityState.Modified;
db.SaveChanges();
}
catch { }
Session["err"] = "";
Session["msg"] = "Deleted Successfully";
}
catch { }
return(RedirectToAction("Edit", "PurchaseInvoice", new { id = purchaseinvoicedetail.PurchaseInvoiceID }));
}
public static void Duplicate(PurchaseInvoice obj, MethodReturnEventArgs <Zetbox.Basic.Invoicing.Receipt> e)
{
var ctx = obj.Context;
var result = ctx.Create <PurchaseInvoice>();
result.Description = obj.Description;
result.Document = obj.Document;
result.InternalOrganization = obj.InternalOrganization;
result.Message = obj.Message;
result.Supplier = obj.Supplier;
foreach (var it in obj.Items)
{
var item = ctx.Create <PurchaseInvoiceItem>();
item.Amount = it.Amount;
item.AmountNet = it.AmountNet;
item.Description = it.Description;
item.Quantity = it.Quantity;
item.UnitPrice = it.UnitPrice;
item.VATType = it.VATType;
result.Items.Add(item);
}
e.Result = result;
}
public static void CreateTemplate(PurchaseInvoice obj, MethodReturnEventArgs <Zetbox.Basic.Invoicing.ReceiptTemplate> e)
{
var ctx = obj.Context;
var result = ctx.Create <PurchaseInvoiceTemplate>();
// TODO: migrate this: result.DueDate.DaysOffset = (obj.DueDate - obj.Date).TotalDays;
result.Description = obj.Description;
result.Document = obj.Document;
result.IntOrg = obj.InternalOrganization;
result.Message = obj.Message;
result.Supplier = obj.Supplier;
foreach (var it in obj.Items)
{
var item = ctx.Create <PurchaseInvoiceItemTemplate>();
item.Amount = it.Amount;
item.AmountNet = it.AmountNet;
item.Description = it.Description;
item.Quantity = it.Quantity;
item.UnitPrice = it.UnitPrice;
item.VATType = it.VATType;
result.Items.Add(item);
}
e.Result = result;
}
public PurchaseInvoice ConfirmObject(PurchaseInvoice purchaseInvoice, DateTime ConfirmationDate, IPurchaseInvoiceDetailService _purchaseInvoiceDetailService, IPurchaseOrderService _purchaseOrderService,
IPurchaseReceivalService _purchaseReceivalService, IPurchaseReceivalDetailService _purchaseReceivalDetailService, IPayableService _payableService)
{
purchaseInvoice.ConfirmationDate = ConfirmationDate;
if (_validator.ValidConfirmObject(purchaseInvoice, _purchaseInvoiceDetailService, _purchaseReceivalService, _purchaseReceivalDetailService))
{
// confirm details
// add all amount into amountpayable
IList <PurchaseInvoiceDetail> details = _purchaseInvoiceDetailService.GetObjectsByPurchaseInvoiceId(purchaseInvoice.Id);
foreach (var detail in details)
{
detail.Errors = new Dictionary <string, string>();
_purchaseInvoiceDetailService.ConfirmObject(detail, ConfirmationDate, _purchaseReceivalDetailService);
}
purchaseInvoice = CalculateAmountPayable(purchaseInvoice, _purchaseInvoiceDetailService);
// confirm object
// create payable
purchaseInvoice = _repository.ConfirmObject(purchaseInvoice);
PurchaseReceival purchaseReceival = _purchaseReceivalService.GetObjectById(purchaseInvoice.PurchaseReceivalId);
_purchaseReceivalService.CheckAndSetInvoiceComplete(purchaseReceival, _purchaseReceivalDetailService);
PurchaseOrder purchaseOrder = _purchaseOrderService.GetObjectById(purchaseReceival.PurchaseOrderId);
Payable payable = _payableService.CreateObject(purchaseOrder.ContactId, Constant.PayableSource.PurchaseInvoice, purchaseInvoice.Id, purchaseInvoice.AmountPayable, purchaseInvoice.DueDate);
}
return(purchaseInvoice);
}
public bool ValidConfirmObject(PurchaseInvoice purchaseInvoice, IPurchaseInvoiceDetailService _purchaseInvoiceDetailService,
IPurchaseReceivalService _purchaseReceivalService, IPurchaseReceivalDetailService _purchaseReceivalDetailService)
{
purchaseInvoice.Errors.Clear();
VConfirmObject(purchaseInvoice, _purchaseInvoiceDetailService, _purchaseReceivalService, _purchaseReceivalDetailService);
return(isValid(purchaseInvoice));
}
public dynamic Insert(PurchaseInvoice model)
{
try
{
if (!AuthenticationModel.IsAllowed("Create", Core.Constants.Constant.MenuName.PurchaseInvoice, Core.Constants.Constant.MenuGroupName.Transaction))
{
Dictionary <string, string> Errors = new Dictionary <string, string>();
Errors.Add("Generic", "You are Not Allowed to Add record");
return(Json(new
{
Errors
}, JsonRequestBehavior.AllowGet));
}
model = _purchaseInvoiceService.CreateObject(model, _purchaseReceivalService);
}
catch (Exception ex)
{
LOG.Error("Insert Failed", ex);
Dictionary <string, string> Errors = new Dictionary <string, string>();
Errors.Add("Generic", "Error " + ex);
return(Json(new
{
Errors
}, JsonRequestBehavior.AllowGet));
}
return(Json(new
{
model.Errors
}));
}
public dynamic UnConfirm(PurchaseInvoice model)
{
try
{
if (!AuthenticationModel.IsAllowed("UnConfirm", Core.Constants.Constant.MenuName.PurchaseInvoice, Core.Constants.Constant.MenuGroupName.Transaction))
{
Dictionary <string, string> Errors = new Dictionary <string, string>();
Errors.Add("Generic", "You are Not Allowed to UnConfirm record");
return(Json(new
{
Errors
}, JsonRequestBehavior.AllowGet));
}
var data = _purchaseInvoiceService.GetObjectById(model.Id);
model = _purchaseInvoiceService.UnconfirmObject(data, _purchaseInvoiceDetailService, _purchaseReceivalService, _purchaseReceivalDetailService, _paymentVoucherDetailService, _payableService);
}
catch (Exception ex)
{
LOG.Error("Unconfirm Failed", ex);
Dictionary <string, string> Errors = new Dictionary <string, string>();
Errors.Add("Generic", "Error " + ex);
return(Json(new
{
Errors
}, JsonRequestBehavior.AllowGet));
}
return(Json(new
{
model.Errors
}));
}
public dynamic GetInfo(int Id)
{
PurchaseInvoice model = new PurchaseInvoice();
try
{
model = _purchaseInvoiceService.GetObjectById(Id);
}
catch (Exception ex)
{
LOG.Error("GetInfo", ex);
Dictionary <string, string> Errors = new Dictionary <string, string>();
Errors.Add("Generic", "Error " + ex);
return(Json(new
{
Errors
}, JsonRequestBehavior.AllowGet));
}
return(Json(new
{
model.Id,
model.Code,
model.PurchaseReceivalId,
PurchaseReceival = _purchaseReceivalService.GetObjectById(model.PurchaseReceivalId).Code,
model.Discount,
model.Description,
model.IsTaxable,
model.InvoiceDate,
model.DueDate,
model.AmountPayable,
model.Errors
}, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,BroughtId,When,ShippedId,CheckedId")] PurchaseInvoice purchaseInvoice)
{
if (id != purchaseInvoice.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(purchaseInvoice);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PurchaseInvoiceExists(purchaseInvoice.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(purchaseInvoice));
}
public HttpResponseMessage Post([FromBody] PurchaseInvoice inv)
{
String resp = "{\"Response\":\"Undefine\"}";
var response = Request.CreateResponse(HttpStatusCode.OK);
try
{
var ctx = new GASEntities();
if (inv != null)
{
ctx.PurchaseInvoices.Add(inv);
ctx.SaveChanges();
resp = "{\"Response\":\"OK\"}";
}
}
catch (Exception ex)
{
int a = 1;
resp = "{\"Response\":\"Fail\"}";
response = Request.CreateResponse(HttpStatusCode.InternalServerError);
}
// var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(resp, System.Text.Encoding.UTF8, "application/json");
return(response);
}
public bool ValidUnconfirmObject(PurchaseInvoice purchaseInvoice, IPurchaseInvoiceDetailService _purchaseInvoiceDetailService,
IPaymentVoucherDetailService _paymentVoucherDetailService, IPayableService _payableService)
{
purchaseInvoice.Errors.Clear();
VUnconfirmObject(purchaseInvoice, _purchaseInvoiceDetailService, _paymentVoucherDetailService, _payableService);
return(isValid(purchaseInvoice));
}
public PurchaseInvoiceComplex Create(PurchaseInvoiceComplex source)
{
#region 取資料
#endregion
#region 邏輯驗證
if (this.IsDataExists(source))
{
throw new Exception($"{"InvoiceID".ToLocalized()}:{source.Invoice.InvoiceID} 已經存在！");
}
#endregion
#region 變為Models需要之型別及邏輯資料
PurchaseInvoice main = GetPurchaseInvoiceOnCreate(source);
List <PurchaseInvoiceDetail> children = GetChildOnCreate(main, source);
#endregion
#region Models資料庫
this._Repository.Create(main);
foreach (PurchaseInvoiceDetail item in children)
{
this._DetailRepository.Create(item);
}
this._UnitOfWork.SaveChange();
#endregion
return(this.Get(main.InvoiceID));
}
public PurchaseInvoice VConfirmObject(PurchaseInvoice purchaseInvoice, IPurchaseInvoiceDetailService _purchaseInvoiceDetailService,
IPurchaseReceivalService _purchaseReceivalService, IPurchaseReceivalDetailService _purchaseReceivalDetailService)
{
VHasConfirmationDate(purchaseInvoice);
if (!isValid(purchaseInvoice))
{
return(purchaseInvoice);
}
VPurchaseReceivalHasNotBeenInvoiceCompleted(purchaseInvoice, _purchaseReceivalService);
if (!isValid(purchaseInvoice))
{
return(purchaseInvoice);
}
VHasNotBeenDeleted(purchaseInvoice);
if (!isValid(purchaseInvoice))
{
return(purchaseInvoice);
}
VHasNotBeenConfirmed(purchaseInvoice);
if (!isValid(purchaseInvoice))
{
return(purchaseInvoice);
}
VHasPurchaseInvoiceDetails(purchaseInvoice, _purchaseInvoiceDetailService);
if (!isValid(purchaseInvoice))
{
return(purchaseInvoice);
}
VAllPurchaseInvoiceDetailsAreConfirmable(purchaseInvoice, _purchaseInvoiceDetailService, _purchaseReceivalDetailService);
return(purchaseInvoice);
}
public InvoiceModel(PurchaseInvoice invoice)
{
this.Description = invoice.Description?.Split('\n');
this.Number = invoice.InvoiceNumber;
this.Date = invoice.InvoiceDate.ToString("yyyy-MM-dd");
this.CustomerReference = invoice.CustomerReference;
this.SubTotal = invoice.TotalBasePrice.ToString("N2", new CultureInfo("nl-BE"));
this.TotalExVat = invoice.TotalExVat.ToString("N2", new CultureInfo("nl-BE"));
this.VatRate = invoice.VatRegime?.VatRate?.Rate.ToString("n2");
this.TotalVat = invoice.TotalVat.ToString("N2", new CultureInfo("nl-BE"));
this.IrpfRate = invoice.IrpfRegime?.IrpfRate?.Rate.ToString("n2");
// IRPF is subtracted for total amount to pay
var totalIrpf = invoice.TotalIrpf * -1;
this.TotalIrpf = totalIrpf.ToString("N2", new CultureInfo("nl-BE"));
this.PrintIrpf = invoice.TotalIrpf != 0;
this.TotalIncVat = invoice.TotalIncVat.ToString("N2", new CultureInfo("nl-BE"));
var currencyIsoCode = invoice.Currency.IsoCode;
this.GrandTotal = currencyIsoCode + " " + invoice.GrandTotal.ToString("N2", new CultureInfo("nl-BE"));
}
protected void Page_Load(object sender, EventArgs e)
{
string action = Request["action"];
string PurchaseInvoiceId = Request["PurchaseInvoiceId"];
string where = "";
string sql = "";
PurchaseInvoice Pient = null;
DataTable dt;
switch (action)
{
case "load":
if (!string.IsNullOrEmpty(Request["InvoiceNo"]))
{
where += " and InvoiceNo like '%" + Request["InvoiceNo"].Trim() + "%'";
}
if (!string.IsNullOrEmpty(Request["SupplierName"]))
{
where += " and SupplierName like '%" + Request["SupplierName"].Trim() + "%'";
}
if (!string.IsNullOrEmpty(Request["ProductCode"]))
{
where += " and Id in (select distinct PurchaseInvoiceId from SHHG_AimExamine..PurchaseInvoiceDetail where ProductCode like '%" + Request["ProductCode"] + "%')";
}
sql = @"select * from SHHG_AimExamine..PurchaseInvoice where 1=1 " + where;
dt = DataHelper.QueryDataTable(GetPageSql(sql));
Response.Write("{total:" + totalProperty + ",rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
case "loaddetail":
sql = @"select * from SHHG_AimExamine..PurchaseInvoiceDetail
where PurchaseInvoiceId='" + PurchaseInvoiceId + "' order by ProductCode asc";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{innerrows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
case "delete":
string Id = Request["Id"];
Pient = PurchaseInvoice.Find(Id);
IList <PurchaseInvoiceDetail> PidEnts = PurchaseInvoiceDetail.FindAllByProperty("PurchaseInvoiceId", Id);
foreach (PurchaseInvoiceDetail PidEnt in PidEnts)
{
sql = @"select sum(isnull(InvoiceQuantity,0)) from SHHG_AimExamine..PurchaseInvoiceDetail where InWarehouseDetailId='" + PidEnt.InWarehouseDetailId + "'";
PidEnt.DoDelete();
if (!string.IsNullOrEmpty(PidEnt.InWarehouseDetailId))
{
InWarehouseDetail iwdEnt = InWarehouseDetail.Find(PidEnt.InWarehouseDetailId);
iwdEnt.KaiPiaoQuan = DataHelper.QueryValue <Int32>(sql);
iwdEnt.DoUpdate();
}
}
Pient.DoDelete();
break;
}
}
private PurchaseInvoice GetPurchaseInvoiceOnUpdate(PurchaseInvoiceComplex source)
{
PurchaseInvoice info = Mapper.Map <PurchaseInvoice>(source.Invoice);
info.LastPerson = IdentityService.GetUserData().UserID;
info.LastUpdate = DateTime.Now;
return(info);
}
public static void NotifyDeleting(PurchaseInvoice obj)
{
// Workaround - remove from lists
foreach (var item in obj.Items.ToList())
{
obj.Context.Delete(item);
}
}
public PurchaseInvoice VHasNotBeenDeleted(PurchaseInvoice purchaseInvoice)
{
if (purchaseInvoice.IsDeleted)
{
purchaseInvoice.Errors.Add("Generic", "Sudah dihapus");
}
return(purchaseInvoice);
}
public PurchaseInvoice VHasBeenConfirmed(PurchaseInvoice purchaseInvoice)
{
if (!purchaseInvoice.IsConfirmed)
{
purchaseInvoice.Errors.Add("Generic", "Sudah dikonfirmasi");
}
return(purchaseInvoice);
}
public PurchaseInvoice VHasDiscountBetweenZeroAndHundred(PurchaseInvoice purchaseInvoice)
{
if (purchaseInvoice.Discount < 0 || purchaseInvoice.Discount > 100)
{
purchaseInvoice.Errors.Add("Discount", "Harus antara 0 dan 100");
}
return(purchaseInvoice);
}
public PurchaseInvoice VHasDueDate(PurchaseInvoice purchaseInvoice)
{
if (purchaseInvoice.DueDate == null)
{
purchaseInvoice.Errors.Add("DueDate", "Tidak boleh kosong");
}
return(purchaseInvoice);
}
public PurchaseInvoice VHasConfirmationDate(PurchaseInvoice obj)
{
if (obj.ConfirmationDate == null)
{
obj.Errors.Add("ConfirmationDate", "Tidak boleh kosong");
}
return(obj);
}
public InvoiceSummary(PurchaseInvoice invoice)
{
Id = invoice.Id;
InvoiceNr = invoice.InvoiceNumber;
Description = invoice.HeaderDescription;
Vendor = invoice.VendorCode;
InvoiceDate = invoice.InvoiceDate;
}
public PurchaseInvoice VHasNotBeenConfirmed(PurchaseInvoice purchaseInvoice)
{
if (purchaseInvoice.IsConfirmed)
{
purchaseInvoice.Errors.Add("Generic", "Tidak boleh sudah dikonfirmasi");
}
return(purchaseInvoice);
}
