public void CreateFinalFeedView(CapitalFrm cform) //Display DGV on FINAL Feed tab
{
//Clear
cform.dgvFinalView.Rows.Clear();
cform.dgvFinalView.Refresh();
//Variables
string sent_unid;
double sent_amt;
bool fundCI, fundQA, fundQE, fundQO, fundQM;
fundCI = fundQA = fundQE = fundQO = fundQM = false;
Connection connection = new Connection();
GetSQL sql = new GetSQL();
//loop through feed view and use merge to insert if unmatched
for (int i = 0; i < cform.dgvFeedView.Rows.Count; ++i)
{
//Construct Unid
sent_unid = (string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.portfolio].Value + ":" + cform.dateCB.Text.ToUpper() + " CAP USAGE";
if (sent_unid.Length >= 31)
{
sent_unid = sent_unid.Substring(0, 31);
}
OdbcDataReader dataReader = connection.RunQuery(sql.Lookup_Sent_Info(sent_unid));
//Retrieve amount sent
if (dataReader.HasRows)
{
sent_amt = Convert.ToDouble(dataReader["SENT_AMT"]);
}
else
{
sent_amt = 0;
}
//If box checked and it has not been sent an amount
if ((treasArray.Contains((string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.portfolio].Value) == false) &&
((bool)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fSent_Box].Value == true) &&
sent_amt == 0
)
{
cform.dgvFinalView.Rows.Add(
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fTypology].Value, // Typology
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fPortfolio].Value, // Portfolio
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fCpty].Value, // CPTY
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fInst].Value, // INST
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fFx].Value, // FX
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fTpr].Value, // TPR
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fTdate].Value, // TDATE
Convert.ToDouble(cform.dgvFeedView.Rows[i].Cells[(int)Capital.fTamount].Value), // TAMOUNT
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fTfx].Value, // TFX
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fTtrans].Value, // Ttrans
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fTcomment].Value, // TCOMMENT
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fStrategy].Value, // STRATEGY
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fBrktype].Value, // BRKTYPE
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fBrksrce].Value, // BRKSRCE
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fBrkdest].Value, // BRKDEST
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fUnique_Id].Value, // UNIQUE_ID
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fFund].Value, // FUND
(string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fAcct_Num].Value // ACCT_NUM
);
//set fund bools
switch ((string)cform.dgvFeedView.Rows[i].Cells[(int)Capital.fFund].Value)
{
case "CI":
fundCI = true;
break;
case "QA":
fundQA = true;
break;
case "QE":
fundQE = true;
break;
case "QO":
fundQO = true;
break;
case "QM":
fundQM = true;
break;
}
}
// close
dataReader.Close();
}
//Call enrich feed for treasury
if (fundCI == true)
{
sent_unid = "CAXTON INTL" + ":" + cform.dateCB.Text.ToUpper() + " CAP USAGE";
if (sent_unid.Length >= 31)
{
sent_unid = sent_unid.Substring(0, 31);
}
EnrichFinalFeed(cform, sent_unid, "CI");
}
if (fundQA == true)
{
sent_unid = "QA-TREASURY" + ":" + cform.dateCB.Text.ToUpper() + " CAP USAGE";
if (sent_unid.Length >= 31)
{
sent_unid = sent_unid.Substring(0, 31);
}
EnrichFinalFeed(cform, sent_unid, "QA");
}
if (fundQE == true)
{
sent_unid = "QE-TREASURY" + ":" + cform.dateCB.Text.ToUpper() + " CAP USAGE";
if (sent_unid.Length >= 31)
{
sent_unid = sent_unid.Substring(0, 31);
}
EnrichFinalFeed(cform, sent_unid, "QE");
}
if (fundQO == true)
{
sent_unid = "QO-TREASURY" + ":" + cform.dateCB.Text.ToUpper() + " CAP USAGE";
if (sent_unid.Length >= 31)
{
sent_unid = sent_unid.Substring(0, 31);
}
EnrichFinalFeed(cform, sent_unid, "QO");
}
if (fundQM == true)
{
sent_unid = "QM-TREASURY" + ":" + cform.dateCB.Text.ToUpper() + " CAP USAGE";
if (sent_unid.Length >= 31)
{
sent_unid = sent_unid.Substring(0, 31);
}
EnrichFinalFeed(cform, sent_unid, "QM");
}
//Select tab
cform.CapitalTabs.SelectTab(2);
}
public void EnrichFinalFeed(CapitalFrm cform, string sent_unid, string fund) //Add fund level totals with updated amounts
{
double tAmount;
string tTpr;
tAmount = 0;
Connection connection = new Connection();
GetSQL sql = new GetSQL();
OdbcDataReader dataReader = connection.RunQuery(sql.Lookup_Sent_Info(sent_unid));
//If fund matches update amount for items beign sent
for (int i = 0; i < cform.dgvFinalView.Rows.Count; ++i)
{
if (fund == (string)cform.dgvFinalView.Rows[i].Cells[(int)Capital.fFund].Value)
{
if ((string)cform.dgvFinalView.Rows[i].Cells[(int)Capital.fTpr].Value == "PAY")
{
tAmount = tAmount - Convert.ToDouble(cform.dgvFinalView.Rows[i].Cells[(int)Capital.fTamount].Value);
}
else
{
tAmount = tAmount + Convert.ToDouble(cform.dgvFinalView.Rows[i].Cells[(int)Capital.fTamount].Value);
}
}
}
//Update direction of TPR
if (tAmount > 0)
{
tTpr = "PAY";
}
else
{
tTpr = "RECEIVE";
}
int nRowIndex = 0;
//loop through and update amounts
//apply to feed
if (dataReader.HasRows)
{
nRowIndex = cform.dgvFinalView.Rows.Count;
cform.dgvFinalView.Rows.Add(
(string)dataReader["TYPOLOGY"], // Typology
(string)dataReader["PORTFOLIO"], // Portfolio
(string)dataReader["CPTY"], // CPTY
(string)dataReader["INST"], // INST
(string)dataReader["FX"], // FX
tTpr, // TPR
((DateTime)dataReader["TDATE"]).ToString("MM/dd/yyyy"), // TDATE
Math.Abs(tAmount), // TAMOUNT
(string)dataReader["TFX"], // TFX
dataReader["TTRANS"].ToString(), // Ttrans
(string)dataReader["TCOMMENT"], // TCOMMENT
(string)dataReader["STRATEGY"], // STRATEGY
dataReader["BRKTYPE"].ToString(), // BRKTYPE
(string)dataReader["BRKSRCE"], // BRKSRCE
(string)dataReader["BRKDEST"], // BRKDEST
(string)dataReader["UNIQUE_ID"], // UNIQUE_ID
(string)dataReader["FUND"], // FUND
(string)dataReader["ACCT_NUM"] // ACCT_NUM
);
cform.dgvFinalView.Rows[nRowIndex].DefaultCellStyle.BackColor = Color.Beige;
}
// close
dataReader.Close();
}
public void DisplayFeedView(CapitalFrm cform) //Display DGV on Feed tab
{
//Clear
cform.dgvFeedView.Rows.Clear();
cform.dgvFeedView.Refresh();
Connection connection = new Connection();
GetSQL sql = new GetSQL();
//Variables
string cpty, tpr, strat, sent_unid, sent_date;
double amt, sent_amt;
bool send_bool;
//loop through capital view to create feed view
for (int i = 0; i < cform.dgvCostView.Rows.Count; ++i)
{
//If MTD has a value add to feed
if (Convert.ToDouble(cform.dgvCostView.Rows[i].Cells[(int)Capital.mtd].Value) != 0)
{
//----Set variables
switch ((string)cform.dgvCostView.Rows[i].Cells[(int)Capital.trader].Value)
{
case "CI":
cpty = "CXI";
strat = "CAP USAGE";
break;
case "QA":
case "QE":
case "QO":
case "QM":
cpty = "SCF";
strat = "CAP USAGE";
break;
default:
cpty = "SCF";
strat = "ADJUSTMENTS";
break;
}
sent_unid = (string)cform.dgvCostView.Rows[i].Cells[(int)Capital.portfolio].Value + ":" + cform.dateCB.Text.ToUpper() + " CAP USAGE";
if (sent_unid.Length >= 31)
{
sent_unid = sent_unid.Substring(0, 31);
}
OdbcDataReader dataReader = connection.RunQuery(sql.Lookup_Sent_Info(sent_unid));
if (dataReader.HasRows)
{
sent_date = ((DateTime)dataReader["Sent_ON"]).ToString("MM/dd/yyyy");
sent_amt = Convert.ToDouble(dataReader["SENT_AMT"]);
}
else
{
sent_date = null;
sent_amt = 0;
}
if (Convert.ToDouble(cform.dgvCostView.Rows[i].Cells[(int)Capital.mtd].Value) > 0)
{
tpr = "RECEIVE";
amt = Convert.ToDouble(cform.dgvCostView.Rows[i].Cells[(int)Capital.mtd].Value);
}
else
{
tpr = "PAY";
amt = (Convert.ToDouble(cform.dgvCostView.Rows[i].Cells[(int)Capital.mtd].Value) * -1);
}
if (sent_date == null)
{
send_bool = true;
}
else if ((treasArray.Contains((string)cform.dgvCostView.Rows[i].Cells[(int)Capital.portfolio].Value) == false) &&
(Math.Abs(amt) > Math.Abs(sent_amt)))
{
send_bool = true;
}
else
{
send_bool = false;
}
// Fill out feed DGV
cform.dgvFeedView.Rows.Add("IMPUTED INTEREST", //Typology
(string)cform.dgvCostView.Rows[i].Cells[(int)Capital.portfolio].Value, //Portfolio
cpty, //cpty
"IMPIT", //Inst
"USD", //FX
tpr, //TPR
DateTime.Now.ToString("MM/dd/yyyy"), //TDATE
amt, //AMOUNT
"USD", //TFX
"", //TTRANS
cform.dateCB.Text.ToUpper() + " CAP USAGE", //TCOMMENT
strat, //STRATEGY
"", //BRKTYPE
(string)cform.dgvCostView.Rows[i].Cells[(int)Capital.portfolio].Value, //BRKSRC
"ADJLAA", //BRKDEST
"COSTOFCAP_SCF_" + DateTime.Now.ToString("yymmddhhMMss") + i.ToString(), //UNID
(string)cform.dgvCostView.Rows[i].Cells[(int)Capital.fund].Value, //FUND
"CAXT", //ACCT
sent_date,
sent_amt,
send_bool
);
// close
dataReader.Close();
}
}
}
