public static object GetConfigByFilter(SessionInfo sessioninfo, string name, int jtStartIndex, int jtPageSize, string jtSorting)
{
try
{
LoggingHelper.Debug("Begin Get config by " + name);
//Return result to jTable
PCCFConfigBusiness _factorBusiness = new PCCFConfigBusiness();
//Get data from database
List <MA_PCCF_CONFIG> factors = _factorBusiness.GetConfigByFilter(sessioninfo, name, jtSorting);
LoggingHelper.Debug("End Get config");
//Return result to jTable
return(new
{
Result = "OK"
,
Records = jtPageSize > 0 ? factors.Skip(jtStartIndex).Take(jtPageSize).ToList() : factors
,
TotalRecordCount = factors.Count
});
}
catch (BusinessWorkflowsException bex)
{
return(new { Result = "ERROR", Message = bex.Message });
}
catch (Exception ex)
{
return(new { Result = "ERROR", Message = ex.Message });
}
}
static void Main(string[] args)
{
PCCFConfigBusiness pccfBusiness = new PCCFConfigBusiness();
DA_TRN record = new DA_TRN();
record.ID = Guid.NewGuid();
record.ENGINE_DATE = DateTime.Now;
record.STATUS_ID = new Guid("9161ED18-1298-44FA-BA7D-34522CB40D66");
record.INSTRUMENT_ID = new Guid("33F88EB3-46C0-4667-BCF6-05426321B71B");
record.PRODUCT_ID = new Guid("F85252D1-BC58-4AC6-8B56-2E228FB0A367");
record.LOG.INSERTBYUSERID = new Guid("F85252D1-BC58-4AC6-8B56-2E228FB0A367");
record.LOG.INSERTDATE = DateTime.Now;
record.FIRST.CCY_ID = new Guid("825F343B-CAEA-409B-AE92-CCA2DAB3765E");
record.FIRST.FLAG_PAYREC = "R";
record.FIRST.FLAG_FIXED = false;
record.SECOND.CCY_ID = new Guid("825F343B-CAEA-409B-AE92-CCA2DAB3765E");
record.SECOND.FLAG_PAYREC = "P";
record.SECOND.FLAG_FIXED = false;
var temp = pccfBusiness.ValidatePCCFConfig(null, record);
if (temp != null)
{
Console.WriteLine("PCCF:" + temp.LABEL);
}
else
{
Console.WriteLine("PCCF is not match");
}
Console.WriteLine("End");
Console.ReadLine();
}
static void Main(string[] args)
{
PCCFConfigBusiness pccfBusiness = new PCCFConfigBusiness();
DA_TRN record = new DA_TRN();
record.ID = Guid.NewGuid();
record.ENGINE_DATE = DateTime.Now;
record.STATUS_ID = new Guid("9161ED18-1298-44FA-BA7D-34522CB40D66");
record.INSTRUMENT_ID = new Guid("33F88EB3-46C0-4667-BCF6-05426321B71B");
record.PRODUCT_ID = new Guid("F85252D1-BC58-4AC6-8B56-2E228FB0A367");
record.LOG.INSERTBYUSERID = new Guid("F85252D1-BC58-4AC6-8B56-2E228FB0A367");
record.LOG.INSERTDATE = DateTime.Now;
record.FIRST.CCY_ID = new Guid("825F343B-CAEA-409B-AE92-CCA2DAB3765E");
record.FIRST.FLAG_PAYREC = "R";
record.FIRST.FLAG_FIXED = false;
record.SECOND.CCY_ID = new Guid("825F343B-CAEA-409B-AE92-CCA2DAB3765E");
record.SECOND.FLAG_PAYREC = "P";
record.SECOND.FLAG_FIXED = false ;
var temp = pccfBusiness.ValidatePCCFConfig(null, record);
if(temp!=null)
Console.WriteLine("PCCF:" + temp.LABEL);
else
Console.WriteLine("PCCF is not match");
Console.WriteLine("End");
Console.ReadLine();
}
public static object UpdateFactor(SessionInfo sessioninfo, MA_CONFIG_ATTRIBUTE record)
{
try
{
LoggingHelper.Debug("Update Factor by " + record.ATTRIBUTE);
PCCFConfigBusiness _factorBusiness = new PCCFConfigBusiness();
record.ISACTIVE = record.ISACTIVE == null || !record.ISACTIVE ? false : true;
record.LOG.MODIFYBYUSERID = sessioninfo.CurrentUserId;
record.LOG.MODIFYDATE = DateTime.Now;
var updated = _factorBusiness.UpdateFactor(sessioninfo, record);
LoggingHelper.Debug("End Update");
return(new { Result = "OK" });
}
catch (Exception ex)
{
return(new { Result = "ERROR", Message = ex.Message });
}
}
public static object CreateFactor(SessionInfo sessioninfo, MA_CONFIG_ATTRIBUTE record)
{
try
{
LoggingHelper.Debug("Create Factor by " + record.ATTRIBUTE);
PCCFConfigBusiness _factorBusiness = new PCCFConfigBusiness();
record.ID = Guid.NewGuid();
record.ISACTIVE = record.ISACTIVE == null || !record.ISACTIVE ? false : true;
record.LOG.INSERTBYUSERID = sessioninfo.CurrentUserId;
record.LOG.INSERTDATE = DateTime.Now;
LoggingHelper.Debug("End Create");
var added = _factorBusiness.CreateFactor(sessioninfo, record);
return(new { Result = "OK", Record = added });
}
catch (Exception ex)
{
return(new { Result = "ERROR", Message = ex.Message });
}
}
public static object UpdateConfig(SessionInfo sessioninfo, MA_PCCF_CONFIG record)
{
try
{
LoggingHelper.Debug("Update Config by " + record.LABEL);
PCCFConfigBusiness _factorBusiness = new PCCFConfigBusiness();
record.ISACTIVE = record.ISACTIVE == null || !record.ISACTIVE.Value ? false : true;
record.LABEL = record.LABEL.ToUpper();
record.DESCRIPTION = record.DESCRIPTION.ToUpper();
record.LOG.MODIFYBYUSERID = sessioninfo.CurrentUserId;
record.LOG.MODIFYDATE = DateTime.Now;
var updated = _factorBusiness.UpdateConfig(sessioninfo, record);
LoggingHelper.Debug("End Update");
return(new { Result = "OK" });
}
catch (Exception ex)
{
return(new { Result = "ERROR", Message = ex.Message });
}
}
public static object GetFactorByFilter(SessionInfo sessioninfo, Guid ID)
{
try
{
LoggingHelper.Debug("Begin Get Factor by " + ID);
//Return result to jTable
PCCFConfigBusiness _factorBusiness = new PCCFConfigBusiness();
//Get data from database
List <MA_CONFIG_ATTRIBUTE> factors = _factorBusiness.GetFactorByFilter(sessioninfo, ID);
LoggingHelper.Debug("End Get Factor");
//Return result to jTable
return(new { Result = "OK", Records = factors, TotalRecordCount = factors.Count });
}
catch (BusinessWorkflowsException bex)
{
return(new { Result = "ERROR", Message = bex.Message });
}
catch (Exception ex)
{
return(new { Result = "ERROR", Message = ex.Message });
}
}
public decimal? GetPCCF(SessionInfo sessioninfo, DA_TRN trn)
{
try
{
decimal? decPCCF = null;
LookupBusiness _lookupBusiness = new LookupBusiness();
PCCFConfigBusiness _pccfBusiness = new PCCFConfigBusiness();
MA_PRODUCT product = _lookupBusiness.GetProductByID(sessioninfo, trn.PRODUCT_ID.Value);
ProductCode nProduct = (ProductCode)Enum.Parse(typeof(ProductCode), product.LABEL.Replace(" ", string.Empty));
MA_PCCF pccf = _pccfBusiness.ValidatePCCFConfig(sessioninfo, trn);
//if (pccf == null)
// throw this.CreateException(new Exception(), "Cannot find PCCF for transaction #" + trn.EXT_DEAL_NO);
if (nProduct == ProductCode.BOND || nProduct == ProductCode.REPO)
{
InstrumentBusiness _instrumentBusiness = new InstrumentBusiness();
//------Check whether seleted bond can be used.---------
MA_INSTRUMENT ins = _instrumentBusiness.GetByID(sessioninfo, trn.INSTRUMENT_ID.Value);
if (trn.MATURITY_DATE >= ins.MATURITY_DATE)
{
throw this.CreateException(new Exception(), "Settlement date cannot be equal or after bond maturity date.");
}
if (pccf == null)
throw this.CreateException(new Exception(), "Selected instrument cannot be used.");
//-------------------------------------------------------
decPCCF = LimitHelper.GetPCCFValue(pccf, LimitHelper.GetYearBucket(trn.START_DATE.Value, ins.MATURITY_DATE.Value));
}
else
{
if (pccf == null)
throw this.CreateException(new Exception(), "PCCF is not defined in the system." + "RF");
if (nProduct == ProductCode.SWAP)
{
decPCCF = LimitHelper.GetPCCFValue(pccf, LimitHelper.GetYearBucket(trn.START_DATE.Value, trn.MATURITY_DATE.Value));
}
else if (nProduct == ProductCode.FXSPOT)
{
decPCCF = pccf.DEFAULT;
}
else if (nProduct == ProductCode.FXFORWARD)
{
decPCCF = LimitHelper.GetPCCFValue(pccf, LimitHelper.GetMonthBucket(trn.START_DATE.Value, trn.MATURITY_DATE.Value));
}
else if (nProduct == ProductCode.FXSWAP)
{
if (trn.TRADE_DATE == trn.MATURITY_DATE)
{
decPCCF = pccf.C0D;
}
else if (trn.MATURITY_DATE < trn.SPOT_DATE)
{
decPCCF = pccf.C1D;
}
else if (trn.MATURITY_DATE == trn.SPOT_DATE)
{
decPCCF = pccf.DEFAULT;
}
else
{
decPCCF = LimitHelper.GetPCCFValue(pccf, LimitHelper.GetMonthBucket(trn.START_DATE.Value, trn.MATURITY_DATE.Value));
}
}
}
return decPCCF;
}
catch (Exception ex)
{
throw this.CreateException(ex, null);
}
}
public decimal?GetPCCF(SessionInfo sessioninfo, DA_TRN trn)
{
try
{
decimal? decPCCF = null;
LookupBusiness _lookupBusiness = new LookupBusiness();
PCCFConfigBusiness _pccfBusiness = new PCCFConfigBusiness();
MA_PRODUCT product = _lookupBusiness.GetProductByID(sessioninfo, trn.PRODUCT_ID.Value);
ProductCode nProduct = (ProductCode)Enum.Parse(typeof(ProductCode), product.LABEL.Replace(" ", string.Empty));
MA_PCCF pccf = _pccfBusiness.ValidatePCCFConfig(sessioninfo, trn);
//if (pccf == null)
// throw this.CreateException(new Exception(), "Cannot find PCCF for transaction #" + trn.EXT_DEAL_NO);
if (nProduct == ProductCode.BOND || nProduct == ProductCode.REPO)
{
InstrumentBusiness _instrumentBusiness = new InstrumentBusiness();
//------Check whether seleted bond can be used.---------
MA_INSTRUMENT ins = _instrumentBusiness.GetByID(sessioninfo, trn.INSTRUMENT_ID.Value);
if (trn.MATURITY_DATE >= ins.MATURITY_DATE)
{
throw this.CreateException(new Exception(), "Settlement date cannot be equal or after bond maturity date.");
}
if (pccf == null)
{
throw this.CreateException(new Exception(), "Selected instrument cannot be used.");
}
//-------------------------------------------------------
decPCCF = LimitHelper.GetPCCFValue(pccf, LimitHelper.GetYearBucket(trn.START_DATE.Value, ins.MATURITY_DATE.Value));
}
else
{
if (pccf == null)
{
throw this.CreateException(new Exception(), "PCCF is not defined in the system." + "RF");
}
if (nProduct == ProductCode.SWAP)
{
decPCCF = LimitHelper.GetPCCFValue(pccf, LimitHelper.GetYearBucket(trn.START_DATE.Value, trn.MATURITY_DATE.Value));
}
else if (nProduct == ProductCode.FXSPOT)
{
decPCCF = pccf.DEFAULT;
}
else if (nProduct == ProductCode.FXFORWARD)
{
decPCCF = LimitHelper.GetPCCFValue(pccf, LimitHelper.GetMonthBucket(trn.START_DATE.Value, trn.MATURITY_DATE.Value));
}
else if (nProduct == ProductCode.FXSWAP)
{
if (trn.TRADE_DATE == trn.MATURITY_DATE)
{
decPCCF = pccf.C0D;
}
else if (trn.MATURITY_DATE < trn.SPOT_DATE)
{
decPCCF = pccf.C1D;
}
else if (trn.MATURITY_DATE == trn.SPOT_DATE)
{
decPCCF = pccf.DEFAULT;
}
else
{
decPCCF = LimitHelper.GetPCCFValue(pccf, LimitHelper.GetMonthBucket(trn.START_DATE.Value, trn.MATURITY_DATE.Value));
}
}
}
return(decPCCF);
}
catch (Exception ex)
{
throw this.CreateException(ex, null);
}
}
