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();
}
}
}