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);
}
