public bool guardarDB(tb_transportista_Info info) { try { using (Entities_general Context = new Entities_general()) { tb_transportista Entity = new tb_transportista { IdEmpresa = info.IdEmpresa, IdTransportista = info.IdTransportista = get_id(info.IdEmpresa), Cedula = info.Cedula, Nombre = info.Nombre, Estado = info.Estado = "A", Placa = info.Placa }; Context.tb_transportista.Add(Entity); Context.SaveChanges(); } return(true); } catch (Exception) { throw; } }
public tb_transportista_Info get_info(int IdEmpresa, decimal IdTransportista) { try { tb_transportista_Info info = new tb_transportista_Info(); using (Entities_general Context = new Entities_general()) { tb_transportista Entity = Context.tb_transportista.FirstOrDefault(q => q.IdEmpresa == IdEmpresa && q.IdTransportista == IdTransportista); if (Entity == null) { return(null); } info = new tb_transportista_Info { IdEmpresa = Entity.IdEmpresa, IdTransportista = Entity.IdTransportista, Cedula = Entity.Cedula, Nombre = Entity.Nombre, Estado = Entity.Estado, Placa = Entity.Placa }; } return(info); } catch (Exception) { throw; } }
public bool anularDB(tb_transportista_Info info) { try { using (Entities_general Context = new Entities_general()) { tb_transportista Entity = Context.tb_transportista.FirstOrDefault(q => q.IdEmpresa == info.IdEmpresa && q.IdTransportista == info.IdTransportista); if (Entity == null) { return(false); } Entity.Estado = info.Estado = "I"; Context.SaveChanges(); } return(true); } catch (Exception) { throw; } }
public bool modificarDB(tb_transportista_Info info) { try { using (Entities_general Context = new Entities_general()) { tb_transportista Entity = Context.tb_transportista.FirstOrDefault(q => q.IdEmpresa == info.IdEmpresa && q.IdTransportista == info.IdTransportista); if (Entity == null) { return(false); } Entity.Cedula = info.Cedula; Entity.Nombre = info.Nombre; Entity.Placa = info.Placa; Context.SaveChanges(); } return(true); } catch (Exception) { throw; } }
public Boolean GuardarDB(tb_transportista_Info Info, ref decimal IdTransportista) { try { using (EntitiesGeneral oEnti = new EntitiesGeneral()) { var consulta = from q in oEnti.tb_transportista where q.IdEmpresa == Info.IdEmpresa && q.IdTransportista == Info.IdTransportista select q; if (consulta.ToList().Count == 0) { var registo = new tb_transportista(); registo.IdEmpresa = Info.IdEmpresa; registo.IdTransportista = Info.IdTransportista = IdTransportista = GetIdTransportista(Info.IdEmpresa); registo.Nombre = Info.Nombre; registo.Cedula = Info.Cedula; registo.Estado = Info.Estado; registo.Placa = Info.Placa; oEnti.tb_transportista.Add(registo); oEnti.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.ToString() + " " + ex.Message; throw new Exception(ex.ToString()); } }