public PurchaseInvoiceDetail VCreateObject(PurchaseInvoiceDetail purchaseInvoiceDetail, IPurchaseInvoiceService _purchaseInvoiceService, IPurchaseInvoiceDetailService _purchaseInvoiceDetailService, IPurchaseReceivalDetailService _purchaseReceivalDetailService) { VHasPurchaseInvoice(purchaseInvoiceDetail, _purchaseInvoiceService); if (!isValid(purchaseInvoiceDetail)) { return(purchaseInvoiceDetail); } VHasPurchaseReceivalDetail(purchaseInvoiceDetail, _purchaseReceivalDetailService); if (!isValid(purchaseInvoiceDetail)) { return(purchaseInvoiceDetail); } VPurchaseReceivalDetailAndPurchaseInvoiceMustHaveTheSamePurchaseReceival(purchaseInvoiceDetail, _purchaseReceivalDetailService, _purchaseInvoiceService); if (!isValid(purchaseInvoiceDetail)) { return(purchaseInvoiceDetail); } VIsUniquePurchaseReceivalDetail(purchaseInvoiceDetail, _purchaseInvoiceDetailService, _purchaseReceivalDetailService); if (!isValid(purchaseInvoiceDetail)) { return(purchaseInvoiceDetail); } VNonNegativeNorZeroQuantity(purchaseInvoiceDetail); if (!isValid(purchaseInvoiceDetail)) { return(purchaseInvoiceDetail); } VQuantityIsLessThanOrEqualPendingInvoiceQuantity(purchaseInvoiceDetail, _purchaseReceivalDetailService); return(purchaseInvoiceDetail); }
public dynamic GetInfoDetail(int Id) { PurchaseInvoiceDetail model = new PurchaseInvoiceDetail(); try { model = _purchaseInvoiceDetailService.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.PurchaseReceivalDetailId, PurchaseReceival = _purchaseReceivalDetailService.GetObjectById(model.PurchaseReceivalDetailId).Code, ItemId = _purchaseReceivalDetailService.GetObjectById(model.PurchaseReceivalDetailId).ItemId, Item = _itemService.GetObjectById(_purchaseReceivalDetailService.GetObjectById(model.PurchaseReceivalDetailId).ItemId).Name, model.Quantity, model.Amount, model.Errors }, JsonRequestBehavior.AllowGet)); }
public PurchaseInvoiceDetail GetPurchaseInvoiceDetail(int PIDID) { IDBManager dbm = new DBManager(); PurchaseInvoiceDetail PID = new PurchaseInvoiceDetail(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@InvoiceDetailID", PIDID); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectPurchaseInvoiceDetail"); while (reader.Read()) { PID.InvoiceID = Int32.Parse(reader["InvoiceID"].ToString()); PID.InvoiceDetailID = Int32.Parse(reader["InvoiceDetailID"].ToString()); PID.ProductID = Int32.Parse(reader["ProductID"].ToString()); PID.UnitPrice = Decimal.Parse(reader["UnitPrice"].ToString()); PID.Quantity = Int64.Parse(reader["Quantity"].ToString()); PID.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); } } catch (Exception ex) { log.Write(ex.Message, "GetPurchaseInvoiceDetail"); throw (ex); } finally { dbm.Dispose(); } return(PID); }
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 int AddPurchaseInvoiceDetail(PurchaseInvoiceDetail PID) { IDBManager dbm = new DBManager(); try { dbm.CreateParameters(6); dbm.AddParameters(0, "@InvoiceID", PID.InvoiceID); dbm.AddParameters(1, "@ProductID", PID.ProductID); dbm.AddParameters(2, "@UnitPrice", PID.UnitPrice); dbm.AddParameters(3, "@Quantity", PID.Quantity); dbm.AddParameters(4, "@ModifiedDate", DateTime.Now); dbm.AddParameters(5, "@InvoiceDetailID", PID.InvoiceDetailID); dbm.Parameters[5].Direction = ParameterDirection.Output; dbm.ExecuteNonQuery(CommandType.StoredProcedure, "InsertPurchaseInvoiceDetail"); PID.InvoiceDetailID = Int32.Parse(dbm.Parameters[5].Value.ToString()); } catch (Exception ex) { log.Write(ex.Message, "AddPurchaseInvoiceDetail"); throw (ex); } finally { dbm.Dispose(); } return(PID.InvoiceDetailID); }
public PurchaseInvoiceDetailCollection GetAllPurchaseInvoiceDetailCollection() { IDBManager dbm = new DBManager(); PurchaseInvoiceDetailCollection cols = new PurchaseInvoiceDetailCollection(); try { IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectPurchaseInvoiceDetailsAll"); while (reader.Read()) { PurchaseInvoiceDetail PID = new PurchaseInvoiceDetail(); PID.InvoiceID = Int32.Parse(reader["InvoiceID"].ToString()); PID.InvoiceDetailID = Int32.Parse(reader["InvoiceDetailID"].ToString()); PID.ProductID = Int32.Parse(reader["ProductID"].ToString()); PID.UnitPrice = Decimal.Parse(reader["UnitPrice"].ToString()); PID.Quantity = Int64.Parse(reader["Quantity"].ToString()); PID.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(PID); } } catch (Exception ex) { log.Write(ex.Message, "PurchaseInvoiceDetailCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public bool UpdatePurchaseInvoiceDetail(PurchaseInvoiceDetail PID) { IDBManager dbm = new DBManager(); try { dbm.CreateParameters(6); dbm.AddParameters(0, "@InvoiceID", PID.InvoiceID); dbm.AddParameters(1, "@InvoiceDetailID", PID.InvoiceDetailID); dbm.AddParameters(2, "@ProductID", PID.ProductID); dbm.AddParameters(3, "@UnitPrice", PID.UnitPrice); dbm.AddParameters(4, "@Quantity", PID.Quantity); dbm.AddParameters(5, "@ModifiedDate", DateTime.Now); dbm.ExecuteNonQuery(CommandType.StoredProcedure, "UpdatePurchaseInvoiceDetail"); } catch (Exception ex) { log.Write(ex.Message, "UpdatePurchaseInvoiceDetail"); throw (ex); } finally { dbm.Dispose(); } return(true); }
protected PurchaseInvoiceDetail PurchaseInvoiceDetailsModel() { myPurchaseInvoiceDetail = new PurchaseInvoiceDetail(); if (HidenIdpurchasInvDe.Value != "0") { myPurchaseInvoiceDetail.ID = Convert.ToInt32(HidenIdpurchasInvDe.Value); } // if (ProductListtxt.SelectedValue != "") { myPurchaseInvoiceDetail.ProductID = ProductListtxt.SelectedValue; } // if (ProductPrice.Text != "") { myPurchaseInvoiceDetail.ProductPrice = Convert.ToDouble(ProductPrice.Text); } // if (Qty.Text != "") { myPurchaseInvoiceDetail.Qty = Convert.ToDouble(Qty.Text); } myPurchaseInvoiceDetail.PricePerRecord = Convert.ToDouble(myPurchaseInvoiceDetail.Qty * myPurchaseInvoiceDetail.ProductPrice); return(myPurchaseInvoiceDetail); }
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; } }
public PurchaseInvoiceDetail VNonNegativeNorZeroQuantity(PurchaseInvoiceDetail purchaseInvoiceDetail) { if (purchaseInvoiceDetail.Quantity <= 0) { purchaseInvoiceDetail.Errors.Add("Quantity", "Harus lebih besar dari 0"); } return(purchaseInvoiceDetail); }
public PurchaseInvoiceDetail VHasBeenConfirmed(PurchaseInvoiceDetail purchaseInvoiceDetail) { if (!purchaseInvoiceDetail.IsConfirmed) { purchaseInvoiceDetail.Errors.Add("IsConfirmed", "Belum dikonfirmasi"); } return(purchaseInvoiceDetail); }
public PurchaseInvoiceDetail VHasConfirmationDate(PurchaseInvoiceDetail obj) { if (obj.ConfirmationDate == null) { obj.Errors.Add("ConfirmationDate", "Tidak boleh kosong"); } return(obj); }
public PurchaseInvoiceDetail VHasNotBeenConfirmed(PurchaseInvoiceDetail purchaseInvoiceDetail) { if (purchaseInvoiceDetail.IsConfirmed) { purchaseInvoiceDetail.Errors.Add("IsConfirmed", "Sudah dikonfirmasi"); } return(purchaseInvoiceDetail); }
private void ProcessDetail(IList <string> entStrList, PurchaseInvoice piEnt) { if (entStrList != null && entStrList.Count > 0) { ArrayList idarray = new ArrayList(); string purorderId = string.Empty; decimal totalInvoiceAmount = 0; for (int j = 0; j < entStrList.Count; j++) { Newtonsoft.Json.Linq.JObject objL = JsonHelper.GetObject <Newtonsoft.Json.Linq.JObject>(entStrList[j]); PurchaseInvoiceDetail pbdEnt = new PurchaseInvoiceDetail(); pbdEnt.PurchaseInvoiceId = piEnt.Id; pbdEnt.PurchaseOrderDetailId = objL.Value <string>("PurchaseOrderDetailId"); pbdEnt.ProductId = objL.Value <string>("ProductId"); pbdEnt.ProductCode = objL.Value <string>("ProductCode"); pbdEnt.ProductName = objL.Value <string>("ProductName"); pbdEnt.BuyPrice = Convert.ToDecimal(objL.Value <string>("BuyPrice")); pbdEnt.InvoiceQuantity = Convert.ToInt32(objL.Value <string>("InvoiceQuantity")); pbdEnt.InvoiceAmount = Convert.ToDecimal(objL.Value <string>("InvoiceAmount")); pbdEnt.DoCreate(); totalInvoiceAmount += pbdEnt.InvoiceAmount.Value; //循环每个采购详细的发票数量 如果==采购数 则状态改为已关联 int novoice = Convert.ToInt32(DataHelper.QueryValue("select SHHG_AimExamine.dbo.fun_getNoInvoiceQuantityByPurchaseOrderDetailId('" + pbdEnt.PurchaseOrderDetailId + "')")); if (novoice == 0) { PurchaseOrderDetail podEnt = PurchaseOrderDetail.TryFind(objL.Value <string>("PurchaseOrderDetailId")); if (podEnt.PurchaseOrderId != purorderId) { idarray.Add(podEnt.PurchaseOrderId); purorderId = podEnt.PurchaseOrderId; } podEnt.InvoiceState = "已关联"; podEnt.DoUpdate(); } } //如果所有发票详细的金额==发票的总金额 则把发票的状态改为已关联 if (totalInvoiceAmount == piEnt.InvoiceAmount) { piEnt.State = "已关联"; piEnt.DoUpdate(); } //遍历采购单 如果其下所有的采购详细的发票状态都是已关联 则自身变为已关联 for (int k = 0; k < idarray.Count; k++) { IList <EasyDictionary> edics = DataHelper.QueryDictList("select Id from SHHG_AimExamine..PurchaseOrderDetail where PurchaseOrderId='" + idarray[k].ToString() + "' and InvoiceState='未关联'"); if (edics.Count == 0) { PurchaseOrder poEnt = PurchaseOrder.TryFind(idarray[k].ToString()); poEnt.InvoiceState = "已关联"; if (poEnt.InWarehouseState == "已入库" && poEnt.PayState == "已付款") { poEnt.OrderState = "已结束"; } poEnt.DoUpdate(); } } } }
public PurchaseInvoiceDetail VHasPurchaseInvoice(PurchaseInvoiceDetail purchaseInvoiceDetail, IPurchaseInvoiceService _purchaseInvoiceService) { PurchaseInvoice purchaseInvoice = _purchaseInvoiceService.GetObjectById(purchaseInvoiceDetail.PurchaseInvoiceId); if (purchaseInvoice == null) { purchaseInvoiceDetail.Errors.Add("PurchaseInvoiceId", "Tidak terasosiasi dengan purchase invoice"); } return(purchaseInvoiceDetail); }
public PurchaseInvoiceDetail VHasPurchaseReceivalDetail(PurchaseInvoiceDetail purchaseInvoiceDetail, IPurchaseReceivalDetailService _purchaseReceivalDetailService) { PurchaseReceivalDetail prd = _purchaseReceivalDetailService.GetObjectById(purchaseInvoiceDetail.PurchaseReceivalDetailId); if (prd == null) { purchaseInvoiceDetail.Errors.Add("PurchaseReceivalDetail", "Tidak boleh tidak ada"); } return(purchaseInvoiceDetail); }
public ActionResult CreateNew(int id) { var purchaseinvoice = db.PurchaseInvoices.Where(b => b.PurchaseInvoiceID == id).ToList(); var purchaseinvoicedetail = db.PurchaseInvoiceDetails.Where(b => b.PurchaseInvoiceID == id).ToList(); if (purchaseinvoicedetail.Count == 0) { PurchaseInvoiceDetail purchaseinvoicedetailnew = new PurchaseInvoiceDetail(); purchaseinvoicedetailnew.Description = "-"; purchaseinvoicedetailnew.PurchaseInvoiceID = id; purchaseinvoicedetailnew.Quantity = 0; purchaseinvoicedetailnew.PurchaseInvoiceDetailUnit = 0; purchaseinvoicedetailnew.Rate = 0.00M; purchaseinvoicedetailnew.RateFC = 0.00M; purchaseinvoicedetailnew.DetailValue = 0.00M; purchaseinvoicedetailnew.DetailValueFC = 0.00M; purchaseinvoicedetailnew.Tax = 0; purchaseinvoicedetailnew.NetValue = 0.00M; purchaseinvoicedetailnew.AccountHeadID = 1; purchaseinvoicedetailnew.DetailJob = ""; purchaseinvoicedetailnew.ProductsServices = ""; purchaseinvoicedetailnew.Flag = false; db.PurchaseInvoiceDetails.Add(purchaseinvoicedetailnew); db.SaveChanges(); ViewBag.SingleRow = "1"; } PurchaseInvoicePurchaseInvoiceDetailPurchaseInvoiceDetailAllocationModel multiModel = new PurchaseInvoicePurchaseInvoiceDetailPurchaseInvoiceDetailAllocationModel(); multiModel.PurchaseInvoices = purchaseinvoice; multiModel.PurchaseInvoiceDetails = purchaseinvoicedetail; foreach (PurchaseInvoice bv in purchaseinvoice) { ViewBag.EmployeeID = new SelectList(db.Employees.Where(e => e.EmployeeID > 1), "EmployeeID", "Name", bv.EmployeeID); ViewBag.SupplierID = new SelectList(db.Suppliers, "SupplierID", "Name", bv.SupplierID); ViewBag.CurrencyID = new SelectList(db.Currencys, "CurrencyID", "Name", bv.CurrencyID); ViewBag.DiscountTypeID = new SelectList(db.DiscountTypes, "DiscountTypeID", "Name", bv.DiscountTypeID); var currencyexchangerate = db.Currencys.Where(c => c.CurrencyID == bv.CurrencyID).ToList(); foreach (Currency c in currencyexchangerate) { ViewBag.ExchangeRate = c.ExchangeRate; } } ViewBag.AccountHeads = db.AccountHeads.OrderBy(a => a.Name); ViewBag.Message = Session["msg"]; ViewBag.Error = Session["err"]; Session["err"] = ""; Session["msg"] = ""; ViewBag.Message1 = Session["msg1"]; Session["msg1"] = ""; ViewBag.PageType = "CreateNew"; return(View(multiModel)); }
public PurchaseInvoiceDetail SoftDeleteObject(PurchaseInvoiceDetail purchaseInvoiceDetail, IPurchaseInvoiceService _purchaseInvoiceService) { // TODO : Hard Delete if (_validator.ValidDeleteObject(purchaseInvoiceDetail)) { PurchaseInvoice purchaseInvoice = _purchaseInvoiceService.GetObjectById(purchaseInvoiceDetail.PurchaseInvoiceId); _repository.SoftDeleteObject(purchaseInvoiceDetail); _purchaseInvoiceService.CalculateAmountPayable(purchaseInvoice, this); } return(purchaseInvoiceDetail); }
protected void edit_product_Command(object sender, CommandEventArgs e) { int index = Convert.ToInt32(e.CommandArgument); List <PurchaseInvoiceDetail> gvr = (List <PurchaseInvoiceDetail>)GridView1.DataSource; PurchaseInvoiceDetail PurInvoDetEdit = gvr[index]; HidenIdpurchasInvDe.Value = PurInvoDetEdit.ID.ToString(); ProductListtxt.SelectedValue = PurInvoDetEdit.ProductID.ToString(); Qty.Text = PurInvoDetEdit.Qty.ToString(); ProductPrice.Text = PurInvoDetEdit.ProductPrice.ToString(); }
public PurchaseInvoiceMaster AddPurchaseInvoicemaster(PurchaseViewModel str) { PurchaseInvoiceMaster pur = new PurchaseInvoiceMaster(); pur.CustomerID = str.CustomerID; pur.PurchaseInvoiceNum = str.SupplierInvoice; pur.PurchaseDate = str.PurchaseDate; pur.InvoiceDate = str.SupplierInvoiceDate; pur.TotalBill = str.InvoiceValue; pur.TotalPaid = str.InvoiceValue; pur.TotalDiscount = 0; pur.StoreID = int.Parse(System.Web.HttpContext.Current.Session["storeid"].ToString()); pur.AddedUser = System.Web.HttpContext.Current.Session["username"].ToString(); pur.AddedDate = DateTime.Now; pur.IsDeleted = false; pur.IsCommited = false; cntxt.PurchaseInvoicemasters.Add(pur); cntxt.SaveChanges(); foreach (PurchasedetailViewModel strdet in str.purchasedetailViewModels) { PurchaseInvoiceDetail purchaseInvoiceDetail = new PurchaseInvoiceDetail(); purchaseInvoiceDetail.PurchaseInvoicemasterID = pur.PurchaseInvoicemasterID; purchaseInvoiceDetail.CategoryID = strdet.CategoryID; purchaseInvoiceDetail.ItemNameId = strdet.ItemNameID; purchaseInvoiceDetail.ProductName = strdet.ProductDetails; purchaseInvoiceDetail.Qty = strdet.TotalQty; purchaseInvoiceDetail.SerialNum = strdet.Serial; purchaseInvoiceDetail.TotalPrice = strdet.TotalPrice; purchaseInvoiceDetail.UnitCP = strdet.UnitPrice; purchaseInvoiceDetail.UnitSP = strdet.SellingPrice; purchaseInvoiceDetail.CGSTPercent = strdet.CGSTPercent; purchaseInvoiceDetail.SGSTPercent = strdet.SGSTPercent; purchaseInvoiceDetail.UnitCGSTCP = 0; purchaseInvoiceDetail.UnitSGSTSP = 0; purchaseInvoiceDetail.UserID = 0; purchaseInvoiceDetail.AddedUser = System.Web.HttpContext.Current.Session["username"].ToString(); purchaseInvoiceDetail.AddedDate = DateTime.Now; purchaseInvoiceDetail.IsDeleted = false; cntxt.PurchaseInvoiceDetails.Add(purchaseInvoiceDetail); } cntxt.SaveChanges(); return(pur); }
public PurchaseInvoiceDetail VUpdateObject(PurchaseInvoiceDetail purchaseInvoiceDetail, IPurchaseInvoiceService _purchaseInvoiceService, IPurchaseInvoiceDetailService _purchaseInvoiceDetailService, IPurchaseReceivalDetailService _purchaseReceivalDetailService) { VHasNotBeenConfirmed(purchaseInvoiceDetail); if (!isValid(purchaseInvoiceDetail)) { return(purchaseInvoiceDetail); } VCreateObject(purchaseInvoiceDetail, _purchaseInvoiceService, _purchaseInvoiceDetailService, _purchaseReceivalDetailService); return(purchaseInvoiceDetail); }
public PurchaseInvoiceDetail UnconfirmObject(PurchaseInvoiceDetail purchaseInvoiceDetail, IPurchaseReceivalService _purchaseReceivalService, IPurchaseReceivalDetailService _purchaseReceivalDetailService) { if (_validator.ValidUnconfirmObject(purchaseInvoiceDetail)) { purchaseInvoiceDetail = _repository.UnconfirmObject(purchaseInvoiceDetail); // reverse purchase receival detail PendingInvoiceQuantity PurchaseReceivalDetail purchaseReceivalDetail = _purchaseReceivalDetailService.GetObjectById(purchaseInvoiceDetail.PurchaseReceivalDetailId); _purchaseReceivalDetailService.UndoInvoiceObject(purchaseReceivalDetail, purchaseInvoiceDetail.Quantity, _purchaseReceivalService); } return(purchaseInvoiceDetail); }
public PurchaseInvoiceDetail ConfirmObject(PurchaseInvoiceDetail purchaseInvoiceDetail, DateTime ConfirmationDate, IPurchaseReceivalDetailService _purchaseReceivalDetailService) { purchaseInvoiceDetail.ConfirmationDate = ConfirmationDate; if (_validator.ValidConfirmObject(purchaseInvoiceDetail, this, _purchaseReceivalDetailService)) { purchaseInvoiceDetail = _repository.ConfirmObject(purchaseInvoiceDetail); // update purchase receival detail PendingInvoiceQuantity PurchaseReceivalDetail purchaseReceivalDetail = _purchaseReceivalDetailService.GetObjectById(purchaseInvoiceDetail.PurchaseReceivalDetailId); _purchaseReceivalDetailService.InvoiceObject(purchaseReceivalDetail, purchaseInvoiceDetail.Quantity); } return(purchaseInvoiceDetail); }
public PurchaseInvoiceDetail VIsUniquePurchaseReceivalDetail(PurchaseInvoiceDetail purchaseInvoiceDetail, IPurchaseInvoiceDetailService _purchaseInvoiceDetail, IPurchaseReceivalDetailService _purchaseReceivalDetailService) { IList <PurchaseInvoiceDetail> details = _purchaseInvoiceDetail.GetObjectsByPurchaseInvoiceId(purchaseInvoiceDetail.PurchaseInvoiceId); foreach (var detail in details) { if (detail.PurchaseReceivalDetailId == purchaseInvoiceDetail.PurchaseReceivalDetailId && detail.Id != purchaseInvoiceDetail.Id) { purchaseInvoiceDetail.Errors.Add("PurchaseInvoiceDetail", "Tidak boleh memiliki lebih dari 2 Purchase Receival Detail"); } } return(purchaseInvoiceDetail); }
public PurchaseInvoiceDetail CreateObject(int purchaseInvoiceId, int purchaseReceivalDetailId, int quantity, decimal amount, IPurchaseInvoiceService _purchaseInvoiceService, IPurchaseOrderDetailService _purchaseOrderDetailService, IPurchaseReceivalDetailService _purchaseReceivalDetailService) { PurchaseInvoiceDetail purchaseInvoiceDetail = new PurchaseInvoiceDetail { PurchaseInvoiceId = purchaseInvoiceId, PurchaseReceivalDetailId = purchaseReceivalDetailId, Quantity = quantity }; return(this.CreateObject(purchaseInvoiceDetail, _purchaseInvoiceService, _purchaseOrderDetailService, _purchaseReceivalDetailService)); }
public string PrintError(PurchaseInvoiceDetail obj) { string erroroutput = ""; KeyValuePair <string, string> first = obj.Errors.ElementAt(0); erroroutput += first.Key + "," + first.Value; foreach (KeyValuePair <string, string> pair in obj.Errors.Skip(1)) { erroroutput += Environment.NewLine; erroroutput += pair.Key + "," + pair.Value; } return(erroroutput); }
public PurchaseInvoiceDetail UpdateObject(PurchaseInvoiceDetail purchaseInvoiceDetail, IPurchaseInvoiceService _purchaseInvoiceService, IPurchaseOrderDetailService _purchaseOrderDetailService, IPurchaseReceivalDetailService _purchaseReceivalDetailService) { if (_validator.ValidUpdateObject(purchaseInvoiceDetail, _purchaseInvoiceService, this, _purchaseReceivalDetailService)) { PurchaseReceivalDetail purchaseReceivalDetail = _purchaseReceivalDetailService.GetObjectById(purchaseInvoiceDetail.PurchaseReceivalDetailId); PurchaseOrderDetail purchaseOrderDetail = _purchaseOrderDetailService.GetObjectById(purchaseReceivalDetail.PurchaseOrderDetailId); purchaseInvoiceDetail.Amount = purchaseInvoiceDetail.Quantity * purchaseOrderDetail.Price; _repository.UpdateObject(purchaseInvoiceDetail); PurchaseInvoice purchaseInvoice = _purchaseInvoiceService.GetObjectById(purchaseInvoiceDetail.PurchaseInvoiceId); _purchaseInvoiceService.CalculateAmountPayable(purchaseInvoice, this); } return(purchaseInvoiceDetail); }
private List <PurchaseInvoiceDetail> GetChildOnCreate(PurchaseInvoice master, PurchaseInvoiceComplex source) { List <PurchaseInvoiceDetail> infos = new List <PurchaseInvoiceDetail>(); var wanted = source.ChildList.Where(x => x.IsDirty == true); foreach (var item in wanted) { PurchaseInvoiceDetail temp = Mapper.Map <PurchaseInvoiceDetail>(item); temp.InvoiceID = master.InvoiceID; temp.LastPerson = IdentityService.GetUserData().UserID; temp.LastUpdate = DateTime.Now; infos.Add(temp); } return(infos); }
public PurchaseInvoiceDetail VConfirmObject(PurchaseInvoiceDetail purchaseInvoiceDetail, IPurchaseInvoiceDetailService _purchaseInvoiceDetailService, IPurchaseReceivalDetailService _purchaseReceivalDetailService) { VHasConfirmationDate(purchaseInvoiceDetail); if (!isValid(purchaseInvoiceDetail)) { return(purchaseInvoiceDetail); } VHasNotBeenConfirmed(purchaseInvoiceDetail); if (!isValid(purchaseInvoiceDetail)) { return(purchaseInvoiceDetail); } VQuantityIsLessThanOrEqualPendingInvoiceQuantity(purchaseInvoiceDetail, _purchaseReceivalDetailService); return(purchaseInvoiceDetail); }
private void DoBatchDelete() { IList <object> idList = RequestData.GetList <object>("IdList"); if (idList != null && idList.Count > 0) { foreach (object obj in idList) { IList <PurchaseInvoiceDetail> pidEnts = PurchaseInvoiceDetail.FindAll("from PurchaseInvoiceDetail where PurchaseInvoiceId='" + obj.ToString() + "'"); PurchaseInvoice piEnt = PurchaseInvoice.Find(obj); DeleteInvoiceDetail(piEnt); DataHelper.ExecSql("delete SHHG_AimExamine..PurchaseInvoice where Id='" + obj.ToString() + "'"); } } }