private void button3_Click(object sender, EventArgs e)
{
SqlConnection Connection = new SqlConnection(Con.ConnectionString());
SqlCommand DEL = new SqlCommand("DELETE FROM Suppliers WHERE Company=@Company", Connection);
DEL.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
try
{
Connection.Open();
int s = DEL.ExecuteNonQuery();
Connection.Close();
if (s == 1)
{
toolStripStatusLabel1.Text = "Successfully Deleted";
Names.Text = "";
Comapny.Text = "";
Official.Text = "";
Residential.Text = "";
TPOffice.Text = "";
TPMobile.Text = "";
TPResidential.Text = "";
Fax.Text = "";
Email.Text = "";
Web.Text = "";
Comapny.Focus();
}
}
catch
{
}
}
public static Comapny GetCompanyShares(int Id)
{
Comapny company = new Comapny();
SqlConnection con = new SqlConnection(ConnectDB.GetConnectionString());
string sel = "SELECT Name, curprice, shareAmount " +
"FROM Companies WHERE (Id = @Id) ";
SqlCommand cmd = new SqlCommand(sel, con);
cmd.Parameters.AddWithValue("Id", Id);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
rdr.Read();
company.name = rdr["Name"].ToString();
company.sharePrice = (decimal)rdr["curprice"];
company.shares = (int)(rdr["shareAmount"]);
rdr.Close();
con.Close();
return(company);
}
private void button2_Click(object sender, EventArgs e)
{
Names.Text = "";
Comapny.Text = "";
Official.Text = "";
Residential.Text = "";
TPOffice.Text = "";
TPResidential.Text = "";
TPMobile.Text = "";
Fax.Text = "";
Web.Text = "";
Email.Text = "";
toolStripStatusLabel1.Text = "Cleared";
Comapny.Focus();
}
// GET: Company/Edit/5
public ActionResult Edit(int?id)
{
CompnayViewModel obj = new CompnayViewModel();
Comapny c = db.Comapnies.Find(id);
if (c == null)
{
return(HttpNotFound());
}
else
{
obj.Name = c.CompanyName;
obj.CompanyAddress = c.CompanyAddress;
obj.CompanyType = c.CompanyType;
}
return(View(obj));
}
public ActionResult Create(CompnayViewModel obj)
{
try
{
// TODO: Add insert logic here
Comapny C1 = new Comapny();
C1.CompanyName = obj.Name;
C1.CompanyType = obj.CompanyType;
C1.CompanyAddress = obj.CompanyAddress;
db.Comapnies.Add(C1);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(View());
}
}
private void button1_Click(object sender, EventArgs e)
{
if (Comapny.Text.ToString().Trim(' ') == "")
{
toolStripStatusLabel1.Text = "Please ENter Company Name";
Comapny.Text = "";
Comapny.Focus();
}
else if (Names.Text.ToString().Trim(' ') == "")
{
toolStripStatusLabel1.Text = "Please Enter Name";
Names.Text = "";
Names.Focus();
}
else
{
SqlConnection Connection = new SqlConnection(Con.ConnectionString());
try
{
if (button1.Text.ToString() == "Save")
{
SqlCommand INSERT = new SqlCommand("INSERT INTO Suppliers VALUES(@Names,@Company,@OfficeAddress,@ResidentialAddress,@TPOffice,@TPResidential,@TPMobile,@Fax,@Email,@Web)", Connection);
INSERT.Parameters.AddWithValue("@Names", Names.Text.ToString());
INSERT.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
INSERT.Parameters.AddWithValue("@OfficeAddress", Residential.Text.ToString());
INSERT.Parameters.AddWithValue("@ResidentialAddress", Residential.Text.ToString());
INSERT.Parameters.AddWithValue("@TPOffice", TPOffice.Text.ToString());
INSERT.Parameters.AddWithValue("@TPResidential", TPResidential.Text.ToString());
INSERT.Parameters.AddWithValue("@TPMobile", TPMobile.Text.ToString());
INSERT.Parameters.AddWithValue("@Fax", Fax.Text.ToString());
INSERT.Parameters.AddWithValue("@Email", Email.Text.ToString());
INSERT.Parameters.AddWithValue("@Web", Web.Text.ToString());
Connection.Open();
int a = INSERT.ExecuteNonQuery();
Connection.Close();
if (a == 1)
{
toolStripStatusLabel1.Text = "Successfully Saved";
Names.Text = "";
Comapny.Text = "";
Official.Text = "";
Residential.Text = "";
TPOffice.Text = "";
TPMobile.Text = "";
TPResidential.Text = "";
Fax.Text = "";
Email.Text = "";
Web.Text = "";
}
else
{
toolStripStatusLabel1.Text = "Error Data Not Saved";
}
}
else
{
SqlCommand UPDATENAME = new SqlCommand("UPDATE Suppliers SET Names=@Names WHERE Company=@Company", Connection);
UPDATENAME.Parameters.AddWithValue("@Names", Names.Text.ToString());
UPDATENAME.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand ADD1 = new SqlCommand("UPDATE Suppliers SET OfficeAddress=@OfficeAddress WHERE Company=@Company", Connection);
ADD1.Parameters.AddWithValue("@OfficeAddress", Official.Text.ToString());
ADD1.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand Add2 = new SqlCommand("UPDATE Suppliers SET ResidentialAddress=@ResidentialAddress WHERE Company=@Company", Connection);
Add2.Parameters.AddWithValue("@ResidentialAddress", Residential.Text.ToString());
Add2.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand UPDATETPOFF = new SqlCommand("UPDATE Suppliers SET TPOffice=@TPOffice WHERE Company=@Company", Connection);
UPDATETPOFF.Parameters.AddWithValue("@TPOffice", TPOffice.Text.ToString());
UPDATETPOFF.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand UPTPRES = new SqlCommand("UPDATE Suppliers SET TPResidential=@TPResidential WHERE Company=@Company", Connection);
UPTPRES.Parameters.AddWithValue("@TPResidential", TPResidential.Text.ToString());
UPTPRES.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand UPTPMOB = new SqlCommand("UPDATE Suppliers SET TPMobile=@TPMobile WHERE Company=@Company", Connection);
UPTPMOB.Parameters.AddWithValue("@TPMobile", TPMobile.Text.ToString());
UPTPMOB.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand UPFAX = new SqlCommand("UPDATE Suppliers Set Fax=@Fax WHERE Company=@Company", Connection);
UPFAX.Parameters.AddWithValue("@Fax", Fax.Text.ToString());
UPFAX.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand UPEMAIL = new SqlCommand("UPDATE Suppliers SET Email=@Email WHERE Company=@Company", Connection);
UPEMAIL.Parameters.AddWithValue("@Email", Email.Text.ToString());
UPEMAIL.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand UPWEB = new SqlCommand("UPDATE Suppliers SET Web=@Web WHERE Company=@Company", Connection);
UPWEB.Parameters.AddWithValue("@Web", Web.Text.ToString());
UPWEB.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
Connection.Open();
int a, b, c, d, x, f, g, h, i;
a = UPDATENAME.ExecuteNonQuery();
b = ADD1.ExecuteNonQuery();
c = Add2.ExecuteNonQuery();
d = UPDATETPOFF.ExecuteNonQuery();
x = UPTPRES.ExecuteNonQuery();
f = UPTPMOB.ExecuteNonQuery();
g = UPFAX.ExecuteNonQuery();
h = UPEMAIL.ExecuteNonQuery();
i = UPWEB.ExecuteNonQuery();
if ((a == 1) && (b == 1) && (c == 1) && (d == 1) && (x == 1) && (f == 1) && (g == 1) && (h == 1) && (i == 1))
{
toolStripStatusLabel1.Text = "Update Successfully";
Names.Text = "";
Comapny.Text = "";
Official.Text = "";
Residential.Text = "";
TPOffice.Text = "";
TPMobile.Text = "";
TPResidential.Text = "";
Fax.Text = "";
Email.Text = "";
Web.Text = "";
}
Connection.Close();
}
}
catch
{
MessageBox.Show("Invalid Data Fields or unhandled Error Occered", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Comapny.Focus();
}
}
protected void Sell(int amount, int companyId)
{
int userShares;
Guid UserId;
User user = new User();
Comapny company = new Comapny();
UserId = new Guid(MySession.Current.UserId);
try
{
user = UserDB.GetUser(UserId);
company = CompanyDB.GetCompanyShares(companyId);
userShares = SharesDB.GetUserShares(UserId, companyId);
}
catch (SqlException sqlEx)
{
lblErrorMessage.Text = "A database error has occurred.<br /><br />" +
sqlEx.Message;
return;
}
if (userShares - amount >= 0)
{
user.cash += company.sharePrice * amount;
company.shares += amount;
userShares -= amount;
try
{
SharesDB.UpdateCash(UserId, user.cash);
if (userShares == 0)
{
SharesDB.DeleteUserShares(UserId, companyId);
}
else
{
SharesDB.UpdateUserShares(UserId, companyId, userShares);
}
CompanyDB.UpdateCompanyShares(companyId, company.shares);
dsUserStocks.SelectParameters["UserId"].DefaultValue = MySession.Current.UserId;
}
catch (SqlException sqlEx)
{
lblErrorMessage.Text = "A database error has occurred.<br /><br />" +
sqlEx.Message;
return;
}
try
{
UserHistoryDB.InsertHistory(UserId, companyId, amount, 's', 0, company.sharePrice);
}
catch (SqlException sqlEx)
{
lblErrorMessage.Text = "A database error has occurred.<br /><br />" +
sqlEx.Message;
// lblConfirmation.Text = "";
return;
}
gvwUserStocks.DataBind();
lblErrorMessage.Text = "";
lblConfirmation.Text = "Share sold successfully";
}
else
{
lblConfirmation.Text = "";
lblErrorMessage.Text = "You can not sell that many shares";
}
}
public async Task <IActionResult> ImportMembers(IFormFile postedFile, [FromForm] int userId)
{
try
{
var jsonSB = new System.Text.StringBuilder();
if (postedFile.Length > 0)
{
using (var reader = new System.IO.StreamReader(postedFile.OpenReadStream()))
{
while (reader.Peek() >= 0)
{
jsonSB.AppendLine(reader.ReadLine());
}
}
List <Member> members = JsonConvert.DeserializeObject <List <Member> >(jsonSB.ToString());
members.ForEach(m => m.UserId = userId);
var accounts = members.SelectMany(m => m.Accounts).ToList();
//this list is created to stack companies that are retreived from db in order to decrease db hits
List <Comapny> globalCompanies = new List <Comapny>();
foreach (var account in accounts)
{
var company = globalCompanies.SingleOrDefault(c => c.Name.ToLower() == account.CompanyName.ToLower());
if (company == null)
{
company = _context.Comapnies.SingleOrDefault(c => c.Name.ToLower() == account.CompanyName.ToLower());
//case company doesn't exist in the system
// I chose adding the comapy to the system instead of throwing exception
if (company == null)
{
company = new Comapny()
{
Name = account.CompanyName
};
_context.Comapnies.Add(company);
_context.SaveChanges();
}
globalCompanies.Add(company);
}
account.CompanyId = company.Id;
}
_context.Members.AddRange(members);
await _context.SaveChangesAsync();
}
else
{
return(BadRequest());
}
return(CreatedAtAction("GetMembers", new { UserId = userId }));
}
catch (Exception ex)
{
return(StatusCode(500, $"Internal server error: {ex}"));
}
}
protected void Buy(int amount, int companyId)
{
int userShares;
Guid UserId;
User user = new User();
Comapny company = new Comapny();
UserId = new Guid(MySession.Current.UserId);
try
{
user = UserDB.GetUser(UserId);
company = CompanyDB.GetCompanyShares(companyId);
userShares = SharesDB.GetUserShares(UserId, companyId);
}
catch (SqlException sqlEx)
{
lblErrorMessage.Text = "A database error has occurred.<br /><br />" +
sqlEx.Message;
lblConfirmation.Text = "The stock could not be purchased";
return;
}
//if the user has enough money
if (user.cash - company.sharePrice * amount >= 0)
{
//if the company has enough shares
if (company.shares - amount >= 0)
{
user.cash -= company.sharePrice * amount;
company.shares -= amount;
try
{
if (userShares > 0)
{
SharesDB.UpdateUserShares(UserId, companyId, userShares + amount);
}
else
{
SharesDB.InsertUserShares(UserId, companyId, amount, userShares + amount);
}
SharesDB.UpdateCash(UserId, user.cash);
CompanyDB.UpdateCompanyShares(companyId, company.shares);
}
catch (SqlException sqlEx)
{
lblErrorMessage.Text = "A database error has occurred.<br /><br />" +
sqlEx.Message;
// lblConfirmation.Text = "";
return;
}
try
{
UserHistoryDB.InsertHistory(UserId, companyId, amount, 'b', company.sharePrice, 0);
}
catch (SqlException sqlEx)
{
lblErrorMessage.Text = "A database error has occurred.<br /><br />" +
sqlEx.Message;
// lblConfirmation.Text = "";
return;
}
gwBuyStocks.DataBind();
lblErrorMessage.Text = "";
lblConfirmation.Text = "Share bought successfully";
}
//else inform the user of the lack of available shares
else
{
lblConfirmation.Text = "";
lblErrorMessage.Text = "Sorry no shares of that company are currently available for purchase";
}
}
//else call the user poor
else
{
lblErrorMessage.Text = "You are too poor";
lblConfirmation.Text = "";
}
}
