void fillCombo()
{
StockExpServiceClient sClient2 = new StockExpServiceClient();
var ListType = sClient2.GetComboValuesfromDB();
foreach (var ele in ListType)
{
cbOld.Items.Add(ele.SName);
}
}
private void btnUpload_Click(object sender, EventArgs e)
{
int status = 0;
if (cbNew.Checked && !tbAddNew.Text.Equals(""))
{
String dbname = tbAddNew.Text.ToString();
if (!cbOld.Items.Contains(dbname.ToUpper()))
{
status = 0;
StockExpServiceClient sClient2 = new StockExpServiceClient();
OpenFileDialog openfd = new OpenFileDialog();
openfd.Filter = "Excel Workbook|*.xls;*.xlsx";
DialogResult dr = openfd.ShowDialog();
String filepath = openfd.FileName;
if (!filepath.Equals("") && (filepath.EndsWith(".xls") || filepath.EndsWith(".xlsx")))
{
sClient2.importdatafromexcel(filepath, dbname, status);
this.Hide();
Form2 f2 = new Form2();
f2.ShowDialog();
}
else
{
MessageBox.Show("Please Select a Excel file");
}
}
else
{
MessageBox.Show("Name already Exist");
tbAddNew.Clear();
}
}
else if (cbNew.Checked && tbAddNew.Text.Equals(""))
{
MessageBox.Show("Please Enter the name of The Share");
}
else if (!cbNew.Checked && cbOld.Text.Equals("Select The Stock"))
{
MessageBox.Show("Please Select a Stock");
}
else
{
status = 1;
String dbname2 = cbOld.SelectedItem.ToString();
StockExpServiceClient sClient2 = new StockExpServiceClient();
OpenFileDialog openfd = new OpenFileDialog();
openfd.Filter = "Excel Workbook|*.xls;*.xlsx";
DialogResult dr = openfd.ShowDialog();
String filepath = openfd.FileName;
if (!filepath.Equals("") && (filepath.EndsWith(".xls") || filepath.EndsWith(".xlsx")))
{
sClient2.importdatafromexcel(filepath, dbname2, status);
this.Hide();
Form2 f2 = new Form2();
f2.ShowDialog();
}
else
{
MessageBox.Show("Please Select a Excel file");
}
}
}
private void Compare_Click(object sender, EventArgs e)
{
StockExpServiceClient sClient = new StockExpServiceClient();
DateTime date1 = stockLastDate.Value;
DateTime date2 = dPickDate2.Value;
string date = stockLastDate.Value.ToString("yyyy-M-dd");
int i = 1;
TimeSpan difference = date2.Subtract(date1);
int TDays = Convert.ToInt32(difference.TotalDays);
if (cBRange.Checked)
{
for (; TDays > 0; TDays--)
{
if (!minAverageTextBox.Text.Equals("") && !maxAverageTextBox.Text.Equals("") && !cbChoices.Text.Equals("Select"))
{
Int32 lowerDays = Convert.ToInt32(minAverageTextBox.Text.Trim());
Int32 higherDays = Convert.ToInt32(maxAverageTextBox.Text.Trim());
string sname = cbChoices.SelectedItem.ToString();
string separator = " ";
if (lowerDays > 0 && higherDays > lowerDays)
{
float[] C_val = sClient.GetValuesfromDB(higherDays, date, sname);
if (C_val[0] != 0)
{
var pair = sClient.CalCulateAverage(lowerDays, higherDays, C_val);
float average1 = pair.Key;
float average2 = pair.Value;
int status = sClient.GetResult(C_val[0], average1, average2);
string[] msg1 = new string[] { "Average of ", lowerDays.ToString(), "is", average1.ToString(), "and", higherDays.ToString(), "is ", average2.ToString(), "\n" };
GlobalVariables.message.Add(string.Join(separator, msg1));
if (status == 1)
{
GlobalVariables.Cummulative = GlobalVariables.Cummulative + C_val[0] - C_val[1];
GlobalVariables.CummulativeSell = 0;
if (GlobalVariables.ListtoXls.Count != 0)
{
var lstele = GlobalVariables.ListtoXls[GlobalVariables.ListtoXls.Count - 1];
if (lstele.Result.ToString().Equals("Sell"))
{
GlobalVariables.Count++;
string[] mag = new string[] { "Buy", "Nifty @", "Rs.", C_val[0].ToString(), "with Current Difference =", (C_val[0] - C_val[1]).ToString(), "\n and Cummulitive Difference =", GlobalVariables.Cummulative.ToString(), "\n" };
GlobalVariables.message.Add(string.Join(separator, mag));
GlobalVariables.ListtoXls.Add(new StockList {
Date = date, Closing = C_val[0], Average1 = average1, Average2 = average2, Result = "Buy", Differ = C_val[0] - C_val[1], CDiffer = GlobalVariables.Cummulative, TCount = GlobalVariables.Count, TCDiffer = GlobalVariables.CummulativeSell
});
GlobalVariables.CummulativeSell = 0;
}
else
{
string[] mag = new string[] { "Buy", "Nifty @", "Rs.", C_val[0].ToString(), "with Current Difference =", (C_val[0] - C_val[1]).ToString(), "\n and Cummulitive Difference =", GlobalVariables.Cummulative.ToString(), "\n" };
GlobalVariables.message.Add(string.Join(separator, mag));
GlobalVariables.ListtoXls.Add(new StockList {
Date = date, Closing = C_val[0], Average1 = average1, Average2 = average2, Result = "Buy", Differ = C_val[0] - C_val[1], CDiffer = GlobalVariables.Cummulative, TCount = GlobalVariables.Count, TCDiffer = 0
});
}
}
else
{
string[] mag = new string[] { "Buy", "Nifty @", "Rs.", C_val[0].ToString(), "with Current Difference =", (C_val[0] - C_val[1]).ToString(), "\n and Cummulitive Difference =", GlobalVariables.Cummulative.ToString(), "\n" };
GlobalVariables.message.Add(string.Join(separator, mag));
GlobalVariables.ListtoXls.Add(new StockList {
Date = date, Closing = C_val[0], Average1 = average1, Average2 = average2, Result = "Buy", Differ = C_val[0] - C_val[1], CDiffer = GlobalVariables.Cummulative, TCount = GlobalVariables.Count, TCDiffer = 0
});
}
}
else
{
GlobalVariables.CummulativeSell += C_val[1] - C_val[0];
if (GlobalVariables.ListtoXls.Count != 0)
{
var lstele = GlobalVariables.ListtoXls[GlobalVariables.ListtoXls.Count - 1];
if (lstele.Result.ToString().Equals("Buy"))
{
GlobalVariables.Count++;
string[] mag = new string[] { "Sell", "Nifty @", "Rs.", C_val[0].ToString(), "with Current Difference =", (C_val[0] - C_val[1]).ToString(), "\n and Cummulitive Difference =", GlobalVariables.CummulativeSell.ToString(), "\n" };
GlobalVariables.message.Add(string.Join(separator, mag));
GlobalVariables.ListtoXls.Add(new StockList {
Date = date, Closing = C_val[0], Average1 = average1, Average2 = average2, Result = "Sell", Differ = C_val[0] - C_val[1], CDiffer = GlobalVariables.CummulativeSell, TCount = GlobalVariables.Count, TCDiffer = GlobalVariables.Cummulative
});
GlobalVariables.Cummulative = 0;
}
else
{
string[] mag = new string[] { "Sell", "Nifty @", "Rs.", C_val[0].ToString(), "with Current Difference =", (C_val[0] - C_val[1]).ToString(), "\n and Cummulitive Difference =", GlobalVariables.CummulativeSell.ToString(), "\n" };
GlobalVariables.message.Add(string.Join(separator, mag));
GlobalVariables.ListtoXls.Add(new StockList {
Date = date, Closing = C_val[0], Average1 = average1, Average2 = average2, Result = "Sell", Differ = C_val[0] - C_val[1], CDiffer = GlobalVariables.CummulativeSell, TCount = GlobalVariables.Count, TCDiffer = 0
});
}
}
else
{
string[] mag = new string[] { "Buy", "Nifty @", "Rs.", C_val[0].ToString(), "with Current Difference =", (C_val[0] - C_val[1]).ToString(), "\n and Cummulitive Difference =", GlobalVariables.Cummulative.ToString(), "\n" };
GlobalVariables.message.Add(string.Join(separator, mag));
GlobalVariables.ListtoXls.Add(new StockList {
Date = date, Closing = C_val[0], Average1 = average1, Average2 = average2, Result = "Buy", Differ = C_val[0] - C_val[1], CDiffer = GlobalVariables.Cummulative, TCount = GlobalVariables.Count, TCDiffer = 0
});
}
}
foreach (var element in GlobalVariables.message)
{
rTBResults.AppendText(element.ToString());
}
GlobalVariables.message.Clear();
}
}
}
if (minAverageTextBox.Text.Equals(""))
{
MessageBox.Show("Please Enter Minimum Days");
break;
}
if (maxAverageTextBox.Text.Equals(""))
{
MessageBox.Show("Please Enter Maximum Days");
break;
}
if (cbChoices.Text.Equals("Select"))
{
MessageBox.Show("Please Select a Stock");
break;
}
date1 = date1.AddDays(i);
date = date1.ToString("yyyy-M-dd");
}
}
else
{
if (!minAverageTextBox.Text.Equals("") && !maxAverageTextBox.Text.Equals("") && !cbChoices.Text.Equals("Select"))
{
Int32 lowerDays = Convert.ToInt32(minAverageTextBox.Text.Trim());
Int32 higherDays = Convert.ToInt32(maxAverageTextBox.Text.Trim());
string sname = cbChoices.SelectedItem.ToString();
string separator = " ";
if (lowerDays > 0 && higherDays > lowerDays)
{
float[] C_val = sClient.GetValuesfromDB(higherDays, date, sname);
var pair = sClient.CalCulateAverage(lowerDays, higherDays, C_val);
float average1 = pair.Key;
float average2 = pair.Value;
int status = sClient.GetResult(C_val[0], average1, average2);
string[] msg1 = new string[] { "Average of ", lowerDays.ToString(), "is", average1.ToString(), "and", higherDays.ToString(), "is ", average2.ToString(), "\n" };
string firsthalf = string.Join(separator, msg1);
GlobalVariables.message.Add(firsthalf);
if (status == 1)
{
GlobalVariables.Cummulative = GlobalVariables.Cummulative + C_val[0] - C_val[1];
var lstele = GlobalVariables.ListtoXls[GlobalVariables.ListtoXls.Count - 1];
if (lstele.Result.ToString().Equals("Sell"))
{
GlobalVariables.Count++;
}
string[] mag = new string[] { "Buy", "Nifty @", "Rs.", C_val[0].ToString(), "with Current Difference =", (C_val[0] - C_val[1]).ToString(), "\n and Cummulitive Difference =", GlobalVariables.Cummulative.ToString(), "\n" };
string Secondhalf1 = string.Join(separator, mag);
GlobalVariables.message.Add(Secondhalf1);
GlobalVariables.ListtoXls.Add(new StockList {
Date = date, Closing = C_val[0], Average1 = average1, Average2 = average2, Result = "Buy", Differ = C_val[0] - C_val[1], CDiffer = GlobalVariables.Cummulative
});
GlobalVariables.CummulativeSell = 0;
}
else
{
GlobalVariables.Cummulative = 0;
GlobalVariables.CummulativeSell += C_val[0] - C_val[1];
var lstele = GlobalVariables.ListtoXls[GlobalVariables.ListtoXls.Count - 1];
if (lstele.Result.ToString().Equals("Buy"))
{
GlobalVariables.Count++;
}
string[] mag = new string[] { "Sell", "Nifty @", "Rs.", C_val[0].ToString(), "with Difference=", (C_val[1] - C_val[0]).ToString(), "\n" };
GlobalVariables.message.Add(string.Join(separator, mag));
GlobalVariables.ListtoXls.Add(new StockList {
Date = date, Closing = C_val[0], Average1 = average1, Average2 = average2, Result = "Sell", Differ = C_val[1] - C_val[0], CDiffer = GlobalVariables.CummulativeSell, TCount = GlobalVariables.Count
});
}
foreach (var element in GlobalVariables.message)
{
rTBResults.AppendText(element.ToString());
}
GlobalVariables.message.Clear();
}
}
if (cbChoices.Text.Equals("Select"))
{
MessageBox.Show("Please Select a Stock");
}
if (minAverageTextBox.Text.Equals(""))
{
MessageBox.Show("Please Enter Minimum Days");
}
if (maxAverageTextBox.Text.Equals(""))
{
MessageBox.Show("Please Enter Maximum Days");
}
}
}
