/// <summary>
///
/// </summary>
/// <param name="data"></param>
/// <exception cref="ValidateException"><c>ValidateException</c>.</exception>
/// <exception cref="BusinessException"><c>BusinessException</c>.</exception>
public void ValidateBeforeSaveNew(DealingDTO data)
{
ValidateException validateException = new ValidateException();
ErrorItem errorItem = null;
#region mandatory check
errorItem = CheckEmptyLocationCode(data.LOC_CD);
if (errorItem != null)
{
validateException.AddError(errorItem);
}
errorItem = CheckEmptyLocationName(data.LOC_DESC);
if (errorItem != null)
{
validateException.AddError(errorItem);
}
errorItem = CheckEmptyLocationType(data.LOC_CLS);
if (errorItem != null)
{
validateException.AddError(errorItem);
}
validateException.ThrowIfHasError();
#endregion
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
if (dao.Exist(null, data.LOC_CD))
{
errorItem = new ErrorItem(data.LOC_CD.Owner, TKPMessages.eValidate.VLM0005.ToString());
BusinessException businessException = new BusinessException(errorItem);
throw businessException;
}
}
public ErrorItem CheckNotExistsLocationCode(NZString LOC_CD)
{
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
if (!dao.Exist(null, LOC_CD))
{
return(new ErrorItem(LOC_CD.Owner, TKPMessages.eValidate.VLM0004.ToString()));
}
return(null);
}
/// <summary>
///
/// </summary>
/// <param name="LocationType"></param>
/// <returns></returns>
public LookupData LoadLookupLocation(NZString[] LocationType, NZString[] ExceptLocation)
{
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
DataTable dt = dao.LoadByLocationType(null, LocationType, ExceptLocation, false);
LookupData lookupData = new LookupData(dt,
DealingDTO.eColumns.LOC_DESC.ToString(),
DealingDTO.eColumns.LOC_CD.ToString());
return(lookupData);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public LookupData LoadLookupLocation()
{
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
DataTable dt = DTOUtility.ConvertListToDataTable(dao.LoadAll(null, true));
LookupData lookupData = new LookupData(dt,
DealingDTO.eColumns.LOC_DESC.ToString(),
DealingDTO.eColumns.LOC_CD.ToString());
return(lookupData);
}
/// <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(DealingDTO data)
{
DealingValidator validator = new DealingValidator();
validator.ValidateBeforeSaveUpdate(data);
DealingDAO dao = new DealingDAO(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(DealingDTO data)
{
DealingValidator validator = new DealingValidator();
validator.ValidateBeforeSaveNew(data);
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
return(dao.AddNew(null, data));
}
public List <DealingDTO> LoadAllLocations(bool LimitRow)
{
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
if (LimitRow)
{
return(dao.LoadAllWithLimit(null, true));
}
return(dao.LoadAll(null, true));
}
/// <summary>
/// Load All Location
/// </summary>
/// <param name="dtoAddedLocation">Dummy Location to Added and Set to first Row</param>
/// <returns></returns>
public LookupData LoadLookupLocation_AddDummy(DealingDTO dtoAddedLocation)
{
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
List <DealingDTO> dtoLocations = dao.LoadAll(null, true);
//add Dummy Location and Set to first Row
dtoLocations.Insert(0, dtoAddedLocation);
DataTable dt = DTOUtility.ConvertListToDataTable(dtoLocations);
LookupData lookupData = new LookupData(dt,
DealingDTO.eColumns.LOC_DESC.ToString(),
DealingDTO.eColumns.LOC_CD.ToString());
return(lookupData);
}
public ErrorItem ValidateBeforeDelete(NZString LOC_CD)
{
//ValidateException validateException = new ValidateException();
//ErrorItem errorItem = null;
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
string returnString = dao.ValidateBeforeDelete(null, LOC_CD);
if (returnString == null)
{
return(null);
}
else
{
return(new ErrorItem(LOC_CD.Owner, returnString));
}
}
public int DeleteLocation(NZString LOC_CD)
{
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
return(dao.Delete(null, LOC_CD));
}
public DataTable LoadDealingList()
{
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
return(dao.LoadDealingList(null, false));
}
public DataTable LoadByLocationType(NZString[] LocationType)
{
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
return(dao.LoadByLocationType(null, LocationType, null, false));
}
public DealingDTO LoadLocation(NZString LOC_CD)
{
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
return(dao.LoadByPK(null, LOC_CD));
}
