protected void Page_Load(object sender, EventArgs e)
{
bool _t;
bool _t2;
SendMsgResults _res;
SendMsgList[] _lists;
SendMsgService _svc = new SendMsgService();
_svc.GetMailingListNames(5078, true, "IL110077", out _t, out _t2, out _lists, out _res);
List <SendMsgList> _sendMsgLists = _lists.ToList();
if (!IsPostBack)
{
foreach (SendMsgList item in _lists)
{
DDL_DestinationList.Items.Add(new ListItem()
{
Text = item.ExistingListID.ToString() + " - " + item.NewListDescription, Value = item.ExistingListID.ToString()
});
DDL_OriginalList.Items.Add(new ListItem()
{
Text = item.ExistingListID.ToString() + " - " + item.NewListDescription, Value = item.ExistingListID.ToString()
});
}
}
}
protected void Adduser_WL(int SiteID, string Mail, string FullName, int ListID, string sendurl)
{
bool tmp;
bool AddUsersToListResult;
SendMsgResults _res = new SendMsgResults();
SendMsgService _svc = new SendMsgService();
List <SendMsgUser> _UsersList = new List <SendMsgUser>();
List <SendMsgList> _mailList = new List <SendMsgList>();
//_mailList.Add(new SendMsgList() { ExistingListID = ListID, ExistingListIDSpecified = true });
_mailList.Add(new SendMsgList()
{
ExistingListID = 55, ExistingListIDSpecified = true
});
_UsersList.Add(new SendMsgUser()
{
EmailAddress = Mail, UserSystemFields = new SendMsgFields[4] {
new SendMsgFields()
{
Key = "שם", Value = FullName
}, new SendMsgFields()
{
Key = "קישור הרשמה", Value = sendurl
}, new SendMsgFields()
{
Key = "נרשם דרך מייל", Value = "1"
}, new SendMsgFields()
{
Key = "מהיכן נרשם", Value = FromToIsender
}
}
});
_svc.AddUsersToLists(SiteID, true, "IL110077", _UsersList.ToArray(), _mailList.ToArray(), out AddUsersToListResult, out tmp, out _res);
}
protected void Adduser_WL(int SiteID, string Mail, string FullName)
{
bool tmp = false;
SendMsgResults _res = new SendMsgResults();
SendMsgService _svc = new SendMsgService();
_svc.AddUsersOnly(SiteID, true, "IL110077", new SendMsgUser[]
{
new SendMsgUser()
{
EmailAddress = Mail, UserSystemFields = new SendMsgFields[2] {
new SendMsgFields()
{
Key = "שם", Value = FullName
}, new SendMsgFields()
{
Key = "נרשם דרך פייסבוק", Value = "1"
}
}
}
}, out tmp, out tmp, out _res);
if (_res.ResultMessage.Contains("Failed:1"))
{
using (MySqlConnection conn = new MySqlConnection(cmstrDefualts.ConnStr))
{
conn.Open();
LoginUser.NotAddedToISend(Mail, conn);
}
}
}
protected void Adduser_WL(int SiteID, string Mail, string FullName, int ListID)
{
bool tmp;
bool AddUsersToListResult;
SendMsgResults _res = new SendMsgResults();
SendMsgService _svc = new SendMsgService();
List <SendMsgUser> _UsersList = new List <SendMsgUser>();
List <SendMsgList> _mailList = new List <SendMsgList>();
_mailList.Add(new SendMsgList()
{
ExistingListID = ListID, ExistingListIDSpecified = true
});
_UsersList.Add(new SendMsgUser()
{
EmailAddress = Mail, UserSystemFields = new SendMsgFields[1] {
new SendMsgFields()
{
Key = "שם", Value = FullName
}
}
});
_svc.AddUsersToLists(SiteID, true, "IL110077", _UsersList.ToArray(), _mailList.ToArray(), out AddUsersToListResult, out tmp, out _res);
}
protected void SignByMailLinkButton_Click(object sender, EventArgs e)
{
bool isExists = false;
string email = SendByMailTextBox.Text.Replace("'", "''");
SendByMailTextBox.Text = "";
using (MySqlConnection conn = new MySqlConnection(cmstrDefualts.ConnStr))
{
conn.Open();
string sql = String.Format("Select UserID From tblusers where (EmailAddress='{0}' OR LoginMailAddress='{0}') AND (EmailAddress<>'{1}') ", email, _usermail);
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
isExists = true;
}
dr.Close();
if (!isExists)
{
cmd.CommandText = String.Format("Update tblusers Set EmailAddress='{0}' , SignInByMail=1 where EmailAddress='{1}'", email, _usermail);
Session["LoggedUserMail"] = email;
cmd.ExecuteNonQuery();
Badge.AddBadge(BadgTypeEnum.Join, conn, Session["LoggedUserMail"].ToString());
bool tmp;
bool AddUsersToListResult;
SendMsgService svc = new SendMsgService();
SendMsgResults resSendMsgResults = new SendMsgResults();
List <SendMsgUser> _UsersList = new List <SendMsgUser>();
_UsersList.Add(new SendMsgUser()
{
EmailAddress = email, UserSystemFields = new SendMsgFields[2] {
new SendMsgFields()
{
Key = "שם", Value = User_Fullname
}, new SendMsgFields()
{
Key = "נרשם דרך מייל", Value = "1"
}
}
});
svc.AddUsersOnly(5078, true, "IL110077", _UsersList.ToArray(), out tmp, out AddUsersToListResult, out resSendMsgResults);
Response.Redirect("./");
}
else
{
maillerror.Text = "mail exists!!!";
}
}
}
protected void Adduser_WL(int SiteID, string Mail, string FullName)
{
string groupid = "";
if (Request.Cookies["JoinUsGroup"] != null)
{
groupid = Request.Cookies["JoinUsGroup"].Value;
}
int groupidInt;
if (!int.TryParse(groupid, out groupidInt))
{
groupidInt = 19;
}
bool tmp = false;
bool tmp2 = false;
SendMsgResults _res = new SendMsgResults();
SendMsgService _svc = new SendMsgService();
List <SendMsgList> _mailList = new List <SendMsgList>();
List <SendMsgUser> _UsersList = new List <SendMsgUser>();
_UsersList.Add(new SendMsgUser()
{
EmailAddress = Mail, UserSystemFields = new SendMsgFields[2] {
new SendMsgFields()
{
Key = "שם", Value = FullName
}, new SendMsgFields()
{
Key = "נרשם דרך פייסבוק", Value = "1"
}
}
});
_mailList.Add(new SendMsgList()
{
ExistingListID = groupidInt, ExistingListIDSpecified = true
});
_svc.AddUsersToLists(SiteID, true, "IL110077", _UsersList.ToArray(), _mailList.ToArray(), out tmp2, out tmp, out _res);
if (_res.ResultMessage.Contains("Failed:1"))
{
using (MySqlConnection conn = new MySqlConnection(cmstrDefualts.ConnStr))
{
conn.Open();
LoginUser.NotAddedToISend(Mail, conn);
}
}
}
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 = "הייתה בעיה בתהליך, אנא פנה למתכנת";
}
}
public JsonResult SendValidateCode(string phoneNumber)
{
if (phoneNumber.IsNullOrEmpty())
{
throw new ArgumentNullException();
}
if (SendMsgService.SendValidateCode(phoneNumber))
{
return(CustomResult.SuccessMessage("success"));
}
else
{
return(CustomResult.ErrorMessage("验证码发送失败！"));
}
}
protected void Adduser_WL(int SiteID, string Mail, string FullName)
{
bool tmp = false;
SendMsgResults _res = new SendMsgResults();
SendMsgService _svc = new SendMsgService();
_svc.AddUsersOnly(SiteID, true, "IL110077", new SendMsgUser[]
{
new SendMsgUser()
{
EmailAddress = Mail, UserSystemFields = new SendMsgFields[1] {
new SendMsgFields()
{
Key = "שם", Value = FullName
}
}
}
}, out tmp, out tmp, out _res);
}
protected void Adduser_WL(int SiteID, string Mail, string FullName, int ListID, string sendurl)
{
bool tmp;
bool AddUsersToListResult;
SendMsgResults _res = new SendMsgResults();
SendMsgService _svc = new SendMsgService();
List <SendMsgUser> _UsersList = new List <SendMsgUser>();
List <SendMsgList> _mailList = new List <SendMsgList>();
_mailList.Add(new SendMsgList()
{
ExistingListID = ListID, ExistingListIDSpecified = true
});
//_mailList.Add(new SendMsgList() { ExistingListID = 55, ExistingListIDSpecified = true });
_UsersList.Add(new SendMsgUser()
{
EmailAddress = Mail
});
_svc.AddUsersToLists(SiteID, true, "IL110077", _UsersList.ToArray(), _mailList.ToArray(), out AddUsersToListResult, out tmp, out _res);
}
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();
}
}
public JsonResult FindPwd(string phoneNumber, string number, string name, string identityNumber, string validateCode)
{
string cacheValidateCode = ValidateCodeCache.GetValidateCodeWithExpire(phoneNumber);
if (cacheValidateCode.IsNullOrEmpty() || !cacheValidateCode.Equals(validateCode))
{
return(CustomResult.ErrorMessage("验证码错误或已失效"));
}
string newPwd;
BackMessage backMessage = settingService.FindPassword(number, name, identityNumber, out newPwd);
if (backMessage.Code == 200)
{
SendMsgService.SendNewPassword(phoneNumber, newPwd);
}
return(new JsonResult()
{
Data = backMessage
});
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Request.Url.ToString().StartsWith("https://israelikers.org") && !Request.Url.ToString().Contains("localhost:"))
{
Response.Redirect("https://israelikers.org" + Request.Url.PathAndQuery);
}
else
{
}
if (!string.IsNullOrEmpty(Request.QueryString["lang"]))
{
_UserLang = Request.QueryString["lang"].ToString();
}
if (!string.IsNullOrEmpty(Request.QueryString["mail"]))
{
_Usermail = Request.QueryString["mail"].ToString();
}
if (_Usermail == "")
{
Panel_Error.Visible = true;
}
if (_Usermail != "")
{
bool _userAllowed = false;
bool _userAllowed2 = false;
SendMsgService _srvc = new SendMsgService();
SendMsgList _lst = new SendMsgList();
_srvc.CheckIfUserExistsByMail2(5078, true, _Usermail, out _userAllowed, out _userAllowed2);
if (!_userAllowed)
{
Response.Redirect("./");
}
using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr))
{
con.Open();
MySqlCommand _cmd = new MySqlCommand();
_cmd.Connection = con;
_cmd.CommandText = "select * from tblusers where EmailAddress='" + _Usermail + "'";
MySqlDataReader _dr = _cmd.ExecuteReader();
if (_dr.HasRows)
{
_UserExists = true;
}
_dr.Close();
}
if (_UserLang == "")
{
_UserLang = "Heb";
}
if (!_UserExists)
{
switch (_UserLang.ToLower())
{
case "heb":
Panel_HebReg.Visible = true;
((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text = _Usermail;
MyFormHeb.BackURL = "FacebookConnect.aspx?mail=" + _Usermail + "&lang=" + _UserLang;
break;
case "eng":
Panel_EngReg.Visible = true;
((ASP.controls_cmstrtextboxcontrol_ascx)MyFormEng.FindControl("txtMail")).Text = _Usermail;
MyFormEng.BackURL = "FacebookConnect.aspx?mail=" + _Usermail + "&lang=" + _UserLang;
break;
default:
break;
}
}
else
{
Response.Redirect("FacebookConnect.aspx?mail=" + _Usermail + "&lang=" + _UserLang);
if (_UserLang == "Heb")
{
Panel_HebExists.Visible = true;
ProceedLinkHeb.HRef = "FacebookConnect.aspx?mail=" + _Usermail + "&lang=" + _UserLang;
}
else
{
Panel_EngExists.Visible = true;
ProceedLinkEng.HRef = "FacebookConnect.aspx?mail=" + _Usermail + "&lang=" + _UserLang;
}
}
MyFormHeb.BackURL = "FacebookConnect.aspx?mail=" + _Usermail + "&lang=" + _UserLang;
}
}
public static List <string> GetUserMissions(string UserMail)
{
List <string> MissionList = new List <string>();
bool UsersAllowed = false;
SendMsgService _svc = new SendMsgService();
bool _t3;
bool _t4;
int _t;
bool _t2;
SendMsgStatistics[] Messages_List = new SendMsgStatistics[0];
SendMsgResults _results;
//_svc.GetSentMessages(5078, true, "IL110077", out _t, out _t2, out Messages_List, out _results);
_svc.GetUserByMail(5078, true, UserMail, out _t, out _t2);//convert mail to UserID on Isend
if (_t != 0)
{
_svc.GetUserMessages(5078, true, "IL110077", _t, true, out _t3, out _t4, out Messages_List, out _results); //Getting User Messages
List <SendMsgStatistics> _lst = Messages_List.ToList();
if (_lst.Count > 0)
{
using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr))
{
con.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
MySqlDataReader dr;
foreach (SendMsgStatistics item in _lst)
{
bool MsgExists = false;
cmd.CommandText = string.Format("SELECT * from tblmission2msgs where MessageID={0}", item.MessageID);
dr = cmd.ExecuteReader();
if (dr.Read())
{
MsgExists = true;
if (!MissionList.Contains(dr["MissionName"].ToString()))
{
MissionList.Add(dr["MissionName"].ToString());
}
}
dr.Close();
if (!MsgExists)
{
bool _x1;
bool _x2;
SendMsgStatistics _tmpMsg;
SendMsgResults _tmpResults;
_svc.GetMsgBasicStatistics(5078, true, "IL110077", item.MessageID, true, out _x1, out _x2, out _tmpMsg, out _tmpResults);
if (_tmpResults.ResultID == 200)
{
string _msg = _tmpMsg.OriginalMessage.MessageContent;
Regex _reg = new Regex("name=[a-zA-Z0-9\\-]{36}\\&");
Match regMatch = _reg.Match(_msg);
if (regMatch != null && regMatch.ToString() != "")
{
string missionNameReg = regMatch.ToString().Replace("name=", "").Replace("&", "");
if (missionNameReg != "")
{
cmd.CommandText = "INSERT into tblmission2msgs (MissionName,MessageID) Values ('" + missionNameReg + "','" + item.MessageID + "')";
cmd.ExecuteNonQuery();
if (!MissionList.Contains(missionNameReg))
{
MissionList.Add(missionNameReg);
}
}
}
}
}
}
con.Close();
}
}
}
return(MissionList);
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
bool _userExists_onIL = false;
bool _userExists_onWL = false;
bool _userExists_onWL2 = false;
bool _maillingListExists = false;
bool _maillingListExistsRes;
try
{
using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr))
{
//Checking if mail is Existing on I-Send under UserID 5078
#region Check if user\mail exists on WL
SendMsgService _svc = new SendMsgService();
_svc.CheckIfUserExistsByMail2(5078, true, ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text, out _userExists_onWL, out _userExists_onWL2);
#endregion
//Checking if MailingList Exists on WL
#region Check if Mail List Exists on WL
SendMsgList[] _mailList;
SendMsgResults _tt;
if (GrpID != 0)
{
_svc.GetMailingListNames(5078, true, "IL110077", out _maillingListExistsRes, out _maillingListExistsRes, out _mailList, out _tt);
var q = _mailList.ToList <SendMsgList>().FirstOrDefault(x => x.ExistingListID == GrpID);
if (q != null && q.ExistingListID != 0)
{
_maillingListExists = true;
}
}
#endregion
//Checking if User\Mail existing in Israelikers.org
#region Check if user\mail exists on Israelikers.org
con.Open();
MySqlCommand _cmd = new MySqlCommand();
_cmd.Connection = con;
_cmd.CommandText = " SELECT * from tblUsers where EmailAddress ='" + ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text + "'";
MySqlDataReader _dr = _cmd.ExecuteReader();
if (_dr.HasRows)
{
_userExists_onIL = true;
}
_dr.Close();
con.Close();
#endregion
}
//acting time:
if (!_userExists_onIL)
{
MyFormHeb.IsInsertRedirect = false;
MyFormHeb.CalldoClick();
if (!_userExists_onWL)
{
Adduser_WL(5078, ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text, ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtFullName")).Text, GrpID == 0 || !_maillingListExists ? 19 : GrpID);
}
Session["Logged"] = "true";
Session["LoggedMail"] = ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text;
using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr))
{
con.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandText = "INSERT into tbljoinregisters (MissionName,CreationDate,GrpID,EmailAddress,FullName) Values ('" + MissionName + "',now(),'" + GrpID + "','" + ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text + "','" + ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtFullName")).Text + "')";
cmd.ExecuteNonQuery();
con.Close();
}
Response.Redirect("FacebookConnect.aspx?mail=" + ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text);
}
else
{
lblRegisterStatus.Text = "User Already Exists";
}
}
catch (Exception ex)
{
}
}
protected void Login_Click(object sender, EventArgs e)
{
bool _userExists_onIL = false;
bool _userExists_onWL = false;
bool _userExists_onWL2 = false;
bool _maillingListExists = false;
bool _maillingListExistsRes;
bool isSignIn = false;
try
{
using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr))
{
//Checking if mail is Existing on I-Send under UserID 5078
#region Check if user\mail exists on WL
SendMsgService _svc = new SendMsgService();
_svc.CheckIfUserExistsByMail2(5078, true, ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text, out _userExists_onWL, out _userExists_onWL2);
#endregion
//Checking if MailingList Exists on WL
#region Check if Mail List Exists on WL
SendMsgList[] _mailList;
SendMsgResults _tt;
// Get mailing lists
_svc.GetMailingListNames(5078, true, "IL110077", out _maillingListExistsRes, out _maillingListExistsRes, out _mailList, out _tt);
var SignInML = _mailList.ToList <SendMsgList>().FirstOrDefault(x => x.ExistingListID == 55);
if (SignInML == null)
{
isSignIn = true;
}
if (GrpID != 0)
{
var q = _mailList.ToList <SendMsgList>().FirstOrDefault(x => x.ExistingListID == GrpID);
if (q != null && q.ExistingListID != 0)
{
_maillingListExists = true;
}
}
#endregion
//Checking if User\Mail existing in Israelikers.org
#region Check if user\mail exists on Israelikers.org
con.Open();
MySqlCommand _cmd = new MySqlCommand();
_cmd.Connection = con;
_cmd.CommandText = string.Format(" SELECT UserID from tblUsers where LoginMailAddress='{0}' OR EmailAddress ='{0}'", ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text.Replace("'", "''"));
MySqlDataReader _dr = _cmd.ExecuteReader();
if (_dr.HasRows)
{
_userExists_onIL = true;
}
_dr.Close();
con.Close();
#endregion
}
//acting time:
if (!_userExists_onIL)
{
MyFormHeb.IsInsertRedirect = false;
string myguid = Guid.NewGuid().ToString();
((CMSTRHiddenField)MyFormHeb.FindControl("GuidMyHiddenField")).Value = myguid;
((CMSTRHiddenField)MyFormHeb.FindControl("SignByMailMyHiddenField")).Value = "true";
// save data
MyFormHeb.CalldoClick();
if (!isSignIn)
{
string regurl = siteDefaults.SiteUrl + "/login.aspx?guid=" + myguid + "&grp=" + (GrpID == 0 || !_maillingListExists ? 19 : GrpID);
Adduser_WL(5078, ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text, ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtFullName")).Text, GrpID == 0 || !_maillingListExists ? 19 : GrpID, regurl);
}
//Session["Logged"] = "true";
//Session["LoggedMail"] = ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text;
using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr))
{
con.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
if (!string.IsNullOrEmpty(Request.QueryString["Sender"]))
{
cmd.CommandText = String.Format("INSERT into tbljoinregisters (MissionName,CreationDate,GrpID,EmailAddress,FullName,Refferer) Values ('{0}',now(),'{1}','{2}','{3}','{4}')", MissionName, GrpID, ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text.Replace("'", "''"), ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtFullName")).Text.Replace("'", "''"), Request.QueryString["Sender"]);
}
else
{
cmd.CommandText = String.Format("INSERT into tbljoinregisters (MissionName,CreationDate,GrpID,EmailAddress,FullName) Values ('{0}',now(),'{1}','{2}','{3}')", MissionName, GrpID, ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text.Replace("'", "''"), ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtFullName")).Text.Replace("'", "''"));
}
cmd.ExecuteNonQuery();
con.Close();
}
Response.Redirect("joinusend.aspx?mail=" + ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text);
}
else
{
lblRegisterStatus.Text = "* User Already Exists";
}
}
catch (Exception ex)
{
}
}
protected void Login_Click(object sender, EventArgs e)
{
bool _userExists_onIL = false;
bool _userExists_onWL = false;
bool _userExists_onWL2 = false;
bool _maillingListExists = false;
bool _maillingListExistsRes;
bool isSignIn = false;
try
{
using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr))
{
//Checking if mail is Existing on I-Send under UserID 5078
#region Check if user\mail exists on WL
SendMsgService _svc = new SendMsgService();
_svc.CheckIfUserExistsByMail2(5078, true, ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text, out _userExists_onWL, out _userExists_onWL2);
#endregion
//Checking if MailingList Exists on WL
#region Check if Mail List Exists on WL
SendMsgList[] _mailList;
SendMsgResults _tt;
// Get mailing lists
_svc.GetMailingListNames(5078, true, "IL110077", out _maillingListExistsRes, out _maillingListExistsRes, out _mailList, out _tt);
var SignInML = _mailList.ToList <SendMsgList>().FirstOrDefault(x => x.ExistingListID == 55);
if (SignInML == null)
{
isSignIn = true;
}
if (GrpID != 0)
{
var q = _mailList.ToList <SendMsgList>().FirstOrDefault(x => x.ExistingListID == GrpID);
if (q != null && q.ExistingListID != 0)
{
_maillingListExists = true;
}
}
#endregion
//Checking if User\Mail existing in Israelikers.org
#region Check if user\mail exists on Israelikers.org
con.Open();
MySqlCommand _cmd = new MySqlCommand();
_cmd.Connection = con;
_cmd.CommandText = string.Format(" SELECT UserID from tblUsers where LoginMailAddress='{0}' OR EmailAddress ='{0}'", ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text.Replace("'", "''"));
MySqlDataReader _dr = _cmd.ExecuteReader();
if (_dr.HasRows)
{
_userExists_onIL = true;
}
_dr.Close();
con.Close();
#endregion
}
//acting time:
if (!_userExists_onIL)
{
MyFormHeb.IsInsertRedirect = false;
string myguid = Guid.NewGuid().ToString();
((CMSTRHiddenField)MyFormHeb.FindControl("GuidMyHiddenField")).Value = myguid;
((CMSTRHiddenField)MyFormHeb.FindControl("SignByMailMyHiddenField")).Value = "true";
// save data
MyFormHeb.CalldoClick();
if (!isSignIn)
{
string regurl = siteDefaults.SiteUrl + "/login.aspx?guid=" + myguid + "&grp=" + (GrpID == 0 || !_maillingListExists ? 19 : GrpID);
Adduser_WL(5078, ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text, ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtFullName")).Text, GrpID == 0 || !_maillingListExists ? 19 : GrpID, regurl);
if (!String.IsNullOrEmpty(Request.QueryString["special"]) && Request.QueryString["special"] == "true")
{
string SanFransiscoUrl = "https://panel.i-send.co.il/AddUserFromSite.aspx?eMail=" + ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text.Replace("'", "''") + "&1=" + ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtFullName")).Text.Replace("'", "''") + "&4=0&5=1&form=6557__d9fda905-f5aa-49ae-b6a6-e186f1f4613d";
HttpWebRequest webRequest = (HttpWebRequest)System.Net.WebRequest.Create(SanFransiscoUrl); //setting an httpWebRequest with the URL of the API
webRequest.Method = "GET"; //the type of method the API returns
webRequest.Timeout = 20000; //sets the timeout for the request
webRequest.ContentType = "application/x-www-form-urlencoded"; //the content type. most of the times it will be application/x-www-form-urlencoded
string responseData = "";
try
{
StreamReader MyStream = new StreamReader(webRequest.GetResponse().GetResponseStream()); //creating a stream reader to read the results from the API
responseData = MyStream.ReadToEnd(); //reading the result from the API into a string
}
catch (Exception ex)
{
}
}
}
//Session["Logged"] = "true";
//Session["LoggedMail"] = ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text;
using (MySqlConnection con = new MySqlConnection(siteDefaults.ConnStr))
{
con.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
if (!string.IsNullOrEmpty(Request.QueryString["Sender"]))
{
cmd.CommandText = String.Format("INSERT into tbljoinregisters (MissionName,CreationDate,GrpID,EmailAddress,FullName,Refferer) Values ('{0}',now(),'{1}','{2}','{3}','{4}')", MissionName, GrpID, ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text.Replace("'", "''"), ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtFullName")).Text.Replace("'", "''"), Request.QueryString["Sender"]);
}
else
{
cmd.CommandText = String.Format("INSERT into tbljoinregisters (MissionName,CreationDate,GrpID,EmailAddress,FullName) Values ('{0}',now(),'{1}','{2}','{3}')", MissionName, GrpID, ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text.Replace("'", "''"), ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtFullName")).Text.Replace("'", "''"));
}
cmd.ExecuteNonQuery();
con.Close();
}
Response.Redirect("joinusend.aspx?mail=" + ((ASP.controls_cmstrtextboxcontrol_ascx)MyFormHeb.FindControl("txtMail")).Text);
}
else
{
if (Request.QueryString != null && Request.QueryString["Exists"] != null && Request.QueryString["Exists"] == "true")
{
Response.Redirect(Request.AppRelativeCurrentExecutionFilePath + "?" + Request.QueryString + "#Header");
}
Response.Redirect(Request.AppRelativeCurrentExecutionFilePath + "?Exists=true&" + Request.QueryString + "#Header");
}
}
catch (Exception ex)
{
}
}
