public static void SaveTransHis(VehicleDataContext dc, ItemInstance ItemIns, DateTime txtime, ItemStatus TransType, int cusPayType, decimal ActualCost, string Modifiefby, string OlderEngine,string from, string to)
{
var th = new SaleTransHistory();
th.ActualCost = ActualCost;
th.ReferenceOrderId = 0;
th.FromBranch = from;
th.ToBranch = to;
th.ModifiedDate = DateTime.Now;
th.ItemInstance = ItemIns;
th.TransactionDate = txtime;
th.TransactionType = (int)TransType;
th.ModifiedBy = Modifiefby;
th.OldEngineNo = (OlderEngine == null) ? null : OlderEngine;
dc.SaleTransHistories.InsertOnSubmit(th);
}
public static Entity.SaleTransHistory SaveTransHist(VehicleDataContext db, ItemInstance IInst, DateTime tranDate, ItemStatus status, long ActualCost, string dCode, string bCode)
{
var transHis = new SaleTransHistory
{
ActualCost = ActualCost,
FromBranch = "",
ToBranch = string.Format("{0}-{1}", dCode, bCode),
ModifiedDate = DateTime.Now,
ItemInstance = IInst,
TransactionDate = tranDate,
TransactionType = (int) status,
ModifiedBy = UserHelper.Username
};
db.SaleTransHistories.InsertOnSubmit(transHis);
return transHis;
}
public static ShippingDetail SaveOrUpdateShippingDetail(VehicleDataContext db,long shipId, Entity.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();
SD =
db.ShippingDetails.FirstOrDefault(
p => p.ShippingId == shipId && p.EngineNumber == engineNumber.Trim());
if (SD == null)
{
SD = new ShippingDetail();
SD.ShippingId = shipId;
SD.EngineNumber = engineNumber;
db.ShippingDetails.InsertOnSubmit(SD);
}
SD.ItemType = itemType;
SD.Color = color;
SD.Item = item;
SD.BranchCode = branchCode;
SD.OrderNumber = orderNumber;
SD.Status = status;
SD.VoucherStatus = voucher? 1:0;
SD.ItemCode = item.ItemCode;
SD.VMEPResponseDate = DateTime.MinValue;
if (itemInstance != null) SD.ProductInstanceId = itemInstance.ItemInstanceId;
//if (!string.IsNullOrEmpty(ex))
SD.Exception = ex;
return SD;
}
public static ItemInstance SaveOrUpdateItemInstance(VehicleDataContext db, string dealerCode, string branchCode, string engineNumber, string shipNumber, string invoice, string itemType, Entity.Item item, DateTime impDate, string color, int status, DateTime madeDate, string DatabaseCode)
{
var IIS = db.ItemInstances.FirstOrDefault(p => p.EngineNumber.Equals(engineNumber.Trim()));
if (IIS == null)
{
IIS = new ItemInstance { CreatedDate = DateTime.Now };
IIS.EngineNumber = engineNumber;
db.ItemInstances.InsertOnSubmit(IIS);
}
// get shipping header to take some data
//var SH = db.ShippingHeaders.FirstOrDefault(p => p.ShippingNumber == (shipNumber.Trim()));
//if (SH == null)
//{
// Exception e = new Exception("Shipping number does not exist: " + shipNumber);
// throw e;
//}
//else
//{
// save to database
//IIS.Dealercode = SH.Dealercode;
IIS.ItemType = itemType;
IIS.ItemCode = item.ItemCode;
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.Parse("9999/12/31");
// }
return IIS;
}
//public static List<int> GetItemStatusForSale()
//{
// List<int> list = new List<int>();
// list.Add((int)ItemStatus.AdmitTemporarily);
// list.Add((int)ItemStatus.Imported);
// list.Add((int)ItemStatus.Moved);
// list.Add((int)ItemStatus.Redundant);
// return list;
//}
// select sold items and tiptop items for service
private List<ItemInstance> SelectFromTipTop(int maximumRows, int startRowIndex, string engineNumberLike, string dealerCode, string databaseCode1, string databaseCode2)
{
int page = (maximumRows == 0) ? 0 : startRowIndex / maximumRows;
string databaseCode = databaseCode1;
// get data from tiptop
DataSet ds = Motorbike.GetItemInfo(engineNumberLike, databaseCode, dealerCode, page, maximumRows);
if ((ds == null) || (ds.Tables[0].Rows.Count == 0))
{
databaseCode = databaseCode2;
ds = Motorbike.GetItemInfo(engineNumberLike, databaseCode, dealerCode, page, maximumRows);
}
// count items
count = (int)Motorbike.GetItemInfoCount(engineNumberLike, databaseCode, dealerCode);
HttpContext.Current.Items["listgvSelectEngineRowCount"] = count;
// re pagging if startRow is wrong
if (startRowIndex >= count && count > 0)
{
ds = Motorbike.GetItemInfo(engineNumberLike, databaseCode, dealerCode, 0, maximumRows);
}
// build return list
List<ItemInstance> list = new List<ItemInstance>();
ItemInstance item;
var row = ds.Tables[0].Rows;
int count_ds = row.Count - 1 ;
while(count_ds >= 0)
{
var moreinfo = Motorbike.GetMoreItemInfo(row[count_ds]["EngineNo"].ToString(), row[count_ds]["DatabaseCode"].ToString());
if (!string.IsNullOrEmpty(dealerCode))
{
if (moreinfo.Tables[0].Rows[0]["DealerCode"] != dealerCode)
{
count_ds--;
continue;
}
}
item = new ItemInstance();
if (moreinfo.Tables[0].Rows.Count > 0)
{
item.DealerCode = moreinfo.Tables[0].Rows[0]["DealerCode"].ToString();
item.BranchCode = moreinfo.Tables[0].Rows[0]["DealerCode"].ToString();
item.MadeDate = (DateTime)moreinfo.Tables[0].Rows[0]["OutStockDate"]; ;
item.ImportedDate = (DateTime)moreinfo.Tables[0].Rows[0]["OutStockDate"];
}
item.Item = new Entity.Item();
item.Item.ItemCode = row[count_ds]["ItemCode"].ToString();
item.Item.DatabaseCode = databaseCode;
item.Item.ColorCode = row[count_ds]["ColorCode"].ToString();
item.Item.ColorName = row[count_ds]["ColorCode"].ToString();
item.Item.ItemType = row[count_ds]["ItemCode"].ToString();
item.ItemInstanceId = 0;
item.DatabaseCode = row[count_ds]["DatabaseCode"].ToString();
item.ItemType = item.Item.ItemType;
item.Color = row[count_ds]["ColorCode"].ToString();
item.EngineNumber = row[count_ds]["EngineNo"].ToString();
item.ReleasedDate = DateTime.MinValue;
list.Add(item);
count_ds--;
}
return list;
}
public ItemInstanceEx(ItemInstance i)
{
this.BranchCode = i.BranchCode;
this.Color = i.Color;
this.Comments = i.Comments;
this.CreatedDate = i.CreatedDate;
this.DatabaseCode = i.DatabaseCode;
this.DealerCode = i.DealerCode;
this.EngineNumber = i.EngineNumber;
this.ImportedDate = i.ImportedDate;
//this.Item = i.Item;
this.ItemCode = i.ItemCode;
this.ItemInstanceId = i.ItemInstanceId;
this.ItemType = i.ItemType;
this.MadeDate = i.MadeDate;
this.ReleasedDate = i.ReleasedDate;
this.Status = i.Status;
this.VMEPInvoice = i.VMEPInvoice;
//var sd = i.ShippingDetails.Where(d => d.ShippingHeader.DealerCode == UserHelper.DealerCode).OrderByDescending(s => s.ShippingDetailId).FirstOrDefault();
int voucherstatus = 1;
var sd = CheckVoucherStatus(i.ItemInstanceId, i.DealerCode, i.BranchCode, i.EngineNumber, out voucherstatus);
this.HasVoucher = sd ? false : 1 == voucherstatus;
this.VoucherStatus = sd ? 0 : voucherstatus;
//var sd = s.OrderByDescending(v => v.ShippingDetailId).FirstOrDefault();
//this.HasVoucher = sd == null ? false : sd.VoucherStatus == 1;
//this.VoucherStatus = sd == null ? 0 : sd.VoucherStatus;
}
public static void SetSelectEngineSession(string key, ItemInstance val)
{
HttpContext.Current.Session[string.Format(PopupHelper.SelectEngineSessionString, key)] = val;
}
private void detach_ItemInstances(ItemInstance entity)
{
this.SendPropertyChanging("ItemInstances");
entity.Item = null;
}