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);