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