public com_TerminoPago_Info get_info(int IdEmpresa, int IdTerminoPago) { try { com_TerminoPago_Info info = new com_TerminoPago_Info(); using (Entities_compras Context = new Entities_compras()) { com_TerminoPago Entity = Context.com_TerminoPago.Where(q => q.IdEmpresa == IdEmpresa && q.IdTerminoPago == IdTerminoPago).FirstOrDefault(); if (Entity == null) { return(null); } info = new com_TerminoPago_Info { IdEmpresa = Entity.IdEmpresa, IdTerminoPago = Entity.IdTerminoPago, Descripcion = Entity.Descripcion, Dias = Entity.Dias, Estado = Entity.Estado }; } return(info); } catch (Exception) { throw; } }
public bool anularDB(com_TerminoPago_Info info) { try { using (Entities_compras Context = new Entities_compras()) { com_TerminoPago Entity = Context.com_TerminoPago.Where(q => q.IdEmpresa == info.IdEmpresa && q.IdTerminoPago == info.IdTerminoPago).FirstOrDefault(); if (Entity == null) { return(false); } Entity.Estado = "I"; Entity.IdUsuarioUltAnu = info.IdUsuarioUltAnu; Entity.Fecha_UltAnu = DateTime.Now; Context.SaveChanges(); } return(true); } catch (Exception) { throw; } }
public bool modificarDB(com_TerminoPago_Info info) { try { using (Entities_compras Context = new Entities_compras()) { com_TerminoPago Entity = Context.com_TerminoPago.Where(q => q.IdEmpresa == info.IdEmpresa && q.IdTerminoPago == info.IdTerminoPago).FirstOrDefault(); if (Entity == null) { return(false); } Entity.Descripcion = info.Descripcion; Entity.Dias = info.Dias; Entity.IdUsuarioUltMod = info.IdUsuarioUltMod; Entity.FechaUltMod = DateTime.Now; Context.SaveChanges(); } return(true); } catch (Exception) { throw; } }
public bool guardarDB(com_TerminoPago_Info info) { try { using (Entities_compras Context = new Entities_compras()) { com_TerminoPago Entity = new com_TerminoPago { IdEmpresa = info.IdEmpresa, IdTerminoPago = info.IdTerminoPago = GetID(info.IdEmpresa), Descripcion = info.Descripcion, Dias = info.Dias, Estado = "A", IdUsuario = info.IdUsuario }; Context.com_TerminoPago.Add(Entity); Context.SaveChanges(); } return(true); } catch (Exception) { throw; } }
public Boolean GuardarDB(com_TerminoPago_Info Info) { try { using (EntitiesCompras Context = new EntitiesCompras()) { var Address = new com_TerminoPago(); if (Info.IdTerminoPago != "" && Info.IdTerminoPago != "0") { Address.IdTerminoPago = Info.IdTerminoPago; } else { Address.IdTerminoPago = Info.IdTerminoPago = GetId(); } Address.Descripcion = Info.Descripcion; Address.Estado = "A"; Address.Dias = Info.Dias; //Address.IdUsuario = Info.IdUsuario; //Address.nom_pc = Info.nom_pc; //Address.ip = Info.ip; Context.com_TerminoPago.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.ToString()); } }
public com_TerminoPago_Info get_info_termino_pago_x_proveedor(int IdEmpresa, int plazo, string signo) { try { com_TerminoPago_Info info = new com_TerminoPago_Info(); using (Entities_compras Context = new Entities_compras()) { com_TerminoPago Entity = null; if (signo == "=") { Entity = Context.com_TerminoPago.Where(q => q.IdEmpresa == IdEmpresa && q.Dias == plazo).FirstOrDefault(); } else { Entity = Context.com_TerminoPago.Where(q => q.IdEmpresa == IdEmpresa && q.Dias >= plazo).FirstOrDefault(); } if (Entity == null) { return(null); } info = new com_TerminoPago_Info { IdEmpresa = Entity.IdEmpresa, IdTerminoPago = Entity.IdTerminoPago, Descripcion = Entity.Descripcion, Dias = Entity.Dias, Estado = Entity.Estado }; } return(info); } catch (Exception) { throw; } }