public List <cp_trans_a_generar_x_FormaPago_OP_Info> Get_List_trans_a_generar_x_FormaPago_OP()
{
try
{
EntitiesCuentasxPagar context = new EntitiesCuentasxPagar();
List <cp_trans_a_generar_x_FormaPago_OP_Info> lst = new List <cp_trans_a_generar_x_FormaPago_OP_Info>();
var select = from q in context.cp_trans_a_generar_x_FormaPago_OP
select q;
cp_trans_a_generar_x_FormaPago_OP_Info Info;
foreach (var item in select)
{
Info = new cp_trans_a_generar_x_FormaPago_OP_Info();
Info.IdTipoTransaccion = item.IdTipoTransaccion;
Info.Descripcion = item.Descripcion;
lst.Add(Info);
}
return(lst);
}
catch (Exception ex)
{
string arreglo = ToString();
tb_sis_Log_Error_Vzen_Data oDataLog = new tb_sis_Log_Error_Vzen_Data();
tb_sis_Log_Error_Vzen_Info Log_Error_sis = new tb_sis_Log_Error_Vzen_Info(ex.ToString(), "", arreglo, "", "", "", "", "", DateTime.Now);
oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
mensaje = ex.InnerException + " " + ex.Message;
throw new Exception(ex.InnerException.ToString());
}
}
public Boolean ModificarDB(cp_trans_a_generar_x_FormaPago_OP_Info Info)
{
try
{
Boolean res = false;
EntitiesCuentasxPagar context = new EntitiesCuentasxPagar();
var address = context.cp_trans_a_generar_x_FormaPago_OP.FirstOrDefault(var => var.IdTipoTransaccion == Info.IdTipoTransaccion);
if (address != null)
{
address.Descripcion = Info.Descripcion;
context.SaveChanges();
res = true;
}
return(res);
}
catch (Exception ex)
{
string arreglo = ToString();
tb_sis_Log_Error_Vzen_Data oDataLog = new tb_sis_Log_Error_Vzen_Data();
tb_sis_Log_Error_Vzen_Info Log_Error_sis = new tb_sis_Log_Error_Vzen_Info(ex.ToString(), "", arreglo, "", "", "", "", "", DateTime.Now);
oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
mensaje = ex.ToString() + " " + ex.Message;
throw new Exception(ex.ToString());
}
}
public Boolean ModificarDB(cp_trans_a_generar_x_FormaPago_OP_Info Info)
{
try
{
return(data.ModificarDB(Info));
}
catch (Exception ex)
{
Core.Erp.Info.Log_Exception.LoggingManager.Logger.Log(Core.Erp.Info.Log_Exception.LoggingCategory.Error, ex.Message);
throw new Core.Erp.Info.Log_Exception.DalException(string.Format("", "ModificarDB", ex.Message), ex)
{
EntityType = typeof(cp_trans_a_generar_x_FormaPago_OP_Bus)
};
}
}
private void gridViewTransaccion_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
try
{
// borrarChekgridTransaccion();
// gridViewTransaccion.SetFocusedRowCellValue(colcheckTransaccion, true);
//gridViewTransaccion.SetRowCellValue(e.FocusedRowHandle, colCheckForma, true);
cp_trans_a_generar_x_FormaPago_OP_Info data = (cp_trans_a_generar_x_FormaPago_OP_Info)gridViewTransaccion.GetRow(e.FocusedRowHandle);
if (e.FocusedRowHandle != BindingList_TipoTransac.Count - 1)
{
colIdTipoTransaccion1.OptionsColumn.AllowEdit = false;
var info = BindingList_TipoTransac.Last();
if ((info.IdTipoTransaccion == "" || info.Descripcion == "" || info.IdTipoTransaccion == null || info.Descripcion == null))
{
BindingList_TipoTransac.Remove(info); bandtransac = 0;
}
}
else
{
if (BindingList_TipoTransac.Last().IdTipoTransaccion == "" || BindingList_TipoTransac.Last().IdTipoTransaccion == null)
{
colIdTipoTransaccion1.OptionsColumn.AllowEdit = true;
gridViewTransaccion.FocusedColumn = gridViewTipoOrden_x_Empresa.VisibleColumns[0];
gridViewTransaccion.ShowEditor();
gridViewTransaccion.GetShowEditorMode();
}
}
gridControlTransaccion.Update();
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public Boolean GuardarDB(cp_trans_a_generar_x_FormaPago_OP_Info Info)
{
try
{
EntitiesCuentasxPagar context = new EntitiesCuentasxPagar();
var address = new cp_trans_a_generar_x_FormaPago_OP();
address.Descripcion = Info.Descripcion;
address.IdTipoTransaccion = Info.IdTipoTransaccion;
context.cp_trans_a_generar_x_FormaPago_OP.Add(address);
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
string arreglo = ToString();
tb_sis_Log_Error_Vzen_Data oDataLog = new tb_sis_Log_Error_Vzen_Data();
tb_sis_Log_Error_Vzen_Info Log_Error_sis = new tb_sis_Log_Error_Vzen_Info(ex.ToString(), "", arreglo, "", "", "", "", "", DateTime.Now);
oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
mensaje = ex.InnerException + " " + ex.Message;
throw new Exception(ex.InnerException.ToString());
}
}
private void btnNuevoTransaccion_Click(object sender, EventArgs e)
{
try
{
if (BindingList_TipoTransac.Count > 0)
{
var temp = (cp_trans_a_generar_x_FormaPago_OP_Info)gridViewTransaccion.GetRow(gridViewTransaccion.RowCount - 1);
if (temp.IdTipoTransaccion != "" && temp.Descripcion != "" && temp.IdTipoTransaccion != null && temp.Descripcion != null)
{
Info_TipoTransac = new cp_trans_a_generar_x_FormaPago_OP_Info();
//Info_TipoTransac.IdTipoTransaccion = "";
Info_TipoTransac.Descripcion = "";
BindingList_TipoTransac.Add(Info_TipoTransac);
bandtransac = 1;
gridControlTransaccion.Refresh();
}
}
else
{
colIdTipoTransaccion.OptionsColumn.AllowEdit = true;
gridViewTransaccion.AddNewRow();
BindingList_TipoTransac = new BindingList <cp_trans_a_generar_x_FormaPago_OP_Info>();
bandtransac = 1;
Info_TipoTransac.IdTipoTransaccion = "";
Info_TipoTransac.Descripcion = "";
BindingList_TipoTransac.Add(Info_TipoTransac);
gridControlTransaccion.Refresh();
}
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public cp_trans_a_generar_x_FormaPago_OP_Info Get_Info_trans_a_generar_x_FormaPago_OP(string IdTipoTransaccion)
{
try
{
EntitiesCuentasxPagar context = new EntitiesCuentasxPagar();
cp_trans_a_generar_x_FormaPago_OP_Info Info = new cp_trans_a_generar_x_FormaPago_OP_Info();
var address = context.cp_trans_a_generar_x_FormaPago_OP.FirstOrDefault(var => var.IdTipoTransaccion == IdTipoTransaccion);
if (address != null)
{
Info.IdTipoTransaccion = address.IdTipoTransaccion;
Info.Descripcion = address.Descripcion;
}
return(Info);
}
catch (Exception ex)
{
string arreglo = ToString();
tb_sis_Log_Error_Vzen_Data oDataLog = new tb_sis_Log_Error_Vzen_Data();
tb_sis_Log_Error_Vzen_Info Log_Error_sis = new tb_sis_Log_Error_Vzen_Info(ex.ToString(), "", arreglo, "", "", "", "", "", DateTime.Now);
oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
mensaje = ex.ToString() + " " + ex.Message;
throw new Exception(ex.ToString());
}
}
