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