public ro_Config_Param_contable_Info get_info(int IdEmpresa, int IdDivision, int IdArea, int IdDepartamento, string IdRubro)
{
try
{
ro_Config_Param_contable_Info info = new ro_Config_Param_contable_Info();
using (Entities_rrhh Context = new Entities_rrhh())
{
ro_Config_Param_contable Entity = Context.ro_Config_Param_contable.FirstOrDefault(q => q.IdEmpresa == IdEmpresa && q.IdDivision == IdDivision && q.IdArea == IdArea && q.IdDepartamento == IdDepartamento && q.IdRubro == IdRubro);
if (Entity == null)
{
return(null);
}
info = new ro_Config_Param_contable_Info
{
IdEmpresa = Entity.IdEmpresa,
IdDivision = Entity.IdDivision,
IdArea = Entity.IdArea,
IdDepartamento = Entity.IdDepartamento,
IdRubro = Entity.IdRubro,
IdCentroCosto = Entity.IdCentroCosto,
DebCre = Entity.DebCre,
IdCtaCble = Entity.IdCtaCble,
IdCtaCble_prov_credito = Entity.IdCtaCble_Haber
};
}
return(info);
}
catch (Exception)
{
throw;
}
}
public bool guardarDB(List <ro_Config_Param_contable_Info> info)
{
try
{
using (Entities_rrhh Context = new Entities_rrhh())
{
foreach (var item in info)
{
ro_Config_Param_contable Entity = new ro_Config_Param_contable
{
IdEmpresa = item.IdEmpresa,
IdDivision = item.IdDivision,
IdArea = item.IdArea,
IdDepartamento = item.IdDepartamento,
IdRubro = item.IdRubro,
IdCentroCosto = item.IdCentroCosto,
DebCre = item.DebCre,
IdCtaCble = item.IdCtaCble,
IdCtaCble_Haber = item.IdCtaCble_Haber
};
Context.ro_Config_Param_contable.Add(Entity);
}
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public bool guardarDB(List <ro_Config_Param_contable_Info> info)
{
try
{
using (Entities_rrhh Context = new Entities_rrhh())
{
foreach (var item in info)
{
if (item.IdCtaCble == "")
{
item.IdCtaCble = null;
}
if (item.IdCtaCble_prov_debito == "")
{
item.IdCtaCble_prov_debito = null;
}
if (item.rub_provision == false)
{
ro_Config_Param_contable Entity = new ro_Config_Param_contable
{
IdEmpresa = item.IdEmpresa,
IdDivision = item.IdDivision,
IdArea = item.IdArea,
IdDepartamento = item.IdDepartamento,
IdRubro = item.IdRubro,
IdCentroCosto = item.IdCentroCosto,
DebCre = item.DebCre,
IdCtaCble_Haber = item.IdCtaCble
};
Context.ro_Config_Param_contable.Add(Entity);
}
else
{
ro_Config_Param_contable Entity_ = new ro_Config_Param_contable
{
IdEmpresa = item.IdEmpresa,
IdDivision = item.IdDivision,
IdArea = item.IdArea,
IdDepartamento = item.IdDepartamento,
IdRubro = item.IdRubro,
IdCentroCosto = item.IdCentroCosto,
DebCre = item.DebCre,
IdCtaCble = item.IdCtaCble_prov_debito,
IdCtaCble_Haber = item.IdCtaCble_prov_credito
};
Context.ro_Config_Param_contable.Add(Entity_);
}
}
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public bool ModificarDB(ro_Config_Param_contable_Info info)
{
try
{
using (Entities_rrhh db = new Entities_rrhh())
{
if (info.IdCtaCble == "")
{
info.IdCtaCble = null;
}
if (info.IdCtaCble_prov_debito == "")
{
info.IdCtaCble_prov_debito = null;
}
if (info.IdEmpresa == 0)
{
return(false);
}
var entity = db.ro_Config_Param_contable.Where(q => q.IdEmpresa == info.IdEmpresa && q.IdDivision == info.IdDivision && q.IdArea == info.IdArea && q.IdDepartamento == info.IdDepartamento && q.IdRubro == info.IdRubro).FirstOrDefault();
if (entity != null)
{
entity.IdCtaCble = info.rub_provision == true ? info.IdCtaCble_prov_debito : null;
entity.IdCtaCble_Haber = info.rub_provision == true ? info.IdCtaCble_prov_credito : info.IdCtaCble;
}
else
{
entity = new ro_Config_Param_contable
{
IdEmpresa = info.IdEmpresa,
IdDivision = info.IdDivision,
IdArea = info.IdArea,
IdDepartamento = info.IdDepartamento,
IdRubro = info.IdRubro,
IdCentroCosto = info.IdCentroCosto,
DebCre = info.DebCre,
IdCtaCble = info.rub_provision == true ? info.IdCtaCble_prov_debito : null,
IdCtaCble_Haber = info.rub_provision == true ? info.IdCtaCble_prov_credito : info.IdCtaCble
};
db.ro_Config_Param_contable.Add(entity);
}
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public Boolean GrabarDB(List <ro_Config_Param_contable_Info> lista, ref string msg)
{
try
{
using (EntitiesRoles context = new EntitiesRoles())
{
foreach (var item in lista)
{
var _sel = from q in context.ro_Config_Param_contable
where q.IdEmpresa == item.IdEmpresa && q.IdDivision == item.IdDivision &&
q.IdArea == item.IdArea && q.IdDepartamento == item.IdDepartamento && q.IdRubro == item.IdRubro
select q;
if (_sel.Count() > 0)
{
var contact = context.ro_Config_Param_contable.First(
var => var.IdEmpresa == item.IdEmpresa &&
var.IdDivision == item.IdDivision && var.IdArea == item.IdArea && var.IdDepartamento == item.IdDepartamento &&
var.IdRubro == item.IdRubro);
contact.IdCtaCble = item.IdCtaCble;
contact.IdCentroCosto = item.IdCentroCosto;
contact.DebCre = item.DebCre;
contact.IdCtaCble_Haber = item.IdCtaCble_Haber;
context.SaveChanges();
}
else
{
ro_Config_Param_contable obj = new ro_Config_Param_contable();
obj.IdEmpresa = item.IdEmpresa;
obj.IdDivision = item.IdDivision;
obj.IdArea = item.IdArea;
obj.IdDepartamento = item.IdDepartamento;
obj.IdRubro = item.IdRubro;
obj.IdCtaCble = item.IdCtaCble;
obj.IdCentroCosto = item.IdCentroCosto;
obj.DebCre = item.DebCre;
obj.IdCtaCble_Haber = item.IdCtaCble_Haber;
context.ro_Config_Param_contable.Add(obj);
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);
mensaje = ex.InnerException + " " + ex.Message;
oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
throw new Exception(ex.InnerException.ToString());
}
}
