public static List <myshares> myshares(String email)
{
List <myshares> mm = new List <myshares>();
SqlDataReader reader = null;
String queryString = "SELECT psxrecord.noofstocks, psxrecord.compname, psxrecord.priceofshare FROM (person inner join psxperson on person.cnic= psxperson.cnic) inner join psxrecord on psxrecord.psxaccno=psxperson.psxaccno WHERE '" + email + "'=person.email";
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(queryString, con);
try
{
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
int noofstocks = (int)reader["noofstocks"];
string compname = (string)reader["compname"];
double priceofshare = Convert.ToDouble(reader["priceofshare"]);
myshares k = new myshares();
k.noofstocks = noofstocks;
k.compname = compname;
k.priceoshare = priceofshare;
mm.Add(k);
}
}
catch (SqlException ex)
{
Console.WriteLine("SQL Error" + ex.Message.ToString());
return(null);
}
finally
{
con.Close();
}
return(mm);
}
// -------------------------------------------------person --------------------------------------------
public static List <myshares> matchthedeal(double r1, double r2, int n1, int n2, int shv1, int shv2)
{
List <myshares> mm = new List <myshares>();
SqlDataReader reader = null;
String queryString = "SELECT stocksellercomp.nipostosell,stocksellercomp.compname,stocksellercomp.facevalue FROM stocksellercomp WHERE(((stocksellercomp.facevalue >= " + shv1 + ") and(stocksellercomp.facevalue <= " + shv2 + ")) and((stocksellercomp.nipostosell >= " + n1 + ") and(" + n2 + " >= stocksellercomp.nipostosell)) and((stocksellercomp.dividend >=" + r1 + ") and(stocksellercomp.dividend >= " + r2 + ")))";
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(queryString, con);
try
{
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
int noofstocks = (int)reader["nipostosell"];
string compname = (string)reader["compname"];
double priceofshare = Convert.ToDouble(reader["facevalue"]);
myshares k = new myshares();
k.noofstocks = noofstocks;
k.compname = compname;
k.priceoshare = priceofshare;
mm.Add(k);
}
}
catch (SqlException ex)
{
Console.WriteLine("SQL Error" + ex.Message.ToString());
return(null);
}
queryString = "SELECT buybrokercomp.nipostosell,buybrokercomp.compname,psxcompany.faceval FROM buybrokercomp inner join psxcompany on buybrokercomp.compregno = psxcompany.regno WHERE((psxcompany.faceval >=" + shv1 + ") and (psxcompany.faceval <=" + shv2 + ") and(buybrokercomp.nipostosell >=" + n1 + ") and (buybrokercomp.nipostosell >=" + n2 + ") and(psxcompany.dividend >= " + r1 + ") and (psxcompany.dividend >= " + r2 + ") ) ";
con = new SqlConnection(connectionString);
cmd = new SqlCommand(queryString, con);
try
{
con.Open();
while (reader.Read())
{
int noofstocks = (int)reader["nipostosell"];
string compname = (string)reader["compname"];
double priceofshare = Convert.ToDouble(reader["faceval"]);
myshares k = new myshares();
k.noofstocks = noofstocks;
k.compname = compname;
k.priceoshare = priceofshare;
mm.Add(k);
}
}
catch (SqlException ex)
{
Console.WriteLine("SQL Error" + ex.Message.ToString());
return(null);
}
queryString = "SELECT stockseller.sharevoffr,stockseller.nstockstosell,psxcompany.compname FROM stockseller inner join psxcompany on stockseller.compname = psxcompany.compname WHERE((stockseller.sharevoffr >= " + shv1 + ") and (stockseller.sharevoffr <= " + shv2 + ") and(stockseller.nstockstosell >= " + n1 + ") and (stockseller.nstockstosell >=" + n2 + ") and(psxcompany.dividend >=" + r1 + ") and (psxcompany.dividend >= " + r2 + ") )";
con = new SqlConnection(connectionString);
cmd = new SqlCommand(queryString, con);
try
{
con.Open();
while (reader.Read())
{
int noofstocks = (int)reader["nstockstosell"];
string compname = (string)reader["compname"];
double priceofshare = Convert.ToDouble(reader["sharevoffr"]);
myshares k = new myshares();
k.noofstocks = noofstocks;
k.compname = compname;
k.priceoshare = priceofshare;
mm.Add(k);
}
}
catch (SqlException ex)
{
Console.WriteLine("SQL Error" + ex.Message.ToString());
return(null);
}
queryString = "SELECT buybrokerperson.compname,buybrokerperson.sharevalue,buybrokerperson.noofshares FROM buybrokerperson inner join psxcompany on psxcompany.compname = buybrokerperson.compname WHERE((buybrokerperson.sharevalue >=" + shv1 + ") and (buybrokerperson.sharevalue <= " + shv2 + ") and(buybrokerperson.noofshares >= " + n1 + ") and (buybrokerperson.noofshares >= " + n2 + ") and(psxcompany.dividend >= " + r1 + ") and (psxcompany.dividend >= " + r2 + ") )";
con = new SqlConnection(connectionString);
cmd = new SqlCommand(queryString, con);
try
{
con.Open();
while (reader.Read())
{
int noofstocks = (int)reader["noofshares"];
string compname = (string)reader["compname"];
double priceofshare = Convert.ToDouble(reader["sharevalue"]);
myshares k = new myshares();
k.noofstocks = noofstocks;
k.compname = compname;
k.priceoshare = priceofshare;
mm.Add(k);
}
}
catch (SqlException ex)
{
Console.WriteLine("SQL Error" + ex.Message.ToString());
return(null);
}
return(mm);
}