public AffiliationEntityDC SaveAffilation(AffiliationEntityDC AffiliationEntityDC) { //AccountListEntityDC MemberListEntityDC = new AccountListEntityDC(); AccountsServiceSoapClient membersrv = new AccountsServiceSoapClient(); return(membersrv.SaveAffilation(AffiliationEntityDC)); }
public AffiliationEntityDC SaveAffilation(AffiliationEntityDC AffiliationEntityDC) { AffiliationEntityDC productResponse = new AffiliationEntityDC(); // AccountEntityDC member = new AccountEntityDC(); AccountDAL memberDAL = new AccountDAL(); productResponse = memberDAL.SaveAffilation(AffiliationEntityDC); return(productResponse); }
public AffiliationEntityDC SaveAffilation(AffiliationEntityDC AffiliationEntityDC) { int Count = 0; AccountManager member = new AccountManager(); AffiliationEntityDC ListAccount = new AffiliationEntityDC(); ListAccount = member.SaveAffilation(AffiliationEntityDC); return(ListAccount); }
public AffiliationListEntityDC GetAllAffiliation() { AffiliationListEntityDC Accounts = new AffiliationListEntityDC(); List <AffiliationEntityDC> AccountList = new List <AffiliationEntityDC>(); using (DbConnection conn = Jaqen.CreateConnection()) { conn.Open(); try { using (DbCommand sprocCmd = conn.CreateCommand()) { sprocCmd.CommandType = CommandType.StoredProcedure; sprocCmd.CommandText = GET_ALL_AFFILATION; using (IDataReader sprocReader = Jaqen.ExecuteReader(sprocCmd)) { while (sprocReader.Read()) { AffiliationEntityDC Account = new AffiliationEntityDC(); Account.AffiliationID = sprocReader["AffiliationID"].ToInt(); Account.AffiliationName = sprocReader["AffiliationName"].ToStringDefault(); AccountList.Add(Account); } } Accounts.AffiliationList = AccountList; } } catch (Exception ex) { throw ex; } finally { if (conn != null) { conn.Close(); } } } return(Accounts); }
public AffiliationEntityDC SaveAffilation(AffiliationEntityDC parent) { int AffiliationID = 0; using (DbConnection conn = Jaqen.CreateConnection()) { conn.Open(); try { using (DbCommand sprocCmd = conn.CreateCommand()) { sprocCmd.CommandType = CommandType.StoredProcedure; sprocCmd.CommandText = SAVE_AFFILATION; sprocCmd.Parameters.Add(new SqlParameter("@AffiliationName", parent.AffiliationName.ToDatabaseObj()) { SqlDbType = SqlDbType.NVarChar }); using (IDataReader sprocReader = Jaqen.ExecuteReader(sprocCmd)) { while (sprocReader.Read()) { AffiliationID = sprocReader["AffiliationID"].ToInt(); // parent.AccountID = AccountID; } } } } catch (Exception ex) { throw ex; } finally { if (conn != null) { conn.Close(); } } } return(parent); }