public bool Delete(NewsSubscriber item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("NewsSubscribers_DeleteItem"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}
public int Add(NewsSubscriber item)
{
if (!Tools.CheckEmail(item.Email))
throw new InvalidOperationException("Invalid e-mail address");
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("NewsSubscribers_AddItem"))
{
sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 255).Value = item.Name;
sp.Params.Add("@Email", System.Data.SqlDbType.NVarChar, 255).Value = item.Email;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public bool Update(NewsSubscriber item)
{
if (!Tools.CheckEmail(item.Email))
throw new InvalidOperationException("Invalid e-mail address");
bool result = false;
using (StoredProcedure sp = new StoredProcedure("NewsSubscribers_UpdateItem"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID;
sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 255).Value = item.Name;
sp.Params.Add("@Email", System.Data.SqlDbType.NVarChar, 255).Value = item.Email;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}
public NewsSubscriber GetByID(int id)
{
NewsSubscriber item = null;
using (StoredProcedure sp = new StoredProcedure("NewsSubscribers_GetByID"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = id;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null && r.Read())
{
item = new NewsSubscriber(r);
}
}
}
return item;
}
public bool AddNewsSubscriber(string name, string email)
{
bool result = false;
try
{
NewsSubscribers dao = new NewsSubscribers();
NewsSubscriber item = new NewsSubscriber();
item.Name = name;
item.Email = email;
dao.Add(item);
result = true;
}
catch { }
return result;
}
public List<NewsSubscriber> GetAll()
{
List<NewsSubscriber> all = new List<NewsSubscriber>();
using (StoredProcedure sp = new StoredProcedure("NewsSubscribers_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
NewsSubscriber item = new NewsSubscriber(r);
all.Add(item);
}
}
}
}
return all;
}