public void InsertSingle(ContractCompare_rawObject obj)
{
//Change to SP if required
string sql = @"INSERT INTO ContractCompare_raw(DateOfData, DateOfImport, Record_Type, Receiving_Participant, Account_Number, Borrow_Loan_Indicator, CUSIP_Number, Delivery_Date, Quantity, Contract_Amount, Rebate_Rate, Call_Rate, Rate_Code, Mark_Parameter, NonCash_Collateral, Mark_Rounding_Factor, Accrued_Interest_for_Bounds, Uncompared_Advisory, User_Contract_Information, Income_Tracking_Indicator, DivPercentage) VALUES(@DateOfData, @DateOfImport, @Record_Type, @Receiving_Participant, @Account_Number, @Borrow_Loan_Indicator, @CUSIP_Number, @Delivery_Date, @Quantity, @Contract_Amount, @Rebate_Rate, @Call_Rate, @Rate_Code, @Mark_Parameter, @NonCash_Collateral, @Mark_Rounding_Factor, @Accrued_Interest_for_Bounds, @Uncompared_Advisory, @User_Contract_Information, @Income_Tracking_Indicator, @DivPercentage)";
using (SqlConnection conn = new SqlConnection(cstr))
{
SqlCommand cmd = new SqlCommand(sql, conn);
//cmd.CommandType=CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue(",");
cmd.Parameters.AddWithValue("@DateOfData", SetNullValue(obj.DateOfData));
cmd.Parameters.AddWithValue("@DateOfImport", SetNullValue(obj.DateOfImport));
cmd.Parameters.AddWithValue("@Record_Type", SetNullValue(obj.Record_Type));
cmd.Parameters.AddWithValue("@Receiving_Participant", SetNullValue(obj.Receiving_Participant));
cmd.Parameters.AddWithValue("@Account_Number", SetNullValue(obj.Account_Number));
cmd.Parameters.AddWithValue("@Borrow_Loan_Indicator", SetNullValue(obj.Borrow_Loan_Indicator));
cmd.Parameters.AddWithValue("@CUSIP_Number", SetNullValue(obj.CUSIP_Number));
cmd.Parameters.AddWithValue("@Delivery_Date", SetNullValue(obj.Delivery_Date));
cmd.Parameters.AddWithValue("@Quantity", SetNullValue(obj.Quantity));
cmd.Parameters.AddWithValue("@Contract_Amount", SetNullValue(obj.Contract_Amount));
cmd.Parameters.AddWithValue("@Rebate_Rate", SetNullValue(obj.Rebate_Rate));
cmd.Parameters.AddWithValue("@Call_Rate", SetNullValue(obj.Call_Rate));
cmd.Parameters.AddWithValue("@Rate_Code", SetNullValue(obj.Rate_Code));
cmd.Parameters.AddWithValue("@Mark_Parameter", SetNullValue(obj.Mark_Parameter));
cmd.Parameters.AddWithValue("@NonCash_Collateral", SetNullValue(obj.NonCash_Collateral));
cmd.Parameters.AddWithValue("@Mark_Rounding_Factor", SetNullValue(obj.Mark_Rounding_Factor));
cmd.Parameters.AddWithValue("@Accrued_Interest_for_Bounds", SetNullValue(obj.Accrued_Interest_for_Bounds));
cmd.Parameters.AddWithValue("@Uncompared_Advisory", SetNullValue(obj.Uncompared_Advisory));
cmd.Parameters.AddWithValue("@User_Contract_Information", SetNullValue(obj.User_Contract_Information));
cmd.Parameters.AddWithValue("@Income_Tracking_Indicator", SetNullValue(obj.Income_Tracking_Indicator));
cmd.Parameters.AddWithValue("@DivPercentage", SetNullValue(obj.DivPercentage));
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
//Only use whats in catch block if you included Log.cs
catch (SqlException ex)
{
Utils.LogError(ex.Message);
}
}
}
public ContractCompare_rawObject(ContractCompare_rawObject x)
{
this.DateOfData = x.DateOfData;
this.DateOfImport = x.DateOfImport;
this.Record_Type = x.Record_Type;
this.Receiving_Participant = x.Receiving_Participant;
this.Account_Number = x.Account_Number;
this.Borrow_Loan_Indicator = x.Borrow_Loan_Indicator;
this.CUSIP_Number = x.CUSIP_Number;
this.Delivery_Date = x.Delivery_Date;
this.Quantity = x.Quantity;
this.Contract_Amount = x.Contract_Amount;
this.Rebate_Rate = x.Rebate_Rate;
this.Call_Rate = x.Call_Rate;
this.Rate_Code = x.Rate_Code;
this.Mark_Parameter = x.Mark_Parameter;
this.NonCash_Collateral = x.NonCash_Collateral;
this.Mark_Rounding_Factor = x.Mark_Rounding_Factor;
this.Accrued_Interest_for_Bounds = x.Accrued_Interest_for_Bounds;
this.Uncompared_Advisory = x.Uncompared_Advisory;
this.User_Contract_Information = x.User_Contract_Information;
this.Income_Tracking_Indicator = x.Income_Tracking_Indicator;
this.DivPercentage = x.DivPercentage;
}
public void Replicate(ContractCompare_rawObject x)
{
this.DateOfData = x.DateOfData;
this.DateOfImport = x.DateOfImport;
this.Record_Type = x.Record_Type;
this.Receiving_Participant = x.Receiving_Participant;
this.Account_Number = x.Account_Number;
this.Borrow_Loan_Indicator = x.Borrow_Loan_Indicator;
this.CUSIP_Number = x.CUSIP_Number;
this.Delivery_Date = x.Delivery_Date;
this.Quantity = x.Quantity;
this.Contract_Amount = x.Contract_Amount;
this.Rebate_Rate = x.Rebate_Rate;
this.Call_Rate = x.Call_Rate;
this.Rate_Code = x.Rate_Code;
this.Mark_Parameter = x.Mark_Parameter;
this.NonCash_Collateral = x.NonCash_Collateral;
this.Mark_Rounding_Factor = x.Mark_Rounding_Factor;
this.Accrued_Interest_for_Bounds = x.Accrued_Interest_for_Bounds;
this.Uncompared_Advisory = x.Uncompared_Advisory;
this.User_Contract_Information = x.User_Contract_Information;
this.Income_Tracking_Indicator = x.Income_Tracking_Indicator;
this.DivPercentage = x.DivPercentage;
}
public void InsertSingle(ContractCompare_rawObject obj)
{
DA.InsertSingle(obj);
}
public void InsertSingle(ContractCompare_rawObject obj)
{
//Change to SP if required
string sql =@"INSERT INTO ContractCompare_raw(DateOfData, DateOfImport, Record_Type, Receiving_Participant, Account_Number, Borrow_Loan_Indicator, CUSIP_Number, Delivery_Date, Quantity, Contract_Amount, Rebate_Rate, Call_Rate, Rate_Code, Mark_Parameter, NonCash_Collateral, Mark_Rounding_Factor, Accrued_Interest_for_Bounds, Uncompared_Advisory, User_Contract_Information, Income_Tracking_Indicator, DivPercentage) VALUES(@DateOfData, @DateOfImport, @Record_Type, @Receiving_Participant, @Account_Number, @Borrow_Loan_Indicator, @CUSIP_Number, @Delivery_Date, @Quantity, @Contract_Amount, @Rebate_Rate, @Call_Rate, @Rate_Code, @Mark_Parameter, @NonCash_Collateral, @Mark_Rounding_Factor, @Accrued_Interest_for_Bounds, @Uncompared_Advisory, @User_Contract_Information, @Income_Tracking_Indicator, @DivPercentage)";
using (SqlConnection conn = new SqlConnection(cstr))
{
SqlCommand cmd = new SqlCommand(sql, conn);
//cmd.CommandType=CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue(",");
cmd.Parameters.AddWithValue("@DateOfData", SetNullValue(obj.DateOfData));
cmd.Parameters.AddWithValue("@DateOfImport", SetNullValue(obj.DateOfImport));
cmd.Parameters.AddWithValue("@Record_Type", SetNullValue(obj.Record_Type));
cmd.Parameters.AddWithValue("@Receiving_Participant", SetNullValue(obj.Receiving_Participant));
cmd.Parameters.AddWithValue("@Account_Number", SetNullValue(obj.Account_Number));
cmd.Parameters.AddWithValue("@Borrow_Loan_Indicator", SetNullValue(obj.Borrow_Loan_Indicator));
cmd.Parameters.AddWithValue("@CUSIP_Number", SetNullValue(obj.CUSIP_Number));
cmd.Parameters.AddWithValue("@Delivery_Date", SetNullValue(obj.Delivery_Date));
cmd.Parameters.AddWithValue("@Quantity", SetNullValue(obj.Quantity));
cmd.Parameters.AddWithValue("@Contract_Amount", SetNullValue(obj.Contract_Amount));
cmd.Parameters.AddWithValue("@Rebate_Rate", SetNullValue(obj.Rebate_Rate));
cmd.Parameters.AddWithValue("@Call_Rate", SetNullValue(obj.Call_Rate));
cmd.Parameters.AddWithValue("@Rate_Code", SetNullValue(obj.Rate_Code));
cmd.Parameters.AddWithValue("@Mark_Parameter", SetNullValue(obj.Mark_Parameter));
cmd.Parameters.AddWithValue("@NonCash_Collateral", SetNullValue(obj.NonCash_Collateral));
cmd.Parameters.AddWithValue("@Mark_Rounding_Factor", SetNullValue(obj.Mark_Rounding_Factor));
cmd.Parameters.AddWithValue("@Accrued_Interest_for_Bounds", SetNullValue(obj.Accrued_Interest_for_Bounds));
cmd.Parameters.AddWithValue("@Uncompared_Advisory", SetNullValue(obj.Uncompared_Advisory));
cmd.Parameters.AddWithValue("@User_Contract_Information", SetNullValue(obj.User_Contract_Information));
cmd.Parameters.AddWithValue("@Income_Tracking_Indicator", SetNullValue(obj.Income_Tracking_Indicator));
cmd.Parameters.AddWithValue("@DivPercentage", SetNullValue(obj.DivPercentage));
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
//Only use whats in catch block if you included Log.cs
catch (SqlException ex)
{
Utils.LogError(ex.Message);
}
}
}
private void ConvertToOrigForExistingContractCompareRawTablebak(List<ContractCompareDomesticObject> CCDAList)
{
foreach (ContractCompareDomesticObject ccdo in CCDAList)
{
#region Add item to Contract Compare Raw Object
try
{
ContractCompare_rawObject CCRO = new ContractCompare_rawObject();
CCRO.DateOfData = ccdo.DateOfData;
CCRO.DateOfImport = ccdo.DateOfImport;
CCRO.Record_Type = ccdo.RecordType; //'3';
CCRO.Receiving_Participant = FormatVal(ccdo.ParticipantID, 0, 4, "0000");
CCRO.Account_Number = FormatVal(ccdo.ContraPartyID, 0, 4, "0000");
CCRO.Borrow_Loan_Indicator = string.IsNullOrEmpty(ccdo.ActivityCode) ? " " : ccdo.ActivityCode;
CCRO.CUSIP_Number = FormatCusip(ccdo.SecurityID);
CCRO.Delivery_Date = FormatVal(ccdo.DeliveryDateofDeal, 4, 2, "000000"); //Convert Ex. 03212015 to 032115
CCRO.Quantity = FormatVal(ccdo.OpenQuantity, 0, 5, "000000000");
CCRO.Contract_Amount = FormatVal(ccdo.ContractValue, 0, 6, "000000000000");
CCRO.Rebate_Rate = ccdo.RebateFeeRate; //Adjust in stored proc to read new length of 9 for US. Already done for INTL
CCRO.Call_Rate = "00000";
CCRO.Rate_Code = string.IsNullOrEmpty(ccdo.RebateRateCode) ? " " : ccdo.RebateRateCode;
//MARK PARAMTER
if (!string.IsNullOrEmpty(ccdo.MarginParameter) && ccdo.MarginParameter.Length == 6)
{
string mp = ccdo.MarginParameter.Remove(4, 2);
mp = mp.Remove(0, 1);
CCRO.Mark_Parameter = mp;
}
else
{
CCRO.Mark_Parameter = " ";
}
//COLLATERAL TYPE
if (!string.IsNullOrEmpty(ccdo.CollateralType))
{
CCRO.NonCash_Collateral = ccdo.CollateralType.ToLower() == "c" ? " " : "N";
}
else
{
CCRO.NonCash_Collateral = " ";
}
CCRO.Mark_Rounding_Factor = string.IsNullOrEmpty(ccdo.MarkRoundingFactor) ? "X" : ConvertMarkRoundingTo80ByteSpec(ccdo.MarkRoundingFactor);
CCRO.Accrued_Interest_for_Bounds = ccdo.AccruedBondInterestincludedinmarks;
CCRO.Uncompared_Advisory = ccdo.ComparisonCode; // W,T,M
if (!string.IsNullOrEmpty(ccdo.UserContractInternalReferenceNumber))
{
string bgnref = ccdo.UserContractInternalReferenceNumber.Trim();
bgnref = bgnref.PadRight(15);
CCRO.User_Contract_Information = bgnref;
}
else
{
CCRO.User_Contract_Information = ccdo.UserContractInternalReferenceNumber;
}
//INCOME TRACKING
if (!string.IsNullOrEmpty(ccdo.IncomeTrackingIndicator))
{
CCRO.Income_Tracking_Indicator = ccdo.IncomeTrackingIndicator.ToLower() == "N" ? "N" : " ";
}
else
{
CCRO.Income_Tracking_Indicator = " ";
}
//DIV PERCENT
string DivFlow = FormatVal(ccdo.DividendFlowThrough, 3, 3, "0");
DivFlow = DivFlow == "000" ? "0" : DivFlow;
DivFlow = DivFlow != "0" ? DivFlow.TrimStart("0".ToCharArray()) : DivFlow;
CCRO.DivPercentage = DivFlow;
CCRF.InsertSingle(CCRO);
}
catch (Exception e)
{
Utils.LogError(e.Message);
}
#endregion
}
}
public void InsertSingle(ContractCompare_rawObject obj)
{
DA.InsertSingle(obj);
}
