public override bool Update(iBillingAds ba)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
string q = string.Empty;
q = @"
UPDATE [dbo].[billing_ads]
SET [customerid] = @pCustomerid
,[adid] = @pAdId
,[payment] = @pCost
WHERE id = @pid";
SqlCommand cmd = new SqlCommand(q, conn);
cmd.CommandText = q;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@pid", SqlDbType.Int).Value = ba.Id;
cmd.Parameters.Add("@pCustomerid", SqlDbType.Int).Value = ba.CustomerId;
cmd.Parameters.Add("@pAdId", SqlDbType.Int).Value = ba.AdId;
cmd.Parameters.Add("@pCost", SqlDbType.Money).Value = ba.Payment;
try
{
conn.Open();
int rc = ExecuteNonQuery(cmd);
return(rc == 1);
}
catch (SqlException ex)
{
ErrorHandler.writeSQLExceptionToLogFile(ex);
return(false);
}
}
}
public override bool Insert(iBillingAds ba)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
string q = string.Empty;
SqlCommand cmd = new SqlCommand(q, conn);
q = @"
INSERT INTO [dbo].[billing_ads]
([customerid]
,[adid]
,[payment]
,[paypalid]
,[ppstate]
,[create_time])
VALUES
(@pCustomerid
,@pAdId
,@pCost
,@pPayPalId
,@pState
,@pTime)";
cmd.CommandText = q;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@pCustomerid", SqlDbType.Int).Value = ba.CustomerId;
cmd.Parameters.Add("@pAdId", SqlDbType.Int).Value = ba.AdId;
cmd.Parameters.Add("@pCost", SqlDbType.Money).Value = ba.Payment;
cmd.Parameters.Add("@pPayPalId", SqlDbType.VarChar).Value = ba.PayPalId;
cmd.Parameters.Add("@pState", SqlDbType.VarChar).Value = ba.PayPalState;
cmd.Parameters.Add("@pTime", SqlDbType.DateTime).Value = ba.CreateTime;
try
{
conn.Open();
int rc = ExecuteNonQuery(cmd);
return(rc == 1);
}
catch (SqlException ex)
{
ErrorHandler.writeSQLExceptionToLogFile(ex);
return(false);
}
}
}
protected virtual iBillingAds GetAdBillingFromReader(IDataReader reader, bool singleRecord)
{
if (singleRecord)
{
reader.Read();
}
iBillingAds billing = new iBillingAds(
Convert.ToInt32(reader["id"]),
Convert.ToInt32(reader["customerid"]),
Convert.ToInt32(reader["adid"]),
Convert.ToDouble(reader["payment"]),
reader["paypalid"].ToString(),
reader["ppstate"].ToString(),
Helpers.CheckNullableDate(reader["create_time"])
);
return(billing);
}
public abstract bool Update(iBillingAds c);
public abstract bool Insert(iBillingAds c);