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