public PaymentInfo GetByPK(Guid paymentInfoGuid)
{
if (Guid.Empty == paymentInfoGuid)
{ return new PaymentInfo(); }
try
{
PaymentInfo daPaymentInfo = new PaymentInfo();
using (PSS2012DataContext context = this.DataContext)
{
daPaymentInfo = (
from items in context.PaymentInfos
where items.PaymentInfoGuid == paymentInfoGuid
select items).SingleOrDefault();
}
if (null == daPaymentInfo)
{
throw new DataAccessException("PaymentInfo no longer exists.");
}
return daPaymentInfo;
}
catch (System.Data.SqlClient.SqlException ex)
{
throw this.HandleSqlException(ex);
}
}
public List<PaymentInfo> GetAllWithUndefined()
{
PaymentInfo undefinedPaymentInfo = new PaymentInfo()
{
PaymentInfoGuid = Guid.Empty,
PaymentInfoID = 0,
AmazonToken = "Undefined",
};
List<PaymentInfo> response = this.GetAll().ToList();
response.Add(undefinedPaymentInfo);
return response;
}
/// <summary>
/// Inserts paymentInfo business entity into the data store.
/// </summary>
/// <param name="entity">The paymentInfo business entity to insert.</param>
/// <returns>The paymentInfo identifier.</returns>
public PaymentInfo Insert(PaymentInfo entity)
{
//@@NEW - changed return type to entity type.
try
{
using (PSS2012DataContext context = DataContext)
{
entity.PaymentInfoGuid = Guid.NewGuid();
context.PaymentInfos.InsertOnSubmit(entity);
context.SubmitChanges();
}
//@@NEW - returning full entity.
return entity;
}
catch (System.Data.SqlClient.SqlException ex)
{
throw this.HandleSqlException(ex);
}
}
public void Update(PaymentInfo entity)
{
if (Guid.Empty == entity.PaymentInfoGuid)
throw new PrimaryKeyMissingException("PaymentInfo", entity, "update");
try
{
using (PSS2012DataContext context = DataContext)
{
// Get the entity to update.
PaymentInfo paymentInfoToUpdate = GetByPK(entity.PaymentInfoGuid);
context.PaymentInfos.Attach(paymentInfoToUpdate);
// Set the new values.
//paymentInfoToUpdate.PaymentInfoID = entity.PaymentInfoID;
paymentInfoToUpdate.AmazonToken = entity.AmazonToken;
// Perform the update.
context.SubmitChanges();
}
}
catch (System.Data.SqlClient.SqlException ex)
{
throw this.HandleSqlException(ex);
}
}
public static DA.PaymentInfo ToDataEntity(this BE.PaymentInfo bePaymentInfo)
{
DA.PaymentInfo paymentInfoResult = new DA.PaymentInfo()
{
PaymentInfoGuid = bePaymentInfo.PaymentInfoGuid,
PaymentInfoID = bePaymentInfo.PaymentInfoID,
AmazonToken = bePaymentInfo.AmazonToken,
};
return paymentInfoResult;
}