コード例 #1
0
 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);
 }
コード例 #2
0
 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);
 }
コード例 #3
0
ファイル: InboundModify.cs プロジェクト: cgcq007/Inventory
 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);
         }
     }
 }
コード例 #4
0
 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.");
     }
 }
コード例 #5
0
ファイル: InboundModify.cs プロジェクト: cgcq007/Inventory
 private void InboundModify_Load(object sender, EventArgs e)
 {
     try
     {
         using (var ctx = new ItemContext())
         {
             ItemInbound itemInbound = ctx.ItemInbounds.Find(itemInboundId);
             TrackingNum.Text = itemInbound.TrackingNum;
             itemTitile.Text  = itemInbound.ItemTitle;
             date.Text        = itemInbound.Date.ToString();
             Qty.Text         = itemInbound.Qty.ToString();
             UPC.Text         = itemInbound.UPC;;
             tbShipperID.Text = itemInbound.ShipperId;
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
コード例 #6
0
        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["ItemInboundId"].Value.ToString());
                            indexDelete = indexDelete == 0 ? row.Index - 1 : indexDelete;
                            //string trackingDelete = row.Cells["TrackingNum"].Value.ToString();
                            try
                            {
                                using (var ctx = new ItemContext())
                                {
                                    ItemInbound itemInboundDel = new ItemInbound();
                                    itemInboundDel.ItemInboundId = idDelete;
                                    itemInboundDel.isDelete      = true;
                                    ctx.ItemInbounds.Attach(itemInboundDel);
                                    ctx.Entry(itemInboundDel).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 || UPC.Text.Length != 0 ||
                    InBoundDate.Checked || ShipperID.Text.Length != 0 ||
                    TrackingNum.Text.Trim().Length != 0)
                {
                    Search_Click(this, e);
                }
                else
                {
                    ReLoadData();
                }
                st.returnCurrentRow(indexDelete, dataGridView1);
            }
        }