private void GridConfig_CurrentCellEndEdit(object sender, Syncfusion.UI.Xaml.Grid.CurrentCellEndEditEventArgs e)
{
try
{
}
catch (Exception w)
{
MessageBox.Show("errro al editar:" + w);
}
}
/// <summary>
/// Method to handle end edit event for SfDataGrid.
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
private void OnSfGridCurrentCellEndEdit(object sender, Syncfusion.UI.Xaml.Grid.CurrentCellEndEditEventArgs args)
{
if (!isCurrentCellValueChanged)
{
return;
}
var rowIndex = args.RowColumnIndex.RowIndex;
var columnIndex = args.RowColumnIndex.ColumnIndex;
var range = sfGrid.CoveredCells.GetCoveredCellInfo(rowIndex, columnIndex);
sfGrid.RemoveRange(range);
isEditted = true;
sfGrid.GetVisualContainer().InvalidateMeasure();
}
private void DataGridCxC_CurrentCellEndEdit(object sender, Syncfusion.UI.Xaml.Grid.CurrentCellEndEditEventArgs e)
{
try
{
SfDataGrid grid = sender as SfDataGrid;
int columnindex = grid.ResolveToGridVisibleColumnIndex(e.RowColumnIndex.ColumnIndex);
var column = grid.Columns[columnindex];
if (column.MappingName == "cod_cta")
{
DataRowView row = (DataRowView)dataGridCxC.SelectedItems[0];
//string valueold = row["cod_cta"].ToString(); ;
if (GetCuenta(row["cod_cta"].ToString().Trim()) == false)
{
MessageBox.Show("error no existe la cuenta");
row["cod_cta"] = valueOld;
return;
}
if (GetExistenciaTabla(LB_nombreInf.Text.Trim(), LB_nombreCon.Text.Trim(), row["cod_cta"].ToString().Trim()) == true)
{
MessageBox.Show("error la cuenta ya existe en el informe y el concepto");
row["cod_cta"] = valueOld;
return;
}
string id = row["idrow"].ToString();
string cuenta = row["cod_cta"].ToString();
string query = "update NIRel_Niif set cod_cta='" + cuenta + "' where idrow='" + id + "' ";
if (SiaWin.Func.SqlCRUD(query, idemp) == true)
{
row["nom_cta"] = SiaWin.Func.cmp("comae_cta", "cod_cta", "nom_cta", Convert.ToInt32(cuenta), idemp);
}
}
}
catch (Exception w)
{
MessageBox.Show("error al editar!!@" + w);
}
}
private void GridConfig_CurrentCellEndEdit(object sender, Syncfusion.UI.Xaml.Grid.CurrentCellEndEditEventArgs e)
{
try
{
var reflector = this.GridConfig.View.GetPropertyAccessProvider();
var rowData = GridConfig.GetRecordAtRowIndex(e.RowColumnIndex.RowIndex);
string refer = reflector.GetValue(rowData, "cod_ref").ToString();
var func = refe(refer);
if (func.Item1)
{
if (DBNull.Value.Equals(reflector.GetValue(rowData, "can_rec")))
reflector.SetValue(rowData, "can_rec", 0);
if (DBNull.Value.Equals(reflector.GetValue(rowData, "cantidad")))
reflector.SetValue(rowData, "cantidad", 0);
if (DBNull.Value.Equals(reflector.GetValue(rowData, "cant_nr")))
reflector.SetValue(rowData, "cant_nr", 0);
if (DBNull.Value.Equals(reflector.GetValue(rowData, "obs")))
reflector.SetValue(rowData, "obs", "Ninguna");
if (DBNull.Value.Equals(reflector.GetValue(rowData, "r_h")))
reflector.SetValue(rowData, "r_h", 0);
if (DBNull.Value.Equals(reflector.GetValue(rowData, "r_r")))
reflector.SetValue(rowData, "r_r", 0);
if (DBNull.Value.Equals(reflector.GetValue(rowData, "r_t")))
reflector.SetValue(rowData, "r_t", 0);
if (DBNull.Value.Equals(reflector.GetValue(rowData, "r_o")))
reflector.SetValue(rowData, "r_o", 0);
GridConfig.UpdateDataRow(e.RowColumnIndex.RowIndex);
GridConfig.UpdateLayout();
GridConfig.Columns["cod_ref"].AllowEditing = true;
GridConfig.Columns["can_rec"].AllowEditing = true;
GridConfig.Columns["cantidad"].AllowEditing = true;
GridConfig.Columns["cant_nr"].AllowEditing = true;
GridConfig.Columns["obs"].AllowEditing = true;
GridConfig.Columns["r_h"].AllowEditing = true;
GridConfig.Columns["r_r"].AllowEditing = true;
GridConfig.Columns["r_t"].AllowEditing = true;
GridConfig.Columns["r_o"].AllowEditing = true;
}
else
{
reflector.SetValue(rowData, "cod_ref", "");
reflector.SetValue(rowData, "can_rec", 0);
reflector.SetValue(rowData, "cantidad", 0);
reflector.SetValue(rowData, "cant_nr", 0);
reflector.SetValue(rowData, "obs", "");
reflector.SetValue(rowData, "r_h", 0);
reflector.SetValue(rowData, "r_r", 0);
reflector.SetValue(rowData, "r_t", 0);
reflector.SetValue(rowData, "r_o", 0);
GridConfig.UpdateDataRow(e.RowColumnIndex.RowIndex);
GridConfig.UpdateLayout();
GridConfig.Columns["cod_ref"].AllowEditing = true;
GridConfig.Columns["can_rec"].AllowEditing = true;
GridConfig.Columns["cantidad"].AllowEditing = true;
GridConfig.Columns["cant_nr"].AllowEditing = true;
GridConfig.Columns["obs"].AllowEditing = true;
GridConfig.Columns["r_h"].AllowEditing = true;
GridConfig.Columns["r_r"].AllowEditing = true;
GridConfig.Columns["r_t"].AllowEditing = true;
GridConfig.Columns["r_o"].AllowEditing = true;
}
}
catch (Exception w)
{
SiaWin.Func.SiaExeptionGobal(w);
MessageBox.Show("error al editar:" + w);
}
}
private void GridConfig_CurrentCellEndEdit(object sender, Syncfusion.UI.Xaml.Grid.CurrentCellEndEditEventArgs e)
{
try
{
var reflector = this.GridConfig.View.GetPropertyAccessProvider();
//if (GridConfig.View.IsCurrentBeforeFirst == true)return;
if (Keyboard.IsKeyDown(Key.Up))
{
return;
}
if (Keyboard.IsKeyDown(Key.Right) || Keyboard.IsKeyDown(Key.Tab) || Keyboard.IsKeyDown(Key.Return) || Keyboard.IsKeyDown(Key.Enter))
{
if (GridConfig.View.IsCurrentBeforeFirst == true)
{
return;
}
}
var rowData = GridConfig.GetRecordAtRowIndex(e.RowColumnIndex.RowIndex);
if (DBNull.Value.Equals(reflector.GetValue(rowData, "cod_ref")))
{
return;
}
string refer = reflector.GetValue(rowData, "cod_ref").ToString();
var func = refe(refer);
if (func.Item1)
{
reflector.SetValue(rowData, "nom_ref", func.Item2.Rows[0]["nom_ref"].ToString().Trim()).ToString();
double getCant = 1;
if (DBNull.Value.Equals(reflector.GetValue(rowData, "cantidad")))
{
reflector.SetValue(rowData, "cantidad", 1);
}
getCant = Convert.ToDouble(reflector.GetValue(rowData, "cantidad"));
//if (getCant ==0) reflector.SetValue(rowData, "cantidad", 1);
double saldoin = Convert.ToDouble(SiaWin.Func.SaldoInv(func.Item2.Rows[0]["cod_ref"].ToString().Trim(), tx_bodega.Text, cod_empresa));
reflector.SetValue(rowData, "saldo", saldoin);
double fal = saldoin - getCant;
reflector.SetValue(rowData, "faltantes", fal >= 0 ? 0 : fal);
reflector.SetValue(rowData, "val_ref", Convert.ToDouble(func.Item2.Rows[0]["val_ref"].ToString()));
double sub = Convert.ToDouble(func.Item2.Rows[0]["val_ref"]) * getCant;
reflector.SetValue(rowData, "subtotal", sub);
GridConfig.UpdateDataRow(e.RowColumnIndex.RowIndex);
GridConfig.UpdateLayout();
GridConfig.Columns["nom_ref"].AllowEditing = false;
GridConfig.Columns["cantidad"].AllowEditing = true;
GridConfig.Columns["saldo"].AllowEditing = false;
GridConfig.Columns["faltantes"].AllowEditing = false;
GridConfig.Columns["val_ref"].AllowEditing = false;
GridConfig.Columns["subtotal"].AllowEditing = false;
updateTot();
return;
}
else
{
reflector.SetValue(rowData, "cod_ref", "");
reflector.SetValue(rowData, "nom_ref", "");
reflector.SetValue(rowData, "cantidad", 0);
reflector.SetValue(rowData, "saldo", 0);
reflector.SetValue(rowData, "faltantes", 0);
reflector.SetValue(rowData, "subtotal", 0);
GridConfig.UpdateDataRow(e.RowColumnIndex.RowIndex);
GridConfig.UpdateLayout();
GridConfig.Columns["nom_ref"].AllowEditing = false;
GridConfig.Columns["cantidad"].AllowEditing = true;
GridConfig.Columns["saldo"].AllowEditing = false;
GridConfig.Columns["faltantes"].AllowEditing = false;
GridConfig.Columns["val_ref"].AllowEditing = false;
GridConfig.Columns["subtotal"].AllowEditing = false;
updateTot();
return;
}
}
catch (Exception w)
{
SiaWin.Func.SiaExeptionGobal(w);
MessageBox.Show("error al editar:" + w);
}
}