private void ItemOut_Click(object sender, EventArgs e) { bool select = false; string outTrackingNum = ""; bool del = false; int indexDelete = 0; foreach (DataGridViewRow row in dataGridView1.Rows) { if (Convert.ToBoolean(row.Cells["Selected"].Value)) { select = true; } } if (select) { ConfirmForm cf = new ConfirmForm(outTrackingNum); cf.ShowDialog(); outTrackingNum = cf.getTracking(); if (outTrackingNum.Length == 0) { return; } else { foreach (DataGridViewRow row in dataGridView1.Rows) { if (Convert.ToBoolean(row.Cells["Selected"].Value)) { string itemOut = row.Cells["SN"].Value.ToString(); string snDelete = row.Cells["SN"].Value.ToString(); string inventoryDelete = InOrOut.Text.ToString(); indexDelete = indexDelete == 0 ? row.Index - 1 : indexDelete; try { using (var ctx = new ItemContext()) { //var it = ctx.Items.Where(sn => sn.SN == itemOut); var item = ctx.Items.Where(sn => sn.SN == itemOut).First(); ItemDisposed itemDis = new ItemDisposed(); { itemDis.ItemTitle = row.Cells["ItemTitle"].Value.ToString(); itemDis.SN = row.Cells["SN"].Value.ToString(); itemDis.UPC = row.Cells["UPC"].Value.ToString(); itemDis.OrderId = row.Cells["OrderId"].Value.ToString(); itemDis.DateOfRcv = Convert.ToDateTime(row.Cells["DateOfRcv"].Value); itemDis.DateOfOut = DateTime.Now; itemDis.OriginalTrackingNum = row.Cells["OriginalTrackingNum"].Value.ToString(); itemDis.OutTrackingNumber = outTrackingNum; itemDis.Condition = row.Cells["Condition"].Value.ToString(); itemDis.Listed = row.Cells["Listed"].Value.ToString(); itemDis.ItemInOperator = item.ItemInOperator; itemDis.ServiceMan = item.ServiceMan; itemDis.ItemOutOperator = uname; itemDis.Note = row.Cells["Note"].Value.ToString(); itemDis.ReturnCode = item.ReturnCode; itemDis.Location = row.Cells["Location"].Value.ToString(); } ctx.ItemsDisposed.Add(itemDis); Item it = ctx.Items.Where(u => u.SN == snDelete).First <Item>(); ctx.Items.Remove(it); ctx.SaveChanges(); del = true; } } catch (Exception ex) { del = false; MessageBox.Show(ex.ToString()); } } } } } else { MessageBox.Show("No item selected."); return; } if (del) { //MessageBox.Show("Delete Successfully!"); del = false; if (ItemTitle.Text.Length != 0 || OrderId.Text.Length != 0 || UPC.Text.Length != 0 || SN.Text.Length != 0 || RcvTime.Checked || Condition.Text.Length != 0 || pendingBox.Checked || location.Text.Trim().Length != 0 || LPN.Text.Trim().Length != 0) { Search_Click(this, e); } else { ReLoadData(); } st.returnCurrentRow(indexDelete, dataGridView1); } }
private void Delete_Click(object sender, EventArgs e) { //var first = dataGridView1.Rows.GetFirstRow(DataGridViewElementStates.Selected); //string snDelete = this.dataGridView1.Rows[first].Cells["SN"].Value.ToString(); bool del = false; bool select = false; int indexDelete = 0; foreach (DataGridViewRow row in dataGridView1.Rows) { if (Convert.ToBoolean(row.Cells["Selected"].Value)) { select = true; } } if (select) { if (MessageBox.Show("This item will be permanently deleted!", "Are you sure?", MessageBoxButtons.YesNo) == DialogResult.Yes) { foreach (DataGridViewRow row in dataGridView1.Rows) { if (Convert.ToBoolean(row.Cells["Selected"].Value)) { string snDelete = row.Cells["SN"].Value.ToString(); string oIdDelete = row.Cells["OrderId"].Value.ToString(); string inventoryDelete = InOrOut.Text.ToString(); indexDelete = indexDelete == 0 ? row.Index - 1 : indexDelete; try { using (var ctx = new ItemContext()) { //int id = ctx.ItemBaks.Count() + 1; if (inventoryDelete == "In Inventory") { Item it = ctx.Items.Where(u => u.SN == snDelete).First <Item>(); ctx.Items.Remove(it); ctx.SaveChanges(); del = true; } else { //MessageBox.Show(id.ToString()); ItemDisposed it = ctx.ItemsDisposed.Where(o => o.OrderId == oIdDelete).Where(u => u.SN == snDelete).First <ItemDisposed>(); ItemBak bak = new ItemBak() { ItemTitle = it.ItemTitle, SN = it.SN, UPC = it.UPC, Condition = it.Condition, DateOfOut = it.DateOfOut, DateOfRcv = it.DateOfRcv, ItemInOperator = it.ItemInOperator, ItemOutOperator = it.ItemOutOperator, Listed = it.Listed, Location = it.Location, Note = it.Note, OrderId = it.OrderId, OriginalTrackingNum = it.OriginalTrackingNum, OutTrackingNumber = it.OutTrackingNumber, ReturnCode = it.ReturnCode, ServiceMan = it.ServiceMan }; ctx.ItemBaks.Add(bak); ctx.ItemsDisposed.Remove(it); ctx.SaveChanges(); del = true; } } } catch (Exception ex) { del = false; MessageBox.Show(ex.Message); } finally { } } } } else { return; } } else { MessageBox.Show("No item selected!"); } if (del) { //MessageBox.Show("Delete Successfully!"); del = false; if (ItemTitle.Text.Length != 0 || OrderId.Text.Length != 0 || UPC.Text.Length != 0 || SN.Text.Length != 0 || RcvTime.Checked || Condition.Text.Length != 0 || pendingBox.Checked || location.Text.Trim().Length != 0 || LPN.Text.Trim().Length != 0 || TrackingNum.Text.Trim().Length != 0) { Search_Click(this, e); } else { ReLoadData(); } st.returnCurrentRow(indexDelete, dataGridView1); } }