private void update(object sender, RoutedEventArgs e) { var ac = DateTable2.SelectedItem as Board; using (demoEntities10 conx = new demoEntities10()) { DealerAccount dea = conx.DealerAccounts.FirstOrDefault(r => r.id == ac.id); dea.memberid = Convert.ToInt64(memid.SelectedValue); dea.accountid = Convert.ToInt64(accid.SelectedValue); dea.state = Convert.ToInt16(stat.SelectedIndex - 1); conx.SaveChanges(); } FillDataGrid(); }
private void insertFunc(object sender, RoutedEventArgs e) { if (memid.SelectedItem == null || accid.SelectedItem == null || stat.SelectedItem == null) { MessageBox.Show("Талбар дутууу !!!!"); return; } using (demoEntities10 contx = new demoEntities10()) { DealerAccount dea = new DealerAccount { memberid = Convert.ToInt32(memid.SelectedValue), accountid = Convert.ToInt64(accid.SelectedValue), state = Convert.ToInt16(stat.SelectedIndex - 1), modified = DateTime.Now, }; contx.DealerAccounts.Add(dea); contx.SaveChanges(); } FillDataGrid(); }
public IHttpActionResult GetAllDealers(string id) { bool includeAddress = false; DealerAccount dealer = null; using (var ctx = new EasyBillingEntities()) { dealer = ctx.Dealers.Include("State").Where(x => x.Token_number == id).Select(s => new DealerAccount() { Token_number = s.Token_number, Name = s.Name, Email = s.Email, Phone_number = s.Phone_number, Address = s.Address, Dealer_code = s.Dealer_code, State_Name = s.State_Name, Isactive = s.Isactive, stcd = (from a in ctx.States where a.State_Code == s.State select a.Name).Distinct().FirstOrDefault(), Statecd = s.State == null || includeAddress == false ? null : new StateData() { State1 = s.State1.Name, }, State = s.State, }).FirstOrDefault(); } if (dealer == null) { return(NotFound()); } return(Ok(dealer)); }