public AffiliationListEntityDC GetAllAffiliation()
{
AffiliationListEntityDC productResponse = new AffiliationListEntityDC();
// AccountEntityDC member = new AccountEntityDC();
AccountDAL memberDAL = new AccountDAL();
productResponse = memberDAL.GetAllAffiliation();
return(productResponse);
}
public AffiliationListEntityDC GetAllAffiliation()
{
int Count = 0;
AccountManager member = new AccountManager();
AffiliationListEntityDC ListAccount = new AffiliationListEntityDC();
ListAccount = member.GetAllAffiliation();
return(ListAccount);
}
public ActionResult GetAllAffiliation()
{
int Count = 0;
string roleid = null;
AccountBLL EmployeeBLL = new AccountBLL();
AffiliationListEntityDC data = new AffiliationListEntityDC();
data = EmployeeBLL.GetAllAffiliation();
Dictionary <string, object> retData = new Dictionary <string, object>();
retData.Add("data", data);
retData.Add("total", Count);
return(Json(retData, JsonRequestBehavior.AllowGet));
}
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);
}
