public static Invoice GetInvoiceByItemInstance(Iteminstance ii) { Invoice res; IDao<Invoice, long> dao = DaoFactory.GetDao<Invoice, long>(); dao.SetCriteria(new ICriterion[] { Expression.Eq("Iteminstance", ii) }); List<Invoice> listInvoice = dao.GetAll(); if (listInvoice.Count > 0) { res = listInvoice[0]; return res; } return null; }
public static Shippingdetail GetShippingdetailByItemInstance(Iteminstance ii) { Shippingdetail res; Shippingdetail sh = new Shippingdetail(); IDao<Shippingdetail, long> dao = DaoFactory.GetDao<Shippingdetail, long>(); dao.SetCriteria(new ICriterion[] { Expression.Eq("PRODUCTINSTANCE", ii) }); List<Shippingdetail> listShippingdetail = dao.GetAll(); if (listShippingdetail.Count > 0) { res = new Shippingdetail(); res = listShippingdetail[0]; return res; } return null; }
/* tntung * 30/07/2007 */ public TransHis SaveTranHis(Iteminstance ItemIns, DateTime txtime, ItemStatus TransType, int cusPayType, decimal ActualCost, string Modifiefby, string OlderEngine,string from, string to) { TransHis tshx = new TransHis(); tshx.Actualcost = ActualCost; tshx.Referenceorderid = 0; tshx.Frombranch = from; tshx.Tobranch = to; tshx.Modifieddate = DateTime.Now; tshx.Iteminstance = ItemIns; tshx.Transactiondate = txtime; tshx.Transactiontype = (int)TransType; tshx.Modifiedby = Modifiefby; tshx.Oldengineno = (OlderEngine == null) ? null : OlderEngine; return tshx; }
public static Iteminstance SaveOrUpdateItemInstance(string dealerCode, string branchCode, string engineNumber, string shipNumber, string invoice, string itemType, Item item, DateTime impDate, string color, int status, DateTime madeDate, string DatabaseCode) { IDao<Iteminstance, long> dao; //List<Iteminstance> list; Iteminstance IIS = null; dao = DaoFactory.GetDao<Iteminstance, long>(); dao.SetCriteria(new ICriterion[] { Expression.Eq("Enginenumber", engineNumber.Trim()) }); //// khong cho phep de` du lieu xe cu //if (dao.GetCount() > 0) //{ // Exception e = new Exception("Enginenumber exist: " + engineNumber); // throw e; //} List<Iteminstance> list = dao.GetAll(); if (list.Count > 0) IIS = (Iteminstance)list[0]; else { IIS = new Iteminstance(); IIS.Createddate = DateTime.Now; } // get shipping header to take some data ShippingHeader SH = GetShippingHeaderByShippingNumber(shipNumber); if (SH == null) { Exception e = new Exception("Shipping number does not exist: " + shipNumber); throw e; } else { // save to database //IIS.Dealercode = SH.Dealercode; IIS.Enginenumber = engineNumber; IIS.Itemtype = itemType; IIS.Item = item; IIS.Importeddate = impDate; IIS.Color = color; IIS.Status = status; IIS.Dealercode = dealerCode; IIS.Vmepinvoice = invoice; IIS.Databasecode = DatabaseCode; if (madeDate > DateTime.MinValue) IIS.Madedate = madeDate; IIS.Branchcode = branchCode; IIS.Releaseddate = DateTime.MaxValue; dao.SaveOrUpdate(IIS); } return IIS; }
public static TransHis SaveTransHist(Iteminstance IInst, DateTime tranDate, ItemStatus status, long ActualCost, string dCode, string bCode) { IDao<TransHis, long> dao = DaoFactory.GetDao<TransHis, long>(); TransHis transHis = new TransHis(); transHis.Actualcost = ActualCost; transHis.Frombranch = ""; transHis.Tobranch = string.Format("{0}-{1}", dCode, bCode); transHis.Modifieddate = DateTime.Now; transHis.Iteminstance = IInst; transHis.Transactiondate = tranDate; transHis.Transactiontype = (int)status; transHis.Modifiedby = UserHelper.Username; try { return dao.Save(transHis); } catch { return null; } }
public static Shippingdetail SaveOrUpdateShippingDetail(long shipId, Item item, string engineNumber, int status, bool voucher, string ex, Iteminstance itemInstance, string itemType, string color, string branchCode, string orderNumber) { IDao<Shippingdetail, long> dao; IDao<ShippingHeader, long> shdao; List<Shippingdetail> list; Shippingdetail SD = null; dao = DaoFactory.GetDao<Shippingdetail, long>(); dao.SetCriteria(new ICriterion[] { Expression.And(Expression.Eq("Shippingheader.Id", shipId), Expression.Eq("Enginenumber", engineNumber.Trim())) }); list = dao.GetAll(); if (list.Count > 0) SD = (Shippingdetail)list[0]; if (SD == null) { shdao = DaoFactory.GetDao<ShippingHeader, long>(); SD = new Shippingdetail(); SD.Shippingheader = shdao.GetById(shipId, false); //true -> false SD.Enginenumber = engineNumber; } SD.Itemtype = itemType; SD.Color = color; SD.Item = item; SD.Branchcode = branchCode; SD.Ordernumber = orderNumber; SD.Status = status; SD.Voucherstatus = voucher; if (itemInstance != null) SD.PRODUCTINSTANCE = itemInstance; //if (!string.IsNullOrEmpty(ex)) SD.Exception = ex; dao.SaveOrUpdate(SD); return SD; }
private bool CheckAppliable(Iteminstance itemins) { switch (Motorbike.CheckExchangeEngineNo(txtEngineNo.Text.Trim(), txtEngineNoCancel.Text.Trim(), itemins.Item.Id.ToString())) { case 0: return true; case -1: ShowMessage(Resources.Message.Reformation_ApplyCase1, true); return false; case -2: ShowMessage(Resources.Message.Reformation_ApplyCase2, true); return false; case -3: ShowMessage(Resources.Message.Reformation_ApplyCase3, true); return false; default: return false; } }
private decimal GetItemIssuePrice(Iteminstance iis) { decimal price = 0; IDao<TransHis, long> dao = DaoFactory.GetDao<TransHis, long>(); dao.SetCriteria(new ICriterion[] { Expression.Eq("Iteminstance", iis), Expression.In("Transactiontype", new int[] { (int)ItemStatus.Imported, (int)ItemStatus.AdmitTemporarily }) }); dao.SetOrder(new NHibernate.Expression.Order[] { NHibernate.Expression.Order.Asc("Transactiondate") }); List<TransHis> list = dao.GetAll(); if (list.Count > 0) price = list[0].Actualcost; return price; }