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