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;
}
}
}
