private void Delete_Click(object sender, RoutedEventArgs e)
{
//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_linq.Products.DeleteOnSubmit(p);
p_linq.SubmitChanges();
DG_Product.ItemsSource = p_linq.Products.ToList();
if (id <= DG_Product.Items.Count - 1)
{
DG_Product.SelectedIndex = id;
}
}
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 Delete_Click(object sender, RoutedEventArgs e)
{
Stock_ classObj = DG_Stock.SelectedItem as Stock_;
ID = classObj.Product_Id;
stock_member = stock_context.Stock_s.Where(w => w.Product_Id == ID).FirstOrDefault();
stock_context.Stock_s.DeleteOnSubmit(stock_member);
stock_context.SubmitChanges();
DG_Stock.ItemsSource = stock_context.Stock_s.ToList();
if (ID <= DG_Stock.Items.Count - 1)
{
DG_Stock.SelectedIndex = ID;
}
Product_name.Text = auto_number.Text = Product_code.Text = "";
Transaction_date.SelectedDate = System.DateTime.Now;
}
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;
}
}
}
