private SalesUnitPriceUIDM MapDTOToModel(SalesUnitPriceDTO Price, ItemDTO Item, DealingDTO Customer) { SalesUnitPriceUIDM model = new SalesUnitPriceUIDM(); model.CRT_BY = Price.CRT_BY; model.CRT_DATE = Price.CRT_DATE; model.CRT_MACHINE = Price.CRT_MACHINE; model.UPD_BY = Price.UPD_BY; model.UPD_DATE = Price.UPD_DATE; model.UPD_MACHINE = Price.UPD_MACHINE; model.ITEM_CD = Price.ITEM_CD; model.START_EFFECTIVE_DATE = Price.START_EFFECTIVE_DATE; model.PRICE = Price.PRICE; model.CURRENCY = Price.CURRENCY; model.REMARK = Price.REMARK; model.OLD_DATA = Price.OLD_DATA; if (Item != null && !Item.ITEM_DESC.IsNull) { model.SHORT_NAME = Item.SHORT_NAME; } if (Customer != null && !Customer.LOC_DESC.IsNull) { model.CUSTOMER_NAME = Customer.LOC_DESC; } return(model); }
/// <summary> /// Update record by using primary key value on the given data variable /// </summary> /// <param name="database"></param> /// <param name="data">Data with primary key value.</param> /// <returns></returns> public int UpdateWithoutPK(Database database, SalesUnitPriceDTO data) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" UPDATE " + data.TableName); sb.AppendLine(" SET "); sb.AppendLine(" " + SalesUnitPriceDTO.eColumns.UPD_BY + "=@UPD_BY"); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.UPD_DATE + "=GETDATE()"); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.UPD_MACHINE + "=@UPD_MACHINE"); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.PRICE + "=@PRICE"); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.REMARK + "=@REMARK"); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.OLD_DATA + "=@OLD_DATA"); sb.AppendLine(" WHERE "); sb.AppendLine(" " + SalesUnitPriceDTO.eColumns.ITEM_CD + "=@ITEM_CD"); sb.AppendLine(" AND " + SalesUnitPriceDTO.eColumns.START_EFFECTIVE_DATE + "=@START_EFFECTIVE_DATE"); sb.AppendLine(" AND " + SalesUnitPriceDTO.eColumns.CURRENCY + "=@CURRENCY"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("@UPD_BY", DataType.NVarChar, data.UPD_BY.Value); req.Parameters.Add("@UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value); req.Parameters.Add("@ITEM_CD", DataType.Default, data.ITEM_CD.Value); req.Parameters.Add("@START_EFFECTIVE_DATE", DataType.DateTime, data.START_EFFECTIVE_DATE.Value); req.Parameters.Add("@PRICE", DataType.Number, data.PRICE.Value); req.Parameters.Add("@CURRENCY", DataType.NVarChar, data.CURRENCY.Value); req.Parameters.Add("@REMARK", DataType.NVarChar, data.REMARK.Value); req.Parameters.Add("@OLD_DATA", DataType.Default, data.OLD_DATA.Value); #endregion return(db.ExecuteNonQuery(req)); }
public void SaveUpdate(SalesUnitPriceUIDM data) { SalesUnitPriceDTO dto = MapModelToDTO(data); SalesUnitPriceBIZ biz = new SalesUnitPriceBIZ(); biz.SaveUpdate(dto); }
public void ValidateBeforeSaveNew(SalesUnitPriceDTO dto) { BusinessException businessException = CheckSalesUnitPriceExist(dto.ITEM_CD, dto.START_EFFECTIVE_DATE, dto.CURRENCY); if (businessException != null) { throw businessException; } }
/// <summary> /// /// </summary> /// <param name="data"></param> /// <returns></returns> /// <exception cref="EVOFramework.ValidateException"><c>ValidateException</c>.</exception> /// <exception cref="EVOFramework.BusinessException"><c>BusinessException</c>.</exception> public int SaveUpdate(SalesUnitPriceDTO data) { SalesUnitPriceValidator validator = new SalesUnitPriceValidator(); validator.ValidateBeforeSaveUpdate(data); SalesUnitPriceDAO dao = new SalesUnitPriceDAO(CommonLib.Common.CurrentDatabase); return(dao.UpdateWithoutPK(null, data)); }
/// <summary> /// /// </summary> /// <param name="data"></param> /// <returns></returns> /// <exception cref="EVOFramework.ValidateException"><c>ValidateException</c>.</exception> /// <exception cref="EVOFramework.BusinessException"><c>BusinessException</c>.</exception> public int SaveNew(SalesUnitPriceDTO data) { SalesUnitPriceValidator validator = new SalesUnitPriceValidator(); validator.ValidateBeforeSaveNew(data); SalesUnitPriceDAO dao = new SalesUnitPriceDAO(CommonLib.Common.CurrentDatabase); return(dao.AddNew(null, data)); }
/// <summary> /// Check exist before manipulate data. If found record will update data. Otherwise insert new data. /// </summary> /// <param name="database"></param> /// <param name="data"></param> /// <returns></returns> public int AddNewOrUpdate(Database database, SalesUnitPriceDTO data) { Database db = UseDatabase(database); if (Exist(database, data.ITEM_CD, data.START_EFFECTIVE_DATE, data.CURRENCY)) { return(UpdateWithoutPK(db, data)); } return(AddNew(db, data)); }
/// <summary> /// Insert new record into database. /// </summary> /// <param name="database"></param> /// <param name="data"></param> /// <returns></returns> public int AddNew(Database database, SalesUnitPriceDTO data) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" INSERT INTO " + data.TableName + "("); sb.AppendLine(" " + SalesUnitPriceDTO.eColumns.CRT_BY); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.CRT_DATE); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.CRT_MACHINE); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.UPD_BY); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.UPD_DATE); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.UPD_MACHINE); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.ITEM_CD); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.START_EFFECTIVE_DATE); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.PRICE); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.CURRENCY); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.REMARK); sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.OLD_DATA); sb.AppendLine(") VALUES("); sb.AppendLine(" @CRT_BY"); sb.AppendLine(" ,GETDATE()"); sb.AppendLine(" ,@CRT_MACHINE"); sb.AppendLine(" ,@UPD_BY"); sb.AppendLine(" ,GETDATE()"); sb.AppendLine(" ,@UPD_MACHINE"); sb.AppendLine(" ,@ITEM_CD"); sb.AppendLine(" ,@START_EFFECTIVE_DATE"); sb.AppendLine(" ,@PRICE"); sb.AppendLine(" ,@CURRENCY"); sb.AppendLine(" ,@REMARK"); sb.AppendLine(" ,@OLD_DATA"); sb.AppendLine(" )"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("@CRT_BY", DataType.NVarChar, data.CRT_BY.Value); req.Parameters.Add("@CRT_MACHINE", DataType.NVarChar, data.CRT_MACHINE.Value); req.Parameters.Add("@UPD_BY", DataType.NVarChar, data.UPD_BY.Value); req.Parameters.Add("@UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value); req.Parameters.Add("@ITEM_CD", DataType.Default, data.ITEM_CD.Value); req.Parameters.Add("@START_EFFECTIVE_DATE", DataType.DateTime, data.START_EFFECTIVE_DATE.Value); req.Parameters.Add("@PRICE", DataType.Number, data.PRICE.Value); req.Parameters.Add("@CURRENCY", DataType.NVarChar, data.CURRENCY.Value); req.Parameters.Add("@REMARK", DataType.NVarChar, data.REMARK.Value); req.Parameters.Add("@OLD_DATA", DataType.Default, data.OLD_DATA.Value); #endregion return(db.ExecuteNonQuery(req)); }
private SalesUnitPriceDTO MapModelToDTO(SalesUnitPriceUIDM data) { SalesUnitPriceDTO dto = new SalesUnitPriceDTO(); dto.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dto.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dto.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dto.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dto.ITEM_CD = data.ITEM_CD; dto.START_EFFECTIVE_DATE = data.START_EFFECTIVE_DATE; dto.PRICE = data.PRICE; dto.CURRENCY = data.CURRENCY; dto.REMARK = data.REMARK; dto.OLD_DATA = new NZInt(null, 0); return(dto); }
public SalesUnitPriceUIDM LoadSalesUnitPriceWithItemInfo(NZString ITEM_CD, NZDateTime START_EFF_DATE, NZString CURRENCY) { SalesUnitPriceBIZ bizPrice = new SalesUnitPriceBIZ(); SalesUnitPriceDTO dtoPrice = bizPrice.LoadSalesUnitPriceByPK(ITEM_CD, START_EFF_DATE, CURRENCY); if (dtoPrice == null) { return(null); } ItemBIZ bizItem = new ItemBIZ(); ItemDTO dtoItem = bizItem.LoadItem(ITEM_CD); DealingBIZ bizCust = new DealingBIZ(); DealingDTO dtoCust = null; if (dtoItem != null && !dtoItem.CUSTOMER_CD.IsNull) { dtoCust = bizCust.LoadLocation(dtoItem.CUSTOMER_CD); } return(MapDTOToModel(dtoPrice, dtoItem, dtoCust)); }
public void ValidateBeforeSaveUpdate(SalesUnitPriceDTO dto) { }