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