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 = ""; } }