public GateTerminalListEntityDC GetAllGateTerminalByAccountID(Guid AccountID, string Search, int PageIndex, int PageSize) { GateTerminalListEntityDC MemberListEntityDC = new GateTerminalListEntityDC(); GateTerminalsServiceSoapClient membersrv = new GateTerminalsServiceSoapClient(); return(membersrv.GetAllGateTerminalByID(AccountID.ToString(), Search, PageIndex, PageSize)); }
public GateTerminalListEntityDC GetAllGateTerminal(Guid AcctID, string Search, int PageIndex, int PageSize, out int Count) { GateTerminalListEntityDC productResponse = new GateTerminalListEntityDC(); GateTerminalEntityDC member = new GateTerminalEntityDC(); GateTerminalDAL memberDAL = new GateTerminalDAL(); productResponse = memberDAL.GetAllGateTerminal(AcctID, Search, PageIndex, PageSize, out Count); return(productResponse); }
public GateTerminalListEntityDC GetAllGateTerminalByID(string AccountID, string Search, int PageIndex, int PageSize, out int count) { Guid AcctID = AccountID.ToGuid(); GateTerminalManager member = new GateTerminalManager(); GateTerminalListEntityDC ListAccount = new GateTerminalListEntityDC(); ListAccount = member.GetAllGateTerminal(AcctID, Search, PageIndex, PageSize, out count); return(ListAccount); }
public ActionResult List(Guid AccountID, string Search, int PageIndex, int PageSize) { string Count = ""; string roleid = null; GateTerminalBLL EmployeeBLL = new GateTerminalBLL(); GateTerminalListEntityDC data = new GateTerminalListEntityDC(); data = EmployeeBLL.GetAllGateTerminalByAccountID(AccountID, Search, PageIndex, PageSize); Dictionary <string, object> retData = new Dictionary <string, object>(); retData.Add("data", data); retData.Add("total", Count); return(Json(retData, JsonRequestBehavior.AllowGet)); }
public ActionResult GateTerminalList(Guid AccountID, string Search, int PageIndex, int PageSize) { string Count = ""; GateTerminalBLL AccountBLL = new GateTerminalBLL(); GateTerminalListEntityDC data = new GateTerminalListEntityDC(); GlobalModel global = new GlobalModel(); string companyid = null; if (global.SelectUserRoleID != "1") { companyid = global.Company; } data = AccountBLL.GetAllGateTerminalByAccountID(AccountID, Search, PageIndex, PageSize); Dictionary <string, object> retData = new Dictionary <string, object>(); // FOR RESPONSE retData.Add("data", data); retData.Add("total", Count); return(Json(retData, JsonRequestBehavior.AllowGet)); }
public GateTerminalListEntityDC GetAllGateTerminal(Guid AcctID, string Search, int PageIndex, int PageSize, out int Count) { GateTerminalListEntityDC Accounts = new GateTerminalListEntityDC(); List <GateTerminalEntityDC> AccountList = new List <GateTerminalEntityDC>(); using (DbConnection conn = DeLorean.CreateConnection()) { conn.Open(); try { using (DbCommand sprocCmd = conn.CreateCommand()) { sprocCmd.CommandType = CommandType.StoredProcedure; sprocCmd.CommandText = GET_ALL_GATETERMINAL_BY_ACCOUNT_ID; sprocCmd.Parameters.Add(new SqlParameter("@AccountID", AcctID.ToGuid()) { SqlDbType = SqlDbType.UniqueIdentifier }); sprocCmd.Parameters.Add(new SqlParameter("@Search", Search.ToStringDefault()) { SqlDbType = SqlDbType.NVarChar }); sprocCmd.Parameters.Add(new SqlParameter("@PageIndex", PageIndex.ToInt()) { SqlDbType = SqlDbType.Int }); sprocCmd.Parameters.Add(new SqlParameter("@PageSize", PageSize.ToInt()) { SqlDbType = SqlDbType.Int }); var CountResult = sprocCmd.CreateParameter(); CountResult.ParameterName = "@Count"; CountResult.Direction = ParameterDirection.Output; CountResult.DbType = DbType.Int32; sprocCmd.Parameters.Add(CountResult); using (IDataReader sprocReader = DeLorean.ExecuteReader(sprocCmd)) { while (sprocReader.Read()) { GateTerminalEntityDC Account = new GateTerminalEntityDC(); Account.GateTerminalID = sprocReader["GateTerminalID"].ToGuid(); Account.GateTerminalName = sprocReader["GateTerminalName"].ToStringDefault(); Account.AccountID = sprocReader["AccountID"].ToGuid(); Account.AccountName = sprocReader["AccountName"].ToStringDefault(); Account.GateTypeID = sprocReader["GateTypeID"].ToInt(); Account.GateTypeName = sprocReader["GateTypeName"].ToStringDefault(); Account.IsActive = sprocReader["IsActive"].ToBooleanDefault(); Account.CreatedBy = sprocReader["CreatedBy"].ToStringDefault(); Account.CreatedDate = sprocReader["CreatedDate"].ToStringDefault(); Account.UpdatedBy = sprocReader["UpdatedBy"].ToStringDefault(); Account.UpdatedDate = sprocReader["UpdatedDate"].ToStringDefault(); AccountList.Add(Account); } } Accounts.GateTerminalList = AccountList; Count = CountResult.Value.ToInt(); } } catch (Exception ex) { throw ex; } finally { if (conn != null) { conn.Close(); } } } return(Accounts); }