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)
{
}
