public ClientContactBE Selecciona(int IdClientContact) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientContact_Selecciona"); db.AddInParameter(dbCommand, "pidClientContact", DbType.Int32, IdClientContact); IDataReader reader = db.ExecuteReader(dbCommand); ClientContactBE ClientContact = null; while (reader.Read()) { ClientContact = new ClientContactBE(); ClientContact.IdCompany = Int32.Parse(reader["IdCompany"].ToString()); ClientContact.IdClient = Int32.Parse(reader["IdClient"].ToString()); ClientContact.IdClientContact = Int32.Parse(reader["idClientContact"].ToString()); ClientContact.Name = reader["Name"].ToString(); ClientContact.FirtsName = reader["FirtsName"].ToString(); ClientContact.Company = reader["Company"].ToString(); ClientContact.Occupation = reader["Occupation"].ToString(); ClientContact.IdCountry = Int32.Parse(reader["IdCountry"].ToString()); ClientContact.NameCountry = reader["NameCountry"].ToString(); ClientContact.Phone1 = reader["Phone1"].ToString(); ClientContact.Phone2 = reader["Phone2"].ToString(); ClientContact.CelPhone = reader["CelPhone"].ToString(); ClientContact.Fax = reader["Fax"].ToString(); ClientContact.Email = reader["Email"].ToString(); ClientContact.InformationAdditional = reader["InformationAdditional"].ToString(); ClientContact.FlagState = Boolean.Parse(reader["FlagState"].ToString()); } reader.Close(); reader.Dispose(); return(ClientContact); }
public void Elimina(ClientContactBE pItem) { try { ClientContactDL ClientContact = new ClientContactDL(); ClientContact.Elimina(pItem); } catch (Exception ex) { throw ex; } }
public void Actualiza(ClientContactBE pItem) { try { ClientContactDL ClientContact = new ClientContactDL(); ClientContact.Actualiza(pItem); } catch (Exception ex) { throw ex; } }
public ClientContactBE Selecciona(int IdClientContact) { try { ClientContactDL ClientContact = new ClientContactDL(); ClientContactBE objEmp = ClientContact.Selecciona(IdClientContact); return(objEmp); } catch (Exception ex) { throw ex; } }
public void Elimina(ClientContactBE pItem) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientContact_Elimina"); db.AddInParameter(dbCommand, "pIdClientContact", DbType.Int32, pItem.IdClientContact); 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 void Actualiza(ClientContactBE pItem) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_ClientContact_Actualiza"); db.AddInParameter(dbCommand, "pIdClientContact", DbType.Int32, pItem.IdClientContact); db.AddInParameter(dbCommand, "pIdClient", DbType.Int32, pItem.IdClient); db.AddInParameter(dbCommand, "pName", DbType.String, pItem.Name); db.AddInParameter(dbCommand, "pFirtsName", DbType.String, pItem.FirtsName); db.AddInParameter(dbCommand, "pCompany", DbType.String, pItem.Company); db.AddInParameter(dbCommand, "pOccupation", DbType.String, pItem.Occupation); 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, "pCelPhone", DbType.String, pItem.CelPhone); db.AddInParameter(dbCommand, "pFax", DbType.String, pItem.Fax); db.AddInParameter(dbCommand, "pEmail", DbType.String, pItem.Email); db.AddInParameter(dbCommand, "pInformationAdditional", DbType.String, pItem.InformationAdditional); 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); }