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;
}
