private void Add_Click(object sender, EventArgs e)
{
if (userName.Text.Trim().Length != 0 && pwd.Text.Trim().Length != 0 && userType.Text.Length != 0)
{
try
{
using (var ctx = new ItemContext())
{
User u = new User()
{
UserName = userName.Text.Trim(), UserPwd = pwd.Text.Trim(), UserType = userType.Text.Trim()
};
ctx.Users.Add(u);
ctx.SaveChanges();
MessageBox.Show("Successfully added new user!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Clear_Click(this, e);
}
}
else
{
MessageBox.Show("Please complete the information!");
}
}
private void button1_Click(object sender, EventArgs e)
{
string pwd = textBox2.Text.Trim().ToString();
if (textBox2.Text.Trim().Length == 0 || textBox3.Text.Trim() != textBox2.Text.Trim())
{
MessageBox.Show("Failed, password and confirm password are not equal or empty!", "System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
try
{
using (var ctx = new ItemContext())
{
User user = new User()
{
UserName = uname, UserPwd = textBox2.Text.Trim().ToString()
};
ctx.Users.Attach(user);
ctx.Entry(user).State = System.Data.Entity.EntityState.Modified;
ctx.Entry(user).Property(x => x.UserType).IsModified = false;
ctx.SaveChanges();
MessageBox.Show("Password Successfully Changed!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (itemTitile.Text.Length != 0 && UPC.Text.Length != 0 && date.Text.Length != 0 && TrackingNumLabel.Text.Length != 0)
{
try
{
using (var ctx = new ItemContext())
{
ItemInbound itemInbound = ctx.ItemInbounds.Where(u => u.ItemInboundId == itemInboundId).FirstOrDefault();
itemInbound.ItemTitle = itemTitile.Text;
itemInbound.Date = Convert.ToDateTime(date.Text);
itemInbound.Qty = Convert.ToInt32(Qty.Text);
itemInbound.UPC = UPC.Text;
itemInbound.TrackingNum = TrackingNum.Text;
itemInbound.ShipperId = tbShipperID.Text;
ctx.Entry(itemInbound).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
MessageBox.Show("Successfully updated!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Selected)
{
try
{
using (var ctx = new ItemContext())
{
ItemInbound it = new ItemInbound();
it.ItemInboundId = Convert.ToInt32(row.Cells[0].Value.ToString());
it.isDelete = false;
ctx.ItemInbounds.Attach(it);
ctx.Entry(it).State = System.Data.Entity.EntityState.Unchanged;
ctx.Entry(it).Property(p => p.isDelete).IsModified = true;
ctx.SaveChanges();
MessageBox.Show("Restore successfully.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
fillBy1ToolStripButton_Click(this, e);
}
private void button1_Click(object sender, EventArgs e)
{
if (itemTitile.Text.Trim().Length != 0 && TrackingNum.Text.Trim().Length != 0 && UPC.Text.Trim().Length != 0)
{
try
{
using (var ctx = new ItemContext())
{
ItemInbound II = new ItemInbound()
{
ItemTitle = itemTitile.Text.Trim(), TrackingNum = TrackingNum.Text.Trim(), Date = Convert.ToDateTime(date.Text.ToString()), Qty = Convert.ToInt32(Qty.Text), Manipulator = manipulator, UPC = UPC.Text.Trim(), ShipperId = tbShipperID.Text.Trim(), isDelete = false
};
ctx.ItemInbounds.Add(II);
ctx.SaveChanges();
}
MessageBox.Show("Record successfully added!");
UPC.Text = "";
TrackingNum.Text = "";
date.Value = DateTime.Now;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("itemTitile, TrackingNum, UPC cannot be null.");
}
}
private void ReadyToOut_Click(object sender, EventArgs e)
{
int position = dataGridView1.Rows.GetFirstRow(DataGridViewElementStates.Selected);
string currentRow = dataGridView1.Rows[position].Cells["SN"].Value.ToString();
try
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (Convert.ToBoolean(row.Cells["Selected"].Value))
{
using (var ctx = new ItemContext())
{
string rdy = row.Cells["SN"].Value.ToString();
var pending = ctx.Items.Where(sn => sn.SN == rdy).Select(x => x.Pending).First();
var condition = ctx.Items.Where(sn => sn.SN == rdy).Select(x => x.Condition).First();
if (pending == null)
{
pending = false;
}
if (condition == null)
{
MessageBox.Show("The item without condition cannot set to rdy.");
return;
}
if (condition.Contains("unchecked") || condition.Contains("Unchecked") || condition.Contains("Defective"))
{
MessageBox.Show(condition.ToString() + " Item Cannot set to rdy to out");
return;
}
Item ite = new Item()
{
SN = row.Cells["SN"].Value.ToString(), Pending = !Convert.ToBoolean(pending.Value)
};
ctx.Entry <Item>(ite).State = EntityState.Unchanged;
ctx.Entry <Item>(ite).Property(p => p.Pending).IsModified = true;
ctx.SaveChanges();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
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(currentRow, dataGridView1);
}
}
private void button3_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Selected)
{
try
{
int selectedId = Convert.ToInt32(row.Cells[0].Value.ToString());
using (var ctx = new ItemContext())
{
ItemInbound it = ctx.ItemInbounds.Where(id => id.ItemInboundId == selectedId).First <ItemInbound>();
ctx.ItemInbounds.Remove(it);
ctx.SaveChanges();
MessageBox.Show("Delete successfully.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
fillBy1ToolStripButton_Click(this, e);
}
private void Modify_Click(object sender, EventArgs e)
{
if (userName.Text.Trim().Length != 0)
{
try
{
using (var ctx = new ItemContext())
{
User u = new User()
{
UserName = userName.Text.Trim(), UserPwd = pwd.Text.Trim(), UserType = userType.Text
};
ctx.Users.Attach(u);
ctx.Entry(u).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
MessageBox.Show("Successfully Updated!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Clear_Click(this, e);
}
}
else
{
MessageBox.Show("Please select one user!");
}
}
private void Delete_Click(object sender, EventArgs e)
{
if (userName.Text.Trim().Length != 0)
{
try
{
using (var ctx = new ItemContext())
{
User u = ctx.Users.Where(uname => uname.UserName == userName.Text.Trim()).First <User>();
ctx.Users.Remove(u);
ctx.SaveChanges();
MessageBox.Show(userName.Text.ToString() + " is deleted successfully!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Clear_Click(this, e);
}
}
else
{
MessageBox.Show("Pleas Select one user!");
}
}
//private void setFridViewProperty()
//{
// dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
// dataGridView1.ReadOnly = true;
// dataGridView1.ClearSelection();
// dataGridView1.RowHeadersVisible = false;
// dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
// dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.DisplayedCells;
// dataGridView1.RowsDefaultCellStyle.WrapMode = DataGridViewTriState.True;
// dataGridView1.AllowUserToResizeRows = false;
// dataGridView1.AllowUserToResizeColumns = true;
// dataGridView1.AllowUserToAddRows = false;
//}
private void Clear_Click(object sender, EventArgs e)
{
DateTime time1 = Convert.ToDateTime(dateTimePicker1.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.ItemBaks.Where(a => a.DateOfOut.CompareTo(time1) < 0);
foreach (var ite in list)
{
ctx.ItemBaks.Remove(ite);
}
ctx.SaveChanges();
MessageBox.Show("Clearance Successfully!");
}
}
RecentDeletion_Load(this, e);
}
private void button1_Click(object sender, EventArgs e)
{
if (itemTitile.Text.Trim().Length != 0 && TrackingNum.Text.Trim().Length != 0 && SN.Text.Trim().Length != 0)
{
try
{
using (var ctx = new ItemContext())
{
DateTime timeLimit = DateTime.Now.AddDays(-3);
var itemExist = ctx.ItemOutbounds.Where(x => x.TrackingNum == TrackingNum.Text.Trim()).Where(time => DateTime.Compare(time.Date, timeLimit) > 0).ToList();
if (itemExist.Count > 0)
{
if (MessageBox.Show("The tracking number has been used in recent 3 days.", "Do you want to continue?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
}
else
{
return;
}
}
ItemOutbound IO = new ItemOutbound()
{
ItemTitle = itemTitile.Text.Trim(), TrackingNum = TrackingNum.Text.Trim(), Date = Convert.ToDateTime(date.Text.ToString()), Qty = Convert.ToInt32(Qty.Text), Manipulator = manipulator, SN = SN.Text.Trim(), isDelete = false
};
ctx.ItemOutbounds.Add(IO);
ctx.SaveChanges();
}
MessageBox.Show("Record successfully added!");
SN.Text = "";
TrackingNum.Text = "";
date.Value = DateTime.Now;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("itemTitile, TrackingNum, SN cannot be null.");
}
}
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 button1_Click(object sender, EventArgs e)
{
if (itemTitile.Text.Length != 0 && orderId.Text.Length != 0 && SN.Text.Length != 0 && condition.Text.Length != 0)
{
try
{
//determine editors
editor = editorMaker(editor);
if (SN.ReadOnly)
{
using (var ctx = new ItemContext())
{
Item ite;
if (utype == "serviceMan")
{
//Item it = ctx.Items.SingleOrDefault(a => a.SN == snCode);
//it.ItemTitle = itemTitile.Text.Trim();
//it.DateOfRcv = Convert.ToDateTime(dateOfRcv.Text);
//it.OrderId = orderId.Text.Trim();
//it.UPC = UPC.Text.Trim();
//it.SN = SN.Text.Trim();
//it.ReturnCode = returnCode.Text.Trim();
//it.Location = location.Text.Trim();
//it.Listed = listed.Text;
//it.ServiceMan = uname;
//it.Condition = condition.Text;
//it.OriginalTrackingNum = originalTrackingNum.Text.Trim();
//it.Note = Note.Text.Trim();
//ctx.Items.Attach(it);
//ctx.Entry(it).State = System.Data.Entity.EntityState.Modified;
ite = new Item()
{
ItemTitle = itemTitile.Text.Trim(),
DateOfRcv = Convert.ToDateTime(dateOfRcv.Text),
OrderId = orderId.Text.Trim(),
UPC = UPC.Text.Trim(),
SN = SN.Text.Trim(),
OriginalTrackingNum = originalTrackingNum.Text.Trim(),
ReturnCode = returnCode.Text.Trim(),
Location = location.Text.Trim(),
Listed = listed.Text,
ServiceMan = editor,
Condition = condition.Text,
Note = Note.Text.Trim()
};
ctx.Items.Attach(ite);
ctx.Entry(ite).State = System.Data.Entity.EntityState.Modified;
ctx.Entry(ite).Property(x => x.ItemInOperator).IsModified = false;
ctx.Entry(ite).Property(y => y.Pending).IsModified = false;
}
else
{
ite = new Item()
{
ItemTitle = itemTitile.Text.Trim(),
DateOfRcv = Convert.ToDateTime(dateOfRcv.Text),
OrderId = orderId.Text.Trim(),
UPC = UPC.Text.Trim(),
SN = SN.Text.Trim(),
OriginalTrackingNum = originalTrackingNum.Text.Trim(),
ReturnCode = returnCode.Text.Trim(),
Location = location.Text.Trim(),
Listed = listed.Text,
Condition = condition.Text,
Note = Note.Text.Trim()
};
ctx.Items.Attach(ite);
ctx.Entry(ite).State = System.Data.Entity.EntityState.Modified;
ctx.Entry(ite).Property(x => x.ItemInOperator).IsModified = false;
ctx.Entry(ite).Property(x => x.ServiceMan).IsModified = false;
ctx.Entry(ite).Property(y => y.Pending).IsModified = false;
}
ctx.SaveChanges();
MessageBox.Show("Successfully updated!");
this.Dispose(true);
}
}
else
{
try
{
using (ItemContext ctx = new ItemContext())
{
Item it = ctx.Items.SingleOrDefault(a => a.SN == snCode);
Item itNew = new Item()
{
ItemTitle = itemTitile.Text.Trim(),
OrderId = orderId.Text.Trim(),
UPC = UPC.Text.Trim(),
SN = SN.Text.Trim(),
OriginalTrackingNum = originalTrackingNum.Text.Trim(),
ReturnCode = returnCode.Text.Trim(),
Location = location.Text.Trim(),
DateOfRcv = Convert.ToDateTime(dateOfRcv.Text.ToString()),
Listed = listed.Text,
ItemInOperator = it.ItemInOperator,
Condition = condition.Text,
Note = Note.Text.Trim(),
Pending = it.Pending,
ServiceMan = editorMaker(editor)
};
ctx.Items.Remove(it);
ctx.Items.Add(itNew);
ctx.SaveChanges();
MessageBox.Show("Successfully updated!");
snCode = SN.Text;
this.Dispose(true);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
}
else
{
MessageBox.Show("Item title, order ID, and Condition are required. ");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (itemTitile.Text.Length != 0 && dateOfRcv.Text.Length != 0 && orderId.Text.Length != 0 && SN.Text.Length != 0)
{
//if (!(Regex.IsMatch(Regex.Replace(orderId.Text.Trim().ToString(), "-",""), StrRegex(1))))
//{
// //MessageBox.Show(orderId.Text.Trim().ToString().Split('-')[0].ToString());
// MessageBox.Show("Order Number has to be number, alphabet and '-'!", "System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return;
//}
//if (UPC.Text.Trim().Length != 0 && !(Regex.IsMatch(UPC.Text.Trim().ToString(), StrRegex(3))))
//{
// MessageBox.Show("UPC has to be number!", "System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return;
//}
//if (!Regex.IsMatch(SN.Text.Trim().ToString(), StrRegex(1)))
//{
// MessageBox.Show("SN has to be number or alphabet!", "System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return;
//}
try
{
using (var ctx = new ItemContext())
{
//MessageBox.Show(dateOfRcv.Text.ToString());
Item Ite = new Item()
{
ItemTitle = itemTitile.Text.Trim(), OrderId = orderId.Text.Trim(), UPC = UPC.Text.Trim(), SN = SN.Text.Trim(), OriginalTrackingNum = originalTrackingNum.Text.Trim(), ReturnCode = returnCode.Text.Trim(), Location = location.Text.Trim(), DateOfRcv = Convert.ToDateTime(dateOfRcv.Text.ToString()), Listed = listed.Text, ItemInOperator = uname, Condition = condition.Text, Note = Note.Text.Trim(), Pending = false
};
//var WholeRecord = ctx.Items.Select(a => a.SN).Union(ctx.ItemsDisposed.Select(b => b.SN));
var WholeRecord = ctx.Items.Select(a => a.SN);
//MessageBox.Show(WholeRecord.Where(x => x.Equals(SN.Text.Trim())).ToList().ToString());
if (WholeRecord.Where(x => x.Equals(SN.Text.Trim())).ToList().Count == 0)
{
ctx.Items.Add(Ite);
ctx.SaveChanges();
MessageBox.Show("Successfully added!");
//MessageBox.Show(WholeRecord.Where(x => x.Equals(SN.Text.Trim())).ToList().ToString());
foreach (Control ctr in this.Controls)
{
if (ctr is TextBox)
{
if (ctr.Name == itemTitile.Name || ctr.Name == originalTrackingNum.Name || ctr.Name == orderId.Name || ctr.Name == location.Name)
{
continue;
}
ctr.Text = "";
}
}
noSNCheckBox.Checked = false;
dateOfRcv.Value = DateTime.Now;
listed.SelectedIndex = 0;
//condition.SelectedIndex = 0;
}
else
{
MessageBox.Show("Item already exists in inventory!");
//MessageBox.Show(WholeRecord.ToString());
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
}
else
{
MessageBox.Show("Item title, orderID, and SN are required.");
}
}
private void SaveAll_Click(object sender, EventArgs e)
{
if (itemTitile.Text.Trim().Length > 0 || location.Text.Trim().Length > 0 ||
listed.Text.Trim().Length > 0 || condition.Text.Trim().Length > 0 ||
note.Text.Trim().Length > 0 || upc.Text.Trim().Length > 0)
{
foreach (string sn in SN)
{
try
{
using (ItemContext ctx = new ItemContext())
{
Item it = ctx.Items.Find(sn);
it.ServiceMan = uname;
foreach (Control ctr in this.Controls)
{
if (ctr.Text.Trim().Length != 0)
{
switch (ctr.Name)
{
case "itemTitile":
it.ItemTitle = ctr.Text.Trim();
break;
case "location":
it.Location = ctr.Text.Trim();
break;
case "listed":
it.Listed = ctr.Text.Trim();
break;
case "condition":
it.Condition = ctr.Text.Trim();
break;
case "upc":
it.UPC = ctr.Text.Trim();
break;
case "note":
it.Note = ctr.Text.Trim();
break;
}
}
}
ctx.Items.Attach(it);
ctx.Entry(it).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return;
}
}
MessageBox.Show("Successfull updated multiple items!");
this.Dispose();
}
else
{
MessageBox.Show("Nothing can be updated!");
}
}
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);
}
}
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)
{
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 record will be deleted!", "Are you sure?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (Convert.ToBoolean(row.Cells["Selected"].Value))
{
int idDelete = Convert.ToInt32(row.Cells["ItemOutboundId"].Value.ToString());
indexDelete = indexDelete == 0 ? row.Index - 1 : indexDelete;
//string trackingDelete = row.Cells["TrackingNum"].Value.ToString();
try
{
using (var ctx = new ItemContext())
{
ItemOutbound itemOutboundDel = new ItemOutbound();
itemOutboundDel.ItemOutboundId = idDelete;
itemOutboundDel.isDelete = true;
ctx.ItemOutbounds.Attach(itemOutboundDel);
ctx.Entry(itemOutboundDel).Property(x => x.isDelete).IsModified = true;
ctx.SaveChanges();
del = true;
}
}
catch (Exception ex)
{
del = false;
MessageBox.Show(ex.Message);
}
}
}
}
}
else
{
MessageBox.Show("No item selected!");
}
if (del) // deleted
{
del = false;
if (ItemTitle.Text.Length != 0 || SN.Text.Length != 0 ||
OutBoundDate.Checked || Manipulator.Text.Length != 0 ||
TrackingNum.Text.Trim().Length != 0)
{
Search_Click(this, e);
}
else
{
ReLoadData();
}
st.returnCurrentRow(indexDelete, dataGridView1);
}
}