private void DataGrid_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
Stock_ classObj = DG_Stock.SelectedItem as Stock_;
int id = classObj.Product_Id;
var query = from m in stock_context.Stock_s
where m.Product_Id == id
select m;
foreach (var q in query)
{
Product_code.Text = Convert.ToString(q.Product_Id);
Product_name.Text = q.Product_Name;
Transaction_date.SelectedDate = q.Trans_Date;
auto_number.Text = Convert.ToString(q.Quantity);
}
}
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 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;
}
}
}
partial void DeleteStock_(Stock_ instance);
partial void UpdateStock_(Stock_ instance);
partial void InsertStock_(Stock_ instance);