public static GatewayType GetByID(Guid id) { DbCommand cmd = SqlHelpers.CreateCommand(DataHelpers.ConnectionString, "dbo.ctx_GET_GATEWAY_TYPE"); cmd.AddInputParam("pGatewayTypeID", DbType.Guid, id); DataTable table = cmd.ExecuteSelectTable(); GatewayType type = new GatewayType(); if ((table != null) && (table.Rows.Count > 0)) { type = table.Rows[0].ToGatewayType(); } return type; }
public static GatewayType Save(GatewayType gatewayType) { DbCommand cmd = SqlHelpers.CreateCommand(DataHelpers.ConnectionString, "dbo.ctx_SAVE_GATEWAY_TYPE"); cmd.AddInputOutputParam("pGatewayTypeID", DbType.Guid, gatewayType.ID); cmd.AddInputOutputParam("pName", DbType.String, gatewayType.Name); cmd.AddInputOutputParam("pLiveUrl", DbType.String, gatewayType.LiveURL); cmd.AddInputOutputParam("pTestUrl", DbType.String, gatewayType.TestURL); cmd.AddInputOutputParam("pTestLoginId", DbType.String, gatewayType.TestLoginID); cmd.AddInputOutputParam("pTestTransactionKey", DbType.String, gatewayType.TestTransactionKey); cmd.AddOutputParam("oCreationDate", DbType.DateTime); cmd.AddOutputParam("oLastEditDate", DbType.DateTime); if (int.Parse(SqlHelpers.ExecuteNonQuery(cmd).ToString()) > 0) { gatewayType.ID = cmd.ExtractGuid("pGatewayTypeID"); gatewayType.Name = cmd.ExtractString("pName"); gatewayType.LiveURL = cmd.ExtractString("pLiveUrl"); gatewayType.TestURL = cmd.ExtractString("pTestUrl"); gatewayType.TestLoginID = cmd.ExtractString("pTestLoginId"); gatewayType.TestTransactionKey = cmd.ExtractString("pTestTransactionKey"); gatewayType.CreationDate = cmd.ExtractDateTime("oCreationDate"); gatewayType.LastEditDate = cmd.ExtractDateTime("oLastEditDate"); } return gatewayType; }
public static GatewayType ToGatewayType(this DataRow dr) { GatewayType type = new GatewayType(); type.ID = dr.GetGuid("Id"); type.Name = dr.GetString("Name"); type.LiveURL = dr.GetString("LiveUrl"); type.TestURL = dr.GetString("TestUrl"); type.TestLoginID = dr.GetString("TestLoginId"); type.TestTransactionKey = dr.GetString("TestTransactionKey"); type.CreationDate = dr.GetDate("CreationDate"); type.LastEditDate = dr.GetDate("LastEditDate"); return type; }