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