private string[] Validate()
{
List <string> errors = new List <string>();
if (KeyName.Trim() == "")
{
errors.Add("Domain name cannot be blank.");
}
if (KeyName.ToLower().Trim() == "www")
{
errors.Add("Domain name not allowed.");
}
if (KeyName.ToLower().Trim() == "api")
{
errors.Add("Domain name not allowed.");
}
if (KeyName.ToLower().Trim() == "admin")
{
errors.Add("Domain name not allowed.");
}
if (KeyName.ToLower().Trim() == "master")
{
errors.Add("Domain name not allowed.");
}
if (!IsValidEmail(Email.Trim()))
{
errors.Add("Invalid email address.");
}
if (Password.Trim().Length < 6)
{
errors.Add("Password must be at least 6 characters.");
}
if (errors.Count == 0)
{
if (System.Text.RegularExpressions.Regex.Match(KeyName, "[A-Za-z0-9\\-_]{1,99}").Value != KeyName)
{
errors.Add("Domain name can only contain letters, numbers and hyphens.");
}
}
if (errors.Count == 0)
{
if (StreamingLiveLib.Site.LoadByKeyName(KeyName.ToLower().Trim()) != null)
{
errors.Add("Sorry, this domain name is already taken.");
}
}
if (errors.Count == 0)
{
if (StreamingLiveLib.User.LoadByEmail(Email) != null)
{
errors.Add("There is already an account registered with this email address. Log in instead.");
}
}
return(errors.ToArray());
}
public override int CreateTable()
{
var sqlStr = new StringBuilder();
sqlStr.AppendFormat("CREATE TABLE [{0}](", TableName);
foreach (var item in Properties)
{
try
{
if (!item.PropertyType.IsSealed)
{
continue;
}
sqlStr.AppendFormat("[{0}{1}] ", Prefix, item.Name);
if (item.PropertyType == typeof(string))
{
sqlStr.AppendFormat("{0}(max)", SqlDbTypes[item.PropertyType]);
}
else if (item.PropertyType.IsEnum)
{
sqlStr.AppendFormat("{0}", SqlDbTypes[typeof(Enum)]);
}
else
{
sqlStr.AppendFormat("{0}", SqlDbTypes[item.PropertyType]);
}
if (Prefix + item.Name.ToLower() == KeyName.ToLower())
{
sqlStr.Append(" PRIMARY KEY ");
if (item.PropertyType == typeof(Int64) || item.PropertyType == typeof(Int32) || item.PropertyType == typeof(Int16))
{
sqlStr.Append("IDENTITY");
}
}
sqlStr.Append(",");
}
catch { }
}
sqlStr.Append(")");
using (IDbConnection conn = new SqlConnection(GetConnectionString_Read(typeof(T))))
{
conn.Execute(sqlStr.ToString());
}
return(1);
}
public bool IsFilterMatch(string text)
{
// if no filter then...
if (string.IsNullOrEmpty(text))
{
// Show record.
return(true);
}
var value = text.ToLower();
return
((!string.IsNullOrEmpty(KeyName) && KeyName.ToLower().Contains(value)) ||
(!string.IsNullOrEmpty(KeyValue) && KeyValue.ToLower().Contains(value)) ||
(!string.IsNullOrEmpty(Replacement) && Replacement.ToLower().Contains(value)));
}
public IActionResult OnPostRegister()
{
if (ModelState.IsValid)
{
string[] errors = Validate();
if (errors.Length == 0)
{
string webRoot = CachedData.Environment.WebRootPath;
StreamingLiveLib.Site s = new StreamingLiveLib.Site()
{
KeyName = KeyName.ToLower().Trim(), PrimaryColor = "#24b9ff", ContrastColor = "#ffffff", HeaderColor = "#24b9ff", HomePageUrl = "/", LogoUrl = "/data/master/logo.png", RegistrationDate = DateTime.UtcNow
};
s.Save();
StreamingLiveLib.User u = new StreamingLiveLib.User()
{
Email = Email.ToLower().Trim(), Password = StreamingLiveLib.User.HashPassword(Password.Trim()), DisplayName = "Admin"
};
u.ResetGuid = Guid.NewGuid().ToString();
u.Save();
StreamingLiveLib.Role r = new StreamingLiveLib.Role()
{
Name = "admin", SiteId = s.Id, UserId = u.Id
};
r.Save();
new StreamingLiveLib.Button()
{
SiteId = s.Id, Sort = 1, Text = "Resources", Url = "about:blank"
}.Save();
new StreamingLiveLib.Button()
{
SiteId = s.Id, Sort = 2, Text = "Give", Url = "about:blank"
}.Save();
new StreamingLiveLib.Tab()
{
SiteId = s.Id, Sort = 1, TabType = "chat", TabData = "", Icon = "far fa-comment", Text = "Chat", Url = ""
}.Save();
new StreamingLiveLib.Tab()
{
SiteId = s.Id, Sort = 2, TabType = "url", TabData = "", Icon = "fas fa-bible", Text = "Bible", Url = "https://www.bible.com/en-GB/bible/111/GEN.1.NIV"
}.Save();
new StreamingLiveLib.Tab()
{
SiteId = s.Id, Sort = 3, TabType = "prayer", TabData = "", Icon = "fas fa-praying-hands", Text = "Prayer", Url = ""
}.Save();
DateTime serviceTime = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day, 9 + 5, 0, 0).AddDays(1);
while (serviceTime.DayOfWeek != DayOfWeek.Sunday)
{
serviceTime = serviceTime.AddDays(1);
}
new StreamingLiveLib.Service()
{
SiteId = s.Id, ChatAfter = 15 * 60, ChatBefore = 15 * 60, Duration = 60 * 60, EarlyStart = 5 * 60, Provider = "youtube_watchparty", ProviderKey = "zFOfmAHFKNw", VideoUrl = "https://www.youtube.com/embed/zFOfmAHFKNw?autoplay=1&controls=0&showinfo=0&rel=0&modestbranding=1&disablekb=1", ServiceTime = serviceTime, TimezoneOffset = 300, Recurring = false
}.Save();
Utils.CopyS3(S3Client, "data/master/data.json", $"data/{s.KeyName}/data.json");
Utils.CopyS3(S3Client, "data/master/data.css", $"data/{s.KeyName}/data.css");
try
{
string body = "<a href=\"https://" + s.KeyName + ".streaminglive.church/\">https://" + s.KeyName + ".streaminglive.church/</a> - " + u.Email;
//StreamingLiveLib.Aws.EmailHelper.SendEmail(CachedData.SupportEmail, CachedData.SupportEmail, "New StreamingLive.church Registration", body);
}
catch { }
AppUser.Login(u);
var claims = new[] { new Claim(ClaimTypes.Name, u.ResetGuid), new Claim(ClaimTypes.Role, "User") };
var identity = new ClaimsIdentity(claims, CookieAuthenticationDefaults.AuthenticationScheme);
HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, new ClaimsPrincipal(identity));
return(Redirect("/cp/"));
}
else
{
OutputMessage = Utils.FormatMessage("<b>Error:</b><ul><li>" + String.Join("</li><li>", errors) + "</li></ul>", true);
return(Page());
}
}
else
{
return(Page());
}
}