public GiftCardUsageTransaction(int GiftCardUsageID, string GiftCardUsageGUID, int GiftCardID, int UsageTypeID, int UsedByCustomerID, int OrderNumber, decimal Amount, string ExtensionData, DateTime CreatedOn)
{
m_Giftcardusageid = GiftCardUsageID;
m_Giftcardusageguid = GiftCardUsageGUID;
m_Giftcardid = GiftCardID;
m_UsageType = (GiftCardUsageReasons)Enum.Parse(typeof(GiftCardUsageReasons), UsageTypeID.ToString());
m_Usedbycustomerid = UsedByCustomerID;
m_Ordernumber = OrderNumber;
m_Amount = Amount;
m_Extensiondata = ExtensionData;
m_Createdon = CreatedOn;
}
public static GiftCardUsageTransaction CreateTransaction(int GiftCardID, GiftCardUsageReasons UsageReason, int UsedByCustomerID, int OrderNumber, decimal Amount, string ExtensionData)
{
var GiftCardUsageID = 0;
using (var cn = new SqlConnection(DB.GetDBConn()))
{
cn.Open();
using (var cmd = new SqlCommand())
{
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.aspdnsf_insGiftCardUsage";
cmd.Parameters.Add(new SqlParameter("@GiftCardID", SqlDbType.Int, 4));
cmd.Parameters.Add(new SqlParameter("@UsageTypeID", SqlDbType.Int, 4));
cmd.Parameters.Add(new SqlParameter("@UsedByCustomerID", SqlDbType.Int, 4));
cmd.Parameters.Add(new SqlParameter("@OrderNumber", SqlDbType.Int, 4));
cmd.Parameters.Add(new SqlParameter("@Amount", SqlDbType.Decimal, 8));
cmd.Parameters.Add(new SqlParameter("@ExtensionData", SqlDbType.NText));
cmd.Parameters.Add(new SqlParameter("@GiftCardUsageID", SqlDbType.Int, 4)).Direction = ParameterDirection.Output;
cmd.Parameters["@GiftCardID"].Value = GiftCardID;
cmd.Parameters["@UsageTypeID"].Value = (int)UsageReason;
cmd.Parameters["@UsedByCustomerID"].Value = UsedByCustomerID;
cmd.Parameters["@OrderNumber"].Value = OrderNumber;
cmd.Parameters["@Amount"].Value = Amount;
cmd.Parameters["@ExtensionData"].Value = ExtensionData;
try
{
cmd.ExecuteNonQuery();
GiftCardUsageID = Int32.Parse(cmd.Parameters["@GiftCardUsageID"].Value.ToString());
}
catch (Exception ex)
{
SysLog.LogException(ex, MessageTypeEnum.DatabaseException, MessageSeverityEnum.Error);
}
}
}
if (GiftCardID > 0)
{
return(new GiftCardUsageTransaction(GiftCardUsageID));
}
return(null);
}
GiftCardUsageTransaction(int GiftCardTransactionID)
{
using (var dbconn = DB.dbConn())
{
dbconn.Open();
using (var dr = DB.GetRS("aspdnsf_getGiftCardUsage " + GiftCardTransactionID.ToString(), dbconn))
{
if (dr.Read())
{
m_Giftcardusageid = DB.RSFieldInt(dr, "GiftCardUsageID");
m_Giftcardusageguid = DB.RSFieldGUID(dr, "GiftCardUsageGUID");
m_Giftcardid = DB.RSFieldInt(dr, "GiftCardID");
m_UsageType = (GiftCardUsageReasons)Enum.Parse(typeof(GiftCardUsageReasons), DB.RSFieldInt(dr, "UsageTypeID").ToString());
m_Usedbycustomerid = DB.RSFieldInt(dr, "UsedByCustomerID");
m_Ordernumber = DB.RSFieldInt(dr, "OrderNumber");
m_Amount = DB.RSFieldDecimal(dr, "Amount");
m_Extensiondata = DB.RSField(dr, "ExtensionData");
m_Createdon = DB.RSFieldDateTime(dr, "CreatedOn");
}
}
}
}