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()); } }