public void Actualiza(ClientAddressBE pItem) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientAddress_Actualiza"); db.AddInParameter(dbCommand, "pIdClientAddress", DbType.Int32, pItem.IdClientAddress); db.AddInParameter(dbCommand, "pIdClient", DbType.Int32, pItem.IdClient); db.AddInParameter(dbCommand, "pSequence", DbType.Int32, pItem.Sequence); db.AddInParameter(dbCommand, "pIdType", DbType.Int32, pItem.IdType); db.AddInParameter(dbCommand, "pDestination", DbType.String, pItem.Destination); db.AddInParameter(dbCommand, "pCity", DbType.String, pItem.City); db.AddInParameter(dbCommand, "pState", DbType.String, pItem.State); db.AddInParameter(dbCommand, "pIdCountry", DbType.Int32, pItem.IdCountry); db.AddInParameter(dbCommand, "pPhone1", DbType.String, pItem.Phone1); db.AddInParameter(dbCommand, "pPhone2", DbType.String, pItem.Phone2); db.AddInParameter(dbCommand, "pFax", DbType.String, pItem.Fax); db.AddInParameter(dbCommand, "pEmail", DbType.String, pItem.Email); db.AddInParameter(dbCommand, "pWebPage", DbType.String, pItem.WebPage); db.AddInParameter(dbCommand, "pReference", DbType.String, pItem.Reference); db.AddInParameter(dbCommand, "pFlagState", DbType.Boolean, pItem.FlagState); db.AddInParameter(dbCommand, "pLogin", DbType.String, pItem.Login); db.AddInParameter(dbCommand, "pMachine", DbType.String, pItem.Machine); db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany); db.ExecuteNonQuery(dbCommand); }
public void Elimina(ClientAddressBE pItem) { try { ClientAddressDL ClientAddress = new ClientAddressDL(); ClientAddress.Elimina(pItem); } catch (Exception ex) { throw ex; } }
public void Actualiza(ClientAddressBE pItem) { try { ClientAddressDL ClientAddress = new ClientAddressDL(); ClientAddress.Actualiza(pItem); } catch (Exception ex) { throw ex; } }
public ClientAddressBE Selecciona(int IdClientAddress) { try { ClientAddressDL ClientAddress = new ClientAddressDL(); ClientAddressBE objEmp = ClientAddress.Selecciona(IdClientAddress); return(objEmp); } catch (Exception ex) { throw ex; } }
public void Elimina(ClientAddressBE pItem) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientAddress_Elimina"); db.AddInParameter(dbCommand, "pIdClientAddress", DbType.Int32, pItem.IdClientAddress); db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany); db.AddInParameter(dbCommand, "pLogin", DbType.String, pItem.Login); db.AddInParameter(dbCommand, "pMachine", DbType.String, pItem.Machine); db.ExecuteNonQuery(dbCommand); }
public List <ClientAddressBE> ListaTodosActivo(int IdClient) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientAddress_ListaTodosActivo"); db.AddInParameter(dbCommand, "pIdClient", DbType.Int32, IdClient); IDataReader reader = db.ExecuteReader(dbCommand); List <ClientAddressBE> ClientAddresslist = new List <ClientAddressBE>(); ClientAddressBE ClientAddress; while (reader.Read()) { ClientAddress = new ClientAddressBE(); ClientAddress.IdCompany = Int32.Parse(reader["IdCompany"].ToString()); ClientAddress.IdClient = Int32.Parse(reader["IdClient"].ToString()); ClientAddress.IdClientAddress = Int32.Parse(reader["idClientAddress"].ToString()); ClientAddress.Sequence = Int32.Parse(reader["Sequence"].ToString()); ClientAddress.IdType = Int32.Parse(reader["IdType"].ToString()); ClientAddress.NameType = reader["NameType"].ToString(); ClientAddress.Destination = reader["Destination"].ToString(); ClientAddress.City = reader["City"].ToString(); ClientAddress.State = reader["State"].ToString(); ClientAddress.IdCountry = Int32.Parse(reader["IdCountry"].ToString()); ClientAddress.NameCountry = reader["NameCountry"].ToString(); ClientAddress.Phone1 = reader["Phone1"].ToString(); ClientAddress.Phone2 = reader["Phone2"].ToString(); ClientAddress.Fax = reader["Fax"].ToString(); ClientAddress.Email = reader["Email"].ToString(); ClientAddress.WebPage = reader["WebPage"].ToString(); ClientAddress.Reference = reader["Reference"].ToString(); ClientAddress.FlagState = Boolean.Parse(reader["FlagState"].ToString()); ClientAddress.TipoOper = 4; //CONSULTAR ClientAddresslist.Add(ClientAddress); } reader.Close(); reader.Dispose(); return(ClientAddresslist); }
public ClientAddressBE Selecciona(int IdClientAddress) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientAddress_Selecciona"); db.AddInParameter(dbCommand, "pidClientAddress", DbType.Int32, IdClientAddress); IDataReader reader = db.ExecuteReader(dbCommand); ClientAddressBE ClientAddress = null; while (reader.Read()) { ClientAddress = new ClientAddressBE(); ClientAddress.IdCompany = Int32.Parse(reader["IdCompany"].ToString()); ClientAddress.IdClient = Int32.Parse(reader["IdClient"].ToString()); ClientAddress.IdClientAddress = Int32.Parse(reader["idClientAddress"].ToString()); ClientAddress.Sequence = Int32.Parse(reader["Sequence"].ToString()); ClientAddress.IdType = Int32.Parse(reader["IdType"].ToString()); ClientAddress.NameType = reader["NameType"].ToString(); ClientAddress.Destination = reader["Destination"].ToString(); ClientAddress.City = reader["City"].ToString(); ClientAddress.State = reader["State"].ToString(); ClientAddress.IdCountry = Int32.Parse(reader["IdCountry"].ToString()); ClientAddress.NameCountry = reader["NameCountry"].ToString(); ClientAddress.Phone1 = reader["Phone1"].ToString(); ClientAddress.Phone2 = reader["Phone2"].ToString(); ClientAddress.Fax = reader["Fax"].ToString(); ClientAddress.Email = reader["Email"].ToString(); ClientAddress.WebPage = reader["WebPage"].ToString(); ClientAddress.Reference = reader["Reference"].ToString(); ClientAddress.FlagState = Boolean.Parse(reader["FlagState"].ToString()); } reader.Close(); reader.Dispose(); return(ClientAddress); }