public ActionResult Create([Bind(Include = "OwnerID,OwnerName")] OWNER oWNER)
{
if (ModelState.IsValid)
{
db.OWNER.Add(oWNER);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(oWNER));
}
public ActionResult Create([Bind(Include = "CustId,CustLoginName,CustPassword")] CustomerInfo custLogin)
{
if (ModelState.IsValid)
{
db.CustomerInfoes.Add(custLogin);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(custLogin));
}
public ActionResult Create([Bind(Include = "DealID,StockID,OwnerID,StockQuantity")] APPLICATION aPPLICATION)
{
if (ModelState.IsValid)
{
db.APPLICATION.Add(aPPLICATION);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.OwnerID = new SelectList(db.OWNER, "OwnerID", "OwnerName", aPPLICATION.OwnerID);
return(View(aPPLICATION));
}
public ActionResult Addproduct(Product model)
{
if (ModelState.IsValid)
{
Product obj = new Product();
obj.productname = model.productname;
obj.categoryname = model.categoryname;
dbObj.Products.Add(obj);
dbObj.SaveChanges();
}
ModelState.Clear();
return(View("product"));
}
public ActionResult SalvarFornecedor(Fornecedor f)
{
string resultado = "OK";
List <string> mensagens = new List <string>();
string idSalvo = string.Empty;
if (!ModelState.IsValid)
{
resultado = "AVISO";
mensagens = ModelState.Values.SelectMany(m => m.Errors).Select(m => m.ErrorMessage).ToList();
}
else
{
try
{
// Verifica se o fornecedor já existe
var forn = stock.Fornecedor.FirstOrDefault(x => x.Id == f.Id);
// Se não existe, adiciona e salva (create)
if (forn == null)
{
forn = f;
stock.Fornecedor.Add(forn);
stock.SaveChanges();
}
// Se existe, salva somente as alterações (update)
else
{
forn.Nome = f.Nome;
forn.Telefone = f.Telefone;
forn.Endereco = f.Endereco;
forn.Cidade = f.Cidade;
forn.Pais = f.Pais;
stock.SaveChanges();
}
idSalvo = f.Id.ToString();
}
catch (Exception ex)
{
resultado = "ERRO: " + ex.Message;
}
}
return(Json(new { Resultado = resultado, Mensagens = mensagens, IdSalvo = idSalvo }));
}
public ActionResult Register(CustomerInfo data)
{
try {
db.CustomerInfoes.Add(data);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
} catch {
return(View(data));
}
}
public ActionResult SalvarCategoriaProduto(CategoriaProduto cp)
{
string resultado = "OK";
List <string> mensagens = new List <string>();
string idSalvo = string.Empty;
if (!ModelState.IsValid)
{
resultado = "AVISO";
mensagens = ModelState.Values.SelectMany(m => m.Errors).Select(m => m.ErrorMessage).ToList();
}
else
{
try
{
// Verifica se a categoria já existe
var c = stock.CategoriaProduto.FirstOrDefault(x => x.Id == cp.Id);
// Se não existe, adiciona e salva (create)
if (c == null)
{
c = cp;
stock.CategoriaProduto.Add(c);
stock.SaveChanges();
}
// Se existe, salva somente as alterações (update)
else
{
c.Nome = cp.Nome;
c.Estado = cp.Estado;
stock.SaveChanges();
}
idSalvo = c.Id.ToString();
}
catch (Exception ex)
{
resultado = "ERRO: " + ex.Message;
}
}
return(Json(new { Resultado = resultado, Mensagens = mensagens, IdSalvo = idSalvo }));
}
public ActionResult Register(CustomerInfo data)
{
var loginData = new CustLogin();
//int q = Convert.ToInt32(Session["CustId"]);
//return Content(q.ToString());
try {
loginData.CustId = data.CustId;
loginData.CustLoginName = data.CustLoginName;
loginData.CustPassword = data.CustPassword;
db.CustomerInfoes.Add(data);
db.SaveChanges();
db.CustLogins.Add(loginData);
db.SaveChanges();
//var CustLogin = db.CustLogins.Add(loginData);
return(RedirectToAction("Index", "Home"));
} catch {
//return Content(data.CustId.ToString());
return(View(data));
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
var cbxCell = (DataGridViewCheckBoxCell)this.dataGridView1.Rows[e.RowIndex].Cells[0];
//取得cbxCell EditingCellFormattedValue屬性值
if (cbxCell != null && ((bool)cbxCell.EditingCellFormattedValue == false || (bool)cbxCell.FormattedValue == false))
{
DataGridViewRow s = this.dataGridView1.Rows[e.RowIndex];
//取出headertext
//string h = s.Cells[1].OwningColumn.HeaderText;
//取出value
//string v = s.Cells[1].Value.ToString();
datasave.account = member.account;
datasave.證券代號 = s.Cells[1].Value.ToString();
datasave.證券名稱 = s.Cells[2].Value.ToString();
datasave.成交股數 = s.Cells[3].Value.ToString();
datasave.成交筆數 = s.Cells[4].Value.ToString();
datasave.成交金額 = s.Cells[5].Value.ToString();
datasave.開盤價 = s.Cells[6].Value.ToString();
datasave.最高價 = s.Cells[7].Value.ToString();
datasave.最低價 = s.Cells[8].Value.ToString();
datasave.收盤價 = s.Cells[9].Value.ToString();
datasave.漲跌正or負 = s.Cells[10].Value.ToString();
datasave.漲跌價差 = s.Cells[11].Value.ToString();
db.datasave.Add(datasave);
db.SaveChanges();
}
//else
//{
// dataModel.Delete(datasave);
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public ActionResult Register(CustomerInfo data)
{
try {
//data.CustId = data.CustId.ToString();
db.CustomerInfoes.Add(data);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
} catch {
return(View(data));
//string s=data.
//return Content()
}
}
internal int create(members formData)
{
members result = db.members.Where(m => m.account == formData.account).FirstOrDefault();
if (result == null)
{
db.members.Add(formData);
return(db.SaveChanges());
}
else
{
return(0);
}
}
public int AddProduit(Produit Produit)
{
Context.Produit.Add(Produit);
try
{
Context.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
return(Context.Produit.Add(Produit).Id);
}
public ActionResult MyOrderDetail(Ship postback)
{
//Cart cart = new Cart();
if (this.ModelState.IsValid) //取得目前購物車
{
var currentcart = Cart.Operation.GetCurrentCart();
//取得目前登入使用者Id
int userId = Convert.ToInt32(Session["CustId"]);
using (StockEntities db = new StockEntities()) {
//建立Order物件
var order = new OrderInfo()
{
// UserId = userId,
// RecieverName = postback.RecieverName,
// RecieverPhone = postback.RecieverPhone,
// RecieverAddress = postback.RecieverAddress
CustId = userId,
OrderTotal = currentcart.TotalAmount, //cartitem.Price,
OrderTime = DateTime.Now,
};
////加其入Orders資料表後，儲存變更
db.OrderInfoes.Add(order);
db.SaveChanges();
//取得購物車中OrderDetai物件
var orderDetails = currentcart.ToOrderDetail(order.OrderId);
//將其加入OrderDetails資料表後，儲存變更
db.OrderDetails.AddRange(orderDetails);
db.SaveChanges();
}
return(Content("訂購成功"));
}
return(View());
}
/// <summary>
/// 新增法人持股
/// </summary>
/// <param name="models"></param>
/// <returns></returns>
internal int InsertForeignOwn(List <ForeignOwn> models)
{
var count = 0;
using (var db = new StockEntities())
{
// 有相同日期不上傳
if (models.Count > 0 && models[0] != null && !db.ForeignOwn.AsEnumerable().Any(c => c.Date == models[0].Date))
{
db.ForeignOwn.AddRange(models);
count = db.SaveChanges();
}
}
return(count);
}
/// <summary>
/// 新增三大買賣超
/// </summary>
/// <param name="models"></param>
/// <returns></returns>
internal int Insert3BigBuySell(List <ThreeBigBuySell> models)
{
var count = 0;
using (var db = new StockEntities())
{
// 有相同日期不上傳
if (models.Count > 0 && models[0] != null && !db.ThreeBigBuySell.AsEnumerable().Any(c => c.Date == models[0].Date))
{
db.ThreeBigBuySell.AddRange(models);
count = db.SaveChanges();
}
}
return(count);
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
member = (members)this.Tag;
string oldpassword = txtoldpassword.Text.Trim();
oldpassword = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(oldpassword, "SHA1");
string newpassword = txtnewpassword.Text.Trim();
string newpasswordcheck = txtnewpasswoedcheck.Text.Trim();
if (oldpassword == member.password)
{
if (newpassword != "" && newpasswordcheck != "")
{
newpassword = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(newpassword, "SHA1");
newpasswordcheck = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(newpasswordcheck, "SHA1");
if (newpassword == newpasswordcheck)
{
members Loginmember = db.members.Where(m => m.account == member.account).FirstOrDefault();
Loginmember.password = newpassword;
db.SaveChanges();
MessageBox.Show("密碼變更成功!!", "密碼變更", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Close();
}
else
{
MessageBox.Show("新密碼與新密碼確認不一致!!", "密碼變更", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("請輸入新密碼", "密碼變更", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("舊密碼輸入錯誤!!", "密碼變更", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public ActionResult Index(Ship postback)
{
StockEntities db = new StockEntities();
int usrId = Convert.ToInt32(Session["CustId"]);
var q = from s in db.CustomerInfoes
where s.CustId == usrId
select s;
var result = q.ToList();
var q1 = (from s in db.OrderInfoes
orderby s.OrderId descending
select s.OrderId).FirstOrDefault();
int orderId = q1 + 1;
//StockEntities db = new StockEntities();
//int usrId = Convert.ToInt32(Session["CustId"]);
// var q = from s in db.VW_OrderAndDetailAndCust
// where s.CustId == usrId
// select s;
// var result = q.ToList();
//Cart cart = new Cart();
if (this.ModelState.IsValid == false)
{
/*if (this.ModelState.IsValid) {*/ //取得目前購物車
var currentcart = Cart.Operation.GetCurrentCart();
var q2 = (from s in db.OrderInfoes
orderby s.OrderId descending
select s.OrderId).FirstOrDefault();
int orderid = q2 + 1;
//取得目前登入使用者Id
//int userId = Convert.ToInt32(Session["CustId"]);
//int userId = Convert.ToInt32(Session["CustId"]);
using (StockEntities db1 = new StockEntities()) {
//建立Order物件
var order = new OrderInfo()
{
// UserId = userId,
// RecieverName = postback.RecieverName,
// RecieverPhone = postback.RecieverPhone,
// RecieverAddress = postback.RecieverAddress
OrderId = orderid,
CustId = usrId,
OrderTotal = currentcart.TotalAmount, //cartitem.Price,
OrderTime = DateTime.Now,
};
////加其入Orders資料表後，儲存變更
db1.OrderInfoes.Add(order);
db1.SaveChanges();
//var q2 = (from s in db.OrderInfoes
// orderby s.OrderId descending
// select s.OrderId).FirstOrDefault();
//int orderid = q2 + 1;
//取得購物車中OrderDetai物件
//var orderDetails = currentcart.ToOrderDetail(order.OrderId);
var orderDetails = currentcart.ToOrderDetail(orderid);
//將其加入OrderDetails資料表後，儲存變更
db1.OrderDetails.AddRange(orderDetails);
db1.SaveChanges();
}
var qTotal = (from s in db.OrderDetails
where s.OrderId == orderid
select s).ToList();
int sum = 0;
foreach (var item in qTotal)
{
sum += item.ProdPrice * item.ProdQuantity;
}
//var order = new OrderInfo() {
// // UserId = userId,
// // RecieverName = postback.RecieverName,
// // RecieverPhone = postback.RecieverPhone,
// // RecieverAddress = postback.RecieverAddress
// //OrderId =orderId,
// CustId = usrId,
// OrderTotal = sum, //cartitem.Price,
// OrderTime = DateTime.Now,
//};
//////加其入Orders資料表後，儲存變更
//db.OrderInfoes.Add(order);
//db.SaveChanges();
//return Content("訂購成功");
return(RedirectToAction("MyOrder", "Home"));
}
return(View(result));
}
public int AddMouvement(Mouvement Mouvement)
{
Context.Mouvement.Add(Mouvement);
Context.SaveChanges();
return(Context.Mouvement.Add(Mouvement).Id);
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
members member = this.member;
if (string.IsNullOrEmpty(this.txtNum.Text) || this.txtNum.Text == "0")
{
MessageBox.Show("請輸入賣出張數!!");
this.txtMoney.Text = "0";
return;
}
else if (int.Parse(this.txtNum.Text) > int.Parse(buttonRow.Cells[6].Value.ToString()))
{
MessageBox.Show("賣出張數超出庫存張數@@，請重新輸入!!");
this.txtNum.Text = "";
this.txtMoney.Text = "0";
return;
}
else
{
MessageBox.Show("賣出成功!!");
}
//賣出張數，修改資料表
if (int.Parse(this.txtNum.Text) == int.Parse(buttonRow.Cells[6].Value.ToString()))
{
stocksave save = db.stocksave.AsEnumerable().Where(s => s.證券代號 == buttonRow.Cells[3].Value.ToString() && s.account == member.account).FirstOrDefault();
datamodel.Delete(save);
stockremain remain = db.stockremain.AsEnumerable().Where(r => r.證券代號 == buttonRow.Cells[3].Value.ToString() && r.account == member.account).FirstOrDefault();
datamodel.Delete(remain);
}
else if (int.Parse(this.txtNum.Text) < int.Parse(buttonRow.Cells[6].Value.ToString()))
{
stocksave save = db.stocksave.AsEnumerable().Where(s => s.證券代號 == buttonRow.Cells[3].Value.ToString() && s.account == member.account).FirstOrDefault();
datamodel.Updatestocksave(save, int.Parse(this.txtNum.Text));
stockremain remainsave = db.stockremain.AsEnumerable().Where(r => r.證券代號 == buttonRow.Cells[3].Value.ToString() && r.account == member.account).FirstOrDefault();
datamodel.Updatestockremain(remainsave, int.Parse(this.txtNum.Text));
}
double remainmoney = (double)member.bankmoney + double.Parse(txtMoney.Text);
member.bankmoney = (int)remainmoney;
var mem = (from m in db.members
where m.account == member.account
select m).FirstOrDefault();
if (mem == null)
{
return;
}
mem.bankmoney = member.bankmoney;
db.SaveChanges();
//frmHomePage傳值
FrmHomePage frmHomePage = this.frmHomePage;
frmHomePage.lblbankmoney.Text = member.bankmoney.ToString();
frmHomePage.lblmoney.Text = member.bankmoney.ToString();
frmHomePage.lblbank.Text = member.bankmoney.ToString();
//frmHomePage.dataGridView3.DataSource = null;
//frmHomePage.dataGridView4.DataSource = null;
frmHomePage.dataGridView4.DataSource = db.stockremain.Where(s => s.account == member.account).ToList();
frmHomePage.dataGridView4.Columns["id"].Visible = false;
frmHomePage.dataGridView3.DataSource = db.stocksave.Where(s => s.account == member.account).ToList();
frmHomePage.dataGridView3.Columns["id"].Visible = false;
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
//member傳值
members member = this.member;
if (string.IsNullOrEmpty(this.txtNum.Text) || this.txtNum.Text == "0")
{
MessageBox.Show("請輸入購買張數!!");
this.txtMoney.Text = "0";
return;
}
else if (double.Parse(txtMoney.Text) > member.bankmoney)
{
MessageBox.Show("買進總金額超過帳戶金額QQ，請重新輸入!!");
this.txtNum.Text = "";
this.txtMoney.Text = "0";
return;
}
else
{
MessageBox.Show("買入成功!!");
}
double remainmoney = (double)member.bankmoney - double.Parse(txtMoney.Text);
member.bankmoney = (int)remainmoney;
var mem = (from m in db.members
where m.account == member.account
select m).FirstOrDefault();
if (mem == null)
{
return;
}
mem.bankmoney = member.bankmoney;
db.SaveChanges();
//frmHomePage傳值
FrmHomePage frmHomePage = this.frmHomePage;
frmHomePage.lblbankmoney.Text = member.bankmoney.ToString();
frmHomePage.lblmoney.Text = member.bankmoney.ToString();
frmHomePage.lblbank.Text = member.bankmoney.ToString();
//存入我的庫存 stocksave
stock.account = this.txtAccount.Text;
stock.證券代號 = this.txtStocknum.Text;
stock.證券名稱 = this.txtStockName.Text;
stock.買進價格 = this.txtPrice.Text;
stock.張數 = this.txtNum.Text;
stock.總金額 = this.txtMoney.Text;
db.stocksave.Add(stock);
db.SaveChanges();
//取得收盤價，存入未實現損益
var price = (from d in db.data
join s in db.stocksave.Where(s => s.account == member.account)
on d.證券代號 equals s.證券代號
select d.收盤價).ToList();
stockRemain.account = member.account;
stockRemain.證券代號 = stock.證券代號;
stockRemain.證券名稱 = stock.證券名稱;
stockRemain.成交均價 = stock.買進價格;
stockRemain.張數 = stock.張數;
stockRemain.持有成本 = stock.總金額;
for (int i = 0; i < price.Count(); i++)
{
var code = (from d in db.data
join s in db.stocksave.Where(s => s.account == member.account)
on d.證券代號 equals s.證券代號
select d.證券代號).ToList();
if (stockRemain.證券代號 == code[i])
{
stockRemain.現價 = price[i].ToString();
}
}
stockRemain.現值 = (double.Parse(stockRemain.現價) * double.Parse(stock.張數.ToString()) * number).ToString();
stockRemain.預估收入 = (double.Parse(stockRemain.現價) * double.Parse(stock.張數.ToString()) * number).ToString();
stockRemain.預估損益 = (double.Parse(stockRemain.預估收入) - double.Parse(stockRemain.持有成本)).ToString();
stockRemain.預估獲利率 = ((double.Parse(stockRemain.預估損益) / double.Parse(stockRemain.持有成本)) * 100).ToString("f2") + "%";
db.stockremain.Add(stockRemain);
db.SaveChanges();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}