public static EF6.ProductPriceType Get(Guid id) { EF6.ProductPriceType result = null; using (var ctx = new EF6.RT2020Entities()) { result = ctx.ProductPriceType.Where(x => x.PriceTypeId == id).AsNoTracking().FirstOrDefault(); } return(result); }
public static Guid GetIdByPriceType(string type) { Guid result = Guid.Empty; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.ProductPriceType.Where(x => x.PriceType == type).FirstOrDefault(); if (item == null) { //* 點解冇就 create ? item = new EF6.ProductPriceType(); item.PriceTypeId = Guid.NewGuid(); item.PriceType = type; item.CurrencyCode = "HKD"; item.CoreSystemPrice = false; ctx.ProductPriceType.Add(item); ctx.SaveChanges(); } result = item.PriceTypeId; } return(result); }
private Guid GetPriceType(string priceType) { Guid result = Guid.Empty; using (var ctx = new EF6.RT2020Entities()) { string sql = "PriceType = '" + priceType + "'"; var oType = ctx.ProductPriceType.Where(x => x.PriceType == priceType).FirstOrDefault(); if (oType == null) { oType = new EF6.ProductPriceType(); oType.PriceTypeId = Guid.NewGuid(); oType.PriceType = priceType; oType.CurrencyCode = "HKD"; oType.CoreSystemPrice = false; ctx.ProductPriceType.Add(oType); ctx.SaveChanges(); result = oType.PriceTypeId; } } return(result); }