private void Button2_Click(object sender, EventArgs e) { string setId = context.ProductSets .Select(p => new { p.set_ID }) .Max(m => m.set_ID); int Id = int.Parse(setId); int newId = Id + 1; string newSetId = newId.ToString(); //if(newId < 10) //{ // newSetId = string.Format("00{0}", newId); //}else if(newId < 100) //{ // newSetId = string.Format("0{00}", newId); //} //else //{ // newSetId = string.Format("0{00}", newId); //} ProductSet set = new ProductSet(); set.set_ID = newSetId; set.set_name = textBox2.Text; set.set_status = false; set.set_price = Convert.ToDouble(textBox3.Text); set.set_isDel = 0; context.ProductSets.Add(set); context.SaveChanges(); //var result = context.ProductSets // .Select(p => new { p.set_id }) // .Max(m => m.set_id); for (int i = listView1.Items.Count - 1; i >= 0; i--) { Compose com = new Compose(); com.set_ID = newSetId; com.product_id = listView1.Items[i].SubItems[0].Text; com.product_amount = int.Parse(listView1.Items[i].SubItems[2].Text); context.Composes.Add(com); context.SaveChanges(); } MessageBox.Show("เพิ่มเซ็ตสินค้าเรียบร้อยแล้ว กรูณารอการอนุมัติ"); pro.updateSet(); textBox2.Text = ""; textBox3.Text = ""; listView1.Items.Clear(); }
private void Button3_Click(object sender, EventArgs e) { string data = dataGridView1.SelectedRows[0].Cells[0].Value.ToString(); var result = context.ProductNews .Where(p => p.product_id == data) .First(); DialogResult dialogResult = MessageBox.Show("คุณต้องการลบสินค้านี้ออก ใช่หรือไม่?", "ยืนยันการไล่ออก", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { result.product_status = 0; result.product_amount = 0; context.SaveChanges(); MessageBox.Show("ลบเรียบร้อย"); updateDataSorce(); } }
private void Button2_Click(object sender, EventArgs e) { em.employee_picture = ImageToByteArray(pictureBox1.Image); bindingSource1.EndEdit(); int save = context.SaveChanges(); if (save > 0) { MessageBox.Show("แก้ไขข้อมูลเรียบร้อยแล้ว"); emForm.updateDataSource(); this.Close(); } }
private void Button2_Click(object sender, EventArgs e) { bindingSource1.EndEdit(); int ed = context.SaveChanges(); string id = textBox2.Text; var result = context.ProductNews .Where(p => p.product_id == id) .First(); //RestClient client2 = new RestClient("http://www.csmsu.net"); //RestRequest request2 = new RestRequest("/APDServiceRest/api/Product/" + result.product_id + "/8"); ; //var resultGet = client2.Execute<List<getProduct>>(request2, Method.GET); RestClient client = new RestClient("http://www.csmsu.net"); RestRequest request = new RestRequest("/APDServiceRest/api/Product"); putToService insertP = new putToService(); insertP.productid = textBox2.Text; insertP.productname = textBox3.Text; insertP.productdetail = textBox4.Text; string str = textBox6.Text; while (str.Contains(",")) { int inx = textBox6.Text.IndexOf(','); str = textBox6.Text.Remove(inx, 1); } insertP.productprice = str; insertP.productimgurl = result.product_pic; insertP.shopid = 8; request.AddObject(insertP); var result2 = client.Execute(request, Method.PUT); //MessageBox.Show("Img = "+ converted); if (ed > 0 && result2.ResponseStatus == ResponseStatus.Completed) { MessageBox.Show("แก้ไขข้อมูลสินค้าเรียบร้อยแล้ว"); pro.updateDataSorce(); this.Close(); } }
private void Button2_Click(object sender, EventArgs e) { string name = dataGridView1.SelectedRows[0].Cells[1].Value.ToString(); DialogResult dialogResult = MessageBox.Show("คุณต้องการลบ " + name + " ออก ใช่หรือไม่?", "ยืนยันการลบ", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { string id = dataGridView1.SelectedRows[0].Cells[0].Value.ToString(); var toDel = context.Members .Where(s => s.member_ID == id) .First(); //context.Members.Remove(toDel); toDel.member_status = 0; context.SaveChanges(); updateDataSource(); } }
private void Button2_Click(object sender, EventArgs e) { var result = context.Members .OrderByDescending(m => m.member_ID).First(); int id = int.Parse(result.member_ID); int newId = id + 1; string newMemId = ""; if (newId < 10) { newMemId = string.Format("00{0}", newId); } else if (newId < 100) { newMemId = string.Format("0{00}", newId); } else { newMemId = string.Format("{000}", newId); } Member member = new Member(); member.member_ID = newMemId; member.member_name = textBox1.Text; member.member_tel = textBox2.Text; member.member_addr = textBox3.Text; member.member_picture = ImageToByteArray(pictureBox1.Image); member.member_birthday = dateTimePicker1.Value.Date; member.member_date = DateTime.Now.Date; member.member_user = ""; member.member_pass = ""; member.member_status = 1; context.Members.Add(member); int add = context.SaveChanges(); if (add > 0) { MessageBox.Show("สมัครสมาชิกเรียบร้อย"); mb.updateDataSource(); this.Close(); } }
private void Button3_Click(object sender, EventArgs e) { string name = dataGridView1.SelectedRows[0].Cells[0].Value.ToString(); DialogResult dialogResult = MessageBox.Show("คุณต้องการลบ " + name + " ออก ใช่หรือไม่?", "ยืนยันการไล่ออก", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { string username = dataGridView1.SelectedRows[0].Cells[6].Value.ToString(); var toDel = context.Employees .Where(s => s.employee_user == username) .First(); //context.Employees.Remove(toDel); toDel.employee_status = 0; context.SaveChanges(); updateDataSource(); } }
private void Button1_Click(object sender, EventArgs e) { string id = label26.Text; var result = context.ProductSets .Where(p => p.set_ID == id) .First(); result.set_status = true; int change = context.SaveChanges(); if (change > 0) { MessageBox.Show("อนุมัติสินค้า!!!"); } updateSet(); label26.Text = ""; label28.Text = ""; label30.Text = ""; listView1.Items.Clear(); }
private void Button3_Click(object sender, EventArgs e) { try { var result = context.Receipts .OrderByDescending(r => r.rec_number) .First(); // Gen rec_number string recNum = ""; int oldNum = int.Parse(result.rec_number); int newNum = oldNum + 1; if (newNum < 10) { recNum = string.Format("000{0}", newNum); } else if (newNum < 100) { recNum = string.Format("00{00}", newNum); } else if (newNum < 1000) { recNum = string.Format("0{000}", newNum); } else { recNum = newNum.ToString(); } // check Product Amount bool remain = true; Dictionary <string, int> amount = new Dictionary <string, int>(); for (int i = listView1.Items.Count - 1; i >= 0; i--) { string id = listView1.Items[i].SubItems[0].Text; if (id.Length == 5) { var pro = context.ProductNews .Where(p => p.product_id == id) .First(); bool haveKey = false; foreach (KeyValuePair <string, int> kvp in amount) { if (kvp.Key == pro.product_id) { haveKey = true; } } if (haveKey == false) { amount.Add(pro.product_id, pro.product_amount); } else { amount[pro.product_id] -= int.Parse(listView1.Items[i].SubItems[2].Text); } if (amount[pro.product_id] < int.Parse(listView1.Items[i].SubItems[2].Text)) { remain = false; } } else { var coms = context.Composes .Where(c => c.set_ID == id) .ToList(); foreach (var pro in coms) { bool haveKey = false; foreach (KeyValuePair <string, int> kvp in amount) { if (kvp.Key == pro.product_id) { haveKey = true; } } if (haveKey == false) { amount.Add(pro.product_id, pro.product_amount.GetValueOrDefault(1)); } else { amount[pro.product_id] -= int.Parse(listView1.Items[i].SubItems[2].Text); } if (amount[pro.product_id] < int.Parse(listView1.Items[i].SubItems[2].Text)) { remain = false; } } } } // Product is still in store if (remain == true) { for (int i = listView1.Items.Count - 1; i >= 0; i--) { string number = listView1.Items[i].SubItems[0].Text; Receipt rec = new Receipt(); if (number.Length == 5) { rec.rec_number = recNum; rec.rec_date = DateTime.Now; rec.rec_amount = int.Parse(listView1.Items[i].SubItems[2].Text); rec.employee_ID = user.employee_ID; if (radioButton1.Checked == true) { rec.member_ID = "007"; } else { var mb = context.Members .Where(m => m.member_name == comboBox2.Text) .First(); rec.member_ID = mb.member_ID; } rec.product_ID = listView1.Items[i].SubItems[0].Text; rec.set_ID = "100010"; rec.rec_sum = double.Parse(listView1.Items[i].SubItems[3].Text); context.Receipts.Add(rec); context.SaveChanges(); var dis = context.ProductNews .Where(p => p.product_id == rec.product_ID) .First(); dis.product_amount -= int.Parse(listView1.Items[i].SubItems[2].Text); context.SaveChanges(); } else { rec.rec_number = recNum; rec.rec_date = DateTime.Now; rec.rec_amount = int.Parse(listView1.Items[i].SubItems[2].Text); rec.employee_ID = user.employee_ID; if (radioButton1.Checked == true) { rec.member_ID = "007"; } else { var mb = context.Members .Where(m => m.member_name == comboBox2.Text) .First(); rec.member_ID = mb.member_ID; } rec.product_ID = "-1"; rec.set_ID = listView1.Items[i].SubItems[0].Text; rec.rec_sum = double.Parse(listView1.Items[i].SubItems[3].Text); context.Receipts.Add(rec); context.SaveChanges(); var coms = context.Composes .Where(c => c.set_ID == rec.set_ID) .ToList(); foreach (var com in coms) { var pd = context.ProductNews .Where(p => p.product_id == com.product_id) .First(); pd.product_amount -= int.Parse(listView1.Items[i].SubItems[2].Text); context.SaveChanges(); } } } showReceipt show = new showReceipt(recNum); show.MdiParent = home; show.Show(); } else { MessageBox.Show("สินค้ามีจำนวนไม่พอ!!!"); } } catch { string recNum = "001"; // check Product Amount bool remain = true; Dictionary <string, int> amount = new Dictionary <string, int>(); for (int i = listView1.Items.Count - 1; i >= 0; i--) { string id = listView1.Items[i].SubItems[0].Text; if (id.Length == 5) { var pro = context.ProductNews .Where(p => p.product_id == id) .First(); bool haveKey = false; foreach (KeyValuePair <string, int> kvp in amount) { if (kvp.Key == pro.product_id) { haveKey = true; } } if (haveKey == false) { amount.Add(pro.product_id, pro.product_amount); } else { amount[pro.product_id] -= int.Parse(listView1.Items[i].SubItems[2].Text); } if (amount[pro.product_id] < int.Parse(listView1.Items[i].SubItems[2].Text)) { remain = false; } } else { var coms = context.Composes .Where(c => c.set_ID == id) .ToList(); foreach (var pro in coms) { bool haveKey = false; foreach (KeyValuePair <string, int> kvp in amount) { if (kvp.Key == pro.product_id) { haveKey = true; } } if (haveKey == false) { amount.Add(pro.product_id, pro.product_amount.GetValueOrDefault(1)); } else { amount[pro.product_id] -= int.Parse(listView1.Items[i].SubItems[2].Text); } if (amount[pro.product_id] < int.Parse(listView1.Items[i].SubItems[2].Text)) { remain = false; } } } } // Product is still in store if (remain == true) { for (int i = listView1.Items.Count - 1; i >= 0; i--) { string number = listView1.Items[i].SubItems[0].Text; Receipt rec = new Receipt(); if (number.Length == 5) { rec.rec_number = recNum; rec.rec_date = DateTime.Now; rec.rec_amount = int.Parse(listView1.Items[i].SubItems[2].Text); rec.employee_ID = user.employee_ID; if (radioButton1.Checked == true) { rec.member_ID = "007"; } else { var mb = context.Members .Where(m => m.member_name == comboBox2.Text) .First(); rec.member_ID = mb.member_ID; } rec.product_ID = listView1.Items[i].SubItems[0].Text; rec.set_ID = "100010"; rec.rec_sum = double.Parse(listView1.Items[i].SubItems[3].Text); context.Receipts.Add(rec); context.SaveChanges(); var dis = context.ProductNews .Where(p => p.product_id == rec.product_ID) .First(); dis.product_amount -= int.Parse(listView1.Items[i].SubItems[2].Text); context.SaveChanges(); } else { rec.rec_number = recNum; rec.rec_date = DateTime.Now; rec.rec_amount = int.Parse(listView1.Items[i].SubItems[2].Text); rec.employee_ID = user.employee_ID; if (radioButton1.Checked == true) { rec.member_ID = "007"; } else { var mb = context.Members .Where(m => m.member_name == comboBox2.Text) .First(); rec.member_ID = mb.member_ID; } rec.product_ID = "-1"; rec.set_ID = listView1.Items[i].SubItems[0].Text; rec.rec_sum = double.Parse(listView1.Items[i].SubItems[3].Text); context.Receipts.Add(rec); context.SaveChanges(); var coms = context.Composes .Where(c => c.set_ID == rec.set_ID) .ToList(); foreach (var com in coms) { var pd = context.ProductNews .Where(p => p.product_id == com.product_id) .First(); pd.product_amount -= int.Parse(listView1.Items[i].SubItems[2].Text); context.SaveChanges(); } } } showReceipt show = new showReceipt(recNum); show.MdiParent = home; show.Show(); } else { MessageBox.Show("สินค้ามีจำนวนไม่พอ!!!"); } } }
private void Button2_Click(object sender, EventArgs e) { try { string id = textBox2.Text; var result = context.ProductNews .Where(p => p.product_id == id) .First(); if (result.product_status == 0) { result.product_amount = Decimal.ToInt32(numericUpDown1.Value); result.product_status = 1; result.product_pic = imgUrl; int add = context.SaveChanges(); if (add > 0) { MessageBox.Show("เพิ่มสินค้าเรียบร้อยแล้ว"); //pro.updateDataSorce(); //this.Close(); } } else { MessageBox.Show("มีสินค้าอยู่ในคลังแล้ว"); } } catch { ProductNew product = new ProductNew(); product.product_id = textBox2.Text; product.product_name = textBox3.Text; product.product_detail = textBox4.Text; product.product_type = textBox5.Text; product.product_price = float.Parse(textBox6.Text); product.product_amount = Decimal.ToInt32(numericUpDown1.Value); product.product_pic = imgUrl; product.product_status = 1; context.ProductNews.Add(product); int add = context.SaveChanges(); RestClient client = new RestClient("http://www.csmsu.net"); RestRequest request = new RestRequest("/APDServiceRest/api/Product"); insertProduct insertP = new insertProduct(); insertP.productid = textBox2.Text; insertP.productname = textBox3.Text; insertP.productdetail = textBox4.Text; string str = textBox6.Text; while (str.Contains(",")) { int inx = textBox6.Text.IndexOf(','); str = textBox6.Text.Remove(inx, 1); } insertP.productprice = int.Parse(str); insertP.productimgurl = imgUrl; insertP.shopid = 8; request.AddObject(insertP); var result = client.Execute(request, Method.POST); if (add > 0 && result.ResponseStatus == ResponseStatus.Completed) { MessageBox.Show("เพิ่มสินค้าเรียบร้อยแล้ว!!!"); //pro.updateDataSorce(); //this.Close(); } } }
private void Button2_Click(object sender, EventArgs e) { try { var result = context.Employees .Where(m => m.employee_user == textBox5.Text).First(); MessageBox.Show("username นี้ถูกใช้ไปแล้ว!!!"); } catch { var result = context.Employees .OrderByDescending(m => m.employee_ID).First(); int emId = int.Parse(result.employee_ID); int newId = emId + 1; string newEmId = ""; Employee newEm = new Employee(); if (newId < 10) { newEmId = string.Format("00{0}", newId); } else if (newId < 100) { newEmId = string.Format("0{00}", newId); } else { newEmId = string.Format("{000}", newId); } newEm.employee_ID = newEmId.ToString(); newEm.employee_name = textBox1.Text; newEm.employee_addr = textBox2.Text; newEm.employee_tel = textBox3.Text; newEm.employee_salary = float.Parse(textBox4.Text, CultureInfo.InvariantCulture.NumberFormat); newEm.employee_picture = ImageToByteArray(pictureBox1.Image); newEm.employee_date = DateTime.Now.Date; if (radioButton1.Checked) { newEm.employee_position = "เจ้าของร้าน"; } else if (radioButton2.Checked) { newEm.employee_position = "พนักงานขายหน้าร้าน"; } else if (radioButton3.Checked) { newEm.employee_position = "พนักงานคลังสินค้า"; } newEm.employee_user = textBox5.Text; newEm.employee_pass = textBox6.Text; newEm.employee_status = 1; context.Employees.Add(newEm); int add = context.SaveChanges(); if (add > 0) { MessageBox.Show("เพิ่มพนักงานเรียบร้อย"); em.updateDataSource(); this.Close(); } } }