protected void btnStartProcedure_Click(object sender, EventArgs e)
{
int.TryParse(DDL_DestinationList.SelectedValue, out DestMLID);
int.TryParse(DDL_OriginalList.SelectedValue, out OriginMLID);
if (DestMLID != 0 && OriginMLID != 0)
{
bool _t;
bool _t2;
SendMsgUser[] _users;
SendMsgResults _res;
SendMsgService _svc = new SendMsgService();
_svc.GetMailingListUsers(5078, true, "IL110077", OriginMLID, true, SendMsgUsersRequestType.AllUsers, true, out _t, out _t2, out _users, out _res);
List <SendMsgUser> _lst = _users.ToList <SendMsgUser>();
var q = _lst.Where(x => x.DeleteUserSpecified == true).ToList();
using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr))
{
con.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
foreach (SendMsgUser item in q)
{
cmd.CommandText = "SELECT * from tblusers where EmailAddress='" + item.EmailAddress + "'";
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
FoundUsersList.Add(item);
}
dr.Close();
}
con.Close();
}
foreach (SendMsgUser item in FoundUsersList)
{
Adduser_WL(5078, item.EmailAddress, DestMLID);
}
Repeater_FoundUsers.DataSource = FoundUsersList;
Repeater_FoundUsers.DataBind();
if (FoundUsersList.Count > 0)
{
Panel_FoundUsers.Visible = true;
TotalResults = FoundUsersList.Count;
}
}
else
{
lblStatus.Text = "הייתה בעיה בתהליך, אנא פנה למתכנת";
}
}
protected void Unnamed_Click(object sender, EventArgs e)
{
bool _t;
bool _t2;
SendMsgUser[] _users;
SendMsgResults _res;
SendMsgService _svc = new SendMsgService();
_svc.GetMailingListUsers(5078, true, "IL110077", 17, true, SendMsgUsersRequestType.AllUsers, true, out _t, out _t2, out _users, out _res);
List <SendMsgUser> _lst = _users.ToList <SendMsgUser>();
var q = _lst.Where(x => x.DeleteUserSpecified == true).ToList();
using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr))
{
con.Open();
MySqlCommand _cmd = new MySqlCommand();
_cmd.Connection = con;
q.ForEach(p =>
{
bool itemExists = false;
_cmd.CommandText = "SELECT * from tblUsers where EmailAddress ='" + p.EmailAddress + "'";
MySqlDataReader _dr = _cmd.ExecuteReader();
if (_dr.HasRows)
{
itemExists = true;
}
_dr.Close();
if (!itemExists)
{
_cmd.CommandText = string.Format("INSERT into tblUsers (tblUsers.FullName,tblUsers.EmailAddress,tblUsers.Password) Values('{0}','{1}','{2}')", p.UserSystemFields[0].Value, p.EmailAddress, p.UserSystemFields[1].Value);
_cmd.ExecuteNonQuery();
}
});
con.Close();
}
}