コード例 #1
0
        public Inventory()
        {
            InitializeComponent();

            DataClassesLinqDataContext db = new DataClassesLinqDataContext(DataAccessClassLinq.connectionStringLinq);

            DAL.Inventory iv = db.Inventories.FirstOrDefault(a => a.Inventory_ID.Equals("1"));

            Printer.Text     = iv.Printer;
            Computer.Text    = iv.Computer;
            Mouse.Text       = iv.Mouse;
            Keyboard.Text    = iv.Keyboard;
            Projector.Text   = iv.Projector;
            Camera.Text      = iv.Camera;
            WhiteBoard.Text  = iv.Whiteboard;
            Marker.Text      = iv.Marker;
            Pencil.Text      = iv.Pencil;
            Soap.Text        = iv.Clock;
            PaperBundle.Text = iv.Paperbundle;
            Pen.Text         = iv.Pen;
            Duster.Text      = iv.Duster;
            GeometryBox.Text = iv.Geometrybox;
            Ruler.Text       = iv.Ruler;
            Chair.Text       = iv.Chair;
            Bench.Text       = iv.Bench;
            Table.Text       = iv.Table;
        }
コード例 #2
0
 public InventoryDTO ToDTO(DAL.Inventory i)
 {
     return(new InventoryDTO()
     {
         ClothID = i.ClothID, StoreID = i.StoreID, YearOfProduction = i.YearOfProduction
     });
 }
コード例 #3
0
        private void Button_DONE(object sender, RoutedEventArgs e)
        {
            DataClassesLinqDataContext db = new DataClassesLinqDataContext(DataAccessClassLinq.connectionStringLinq);

            DAL.Inventory iv = db.Inventories.FirstOrDefault(a => a.Inventory_ID.Equals("1"));


            if (Edit.Content.ToString() == "EDIT")
            {
                Edit.Content          = "DONE";
                Printer.IsEnabled     = true;
                Computer.IsEnabled    = true;
                Mouse.IsEnabled       = true;
                Keyboard.IsEnabled    = true;
                Projector.IsEnabled   = true;
                Camera.IsEnabled      = true;
                WhiteBoard.IsEnabled  = true;
                Marker.IsEnabled      = true;
                Pencil.IsEnabled      = true;
                Soap.IsEnabled        = true;
                PaperBundle.IsEnabled = true;
                Pen.IsEnabled         = true;
                Duster.IsEnabled      = true;
                GeometryBox.IsEnabled = true;
                Ruler.IsEnabled       = true;
                Chair.IsEnabled       = true;
                Bench.IsEnabled       = true;
                Table.IsEnabled       = true;



                /* iv.Printer = Printer.Text;
                 * iv.Computer = Computer.Text;
                 * iv.Mouse = Mouse.Text;
                 * iv.Keyboard = Keyboard.Text;
                 * iv.Projector = Projector.Text;
                 * iv.Camera = Camera.Text;
                 * iv.Whiteboard = WhiteBoard.Text;
                 * iv.Marker = Marker.Text;
                 * iv.Clock = Soap.Text;
                 * iv.Paperbundle = PaperBundle.Text;
                 * iv.Pen = Pen.Text;
                 * iv.Duster = Duster.Text;
                 * iv.Geometrybox = GeometryBox.Text;
                 * iv.Ruler = Ruler.Text;
                 * iv.Chair = Chair.Text;
                 * iv.Bench = Bench.Text;
                 * iv.Table = Table.Text;*/

                // db.Inventories.InsertOnSubmit(iv);
                //db.SubmitChanges();
            }
            else
            {
                Edit.Content          = "EDIT";
                Printer.IsEnabled     = false;
                Computer.IsEnabled    = false;
                Mouse.IsEnabled       = false;
                Keyboard.IsEnabled    = false;
                Projector.IsEnabled   = false;
                Camera.IsEnabled      = false;
                WhiteBoard.IsEnabled  = false;
                Marker.IsEnabled      = false;
                Pencil.IsEnabled      = false;
                Soap.IsEnabled        = false;
                PaperBundle.IsEnabled = false;
                Pen.IsEnabled         = false;
                Duster.IsEnabled      = false;
                GeometryBox.IsEnabled = false;
                Ruler.IsEnabled       = false;
                Chair.IsEnabled       = false;
                Bench.IsEnabled       = false;
                Table.IsEnabled       = false;



                //Printer.Text = iv.Printer;
                //Computer.Text = iv.Computer;
                //Mouse.Text = iv.Mouse;
                //Keyboard.Text = iv.Keyboard;
                //Projector.Text = iv.Projector;
                //Camera.Text = iv.Camera;
                //WhiteBoard.Text = iv.Whiteboard;
                //Marker.Text = iv.Marker;
                //Pencil.Text = iv.Pencil;
                //Soap.Text = iv.Clock;
                //PaperBundle.Text = iv.Paperbundle;
                //Pen.Text = iv.Pen;
                //Duster.Text = iv.Duster;
                //GeometryBox.Text = iv.Geometrybox;
                //Ruler.Text = iv.Ruler;
                //Chair.Text = iv.Chair;
                //Bench.Text = iv.Bench;
                //Table.Text = iv.Table;

                iv.Printer     = Printer.Text;
                iv.Computer    = Computer.Text;
                iv.Mouse       = Mouse.Text;
                iv.Keyboard    = Keyboard.Text;
                iv.Projector   = Projector.Text;
                iv.Camera      = Camera.Text;
                iv.Whiteboard  = WhiteBoard.Text;
                iv.Marker      = Marker.Text;
                iv.Clock       = Soap.Text;
                iv.Paperbundle = PaperBundle.Text;
                iv.Pen         = Pen.Text;
                iv.Duster      = Duster.Text;
                iv.Geometrybox = GeometryBox.Text;
                iv.Ruler       = Ruler.Text;
                iv.Chair       = Chair.Text;
                iv.Bench       = Bench.Text;
                iv.Table       = Table.Text;

                //db.Inventories.InsertOnSubmit(iv);
                db.SubmitChanges();
            }
        }