private void Add_Click(object sender, RoutedEventArgs e) { using (ProductLinqClassesDataContext p_linq = new ProductLinqClassesDataContext()) { p.Product_Name = PName.Text; p.Product_Description = PDescription.Text; p.Product_Status = PStatus.Text; p_linq.Products.InsertOnSubmit(p); p_linq.SubmitChanges(); DG_Product.ItemsSource = p_linq.Products.ToList(); PName.Text = PDescription.Text = PStatus.Text = ""; } }
private void Add_Click(object sender, RoutedEventArgs e) { using (ProductLinqClassesDataContext p_linq = new ProductLinqClassesDataContext()) { stock_member.Product_Id = Convert.ToInt32(Product_code.Text); stock_member.Product_Name = Product_name.Text; stock_member.Trans_Date = Transaction_date.SelectedDate; stock_member.Quantity = Convert.ToInt32(auto_number.Text); p_linq.Stock_s.InsertOnSubmit(stock_member); p_linq.SubmitChanges(); DG_Stock.ItemsSource = p_linq.Stock_s.ToList(); Product_code.Text = Product_name.Text = auto_number.Text = ""; Transaction_date.SelectedDate = System.DateTime.Now; } }
private void Update_Click(object sender, RoutedEventArgs e) { if (DG_Product.CurrentCell.Item != null) { using (ProductLinqClassesDataContext p_linq = new ProductLinqClassesDataContext()) { Product classObj = DG_Product.SelectedItem as Product; id = classObj.Product_Id; p = p_linq.Products.Where(w => w.Product_Id == id).FirstOrDefault(); p.Product_Name = PName.Text; p.Product_Description = PDescription.Text; p.Product_Status = PStatus.Text; p_linq.SubmitChanges(); DG_Product.ItemsSource = p_linq.Products.ToList(); } } }
private void Update_Click(object sender, RoutedEventArgs e) { if (DG_Stock.CurrentCell.Item != null) { using (ProductLinqClassesDataContext p_linq = new ProductLinqClassesDataContext()) { Stock_ classObj = DG_Stock.SelectedItem as Stock_; ID = classObj.Product_Id; stock_member = p_linq.Stock_s.Where(w => w.Product_Id == ID).FirstOrDefault(); stock_member.Product_Name = Product_name.Text; stock_member.Trans_Date = Transaction_date.SelectedDate; stock_member.Quantity = Convert.ToInt32(auto_number.Text); p_linq.SubmitChanges(); DG_Stock.ItemsSource = p_linq.Stock_s.ToList(); Product_name.Text = auto_number.Text = Product_code.Text = ""; Transaction_date.SelectedDate = System.DateTime.Now; } } }