protected virtual iCustomerAds GetCustomerAdsFromReader(IDataReader reader, bool singleRecord)
{
if (singleRecord)
{
reader.Read();
}
iCustomerAds customerAd = new iCustomerAds(
Convert.ToInt32(reader["id"]),
Convert.ToInt32(reader["customerid"]),
reader["adtype"].ToString(),
reader["addetails"].ToString(),
reader["img1"].ToString(),
reader["img2"].ToString(),
reader["img3"].ToString(),
reader["img4"].ToString(),
Convert.ToDateTime(reader["expires"]),
Convert.ToBoolean(reader["paid"]),
Convert.ToBoolean(reader["active"]),
Convert.ToBoolean(reader["confirmed"]),
reader["url"].ToString(),
Convert.ToBoolean(reader["declined"])
);
return(customerAd);
}
public override bool Update(iCustomerAds c)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
string q = string.Empty;
q = @"UPDATE customerads SET
customerid = @pCustomerid,
adtype = @pAdtype,
addetails = @pAddetails,
img1 = @pImg1,
img2 = @pImg2,
img3 = @pImg3,
img4 = @pImg4,
expires = @pExpires,
paid = @ePaid,
active = @pActive,
confirmed = @pConfirmed,
url = @pUrl
WHERE id = @pid";
SqlCommand cmd = new SqlCommand(q, conn);
cmd.CommandText = q;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@pCustomerid", SqlDbType.Int).Value = c.CustomerId;
cmd.Parameters.Add("@pAdtype", SqlDbType.VarChar).Value = c.AdType;
cmd.Parameters.Add("@pAddetails", SqlDbType.VarChar).Value = c.AdDetails;
if (c.Img1 != null)
{
cmd.Parameters.Add("@pImg1", SqlDbType.VarChar).Value = c.Img1;
}
else
{
cmd.Parameters.Add("@pImg1", SqlDbType.VarChar).Value = DBNull.Value;
}
if (c.Img2 != null)
{
cmd.Parameters.Add("@pImg2", SqlDbType.VarChar).Value = c.Img2;
}
else
{
cmd.Parameters.Add("@pImg2", SqlDbType.VarChar).Value = DBNull.Value;
}
if (c.Img3 != null)
{
cmd.Parameters.Add("@pImg3", SqlDbType.VarChar).Value = c.Img3;
}
else
{
cmd.Parameters.Add("@pImg3", SqlDbType.VarChar).Value = DBNull.Value;
}
if (c.Img4 != null)
{
cmd.Parameters.Add("@pImg4", SqlDbType.VarChar).Value = c.Img4;
}
else
{
cmd.Parameters.Add("@pImg4", SqlDbType.VarChar).Value = DBNull.Value;
}
cmd.Parameters.Add("@pExpires", SqlDbType.DateTime).Value = c.Expires;
cmd.Parameters.Add("@pPaid", SqlDbType.Bit).Value = c.Paid;
cmd.Parameters.Add("@pActive", SqlDbType.Bit).Value = c.Active;
cmd.Parameters.Add("@pConfirmed", SqlDbType.Bit).Value = c.Confirmed;
cmd.Parameters.Add("@pUrl", SqlDbType.VarChar).Value = c.URL;
try
{
conn.Open();
int rc = ExecuteNonQuery(cmd);
return(rc == 1);
}
catch (SqlException ex)
{
ErrorHandler.writeSQLExceptionToLogFile(ex);
return(false);
}
finally
{
conn.Close();
}
}
}
public override int Insert(iCustomerAds c)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
string q = string.Empty;
SqlCommand cmd = new SqlCommand(q, conn);
q = @"INSERT INTO customerads (customerid,
adtype,
addetails,
img1,
img2,
img3,
img4,
expires,
paid,
active,
confirmed,
url)
VALUES (@pCustomerid,
@pAdtype,
@pAddetails,
@pImg1,
@pImg2,
@pImg3,
@pImg4,
@pExpires,
@pPaid,
@pActive,
@pConfirmed,
@pUrl);
SELECT SCOPE_IDENTITY();";
cmd.CommandText = q;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@pCustomerid", SqlDbType.Int).Value = c.CustomerId;
cmd.Parameters.Add("@pAdtype", SqlDbType.VarChar).Value = c.AdType;
cmd.Parameters.Add("@pAddetails", SqlDbType.VarChar).Value = c.AdDetails;
if (c.Img1 != null)
{
cmd.Parameters.Add("@pImg1", SqlDbType.VarChar).Value = c.Img1;
}
else
{
cmd.Parameters.Add("@pImg1", SqlDbType.VarChar).Value = DBNull.Value;
}
if (c.Img2 != null)
{
cmd.Parameters.Add("@pImg2", SqlDbType.VarChar).Value = c.Img2;
}
else
{
cmd.Parameters.Add("@pImg2", SqlDbType.VarChar).Value = DBNull.Value;
}
if (c.Img3 != null)
{
cmd.Parameters.Add("@pImg3", SqlDbType.VarChar).Value = c.Img3;
}
else
{
cmd.Parameters.Add("@pImg3", SqlDbType.VarChar).Value = DBNull.Value;
}
if (c.Img4 != null)
{
cmd.Parameters.Add("@pImg4", SqlDbType.VarChar).Value = c.Img4;
}
else
{
cmd.Parameters.Add("@pImg4", SqlDbType.VarChar).Value = DBNull.Value;
}
cmd.Parameters.Add("@pExpires", SqlDbType.DateTime).Value = c.Expires;
cmd.Parameters.Add("@pPaid", SqlDbType.Bit).Value = c.Paid;
cmd.Parameters.Add("@pActive", SqlDbType.Bit).Value = c.Active;
cmd.Parameters.Add("@pConfirmed", SqlDbType.Bit).Value = c.Confirmed;
cmd.Parameters.Add("@pUrl", SqlDbType.VarChar).Value = c.URL;
try
{
conn.Open();
int rc = Convert.ToInt32(ExecuteScalar(cmd));
return(rc);
}
catch (SqlException ex)
{
ErrorHandler.writeSQLExceptionToLogFile(ex);
return(0);
}
}
}
public abstract bool Update(iCustomerAds c);
public abstract int Insert(iCustomerAds c);
