static bool valida_fechahora_sesion(DateTime ld_fecha, Fundraising_PTDM.FUNDRAISING_PT.Cajas lo_caja) { bool pass_fechahora = true; int total_minutes_new = (ld_fecha.Hour * 60) + ld_fecha.Minute; int time_new_sesion = Fundraising_PT.Properties.Settings.Default.time_new_sesion; XPView vhora_sesion = new XPView(XpoDefault.Session, typeof(Fundraising_PTDM.FUNDRAISING_PT.Sesiones)); vhora_sesion.AddProperty("fecha_hora", "fecha_hora", false, true, DevExpress.Xpo.SortDirection.Descending); vhora_sesion.Criteria = CriteriaOperator.Parse(string.Format("GetDay(fecha_hora) = {0} and GetMonth(fecha_hora) = {1} and GetYear(fecha_hora) = {2} and caja.oid = '{3}'", ld_fecha.Day, ld_fecha.Month, ld_fecha.Year, lo_caja.oid)); // if (vhora_sesion.Count > 0) { int time_diff = 0; int total_minutes_exis = 0; foreach (ViewRecord items in vhora_sesion) { DateTime fecha_hora = (DateTime)items["fecha_hora"]; total_minutes_exis = (fecha_hora.Hour * 60) + fecha_hora.Minute; time_diff = total_minutes_new - total_minutes_exis; if (time_diff < time_new_sesion) { pass_fechahora = false; break; } } } // vhora_sesion.Dispose(); // return(pass_fechahora); }
void textBox_buscacodigointegrado_Validated(object sender, EventArgs e) { bool sw1 = true; if (textBox_buscacodigointegrado.lValue.Trim() != string.Empty) { // XPView vbuscacodigo = new XPView(XpoDefault.Session, typeof(Fundraising_PTDM.FUNDRAISING_PT.Cajas)); vbuscacodigo.AddProperty("void", "oid", true, true, DevExpress.Xpo.SortDirection.None); vbuscacodigo.AddProperty("vcodigo_integrado", "Trim(ToStr(sucursal))+Trim(codigo)", true, true, DevExpress.Xpo.SortDirection.None); vbuscacodigo.CriteriaString = string.Format("Trim(ToStr(sucursal))+Trim(codigo) = '{0}'", textBox_buscacodigointegrado.lValue.Trim()); // int seek_position = -1; Guid v_oid = Guid.Empty; string v_codigo_integrado = string.Empty; foreach (ViewRecord item_buscacodigo in vbuscacodigo) { v_oid = (item_buscacodigo["void"] == null ? Guid.Empty : (Guid)item_buscacodigo["void"]); v_codigo_integrado = (item_buscacodigo["vcodigo_integrado"] == null ? string.Empty : (String)item_buscacodigo["vcodigo_integrado"]); seek_position = bindingSource1.Find("oid", v_oid); bindingSource1.Position = seek_position; } // textBox_buscacodigointegrado.Enabled = false; textBox_buscacodigointegrado.Visible = false; // if (vbuscacodigo.Count <= 0 | seek_position < 0) { MessageBox.Show("No se encontro ningun registro con el Código Integrado: " + textBox_buscacodigointegrado.lValue.Trim(), "Buscar Código Integrado.", MessageBoxButtons.OK, MessageBoxIcon.Information); sw1 = false; } // vbuscacodigo.Dispose(); // } else { textBox_buscacodigointegrado.Enabled = false; textBox_buscacodigointegrado.Visible = false; sw1 = false; } // textBox_buscacodigointegrado.lValue = string.Empty; textBox_buscacodigointegrado.textEdit1.Text = string.Empty; // }
public override void eliminar(object sender, EventArgs e) { if (this_primary_object_persistent_current != null) { try { this_primary_object_persistent_current.Reload(); // XPView vcuentas_bancarias = new XPView(XpoDefault.Session, typeof(Fundraising_PTDM.FUNDRAISING_PT.Bancos_Cuentas)); vcuentas_bancarias.AddProperty("void", "oid", true, true, DevExpress.Xpo.SortDirection.None); // XPView vcajas = new XPView(XpoDefault.Session, typeof(Fundraising_PTDM.FUNDRAISING_PT.Cajas)); vcajas.AddProperty("void", "oid", true, true, DevExpress.Xpo.SortDirection.None); // XPView vdepositos = new XPView(XpoDefault.Session, typeof(Fundraising_PTDM.FUNDRAISING_PT.Depositos_Bancarios)); vdepositos.AddProperty("void", "oid", true, true, DevExpress.Xpo.SortDirection.None); // XPView vpuntos_bancarios = new XPView(XpoDefault.Session, typeof(Fundraising_PTDM.FUNDRAISING_PT.Puntos_Bancarios)); vpuntos_bancarios.AddProperty("void", "oid", true, true, DevExpress.Xpo.SortDirection.None); // XPView vsesiones = new XPView(XpoDefault.Session, typeof(Fundraising_PTDM.FUNDRAISING_PT.Sesiones)); vsesiones.AddProperty("void", "oid", true, true, DevExpress.Xpo.SortDirection.None); // XPView vrecaudaciones = new XPView(XpoDefault.Session, typeof(Fundraising_PTDM.FUNDRAISING_PT.Recaudaciones)); vrecaudaciones.AddProperty("void", "oid", true, true, DevExpress.Xpo.SortDirection.None); // vcuentas_bancarias.Criteria = CriteriaOperator.Parse(string.Format("sucursal = {0}", ((Fundraising_PTDM.FUNDRAISING_PT.Sucursales)this_primary_object_persistent_current).codigo)); vcajas.Criteria = CriteriaOperator.Parse(string.Format("sucursal = {0}", ((Fundraising_PTDM.FUNDRAISING_PT.Sucursales)this_primary_object_persistent_current).codigo)); vdepositos.Criteria = CriteriaOperator.Parse(string.Format("sucursal = {0}", ((Fundraising_PTDM.FUNDRAISING_PT.Sucursales)this_primary_object_persistent_current).codigo)); vpuntos_bancarios.Criteria = CriteriaOperator.Parse(string.Format("sucursal = {0}", ((Fundraising_PTDM.FUNDRAISING_PT.Sucursales)this_primary_object_persistent_current).codigo)); vsesiones.Criteria = CriteriaOperator.Parse(string.Format("sucursal = {0}", ((Fundraising_PTDM.FUNDRAISING_PT.Sucursales)this_primary_object_persistent_current).codigo)); vrecaudaciones.Criteria = CriteriaOperator.Parse(string.Format("sucursal = {0}", ((Fundraising_PTDM.FUNDRAISING_PT.Sucursales)this_primary_object_persistent_current).codigo)); // int cantidad_asociaciones = vcuentas_bancarias.Count + vcajas.Count + vdepositos.Count + vpuntos_bancarios.Count + vsesiones.Count + vrecaudaciones.Count; // if (cantidad_asociaciones > 0 | ((Fundraising_PTDM.FUNDRAISING_PT.Sucursales)this_primary_object_persistent_current).codigo == Fundraising_PT.Properties.Settings.Default.sucursal) { if (MessageBox.Show("NO se puede Eliminar la sucursal porque existen asociaciones de datos con la sucursal seleccionada." + Environment.NewLine + "Desea cambiar el estatus de la sucursal a InActiva ?", "Eliminar Sucursal", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.OK) { ((Fundraising_PTDM.FUNDRAISING_PT.Bancos)this_primary_object_persistent_current).status = 2; this_primary_object_persistent_current.Save(); lookUp_status.gridLookUpEdit1.Refresh(); } } else { base.eliminar(sender, e); } // vcuentas_bancarias.Dispose(); vcajas.Dispose(); vdepositos.Dispose(); vpuntos_bancarios.Dispose(); vsesiones.Dispose(); vrecaudaciones.Dispose(); } catch (Exception) { Fundraising_PT.Clases.MsgBoxUtil.HackMessageBox("Data Reload", "Continuar", "Ignorar"); switch (MessageBox.Show("No se pudo leer los datos desde el servidor para el registro actual..." + Environment.NewLine + Environment.NewLine + "Posiblemente otro usuario lo elimino mientras usted lo tenia seleccionado para eliminarno !!!" + Environment.NewLine + Environment.NewLine + "Seleccione una opción para continuar ?" + Environment.NewLine + Environment.NewLine + "Data Reload : Ejecutar (Data Reload) Vuelve a cargar todas las colecciones de datos desde el servidor." + Environment.NewLine + Environment.NewLine + "Cancelar : Cancela la eliminación de datos del registro actual y salta al siguiente registro. " + Environment.NewLine + Environment.NewLine + "Ignorar : Ignora la lectura de los datos del registro desde el servidor y permanece sobre el.", "Data Reload (Eliminar)", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1)) { case DialogResult.Yes: this.datareload(); bindingSource1.MoveFirst(); this_primary_object_persistent_current = ((XPBaseObject)bindingSource1.Current); break; case DialogResult.No: if (bindingSource1.Count <= 0) { bindingSource1.MoveFirst(); this_primary_object_persistent_current = ((XPBaseObject)bindingSource1.Current); break; } if (bindingSource1.Count > 0 & bindingSource1.Position >= bindingSource1.Count) { bindingSource1.MovePrevious(); this_primary_object_persistent_current = ((XPBaseObject)bindingSource1.Current); break; } if (bindingSource1.Count > 0 & bindingSource1.Position == 0) { bindingSource1.MoveNext(); this_primary_object_persistent_current = ((XPBaseObject)bindingSource1.Current); break; } if (bindingSource1.Count > 0 & (bindingSource1.Position > 0 & bindingSource1.Position < bindingSource1.Count)) { bindingSource1.MoveNext(); this_primary_object_persistent_current = ((XPBaseObject)bindingSource1.Current); break; } else { bindingSource1.MoveFirst(); this_primary_object_persistent_current = ((XPBaseObject)bindingSource1.Current); break; } } Fundraising_PT.Clases.MsgBoxUtil.UnHackMessageBox(); } } }