public ActionResult Create([Bind(Include = "TongHuaID,TongHuaBiaoTi,TongHuaNeiRong,TongHuaLeiBieID,PaiXu")] e_tonghuaxinxi e_tonghuaxinxi) { if (ModelState.IsValid) { db.e_tonghuaxinxi.Add(e_tonghuaxinxi); db.SaveChanges(); return(RedirectToAction("Index")); } else { ViewBag.ErrorInfo = "信息验证失败"; } return(View(e_tonghuaxinxi)); }
protected void CancelarMatriculacion_Click(object sender, EventArgs e) { ModelDatabase db = new ModelDatabase(); int idActividad; int idUsuario; bool bA = Int32.TryParse(Request.QueryString["id_actividad"], out idActividad); bool bM = Int32.TryParse(Request.Cookies["usuario"].Values["id_usuario"], out idUsuario); Matricula matriculaAEliminar = (from m in db.Matriculas where m.usuario_estudiante == idUsuario && m.actividad_id_actividad == idActividad select m).Take(1).First(); if (matriculaAEliminar.asistencia == Matricula.TipoDeAsistencia.Presente) { FailureText.Text = "No puede eliminar una matricula si ya tomo asistencia"; } Actividad actividad = (from a in db.Actividads where a.id_actividad == idActividad select a).Take(1).First(); if (actividad.fecha_final.AddHours(1) > DateTime.Now.AddHours(1)) { FailureText.Text = "No puede eliminar una matricula si la actividad ya se realizo"; } db.Matriculas.Remove(matriculaAEliminar); db.SaveChanges(); Response.Redirect("~/PaginasEstudiante/Actividades/MisActividades"); }
public void Post([FromBody] UserEntity value) { using (var modelDatabase = new ModelDatabase()) { modelDatabase.Users.Add(value); modelDatabase.SaveChanges(); } }
private void AsignarseConTraslapes() { ModelDatabase db = new ModelDatabase(); int idUsuario = Int32.Parse(Request.Cookies["usuario"].Values["id_usuario"]); int idCurso = Int32.Parse(Request.QueryString["id_curso"]); IQueryable <Actividad> actividadesAMatricular = (from a in db.Actividads where a.curso_id_curso == idCurso select a); foreach (Actividad actividadAMatricular in actividadesAMatricular) { Matricula matricula = new Matricula() { asistencia = Matricula.TipoDeAsistencia.Ausente, usuario_estudiante = idUsuario, actividad_id_actividad = actividadAMatricular.id_actividad }; db.Matriculas.Add(matricula); } db.SaveChanges(); Response.Redirect("~/PaginasEstudiante/Cursos/MisCursos"); }
public void Delete(UserBasedProxy basedProxy) { var foundUser = ModelDatabase.GetUser(basedProxy); ModelDatabase.Users.Remove(foundUser); ModelDatabase.SaveChanges(); }
public void Edit(DisciplineExtendedProxy oldExtendedProxy, DisciplineExtendedProxy newExtendedProxy) { var foundDiscipline = ModelDatabase.GetDiscipline(oldExtendedProxy); var newGroupDiscipline = ModelDatabase.GetGroup(newExtendedProxy.GroupName); foundDiscipline.DisciplineName = newExtendedProxy.DisciplineName; foundDiscipline.TotalHours = newExtendedProxy.TotalHours; foundDiscipline.ClassHours = newExtendedProxy.ClassHours; if (foundDiscipline.ControlType != newExtendedProxy.ControlType) { foreach (var assessmentByDiscipline in ModelDatabase.AssessmentByDisciplines.Where(a => a.DisciplineId == foundDiscipline.DisciplineId)) { assessmentByDiscipline.Assessment = (int)Assessment.None; } foundDiscipline.ControlType = newExtendedProxy.ControlType; } if (foundDiscipline.GroupId != newGroupDiscipline.GroupId) { DeleteAssessmentByDisciplines(assessmentByDiscipline => assessmentByDiscipline.DisciplineId == foundDiscipline.DisciplineId); ModelDatabase.AssessmentByDisciplines.AddRange( newGroupDiscipline.Students.Select(student => new AssessmentByDiscipline { Student = student, Discipline = foundDiscipline, Group = newGroupDiscipline, Assessment = (int)Assessment.None })); foundDiscipline.Group = newGroupDiscipline; } ModelDatabase.SaveChanges(); }
public void Edit(StudentExtendedProxy oldExtendedProxy, StudentExtendedProxy newExtendedProxy) { var foundStudent = ModelDatabase.GetStudent(oldExtendedProxy); foundStudent.FirstName = newExtendedProxy.FirstName; foundStudent.SecondName = newExtendedProxy.SecondName; foundStudent.ThirdName = newExtendedProxy.ThirdName; foundStudent.DateOfBirth = newExtendedProxy.DateOfBirth; foundStudent.PreviousEducationName = newExtendedProxy.PreviousEducationName; foundStudent.PreviousEducationYear = newExtendedProxy.PreviousEducationYear; foundStudent.EnrollmentName = newExtendedProxy.EnrollmentName; foundStudent.EnrollmentYear = newExtendedProxy.EnrollmentYear; foundStudent.ExpulsionName = newExtendedProxy.ExpulsionName; foundStudent.ExpulsionYear = newExtendedProxy.ExpulsionYear; foundStudent.ExpulsionOrderDate = newExtendedProxy.ExpulsionOrderDate; foundStudent.ExpulsionOrderNumber = newExtendedProxy.ExpulsionOrderNumber; foundStudent.DiplomaTopic = newExtendedProxy.DiplomaTopic; foundStudent.DiplomaAssessment = (int)newExtendedProxy.DiplomaAssessment; foundStudent.ProtectionDate = newExtendedProxy.ProtectionDate; foundStudent.ProtocolNumber = newExtendedProxy.ProtocolNumber; foundStudent.RegistrationNumber = newExtendedProxy.RegistrationNumber; foundStudent.RegistrationDate = newExtendedProxy.RegistrationDate; foundStudent.AssessmentByDisciplines.ForEach(assessmentByDiscipline => assessmentByDiscipline.Assessment = (int)newExtendedProxy.AssessmentByDisciplines.First(a => a.NameOfDiscipline == assessmentByDiscipline.Discipline.DisciplineName) .Assessment); ModelDatabase.SaveChanges(); }
protected void Save_Click(object sender, EventArgs e) { int idUsuario = Int32.Parse(Request.Cookies.Get("usuario").Values["id_usuario"]); string imgPath = SubirImage(); if (imgPath == "error") { FailureText.Text = "Imagen no valida"; } Carta carta = new Carta() { asunto = txbAsunto.Text, contenido = txbContenido.Text, imagen = "~/" + imgPath, usuario_instructor = idUsuario }; ModelDatabase db = new ModelDatabase(); db.Cartas.Add(carta); db.SaveChanges(); Response.Redirect("~/PaginasInstructor/MisCartas"); }
private void UpdateCarta() { ModelDatabase db = new ModelDatabase(); int idC; bool b = Int32.TryParse(Request.QueryString["idCarta"], out idC); if (!b) { idC = 02; } Carta cart = (from c in db.Cartas where c.id_carta == idC select c).Take(1).First(); cart.asunto = txbAsunto.Text; cart.contenido = txbContenido.Text; cart.imagen = txbUrlImgen.Text; db.SaveChanges(); initCarta(); llenarControles(); }
protected void Save_Click(object sender, EventArgs e) { if (RevisarCampos()) { ModelDatabase db = new ModelDatabase(); db.Usuarios.Add(new Usuario { carne = txbCarnet.Text, contrasena = txbContraseña.Text, cui = txbCui.Text, nombre = txbNombre.Text, direccion = txbDireccion.Text, telefono = txbTelefono.Text, correo = txbCorreo.Text, fecha_de_nacimiento = new DateTime(Int32.Parse(txbAno.Text), Int32.Parse(txbMes.Text), Int32.Parse(txbDia.Text)), tipo = ListTipo.Text }); db.SaveChanges(); Usuario usuario = (from u in db.Usuarios where u.carne == txbCarnet.Text select u).SingleOrDefault(); initCookiesDeUsuario(usuario); Response.Redirect("~/"); } }
private void UpdateInsumo() { Decimal decimalPrecio; bool b = Decimal.TryParse(txbPrecio.Text, out decimalPrecio); if (!b) { FailureText.Text = "Precio no valido"; llenarControles(); return; } insumo.nombre = txbNombre.Text; insumo.descripcion = txbDescripcion.Text; insumo.estado = DropDownListEstado.SelectedValue; insumo.precio = decimalPrecio; if (RadioButtonSi.Checked) { insumo.disponible = true; } else { insumo.disponible = false; } db.SaveChanges(); Response.Redirect("~/PaginasOperador/Prestamos/Insumos"); }
protected void UpdateActividad() { ModelDatabase db = new ModelDatabase(); int idS; bool b = Int32.TryParse(Request.QueryString["idActividad"], out idS); if (!b) { idS = 02; } /*SELECT * * FROM Actividad * WHERE id_actividad=@IdActividad*/ Actividad activida = (from a in db.Actividads where a.id_actividad == idS select a).Take(1).First(); activida.cuestionario = txbCuestionario.Text; activida.presentacion = txbPresentacion.Text; db.SaveChanges(); initActividad(); llenarControles(); }
protected void Save_Click(object sender, EventArgs e) { int idUsuario = getIdUsuario(txbCarneEstudiante.Text); if (idUsuario == 0) { LiteralError.Text = "carne no valido"; return; } int year, month, day; bool b0, b1, b2; b0 = Int32.TryParse(txbAno.Text, out year); b1 = Int32.TryParse(txbMes.Text, out month); b2 = Int32.TryParse(txbDia.Text, out day); if (!b0 || !b1 || !b2) { LiteralError.Text = "Error en la fecha"; return; } int idInsumo; bool b3 = Int32.TryParse(txbIdInsumo.Text, out idInsumo); if (!b3) { LiteralError.Text = "Insumo no valido"; return; } ModelDatabase db = new ModelDatabase(); Prestamo prestamo = new Prestamo() { descripcion = txbDescripcion.Text, fecha = new DateTime(year, month, day), estado = ListEstado.SelectedValue, insumo_id_insumo = idInsumo, usuario_id_usuario = idUsuario }; db.Prestamoes.Add(prestamo); if (ListEstado.SelectedIndex == 0) { int idI = Int32.Parse(Request.QueryString["idInsumo"]); Insumo insumo = (from i in db.Insumoes where i.id_insumo == idI select i).Take(1).First(); insumo.disponible = false; } db.SaveChanges(); Response.Redirect("~/PaginasOperador/Prestamos/EditarInsumo?idInsumo=" + Request.QueryString["idInsumo"]); }
protected void Save_Click(object sender, EventArgs e) { Decimal d; bool b = Decimal.TryParse(txbCosto.Text, out d); if (!b) { LiteralError.Text = "Costo no valido"; return; } db = new ModelDatabase(); Incidente_insumo incidente_Insumo = new Incidente_insumo() { descripcion = txbDescripcion.Text, costo = d, estado = ListEstado.SelectedValue, activo = true, prestamo_id_prestamo = idPrestamo }; db.Incidente_insumo.Add(incidente_Insumo); db.SaveChanges(); Response.Redirect("~/PaginasOperador/Prestamos/EditarPrestamo?idPrestamo=" + idPrestamo); }
public void Edit(Guid oldTableId, Board newTable) { var board = ModelDatabase.GetBoard(oldTableId); board.Name = newTable.Name; ModelDatabase.SaveChanges(); }
public void Edit(Guid oldTableId, Comment newTable) { var comment = ModelDatabase.GetComment(oldTableId); comment.Content = newTable.Content; ModelDatabase.SaveChanges(); }
public void Edit(BoardId oldBoardId, Board newBoard) { var board = ModelDatabase.GetBoard(oldBoardId); board.Name = newBoard.Name; ModelDatabase.SaveChanges(); }
public void Edit(Guid oldTableId, Column newTable) { var column = ModelDatabase.GetColumn(oldTableId); column.Header = newTable.Header; column.Brush = newTable.Brush; ModelDatabase.SaveChanges(); }
public void Add(Board table) { ModelDatabase.Boards.Add(new BoardEntity { BoardId = Guid.NewGuid(), Name = table.Name }); ModelDatabase.SaveChanges(); }
public void Add(Board board) { ModelDatabase.Boards.Add(new BoardEntity { Id = Guid.NewGuid(), Name = board.Name }); ModelDatabase.SaveChanges(); }
public void Delete(CommentId commentId) { var comment = ModelDatabase.GetComment(commentId); RemoveSpaceForCommentIndex(comment.Index); DeleteComment(commentId); ModelDatabase.SaveChanges(); }
public void Delete(TaskId taskId) { var task = ModelDatabase.GetTask(taskId); RemoveSpaceForTaskIndex(task.Index); DeleteTask(taskId); ModelDatabase.SaveChanges(); }
public void Delete(ColumnId columnId) { var column = ModelDatabase.GetColumn(columnId); RemoveSpaceForColumnIndex(column.Index); DeleteColumn(columnId); ModelDatabase.SaveChanges(); }
public void Edit(UserId oldUserId, User newUser) { var user = ModelDatabase.GetUser(oldUserId); user.Login = newUser.Login; user.Password = newUser.Password; user.AccessType = newUser.AccessType; ModelDatabase.SaveChanges(); }
public void Add(UserExtendedProxy extendedProxy) { ModelDatabase.Users.Add(new User { Login = extendedProxy.Login, Password = extendedProxy.Password, AccessType = extendedProxy.AccessType }); ModelDatabase.SaveChanges(); }
public void Edit(UserExtendedProxy oldExtendedProxy, UserExtendedProxy newExtendedProxy) { var foundUser = ModelDatabase.GetUser(oldExtendedProxy); foundUser.Login = newExtendedProxy.Login; foundUser.Password = newExtendedProxy.Password; foundUser.AccessType = newExtendedProxy.AccessType; ModelDatabase.SaveChanges(); }
public void Edit(Guid oldTableId, User newTable) { var user = ModelDatabase.GetUser(oldTableId); user.Login = newTable.Login; user.Password = newTable.Password; user.AccessType = newTable.AccessType; ModelDatabase.SaveChanges(); }
public void Add(Column table) { ModelDatabase.Columns.Add(new ColumnEntity { ColumnId = Guid.NewGuid(), Header = table.Header, Brush = table.Brush, BoardId = ModelDatabase.GetBoard(table.BoardId).BoardId }); ModelDatabase.SaveChanges(); }
public void Add(User user) { ModelDatabase.Users.Add(new UserEntity { Id = Guid.NewGuid(), Login = user.Login, Password = user.Password, AccessType = user.AccessType }); ModelDatabase.SaveChanges(); }
public void Add(User table) { ModelDatabase.Users.Add(new UserEntity { UserId = Guid.NewGuid(), Login = table.Login, Password = table.Password, AccessType = table.AccessType }); ModelDatabase.SaveChanges(); }