private void backgroundWorker2_DoWork(object sender, DoWorkEventArgs e) { try { if (!string.IsNullOrEmpty(txt_box1.Text)) { this.selectText = txt_box1.Text; switch (isWhat) { case 1: BushingSize bs = bsize.Where(o => o.Size == selectText).FirstOrDefault(); if (bs == null) { bs = new BushingSize(); bs.Size = selectText; bs.dataMakePGM = "AddBushingSize"; bs.dataMakeTime = DateTime.Now; bs.dataMakeUser = AppDrill.username; bs.dataUpdPGM = "AddBushingSize"; bs.dataUpdTime = DateTime.Now; bs.dataUpdUser = AppDrill.username; db.BushingSize.Add(bs); db.SaveChanges(); } break; case 4: DateTime dt = DateTime.Now; Table_MudChemicalsAdded model = MudChemicalsAdded.Where(o => o.Item == txt_box1.Text).FirstOrDefault(); if (model == null) { model = new Table_MudChemicalsAdded(); model.Item = txt_box1.Text; model.dataMakeTime = dt; model.dataMakeUser = AppDrill.username; model.dataMakePGM = "SelectList"; model.dataUpdTime = dt; model.dataUpdUser = AppDrill.username;; model.dataUpdPGM = "SelectList"; db.Table_MudChemicalsAdded.Add(model); db.SaveChanges(); } break; } } else { this.selectText = this.rlv_selectItem.SelectedItem.Text; } } catch { this.selectText = null; } }
private void rbtn_delete_Click(object sender, EventArgs e) { switch (isWhat) { case 1: try { if (MessageBox.Show(message_list[1], message_list[0], MessageBoxButtons.OKCancel) == DialogResult.OK) { string select = rlv_selectItem.SelectedItem.Text; BushingSize bs = bsize.Where(o => o.Size == select).FirstOrDefault(); if (bs != null) { db.BushingSize.Remove(bs); db.SaveChanges(); } rlv_selectItem.Items.RemoveAt(rlv_selectItem.SelectedIndex); } } catch { } break; case 3: try { if (rlv_selectItem.SelectedIndex > 20) { if (MessageBox.Show(message_list[1], message_list[0], MessageBoxButtons.OKCancel) == DialogResult.OK) { string select = rlv_selectItem.SelectedItem.Text; WorkCode w = workcode.Where(o => o.CodeNo == select).FirstOrDefault(); if (w != null) { db.WorkCode.Remove(w); workcode.Remove(w); db.SaveChanges(); d_list.Add(w); } rlv_selectItem.Items.RemoveAt(rlv_selectItem.SelectedIndex); } } } catch { } break; case 4: try { if (MessageBox.Show(message_list[1], message_list[0], MessageBoxButtons.OKCancel) == DialogResult.OK) { string select = rlv_selectItem.SelectedItem.Text; Table_MudChemicalsAdded tm = MudChemicalsAdded.Where(o => o.Item == select).FirstOrDefault(); if (tm != null) { db.Table_MudChemicalsAdded.Remove(tm); db.SaveChanges(); } rlv_selectItem.Items.RemoveAt(rlv_selectItem.SelectedIndex); } } catch { } break; case 5: try { if (MessageBox.Show(message_list[1], message_list[0], MessageBoxButtons.OKCancel) == DialogResult.OK) { string select = rlv_selectItem.SelectedItem.Text; WorkType wt = WT_List.Where(o => o.Type == select).FirstOrDefault(); if (wt != null) { db.WorkType.Remove(wt); db.SaveChanges(); } rlv_selectItem.Items.RemoveAt(rlv_selectItem.SelectedIndex); } } catch { } break; } }