public bool AddUser(string Email, string Name, string phone, int GroupId)
{
System.Data.DataView dv = GetUsers(string.Format("Email='{0}'", StringUtils.SQLEncode(Email)));
if (dv.Count > 0)
{
AddUserToGroup((int)dv[0]["UserId"], GroupId);
return(false);
}
NewsDs _ds = new NewsDs();
IDataAdapter adp = base.GetAdapter(cte.NewsleterUsersAdp);
NewsDs.NewsletterUsersRow row = _ds.NewsletterUsers.NewNewsletterUsersRow();
row.Name = Name;
row.Email = Email;
row.Phone = phone;
row.DateAdded = DateTime.Now;
_ds.NewsletterUsers.AddNewsletterUsersRow(row);
base.UpdateData(adp, _ds);
AddUserToGroup(row.UserId, GroupId);
return(true);
}
public bool DeleteUser(int UserId)
{
NewsDs _ds = new NewsDs();
IDataAdapter adp = base.GetAdapter(cte.NewsleterUsersAdp);
NewsDs.NewsletterUsersRow row = _ds.NewsletterUsers.NewNewsletterUsersRow();
row.UserId = UserId;
_ds.NewsletterUsers.AddNewsletterUsersRow(row);
row.AcceptChanges();
row.Delete();
base.UpdateData(adp, _ds);
return(true);
}
public void UpdateUser(int UserId, string Email, string Name, string Groups)
{
NewsDs _ds = new NewsDs();
IDataAdapter adp = base.GetAdapter(cte.NewsleterUsersAdp);
NewsDs.NewsletterUsersRow row = _ds.NewsletterUsers.NewNewsletterUsersRow();
row.UserId = UserId;
_ds.NewsletterUsers.AddNewsletterUsersRow(row);
row.AcceptChanges();
row.Email = Email;
row.Name = Name;
base.UpdateData(adp, _ds);
UpdateUserGroups(row.UserId, Groups);
}
public bool AddUser(string Title, string FirstName, string LastName, string Company,
string Position, string Address, string City, string State, string ZipCode,
int Country, string Phone, string Email, string Former, string Year,
string Children, string School, string Aware,
int GroupId)
{
System.Data.DataView dv = GetUsers(string.Format("Email='{0}'", StringUtils.SQLEncode(Email)));
if (dv.Count > 0)
{
return(false);
}
NewsDs _ds = new NewsDs();
IDataAdapter adp = base.GetAdapter(cte.NewsleterUsersAdp);
NewsDs.NewsletterUsersRow row = _ds.NewsletterUsers.NewNewsletterUsersRow();
/*row.Title = Title;
* row.FirstName = FirstName;
* row.LastName = LastName;
* row.Company = Company;
* row.Position = Position;
* row.Phone = Phone;
* row.Email = Email;
* row.Former = Former;
* row.Year = Year;
* row.Children = Children;
* row.School = Int32.Parse(School);
* row.Aware = Aware;
* row.GroupId = GroupId;
*/
row.Email = Email;
row.DateAdded = DateTime.Now;
_ds.NewsletterUsers.AddNewsletterUsersRow(row);
base.UpdateData(adp, _ds);
return(true);
}
