private void ListartFrm_Load(object sender, EventArgs e)
{
L_ITEMS.Text = _controlador.TotItems;
DGV.DataSource = _controlador.Source;
DGV.Refresh();
printDialog1.Document = printDocument1;
}
private void AdministradorFrm_Load(object sender, EventArgs e)
{
DTP_DESDE.Value = _controlador.FechaDesde;
DTP_HASTA.Value = _controlador.FechaHasta;
TB_CADENA_BUS_PROV.Text = _controlador.Proveedor;
CB_SUCURSAL.DataSource = _controlador.SucursalSource;
CB_SUCURSAL.SelectedIndex = -1;
CB_TIPO_DOC.DataSource = _controlador.TipoDocSource;
CB_TIPO_DOC.SelectedIndex = -1;
L_TITULO.Text = _controlador.Titulo;
switch (_controlador.TipoAdministrador)
{
case enumerados.EnumTipoAdministrador.AdmDocumentos:
InicializarGrid_1();
break;
}
Actualizar();
DGV.DataSource = _controlador.ItemsSource;
DGV.Refresh();
DGV.Columns[0].Frozen = true;
DGV.Columns[1].Frozen = true;
DGV.Columns[2].Frozen = true;
DGV.Columns[3].Frozen = true;
}
protected void RecuperarInformacion(string id)
{
//Consulta para obtener información del becario
string sql = "SELECT CONCAT(I.apellidos, ', ', I.nombres) AS[Becario], N.nombre AS[Nivel], C.nombre AS[Carrera],"
+ " U.nombre AS[Universidad], P.nombre AS[Programa],"
+ " B.fechaInicio AS[InicioBeca], B.fechaFin AS[FinBeca] FROM Becario B"
+ " INNER JOIN ProgramaBecas P ON B.idPrograma = P.idPrograma"
+ " INNER JOIN Universidad U ON B.idUniversidad = U.idUniversidad"
+ " INNER JOIN Carrera C ON B.idCarrera = C.idCarrera"
+ " INNER JOIN NivelEducativo N ON B.idNivelEducativo = N.idNivelEducativo"
+ " INNER JOIN InformacionPersonal I ON B.idInformacion = I.idInformacion"
+ " WHERE B.idBecario = '" + id + "'";
SqlDataReader reader = DBConnection.GetData(sql);
reader.Read();
nombreB.InnerHtml = "Nombre: " + reader["Becario"];
nivelB.InnerHtml = "Nivel Educativo: " + reader["Nivel"];
carreraB.InnerHtml = "Carrera: " + reader["Carrera"];
universidadB.InnerHtml = "Universidad: " + reader["Universidad"];
programaB.InnerHtml = "Programa de Beca: " + reader["Programa"];
fechaInicioB.InnerHtml = "Inicio de Beca: " + String.Format("{0:yyyy/MM/dd}", reader["InicioBeca"]);
fechaFinB.InnerHtml = "Fin de Beca: " + String.Format("{0:yyyy/MM/dd}", reader["FinBeca"]);
reader.Close();
//Obtenemos información y la asociamos al datagridview
SqlDataSource1.SelectCommand = "SELECT TI.nombre AS[TipoIncidente], TI.descripcion AS[descripcion], BI.idBitacora, BI.fechaAplicacion, BI.descripcion AS[detalles] FROM BitacoraIncidentes BI"
+ " INNER JOIN TipoIncidente TI ON BI.idTipoIncidente = TI.idTipoIncidente"
+ " WHERE BI.idBecario = '" + id + "'";
DGV.DataBind();
}
private void frmTradeBook_Load(object sender, EventArgs e)
{
//if (Settings.Default.Window_LocationTBook != null)
//{
// this.Location = Settings.Default.Window_LocationTBook;
//}
//// Set window size
//if (Settings.Default.WindowS_izeTBook != null)
//{
// this.Size = Settings.Default.WindowS_izeTBook;
//}
var AbbA = frmTradeBook.LoadFormLocationAndSize(this);
this.Location = new Point(AbbA[0], AbbA[1]);
this.Size = new Size(AbbA[2], AbbA[3]);
this.FormClosing += new FormClosingEventHandler(SaveFormLocationAndSize);
load_data();
Type controlType = DGV.GetType();
PropertyInfo pi = controlType.GetProperty("DoubleBuffered", BindingFlags.Instance | BindingFlags.NonPublic);
pi.SetValue(DGV, true, null);
// DGV.Columns["LOGTIME"].SortMode = DataGridViewColumnSortMode.NotSortable;
profile_load();
}
private void fEditarAsiento_EditarOk(object sender, int e)
{
var it = (OOB.Contable.Asiento.Ficha)bs.Current;
var r01 = Globals.MyData.Asiento_GetById(e);
if (r01.Result == OOB.Resultado.EnumResult.isError)
{
Helpers.Msg.Error(r01.Mensaje);
return;
}
it.Id = r01.Entidad.Id;
it.Comprobante = r01.Entidad.Comprobante;
it.Detalle = r01.Entidad.Detalle;
it.FechaEmision = r01.Entidad.FechaEmision;
it.TipoAsiento = r01.Entidad.TipoAsiento;
it.EstaAnulado = r01.Entidad.EstaAnulado;
it.EstaProcesado = r01.Entidad.EstaProcesado;
it.AutoGenerado = r01.Entidad.AutoGenerado;
it.Importe = r01.Entidad.Importe;
it.TipoDocumento = r01.Entidad.TipoDocumento;
if (it.EstaProcesado == false)
{
L_PENDIENTE.Visible = true;
}
else
{
L_PENDIENTE.Visible = false;
}
DGV.Refresh();
}
private void RemisionFrm_Load(object sender, EventArgs e)
{
L_ITEMS.Text = _controlador.ItemEncontrados;
L_PROVEEDOR.Text = _controlador.Proveedor;
DGV.DataSource = _controlador.Source;
DGV.Refresh();
}
private void DGV_RowPrePaint(object sender, DataGridViewRowPrePaintEventArgs e)
{
try{
if (DGV.InvokeRequired)
{
DGV.Invoke(new On_DataPaintdDelegate(DGV_RowPrePaint), sender, e);
return;
}
if (DGV.Rows[e.RowIndex].Cells["Buy_SellIndicator"].Value.ToString() == "BUY")
{
// DGV.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Red;
DGV.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.Blue;
}
else
{
// DGV.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Blue;
DGV.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.Red;
}
}
catch (Exception ex)
{
MessageBox.Show("Trade Book - Funtion Name- toolStripButton1_Click " + ex.Message);
}
}
private void btnComprar_Click(object sender, EventArgs e)
{
DGV objDGV = new DGV();
Imprimir objImprimir = new Imprimir();
bool filaSeleccionada = objDGV.ValidarFilaSeleccionada(dgvProductos);
if (filaSeleccionada)
{
VentaDTO datosProducto = objDGV.ObtenerDatosSeleccionadosDGV(dgvProductos);
AñadirVenta(datosProducto);
string cMensaje = "Compra realizada con éxito";
objImprimir.ImprimirMensaje(cMensaje);
}
else
{
string cMensaje = "Por favor seleccione una fila";
objImprimir.ImprimirMensaje(cMensaje);
}
dgvProductos.ClearSelection();
dgvVentas.ClearSelection();
}
private void ImportarDoc()
{
_controlador.ImportarDoc();
ActualizarDatosTotales();
DGV.Refresh();
IniciarBusqueda();
}
public void ShowRoom()
{
string RoomStuts = "";
if (cmbStuts.SelectedIndex == 0)
{
RoomStuts = "0";
}
else if (cmbStuts.SelectedIndex == 1)
{
RoomStuts = "1";
}
else if (cmbStuts.SelectedIndex == 2)
{
RoomStuts = "2";
}
else if (cmbStuts.SelectedIndex == 3)
{
RoomStuts = "3";
}
SQL.str = "Select * from ViewCheckRoom where RoomStatus='" + RoomStuts + "'";
SQL.RunQuery(SQL.str);
DGV.DataSource = SQL.ds.Tables[0];
DGV.Refresh();
}
private void DGV_DragOver(object sender, DragEventArgs e)
{
var pt = DGV.PointToClient(new Point(e.X, e.Y));
var ht = DGV.HitTest(pt.X, pt.Y);
if ((0 <= ht.RowIndex) && (e.Data.GetData(typeof(DownloadRow)) is DownloadRow row) && (row.GetVisibleIndex() != ht.RowIndex))
{
e.Effect = e.AllowedEffect;
if (_DragOver_RowIndex != ht.RowIndex)
{
_DragOver_RowIndex = ht.RowIndex;
DGV.Invalidate();
}
ScrollIfNeed(in pt);
return;
}
e.Effect = DragDropEffects.None;
if (_DragOver_RowIndex.HasValue)
{
_DragOver_RowIndex = null;
DGV.Invalidate();
}
ScrollIfNeed(in pt);
}
private void moveDown()
{
if (DGV.RowCount > 0)
{
if (DGV.SelectedRows.Count > 0)
{
int rowCount = DGV.Rows.Count;
int index = DGV.SelectedCells[0].OwningRow.Index;
if (index == (rowCount - 2)) // include the header row
{
return;
}
DataGridViewRowCollection rows = DGV.Rows;
// remove the next row and add it in front of the selected row.
DataGridViewRow row = rows[index];
DataGridViewRow prevRow = rows[index + 1];
String rowDate = row.Cells[5].Value.ToString();
String prevRowDate = prevRow.Cells[5].Value.ToString();
row.Cells[5].Value = prevRowDate;
prevRow.Cells[5].Value = rowDate;
DataGridViewRow nextRow = rows[index + 1];
rows.Remove(nextRow);
nextRow.Frozen = false;
rows.Insert(index, nextRow);
DGV.ClearSelection();
DGV.Rows[index + 1].Selected = true;
}
else if (DGV.SelectedCells.Count == 1 && DGV.CurrentCell.RowIndex != DGV.Rows.Count - 2)
{
DGV.CurrentCell = DGV.Rows[DGV.CurrentCell.RowIndex + 1].Cells[DGV.CurrentCell.ColumnIndex];
}
}
}
private void LoadSchool()
{
try {
SQLConn.ConnOpen();
SQLConn.sqL = "Select id, address,phone,fax,email,website from school where id='" + cmbSchool.SelectedValue + "'";
SQLConn.cmd = new NpgsqlCommand(SQLConn.sqL, SQLConn.conn);
SQLConn.dr = SQLConn.cmd.ExecuteReader();
if (SQLConn.dr.Read() == true)
{
cmbSchool.SelectedValue = SQLConn.dr["id"].ToString();
txtAddress.Text = SQLConn.dr["id"].ToString();
txtPhone.Text = SQLConn.dr["phone"].ToString();
cmbEmail.Text = SQLConn.dr["email"].ToString();
txtWeb.Text = SQLConn.dr["website"].ToString();
DGV.Focus();
}
else
{
ResetAll();
}
}
catch (NpgsqlException ex) {
MessageBox.Show(ex.ToString());
}
}
private string PrepareXMLString()
{
string strXMLString = "";
int SrlNo = 1;
decimal Amount = 0;
strXMLString = "<NewDataSet>";
foreach (GridViewRow DGV in dgvBill.Rows)
{
if (DGV.RowType == DataControlRowType.DataRow)
{
TextBox txtAmount = (TextBox)DGV.FindControl("txtAmount");
Amount = (txtAmount.Text.Trim().Length > 0) ? Convert.ToDecimal(txtAmount.Text.Trim()) : 0;
if (Amount > 0)
{
strXMLString += "<TrnDebitNoteDetail";
strXMLString += " SrlNo = \"" + SrlNo.ToString() + "\"";
strXMLString += " PurchaseBillId_FK = \"" + dgvBill.DataKeys[DGV.RowIndex].Value.ToString() + "\"";
strXMLString += " Amount = \"" + Amount + "\"";
strXMLString += " />";
SrlNo += 1;
}
}
}
strXMLString += "</NewDataSet>";
return(strXMLString);
}
private void DGV_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
{
DGV.ClearSelection();
}
}
private string PrepareXMLString()
{
string strXMLString = "";
int SrlNo = 1;
string ByTo = "PAYMENT";
decimal DRAmount = 0;
strXMLString = "<NewDataSet>";
foreach (GridViewRow DGV in dgvFeesHead.Rows)
{
if (DGV.RowType == DataControlRowType.DataRow)
{
TextBox txtAmount = (TextBox)DGV.FindControl("txtAmount");
decimal Amount = (txtAmount.Text.Trim().Length > 0) ? Convert.ToDecimal(txtAmount.Text.Trim()) : 0;
if (Amount > 0)
{
strXMLString += "<TrnCashBankVoucherDetail";
strXMLString += " SrlNo = \"" + SrlNo.ToString() + "\"";
strXMLString += " ByTo = \"" + ByTo + "\"";
strXMLString += " LedgerID = \"" + dgvFeesHead.DataKeys[DGV.RowIndex].Values["AssestLedgerID_FK"].ToString() + "\"";
strXMLString += " DRAmount = \"" + DRAmount + "\"";
strXMLString += " CRAmount = \"" + Amount + "\"";
strXMLString += " />";
SrlNo += 1;
}
}
}
strXMLString += "</NewDataSet>";
return(strXMLString);
}
private void fEditar_AsientoDetalleOk(object sender, List <Detalle> e)
{
var ficha = (OOB.Contable.Asiento.Generar.Ficha)bs.Current;
var ln = new List <OOB.Contable.Asiento.Generar.FichaDetalle>();
int nr = 1;
foreach (var it in e)
{
var nit = new OOB.Contable.Asiento.Generar.FichaDetalle()
{
IdCta = it.Cta.Id,
CodigoCta = it.Codigo,
DescripcionCta = it.Descripcion,
Naturaleza = it.Cta.Naturaleza,
MontoDebe = it.Debe,
MontoHaber = it.Haber,
Renglon = nr,
Signo = ficha.Signo,
};
ln.Add(nit);
}
ficha.IsOk = true;
ficha.Detalles = ln;
DGV.Refresh();
Limpiar_AsientoDetalles();
ActualizarTotales();
}
private void RecuperarInformacion(string id)
{
SqlDataSource1.SelectCommand = "SELECT D.idDesembolso, D.fecha, D.monto, TD.nombre FROM Desembolso D "
+ " INNER JOIN TipoDesembolso TD ON D.idTipoDesembolso = TD.idTipoDesembolso INNER JOIN Ciclo C ON D.idCiclo = C.idCiclo"
+ " WHERE C.idBecario = '" + id + "' ORDER BY fecha DESC ";
DGV.DataBind();
}
void DGV_CurrentCellDirtyStateChanged(object sender, EventArgs e)
{
if (DGV.CurrentCell is DataGridViewCheckBoxCell && DGV.IsCurrentCellDirty)
{
DGV.CommitEdit(DataGridViewDataErrorContexts.Commit);
}
}
private void moveUp()
{
if (DGV.RowCount > 0)
{
if (DGV.SelectedRows.Count > 0)
{
int rowCount = DGV.Rows.Count;
int index = DGV.SelectedCells[0].OwningRow.Index;
if (index == 0)
{
return;
}
DataGridViewRowCollection rows = DGV.Rows;
// remove the previous row and add it behind the selected row.
DataGridViewRow row = rows[index];
DataGridViewRow prevRow = rows[index - 1];
String rowDate = row.Cells[5].Value.ToString();
String prevRowDate = prevRow.Cells[5].Value.ToString();
row.Cells[5].Value = prevRowDate;
prevRow.Cells[5].Value = rowDate;
rows.Remove(prevRow);
prevRow.Frozen = false;
rows.Insert(index, prevRow);
DGV.ClearSelection();
DGV.Rows[index - 1].Selected = true;
}
else if (DGV.SelectedCells.Count == 1 && DGV.CurrentCell.RowIndex != 0)
{
DGV.CurrentCell = DGV.Rows[DGV.CurrentCell.RowIndex - 1].Cells[DGV.CurrentCell.ColumnIndex];
}
}
}
private void AjusteNivelFrm_Load(object sender, EventArgs e)
{
Inicializar();
DGV.DataSource = _controlador.Lista;
DGV.Refresh();
L_ITEMS.Text = _controlador.Items;
}
public void ShowBooking()
{
SQL.str = "Select * from ViewRommCheckIn where where BookingStatus='1' and BookingID='" + txtBookingID.Text + "'";
SQL.RunQuery(SQL.str);
DGV.DataSource = SQL.ds.Tables[0];
DGV.Refresh();
}
private void txt_Search_KeyDown(object sender, KeyEventArgs e)
{
// Enter
if (e.KeyCode == Keys.Enter)
{
e.Handled = true;
if (DGV.CurrentCell == null)
{
return;
}
btn_OK_Click(null, null);
}
// UP
if (e.KeyCode == Keys.Up)
{
e.Handled = true;
DGV.Focus();
}
// Dowen
else if (e.KeyCode == Keys.Down)
{
e.Handled = true;
DGV.Focus();
SendKeys.Send("{DOWN}");
}
}
private void DGV_MouseClick(object sender, MouseEventArgs e)
{
if (e.Button == MouseButtons.Right)
{
int mousCol = DGV.HitTest(e.X, e.Y).ColumnIndex;
int mousRow = DGV.HitTest(e.X, e.Y).RowIndex;
if (mousCol == 5 && DGV.SelectedCells.Count == 1 && DGV.SelectedCells[0].ColumnIndex == 5 && DGV.SelectedCells[0].RowIndex == mousRow)
{
DateMenu.Show(Cursor.Position);
MouseX = e.X;
MouseY = e.Y;
MouseRow = DGV.HitTest(e.X, e.Y).RowIndex;
}
if (mousCol == -1 && DGV.SelectedRows.Count == 1 && DGV.SelectedRows[0].Index == mousRow)
{
menu.Show(Cursor.Position);
MouseX = e.X;
MouseY = e.Y;
MouseRow = DGV.HitTest(e.X, e.Y).RowIndex;
DGV.Rows[MouseRow].Selected = true;
}
if (mousCol == 0 && DGV.SelectedCells.Count == 1 && DGV.SelectedCells[0].ColumnIndex == 0 && DGV.SelectedCells[0].RowIndex == mousRow)
{
NameMenu.Show(Cursor.Position);
MouseX = e.X;
MouseY = e.Y;
MouseRow = DGV.HitTest(e.X, e.Y).RowIndex;
}
}
}
private void RecuperarInformacion(string id)
{
//Consulta para obtener información del becario
string sql = "SELECT CONCAT(I.apellidos, ', ', I.nombres) AS[Becario], N.nombre AS[Nivel], C.nombre AS[Carrera],"
+ " U.nombre AS[Universidad], P.nombre AS[Programa],"
+ " B.fechaInicio AS[InicioBeca], B.fechaFin AS[FinBeca] FROM Becario B"
+ " INNER JOIN ProgramaBecas P ON B.idPrograma = P.idPrograma"
+ " INNER JOIN Universidad U ON B.idUniversidad = U.idUniversidad"
+ " INNER JOIN Carrera C ON B.idCarrera = C.idCarrera"
+ " INNER JOIN NivelEducativo N ON B.idNivelEducativo = N.idNivelEducativo"
+ " INNER JOIN InformacionPersonal I ON B.idInformacion = I.idInformacion"
+ " WHERE B.idBecario = '" + id + "'";
SqlDataReader reader = DBConnection.GetData(sql);
reader.Read();
nombreB.InnerHtml = "Nombre: " + reader["Becario"];
nivelB.InnerHtml = "Nivel Educativo: " + reader["Nivel"];
carreraB.InnerHtml = "Carrera: " + reader["Carrera"];
universidadB.InnerHtml = "Universidad: " + reader["Universidad"];
programaB.InnerHtml = "Programa de Beca: " + reader["Programa"];
fechaInicioB.InnerHtml = "Inicio de Beca: " + String.Format("{0:yyyy/MM/dd}", reader["InicioBeca"]);
fechaFinB.InnerHtml = "Fin de Beca: " + String.Format("{0:yyyy/MM/dd}", reader["FinBeca"]);
reader.Close();
//Obtenemos información y la ponemos en datagridview
SqlDataSource1.SelectCommand = "SELECT anio AS[Anio], idCiclo AS [idCiclo], nCiclo AS [nCiclo], evidenciaNotas AS [Aprobado]"
+ " FROM Ciclo WHERE idBecario = '" + id + "'; ";
DGV.DataBind();
}
private void PrecioMayorFrm_Load(object sender, EventArgs e)
{
DGV.DataSource = _controlador.Source;
DGV.Focus();
DGV.Refresh();
L_PRODUCTO.Text = _controlador.Producto;
}
private void BuscarFrm_Load(object sender, EventArgs e)
{
TB_CADENA.Text = "";
DGV.DataSource = _controlador.Source;
DGV.Refresh();
L_ITEMS.Text = _controlador.Items;
}
private void DGV_MouseMove(object sender, MouseEventArgs e)
{
if (e.Button != MouseButtons.Left)
{
return;
}
var row = GetSelectedDownloadRow();
if (row == null)
{
return;
}
var ht = DGV.HitTest(e.X, e.Y);
if ((ht.RowIndex < 0) || (ht.ColumnIndex < 0))
{
return;
}
if (_DGV_MouseDown_HitTestInfo.Type != DataGridViewHitTestType.Cell)
{
return;
}
const int MOVE_DELTA = 5;
if (Math.Abs(_DGV_MouseDown_ButtonLeft_Location.X - e.X) < MOVE_DELTA &&
Math.Abs(_DGV_MouseDown_ButtonLeft_Location.Y - e.Y) < MOVE_DELTA)
{
return;
}
//-----------------------------------------------------//
_DragOver_RowIndex = null;
DGV.AllowDrop = true;
DGV.DragOver += DGV_DragOver;
DGV.DragDrop += DGV_DragDrop;
DGV.CellPainting += DGV_DragDrop_CellPainting;
try
{
var dragDropEffect = DGV.DoDragDrop(row, DragDropEffects.Move);
if (dragDropEffect == DragDropEffects.Move)
{
SelectDownloadRow(row);
}
else
{
DGV.Invalidate();
}
}
finally
{
DGV.DragOver -= DGV_DragOver;
DGV.DragDrop -= DGV_DragDrop;
DGV.CellPainting -= DGV_DragDrop_CellPainting;
DGV.AllowDrop = false;
}
}
private void FiltrarBusqueda()
{
BT_BUSCAR.Enabled = false;
_controlador.FiltrarBusqueda();
BT_BUSCAR.Enabled = true;
ActualizarBusqueda();
DGV.Focus();
}
private void ListaFrm_Load(object sender, EventArgs e)
{
DGV.DataSource = _controlador.Source;
DGV.Columns[3].Visible = _controlador.IsCantidadVisible;
DGV.Columns[4].Visible = _controlador.IsPrecioVisible;
DGV.Focus();
DGV.Refresh();
}
