private void bttn_NoCliente_Click(object sender, EventArgs e) { using (BankTEntities db = new BankTEntities()) { Turno Turn = new Turno(); try { var getLastTurn = db.Turnoes.Where(x => x.Tipo == "U").OrderByDescending(x => x.ID).First(); if (Convert.ToInt32(getLastTurn.Numero) < 99) { Turn.Numero = (Convert.ToInt32(getLastTurn.Numero) + 1).ToString(); } else { Turn.Numero = "1"; } Turn.Tipo = "U"; Turn.Modulo = "0"; Turn.IDCliente = Cedula; Turn.Estado = "En Espera"; } catch { Turn.Numero = "1"; Turn.Tipo = "U"; Turn.Modulo = "0"; Turn.IDCliente = Cedula; Turn.Estado = "En Espera"; } var TurnCreation = db.Set <Turno>(); TurnCreation.Add(Turn); db.SaveChanges(); FinRes(Turn); } }
private void Updateturn(Turno turnmodel) { using (BankTEntities db = new BankTEntities()) { db.Entry(turnmodel).State = EntityState.Modified; db.SaveChanges(); } }