private void Insert() { //插入数据 UserLoginLog ull = new UserLoginLog { User_ID = "a100", UserName = "******", IP = "20190312", TimeStamp = Guid.NewGuid().ToString("N").Substring(0, 12) }; ctx.UserLoginLogs.InsertOnSubmit(ull); ctx.SubmitChanges(); }
private void button3_Click(object sender, RoutedEventArgs e) { MessageBoxResult m = MessageBox.Show("Удалить?", "", MessageBoxButton.OKCancel); if (m == MessageBoxResult.OK) { Action a = null; if (listBox1.SelectedIndex >= 0) { a = l[listBox1.SelectedIndex]; } if (listBox2.SelectedIndex >= 0) { a = l[listBox1.SelectedIndex]; } using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString)) { if (a != null) { var s1 = from Action in Db.Actions where Action.ActionID == a.ActionID select Action; Db.Actions.DeleteOnSubmit(s1.FirstOrDefault()); Db.SubmitChanges(); } } init(); } }
static void Main() { MyDataContext ctx = new MyDataContext(); BindingSource custs = new BindingSource() { DataSource = ctx.Customers }; BindingSource orders = new BindingSource { DataMember = "Orders", DataSource = custs }; Button btn; using (Form form = new Form { Controls = { new DataGridView() { DataSource = orders, DataMember = "Order_Details", Dock = DockStyle.Fill }, new ComboBox() { DataSource = orders, DisplayMember = "OrderID", Dock = DockStyle.Top }, new ComboBox() { DataSource = custs, DisplayMember = "CompanyName", Dock = DockStyle.Top }, (btn = new Button() { Text = "Save", Dock = DockStyle.Bottom }), // **edit here re textbox etc** new TextBox { DataBindings ={ { "Text", orders, "ShipAddress" } }, Dock = DockStyle.Bottom }, new Label { DataBindings ={ { "Text", custs, "ContactName" } }, Dock = DockStyle.Top }, new Label { DataBindings ={ { "Text", orders, "RequiredDate" } }, Dock = DockStyle.Bottom } } }) { btn.Click += delegate { form.Text = "Saving..."; ctx.SubmitChanges(); form.Text = "Saved"; }; Application.Run(form); } }
private void textBox1_TextChanged(object sender, TextChangedEventArgs e) { using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString)) { IQueryable <Diet> q = from Diet in Db.Diets where Diet.DietID == dietId select Diet; d = q.FirstOrDefault(); d.Duration = Convert.ToInt32(textBox1.Text); Db.SubmitChanges(); } }
private void name_TextChanged(object sender, TextChangedEventArgs e) { using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString)) { IQueryable <Diet> q = from Diet in Db.Diets where Diet.DietID == dietId select Diet; d = q.FirstOrDefault(); d.Name = name.Text; Db.SubmitChanges(); } }
private void button1_Click(object sender, RoutedEventArgs e) { using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString)) { Action a = new Action { Name = name.Text, Energy = Convert.ToDouble(energy.Text) }; NavigationService.Navigate(new Uri("/ActionList.xaml", UriKind.Relative)); Db.Actions.InsertOnSubmit(a); Db.SubmitChanges(); } }
private void button2_Click(object sender, RoutedEventArgs e) { using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString)) { Schedule s = new Schedule { DayWeek = dayIdx, Duration = Convert.ToInt32(duration.Text), Time = time.Text, Action = l[listBox1.SelectedIndex] }; Db.Schedules.InsertOnSubmit(s); Db.SubmitChanges(); } NavigationService.Navigate(new Uri("/Schedule.xaml", UriKind.Relative)); }
private void button2_Click(object sender, RoutedEventArgs e) { using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString)) { IQueryable <Diet> q = from Diet in Db.Diets where Diet.DietID == dietId select Diet; d = q.FirstOrDefault(); d.Name = name.Text; d.Duration = Convert.ToInt32(textBox1.Text); Db.SubmitChanges(); NavigationService.Navigate(new Uri("/InfoPage.xaml", UriKind.Relative)); } }
private void button1_Click(object sender, RoutedEventArgs e) { using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString)) { IQueryable <Dish> RationQuery = from Dish in Db.Dishes where Dish.DishID == l[listBox2.SelectedIndex].DishID select Dish; Dish d = RationQuery.FirstOrDefault(); Ration r = new Ration { DayWeek = listBox1.SelectedIndex, Dish = d, Time = textBox1.Text, WeightDish = Convert.ToInt32(textBox2.Text) }; Db.Rations.InsertOnSubmit(r); Db.SubmitChanges(); NavigationService.Navigate(new Uri("/RationPage.xaml", UriKind.Relative)); } }
private void button1_Click(object sender, RoutedEventArgs e) { using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString)) { DietProduct dp = new DietProduct() { DId = AddDiet.d.DietID, Product = l[SelectedIndex] }; Db.DietProducts.InsertOnSubmit(dp); AddDiet.d.DietProducts.Add(dp); Db.SubmitChanges(); NavigationService.Navigate(new Uri("/AddDiet.xaml", UriKind.Relative)); } }
static void Main() { MyDataContext ctx = new MyDataContext(); BindingSource custs = new BindingSource() { DataSource = ctx.Customers }; BindingSource orders = new BindingSource { DataMember = "Orders", DataSource = custs }; Button btn; using (Form form = new Form { Controls = { new DataGridView() { DataSource = orders, DataMember = "Order_Details", Dock = DockStyle.Fill }, new ComboBox() { DataSource = orders, DisplayMember = "OrderID", Dock = DockStyle.Top }, new ComboBox() { DataSource = custs, DisplayMember = "CompanyName", Dock = DockStyle.Top }, (btn = new Button() { Text = "Save", Dock = DockStyle.Bottom }) } }) { btn.Click += delegate { form.Text = "Saving..."; ctx.SubmitChanges(); form.Text = "Saved"; }; Application.Run(form); } }
public ActionResult Edit(int?id, LearningMVCAppln.Models.User userDetails) //public ActionResult Edit(int? id) { TempData["TempData Name"] = "Akhil"; try { using (var dbContext = new MyDataContext()) { var user = dbContext.Users.FirstOrDefault(userId => userId.UserId == id); if (user != null) { user.FirstName = userDetails.FirstName; user.LastName = userDetails.LastName; user.Address = userDetails.Address; user.PhoneNo = userDetails.PhoneNo; user.EMail = userDetails.EMail; user.Company = userDetails.Company; user.Designation = userDetails.Designation; dbContext.SubmitChanges(); } return(RedirectToAction(nameof(Index))); } } catch (Exception) { return(View()); } //try //{ // Mapper.CreateMap<LearningMVCAppln.Models.User, LearningMVCAppln.User>(); // using (var dbContext = new MyDataContext()) // { // var userDetails1 = dbContext.Users.FirstOrDefault(userId => userId.UserId == id); // var user = Mapper.Map<LearningMVCAppln.Models.User, LearningMVCAppln.User>(userDetails); // //dbContext.Users.InsertOnSubmit(user); // dbContext.SubmitChanges(); // return RedirectToAction(nameof(Index)); // } //} //catch (Exception) //{ // return View(); //} }
private void button3_Click(object sender, RoutedEventArgs e) { MessageBoxResult m = MessageBox.Show("Удалить?", "", MessageBoxButton.OKCancel); if (m == MessageBoxResult.OK) { DietProduct s = null; if (listBox1.SelectedIndex >= 0) { s = list[listBox1.SelectedIndex]; } else if (listBox2.SelectedIndex >= 0) { s = list[listBox2.SelectedIndex]; } else if (listBox3.SelectedIndex >= 0) { s = list[listBox3.SelectedIndex]; } else if (listBox3.SelectedIndex >= 0) { s = list[listBox3.SelectedIndex]; } else if (listBox4.SelectedIndex >= 0) { s = list[listBox4.SelectedIndex]; } else if (listBox5.SelectedIndex >= 0) { s = list[listBox5.SelectedIndex]; } using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString)) { if (s != null) { var s1 = from DietProduct in Db.DietProducts where DietProduct.DPID == s.DPID select DietProduct; Db.DietProducts.DeleteOnSubmit(s1.FirstOrDefault()); Db.SubmitChanges(); } } init(); } }
public ActionResult Create(LearningMVCAppln.Models.User userDetails) { try { Mapper.CreateMap <LearningMVCAppln.Models.User, LearningMVCAppln.User>(); using (var dbContext = new MyDataContext()) { var user = Mapper.Map <LearningMVCAppln.Models.User, LearningMVCAppln.User>(userDetails); dbContext.Users.InsertOnSubmit(user); dbContext.SubmitChanges(); return(RedirectToAction(nameof(Index))); } } catch (Exception) { return(View()); } }
public ActionResult Delete(int?id, Models.User userDetails) { try { using (var dbContext = new MyDataContext()) { var user = dbContext.Users.FirstOrDefault(userId => userId.UserId == id); if (user != null) { dbContext.Users.DeleteOnSubmit(user); dbContext.SubmitChanges(); } return(RedirectToAction(nameof(Index))); } } catch (Exception) { return(View()); } }
public AddDiet() { InitializeComponent(); InitializeComponent(); if (a) { d = new Diet(); using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString)) { d.Name = ""; d.DietProducts = new System.Data.Linq.EntitySet <DietProduct>(); Db.Diets.InsertOnSubmit(d); Db.SubmitChanges(); dietId = (from Diet in Db.Diets select Diet).Count(); } a = false; } else { name.Text = d.Name; textBox1.Text = d.Duration + ""; using (MyDataContext Db = new MyDataContext(MainPage.strConnectionString)) { IQueryable <Diet> q = from Diet in Db.Diets where Diet.DietID == dietId select Diet; d = q.FirstOrDefault(); var list1 = d.DietProducts.ToList(); List <String> ll = new List <string>(); foreach (var s in list1) { ll.Add(s.Product.Name); } lb1.ItemsSource = ll; } } }
public void Save() { _dataContext.SubmitChanges(); }