private void DataSource_UpdatingOrInserting(object sender, EntityDataSourceChangingEventArgs e) { MetaTable childTable = ChildrenColumn.ChildTable; // Comments assume employee/territory for illustration, but the code is generic if (Mode == DataBoundControlMode.Edit) { ObjectContext.LoadProperty(e.Entity, Column.Name); } // Get the collection of territories for this employee dynamic entityList = Column.EntityTypeProperty.GetValue(e.Entity, null); // Go through all the territories (not just those for this employee) foreach (dynamic childEntity in childTable.GetQuery(e.Context)) { // Check if the employee currently has this territory bool isCurrentlyInList = ListContainsEntity(childTable, entityList, childEntity); // Find the checkbox for this territory, which gives us the new state string pkString = childTable.GetPrimaryKeyString(childEntity); ListItem listItem = CheckBoxList1.Items.FindByValue(pkString); if (listItem == null) { continue; } // If the states differs, make the appropriate add/remove change if (listItem.Selected) { if (!isCurrentlyInList) { entityList.Add(childEntity); } } else { if (isCurrentlyInList) { entityList.Remove(childEntity); } } } }
protected void Insert_fields(object sender, EntityDataSourceChangingEventArgs e) { YASA_PL.Standard_Files c = (YASA_PL.Standard_Files)e.Entity; if (c != null) { c.Date_created_modified = DateTime.Now; if (c.filePath != null) { c.File_extension = c.filePath.Substring(c.filePath.LastIndexOf(".") + 1).ToLower(); //add file size information String fileUrl = "~/standard_files/" + c.filePath; String path = Server.MapPath(fileUrl); System.IO.FileInfo fi = null; fi = new System.IO.FileInfo(path); c.File_size = Math.Round(Convert.ToDecimal(fi.Length / 1048576), 2); } } }
protected void Insert_fields(object sender, EntityDataSourceChangingEventArgs e) { YASA_PL.Quality_Instruction_Files c = (YASA_PL.Quality_Instruction_Files)e.Entity; if (c != null) { c.Date_created_modified = DateTime.Now; if (c.filePath != null) { c.File_extension = c.filePath.Substring(c.filePath.LastIndexOf(".") + 1).ToLower(); //add file size information String fileUrl = "~/quality_instruction_files/" + c.filePath; String path = Server.MapPath(fileUrl); System.IO.FileInfo fi = null; fi = new System.IO.FileInfo(path); c.File_size = fi.Length; } } }
protected void EntityDataSource1_Inserting(object sender, EntityDataSourceChangingEventArgs e) { using (PlanetWroxEntities myEntities = new PlanetWroxEntities()) { int photoAlbumId = Convert.ToInt32(Request.QueryString.Get("PhotoAlbumId")); Picture myPicture = (Picture)e.Entity; myPicture.PhotoAlbumId = photoAlbumId; // upload FileUpload FileUpload1 = (FileUpload)ListView1.InsertItem.FindControl("FileUpload1"); string virtualFolder = "~/GigPics/"; string physicalFolder = Server.MapPath(virtualFolder); string fileName = Guid.NewGuid().ToString(); string extension = System.IO.Path.GetExtension(FileUpload1.FileName); FileUpload1.SaveAs(System.IO.Path.Combine(physicalFolder, fileName + extension)); myPicture.ImageUrl = virtualFolder + fileName + extension; } }
protected void edsUsuario_Updating(object sender, EntityDataSourceChangingEventArgs e) { SISMed.Models.Usuario u = e.Entity as SISMed.Models.Usuario; using (var context = new SISMedEntities(e.Context.Connection as EntityConnection)) { var antigo = context.Pessoas.OfType <SISMed.Models.Usuario>().First(c => c.Id == u.Id); TextBox txbSenha = fvUsuario.FindControl("SenhaTextBox") as TextBox; if (string.IsNullOrWhiteSpace(txbSenha.Text)) { u.Senha = antigo.Senha; } else { u.Senha = Password.HashPassword(u.Senha); } } }
protected void Insert_fields(object sender, EntityDataSourceChangingEventArgs e) { YASA_PL.CNC_Program_Files c = (YASA_PL.CNC_Program_Files)e.Entity; if (c != null) { c.Date_created_modified = DateTime.Now; c.UserId = Convert.ToInt32(HttpContext.Current.User.Identity.Name); if (c.filePath != null) { c.File_extension = c.filePath.Substring(c.filePath.LastIndexOf(".") + 1).ToLower(); //add file size information String fileUrl = "~/cnc_program/" + c.filePath; String path = Server.MapPath(fileUrl); System.IO.FileInfo fi = null; fi = new System.IO.FileInfo(path); c.File_size = fi.Length; } } }
protected void Insert_fields(object sender, EntityDataSourceChangingEventArgs e) { YASA_PL.Standard_Files c = (YASA_PL.Standard_Files)e.Entity; if (c != null) { c.Date_created_modified = DateTime.Now; if (c.filePath != null) { c.File_extension = c.filePath.Substring(c.filePath.LastIndexOf(".") + 1).ToLower(); //add file size information String fileUrl = "~/standard_files/" + c.filePath; String path = Server.MapPath(fileUrl); System.IO.FileInfo fi = null; fi = new System.IO.FileInfo(path); c.File_size = Math.Round(Convert.ToDecimal(fi.Length / 1048576), 2); } Session["Record_Info"] = "Edycja pliku zakończona prawidłowo"; redirectlink = "~/StandardSet/Details.aspx?Id=" + c.StandardId; } }
protected void Insert_fields(object sender, EntityDataSourceChangingEventArgs e) { YASA_PL.Fixture_Document_File c = (YASA_PL.Fixture_Document_File)e.Entity; if (c != null) { c.Date_created_modified = DateTime.Now; if (c.filePath != null) { c.File_extension = c.filePath.Substring(c.filePath.LastIndexOf(".") + 1).ToLower(); //add file size information String fileUrl = "~/fixture_files/" + c.filePath; String path = Server.MapPath(fileUrl); System.IO.FileInfo fi = null; fi = new System.IO.FileInfo(path); c.File_size = fi.Length; } Session["Record_Info"] = "Edycja pliku zakończona poprawnie"; redirectlink = "~/FixtureSet/Details.aspx?Id=" + c.FixtureId; } }
protected void EntityDataSource3_Inserting(object sender, EntityDataSourceChangingEventArgs e) { //// Nueva entidad alums_asigs //var nuevo = e.Entity as alum_asig; //nuevo.id_alumno = Convert.ToInt32(DropDownList1.SelectedValue); //nuevo.id_asignatura = Convert.ToInt32(DropDownList2.SelectedValue); //nuevo.nota = 0.0F; //// Establecer las relaciones con idAlum e idAsig //int idAlum = Convert.ToInt32(DropDownList1.SelectedValue); //int idAsig = Convert.ToInt32(DropDownList2.SelectedValue); //// Establecer referencias //object alum; //e.Context.TryGetObjectByKey(new System.Data.EntityKey( // "bd_notasAlumnosEntities.alumnos", "id_alumno", idAlum), out alum); //nuevo.alumno = (alumno)alum; //object asig; //e.Context.TryGetObjectByKey(new System.Data.EntityKey( // "bd_notasAlumnosEntities.asignaturas", "id_asignatura", idAsig), out asig); //nuevo.asignatura = (asignatura)asig; }
protected void edsMovPorCuenta_Updating(object sender, EntityDataSourceChangingEventArgs e) { e.Cancel = true; var entidad = (DMovCtaxBco)e.Entity; var entidadBD = SrvLista.DMovCtaxBco(entidad.IdMovCtaxBco); e.Context.SaveChanges(); if (entidad.nImporte != entidadBD.nImporte || entidad.dFecOpe != entidadBD.dFecOpe) {//-------------------si cambia la fecha, utilizo la fecha menor (mas cerca al saldo inicial) //al cambiar la fecha, debo actualizar todos los saldos afectados a partir de la fecha menor var compararFechas = DateTime.Compare(entidadBD.dFecOpe.Value, entidad.dFecOpe.Value); var fechaOpeMenor = (compararFechas < 0) ? entidadBD.dFecOpe : entidad.dFecOpe; //0 > date1 es menor, 0 = iguales, 0 < date2 es menor //PD la fechaIng siempre sera desde la BD porque el entitydatasource me muestra null var ultiMovi = SrvLista.UltimoMovimientoPorFecha(entidadBD.IdCtaxBco, entidadBD.IdMovCtaxBco, fechaOpeMenor); decimal?saldoInicial = (ultiMovi == null) ? 0 : ultiMovi.nSalFin; //si no hay ultimovi entonces empezara de 0 SrvLista.ActualizarUltimosSaldos(entidadBD.IdCtaxBco, entidadBD.IdMovCtaxBco, fechaOpeMenor, saldoInicial); } }
protected void edsMudarSenha_Updating(object sender, EntityDataSourceChangingEventArgs e) { SISMed.Models.Usuario novo = e.Entity as SISMed.Models.Usuario; using (var context = new SISMedEntities(e.Context.Connection as EntityConnection)) { var antigo = context.Pessoas.OfType <SISMed.Models.Usuario>().First(c => c.Id == novo.Id); TextBox txbSenhaAtual = fvMudarSenha.FindControl("txbSenhaAtual") as TextBox; if (antigo.Senha == Password.HashPassword(txbSenhaAtual.Text)) { novo.Senha = Password.HashPassword(novo.Senha); Response.Redirect("./Default.aspx?successPassword=U2VuaGEgYWx0ZXJhZGEgY29tIHN1Y2Vzc28u"); } else { Response.Redirect("./Default.aspx?errorPassword=QSBzZW5oYSBhdHVhbCBlc3TDoSBpbmNvcnJldGEu"); e.Cancel = true; } } }
protected void CountriesDataSource_Deleting(object sender, EntityDataSourceChangingEventArgs e) { var editedCountry = (Data.Country)e.Entity; using (var context = new Data.WorldEntities()) { var editedCountryInDB = context.Countries .Include("Towns").FirstOrDefault(c => c.Id == editedCountry.Id); if (editedCountryInDB == null) { return; } context.Towns.RemoveRange(editedCountryInDB.Towns); editedCountryInDB.Languages.Clear(); context.SaveChanges(); } }
void DataSource_UpdatingOrInserting(object sender, EntityDataSourceChangingEventArgs e) { MetaTable childTable = ChildrenColumn.ChildTable; if (Mode == DataBoundControlMode.Edit) { ObjectContext.LoadProperty(e.Entity, Column.Name); } dynamic entityCollection = Column.EntityTypeProperty.GetValue(e.Entity, null); foreach (dynamic childEntity in childTable.GetQuery(e.Context)) { var isCurrentlyInList = ListContainsEntity(childTable, entityCollection, childEntity); string pkString = childTable.GetPrimaryKeyString(childEntity); ListItem listItem = CheckBoxList1.Items.FindByValue(pkString); if (listItem == null) { continue; } if (listItem.Selected) { if (!isCurrentlyInList) { entityCollection.Add(childEntity); } } else { if (isCurrentlyInList) { entityCollection.Remove(childEntity); } } } }
protected void edsUsuario_Inserting(object sender, EntityDataSourceChangingEventArgs e) { SISMed.Models.Usuario u = e.Entity as SISMed.Models.Usuario; u.Senha = Password.HashPassword(u.Senha); }
protected void edsConsulta_Inserting(object sender, EntityDataSourceChangingEventArgs e) { Consulta c = e.Entity as Consulta; c.DataHora = DateTime.Now; }
protected void PaymentDataSource_Inserting(object sender, EntityDataSourceChangingEventArgs e) { var newPmnt = (BAGA.Payment)e.Entity; newPmnt.ReservationID = Convert.ToInt32(ListBox1.SelectedValue); }
protected void TownsDataSource_Deleting(object sender, EntityDataSourceChangingEventArgs e) { }
protected void EntityDataSource1_Inserting(object sender, EntityDataSourceChangingEventArgs e) { TPhotoAlbum myPhotoAlbum = (TPhotoAlbum)e.Entity; myPhotoAlbum.strUserName = User.Identity.Name; }
protected void dsUsers_Deleting(object sender, EntityDataSourceChangingEventArgs e) { var it = e.Entity as DA.Users; BL.UserBL.RemoveUserRelationships(it.UserId); }
protected void EntityDataSource1_Updating(object sender, EntityDataSourceChangingEventArgs e) { }
protected void edsSolicitacoes_Inserting(object sender, EntityDataSourceChangingEventArgs e) { Solicitacao s = e.Entity as Solicitacao; s.DataHora = DateTime.Now; }