Exemplo n.º 1
0
 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;
 }
Exemplo n.º 2
0
 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;
 }
Exemplo n.º 3
0
 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;
 }