private void multipleDeleteButton_Click(object sender, EventArgs e)
{
DateTime time1 = Convert.ToDateTime(clearDatePicker.Text);
if (MessageBox.Show("The Log before " + time1.Date + " will be deleted", "Are you sure?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (ItemContext ctx = new ItemContext())
{
var list = ctx.ItemsDisposed.Where(a => a.DateOfOut.CompareTo(time1) < 0);
foreach (var it in list)
{
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();
MessageBox.Show("Clearance Successfully!");
}
}
Management_Load(this, e);
}
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);
}
}