public bool FollowerRegister(int id, string emailAddress, string firstName, string lastName, string company = "", string apikey = "")
{
if (User.Identity.Name != null)
if (!OPIMsys.Filters.ApiKeyHandler.ApiKeyToUser(apikey, Request))
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.Forbidden));
if (!Roles.IsUserInRole("ReportAPI") && !Roles.IsUserInRole("ApiReadUser"))
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.Forbidden));
AccountApiKey apiUser = OPIMsys.Filters.ApiKeyHandler.KeyToAccount(apikey, Request);
if (!Roles.IsUserInRole("ReportAPI"))
if (id != apiUser.CompanyId)
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.Forbidden));
OPIMsys.RegexUtilities regUtil = new RegexUtilities();
if (!regUtil.IsValidEmail(emailAddress))
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.Conflict));
if(db.CompanyFollowers.Where(a => a.EmailAddress == emailAddress).Count() > 0)
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.Conflict));
Company comp = db.Companies.Find(id);
if (comp == null)
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
CompanyFollower follow = new CompanyFollower();
follow.EmailAddress = emailAddress;
follow.FirstName = firstName;
follow.LastName = lastName;
follow.CompanyName = company;
comp.CompanyFollowers.Add(follow);
db.SaveChanges();
return true;
}
private bool ValidarCampos()
{
if (iDTipoDocumentoComboBox.SelectedIndex == -1)
{
errorProvider1.SetError(iDTipoDocumentoComboBox, "Debe seleccionar un tipo de documento");
iDTipoDocumentoComboBox.Focus();
return false;
}
errorProvider1.SetError(iDTipoDocumentoComboBox, "");
if (documentoTextBox.Text == "")
{
errorProvider1.SetError(documentoTextBox, "Debe ingresar un numero de documento");
documentoTextBox.Focus();
return false;
}
errorProvider1.SetError(documentoTextBox, "");
if (nombresContactoTextBox.Text == "")
{
errorProvider1.SetError(nombresContactoTextBox, "Debe ingresar un nombre de contacto");
nombresContactoTextBox.Focus();
return false;
}
errorProvider1.SetError(nombresContactoTextBox, "");
if (apellidosContactoTextBox.Text == "")
{
errorProvider1.SetError(apellidosContactoTextBox, "Debe ingresar un apellido de contacto");
apellidosContactoTextBox.Focus();
return false;
}
errorProvider1.SetError(apellidosContactoTextBox, "");
if (nombreTextBox.Text == "")
{
errorProvider1.SetError(nombreTextBox, "Debe ingresar un nombre de proveedor");
nombreTextBox.Focus();
return false;
}
errorProvider1.SetError(nombreTextBox, "");
if (correoTextBox.Text != "")
{
RegexUtilities regexUtilities = new RegexUtilities();
if(!regexUtilities.IsValidEmail(correoTextBox.Text))
{
errorProvider1.SetError(correoTextBox, "Ingrese un correo valido");
correoTextBox.Focus();
return false;
}
errorProvider1.SetError(correoTextBox, "");
}
return true;
}
private void txtAdminEmail_LostFocus(object sender, EventArgs e)
{
RegexUtilities test = new RegexUtilities();
if(test.IsValidEmail(txtAdminEmail.Text))
{
lblEmailVerify.ForeColor = System.Drawing.Color.Green;
lblEmailVerify.Text = "Email accepted.";
Email_Validated = true;
}
else
{
lblEmailVerify.ForeColor = System.Drawing.Color.Red;
lblEmailVerify.Text = "A valid email is required";
Email_Validated = false;
}
}
protected void signUp_Click(object sender, EventArgs e)
{
if ((newPass.Text.Length != 0) && (newId.Text.Length != 0))
{
string sql2 = string.Format("SELECT Username FROM users WHERE Username = '******'", newId.Text);
var con = new DBCon();
var reader = con.Execute(sql2);
RegexUtilities util = new RegexUtilities();
bool check= util.IsValidEmail(newEmailid.Text);
if (!reader.HasRows && check)
{
con.Close();
string sql = string.Format("INSERT INTO users ([Username], [Password], [email]) VALUES ('{0}', '{1}', '{2}')", newId.Text, newPass.Text,newEmailid.Text);
con.Execute(sql);
checking.Text = "Account Created Successfully!";
con.Close();
}
else if(reader.HasRows)
{
checking.Text = "Username Already Exists!";
con.Close();
}
else if (!check)
{
checking.Text = "Invalid Email ID!";
con.Close();
}
con.Close();
}
else
{
checking.Text = "Invalid Username or Password!";
}
}
private bool validar()
{
if (tbx_nombres.TextLength == 0)
{
MessageBox.Show("Llene el campo Nombres.", "Información incompleta", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
else if (!RegexUtilities.IsOnlyAlphas(tbx_nombres.Text))
{
MessageBox.Show("El nombre no debe contener caracteres numéricos.", "Información inválida.", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
if (tbx_apellidos.TextLength == 0)
{
MessageBox.Show("Llene el campo Apellidos.", "Información incompleta", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
else if (!RegexUtilities.IsOnlyAlphas(tbx_apellidos.Text))
{
MessageBox.Show("El apellido no debe contener caracteres numéricos.", "Información inválida.", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
if (cbx_mesnac.SelectedIndex == -1)
{
MessageBox.Show("Seleccione su mes de nacimiento.", "Información incompleta.", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
if (cbx_dianac.SelectedIndex == -1)
{
MessageBox.Show("Seleccione su día de nacimiento.", "Información incompleta", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
if (tbx_añonac.TextLength == 0)
{
MessageBox.Show("Escriba su año de nacimiento.", "Información incompleta.", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
else if (!RegexUtilities.IsOnlyNumerics(tbx_añonac.Text))
{
MessageBox.Show("El año no debe contener letras.", "Información inválida", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
if (tbx_calle.TextLength == 0)
{
}
if (tbx_numext.TextLength == 0)
{
MessageBox.Show("Llene el número externo.", "Información inválida", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
else if (!RegexUtilities.IsOnlyNumerics(tbx_numext.Text))
{
MessageBox.Show("El número externo contiene letras.", "Información inválida", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
if (tbx_col.TextLength == 0)
{
MessageBox.Show("Llene la colonia de su domicilio.", "Información incompleta", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
if (tbx_estado.TextLength == 0)
{
MessageBox.Show("Llene el estado de su domicilio.", "Información incompleta", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
if (tbx_munic.TextLength == 0)
{
MessageBox.Show("Llene el municipio de su domicilio.", "Información incompleta", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
if (tbx_cp.TextLength == 0)
{
MessageBox.Show("Llene el código postal de su domicilio.", "Información incompleta", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
else if (!RegexUtilities.IsOnlyNumerics(tbx_cp.Text))
{
MessageBox.Show("El código postal no debe contener letras.", "Información inválida", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
if (tbx_curp.TextLength != 18)
{
MessageBox.Show("El CURP debe contener 18 caracteres.", "Información incompleta.", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
if (!RegexUtilities.IsValidEmail(tbx_email.Text))
{
MessageBox.Show("El correo electrónico no es válido.", "Información inválida.", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
if (tbx_password.TextLength != 8)
{
MessageBox.Show("La contraseña debe contener 8 caracteres.", "Información incompleta.", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return(false);
}
client = new ClienteClass(
id_emp,
tbx_nombres.Text,
tbx_apellidos.Text,
new DateTime(Convert.ToInt32(tbx_añonac.Text), Convert.ToInt32(cbx_mesnac.Text), Convert.ToInt32(cbx_dianac.Text)),
new Domicilio(tbx_calle.Text, tbx_numext.Text, tbx_numint.Text, tbx_col.Text, tbx_munic.Text, tbx_estado.Text, tbx_cp.Text),
tbx_curp.Text,
tbx_email.Text,
tbx_password.Text
);
return(true);
}
public void RegexUtilities_ValidateEmailForOnlyDot()
{
Assert.IsFalse(RegexUtilities.IsValidEmail(".com"));
}
public async Task<int> AddUser(string userEmail)
{
try
{
RegexUtilities util = new RegexUtilities();
if (util.IsValidEmail(userEmail))
{
var user = userRepository.Find(u => u.UserName == userEmail);
if (user != null)
{
return 3;
}
else
{
await SendMailHelper.SendInviteFromAdmin(userEmail);
return 2;
}
}
else
{
return 0;
}
}
catch
{
return 0;
}
}
private async void Register()
{
if (string.IsNullOrEmpty(this.FirstName))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.FirstNameValidation,
Languages.Accept);
return;
}
if (string.IsNullOrEmpty(this.LastName))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.LastNameValidation,
Languages.Accept);
return;
}
if (string.IsNullOrEmpty(this.Email))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.EmailValidation,
Languages.Accept);
return;
}
if (!RegexUtilities.IsValidEmail(this.Email))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.EmailValidation2,
Languages.Accept);
return;
}
if (string.IsNullOrEmpty(this.Telephone))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.PhoneValidation,
Languages.Accept);
return;
}
if (string.IsNullOrEmpty(this.Password))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.PasswordValidation,
Languages.Accept);
return;
}
if (this.Password.Length < 6)
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.PasswordValidation2,
Languages.Accept);
return;
}
if (string.IsNullOrEmpty(this.Confirm))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.ConfirmValidation,
Languages.Accept);
return;
}
if (this.Password != this.Confirm)
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.ConfirmValidation2,
Languages.Accept);
return;
}
this.IsRunning = true;
this.IsEnabled = false;
var checkConnetion = await this.apiService.CheckConnection();
if (!checkConnetion.IsSuccess)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
checkConnetion.Message,
Languages.Accept);
return;
}
byte[] imageArray = null;
if (this.file != null)
{
imageArray = FilesHelper.ReadFully(this.file.GetStream());
}
var user = new User
{
Email = this.Email,
FirstName = this.FirstName,
LastName = this.LastName,
Telephone = this.Telephone,
ImageArray = imageArray,
UserTypeId = 1,
Password = this.Password,
};
var apiSecurity = Application.Current.Resources["APISecurity"].ToString();
var response = await this.apiService.Post(
apiSecurity,
"/api",
"/Users",
user);
if (!response.IsSuccess)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
response.Message,
Languages.Accept);
return;
}
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
Languages.ConfirmLabel,
Languages.UserRegisteredMessage,
Languages.Accept);
await Application.Current.MainPage.Navigation.PopAsync();
}
public void RegexUtilities_ValidateEmailForOnlyText()
{
Assert.IsFalse(RegexUtilities.IsValidEmail("abc"));
}
public void AddMedia()
{
List <string> opts = new List <string>()
{
"Song", "Video", "Back"
};
string sel = null;
while (true)
{
Console.Clear();
sel = RegexUtilities.GetMenu(opts);
if (sel == opts[2])
{
return;
}
else if (sel == opts[0])
{
Console.Clear();
string fName = RegexUtilities.WriteData("File Name(with extension): ");
Console.Clear();
try
{
Song song = new Song(fName);
Spotflix.SaveMedia(song);
Console.WriteLine("Win");
Thread.Sleep(2000);
return;
}
catch (Exception)
{
Console.WriteLine("Fail");
Thread.Sleep(2000);
}
}
else if (sel == opts[1])
{
Console.Clear();
string fName = RegexUtilities.WriteData("File Name(with extension): ");
Console.Clear();
try
{
Video video = new Video(fName);
Spotflix.SaveMedia(video);
return;
}
catch (Exception)
{
Console.WriteLine("Fail");
Thread.Sleep(2000);
}
}
}
}
private async void Save()
{
if (string.IsNullOrEmpty(this.User.FirstName))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.FirstNameValidation,
Languages.Accept);
return;
}
if (string.IsNullOrEmpty(this.User.LastName))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.LastNameValidation,
Languages.Accept);
return;
}
if (string.IsNullOrEmpty(this.User.Email))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.EmailValidation,
Languages.Accept);
return;
}
if (!RegexUtilities.IsValidEmail(this.User.Email))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.EmailValidation2,
Languages.Accept);
return;
}
if (string.IsNullOrEmpty(this.User.Telephone))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.PhoneValidation,
Languages.Accept);
return;
}
this.IsRunning = true;
this.IsEnabled = false;
var checkConnetion = await this.apiService.CheckConnection();
if (!checkConnetion.IsSuccess)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
checkConnetion.Message,
Languages.Accept);
return;
}
var userDomain = Converter.ToUserDomain(this.User);
var apiSecurity = Application.Current.Resources["APISecurity"].ToString();
var response = await this.apiService.Post(
apiSecurity,
"/api/account",
"/customer",
userDomain);
if (!response.IsSuccess)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
response.Message,
Languages.Accept);
return;
}
var userApi = await this.apiService.GetUserByEmail(
apiSecurity,
"/api/account",
"/customer/getcustomer",
MainViewModel.GetInstance().Token.TokenType,
MainViewModel.GetInstance().Token.AccessToken,
MainViewModel.GetInstance().Token.UserName);
userApi.ImageArray = User.ImageArray;
var userLocal = Converter.ToUserLocal(userApi, Convert.ToInt32(MainViewModel.GetInstance().Token.UserName));
MainViewModel.GetInstance().User = userLocal;
MainViewModel.GetInstance().Login.registerDataService(userApi, MainViewModel.GetInstance().Token);
MainViewModel.GetInstance().ImageSource = ImageSource.FromStream(() => new MemoryStream(User.ImageArray));
this.dataService.Update(userLocal);
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
Languages.ConfirmLabel,
"Profile Updated Succefully",
Languages.Accept);
// await App.Navigator.PopAsync();
}
public void RegexUtilities_ValidateNullEmail()
{
Assert.IsFalse(RegexUtilities.IsValidEmail(null));
}
public static void Main(string[] args)
{
Console.CursorVisible = false;
RegexUtilities.LoadingScreen();
Thread.Sleep(3000);
List <string> start = new List <string>()
{
"Hello, and welcome to Spotflix!", "Log In", "Register", "Admin Log In", "Exit"
};
List <string> mainMenu = new List <string>()
{
"Menu", "Search", "Profile", "play", "Log out"
};
List <string> searchMenu = new List <string>()
{
"Search: ", "Filters", "Go!", "Back"
};
Console.Clear();
while (true)
{
RegexUtilities.LoadingScreen();
string selectedMenuItem = RegexUtilities.GetMenu(start);
if (selectedMenuItem == "Log In")
{
Console.Clear();
RegexUtilities.LoadingScreen();
string username = Spotflix.LogIn();
if (username != "")
{
User activeUser = Spotflix.GetUserDB[username];
while (true)
{
Console.Clear();
RegexUtilities.LoadingScreen();
selectedMenuItem = RegexUtilities.GetMenu(mainMenu);
if (selectedMenuItem == "Log out")
{
username = ""; break;
}
else if (selectedMenuItem == "Search")
{
while (true)
{
Console.Clear();
RegexUtilities.LoadingScreen();
selectedMenuItem = RegexUtilities.GetMenu(searchMenu);
string searchKey = "";
if (selectedMenuItem == searchMenu[0])
{
Console.Clear();
RegexUtilities.LoadingScreen();
searchMenu[0] = searchMenu[0].Substring(0, 8);
searchKey = RegexUtilities.WriteData(searchMenu[0]);
searchMenu[0] += searchKey;
Console.Clear();
}
else if (selectedMenuItem == searchMenu[2])
{
Filter fil = new Filter();
List <Media> results = fil.Search(searchKey);
if (results.Count > 0)
{
List <string> lsSe = new List <string>();
foreach (Media media in results)
{
lsSe.Add(media.GetMetadata().GetName());
}
lsSe.Add("Back");
while (true)
{
string selectMedia = RegexUtilities.GetMenu(lsSe);
if (selectMedia != "" && selectMedia != "Back")
{
int ind = lsSe.IndexOf(selectMedia);
Media media = results[ind];
if (media.GetType() == typeof(Song))
{
//display info
media.Play();
}
}
else if (selectMedia == "Back")
{
break;
}
}
}
}
else if (selectedMenuItem == searchMenu[3])
{
Console.Clear();
break;
}
}
}
else if (selectedMenuItem == "play")
{
//SoundPlayer player = new SoundPlayer();
//player.SoundLocation = "CSI.wav";
//player.Play();
//Player player = new Player();
//player.Open("CSI.wav");
//Thread.Sleep(30000);
//player.End();
}
}
}
}
else if (selectedMenuItem == "Register")
{
Console.Clear();
RegexUtilities.LoadingScreen();
Spotflix.Register();
Save(Spotflix.GetUserDB, Spotflix.GetMediaDB, Spotflix.GetPeopleDB, fileName);
}
else if (selectedMenuItem == "Admin Log In")
{
Console.Clear();
RegexUtilities.LoadingScreen();
string adm = Spotflix.AdminLogIn();
if (adm != "")
{
User administrator = Spotflix.GetUserDB[adm];
List <string> admMenu = new List <string>()
{
"Add Media", "a", "b", "c", "Log out"
};
while (true)
{
Console.Clear();
selectedMenuItem = RegexUtilities.GetMenu(admMenu);
if (selectedMenuItem == "Add Media")
{
Console.Clear();
RegexUtilities.LoadingScreen();
administrator.AddMedia();
Save(Spotflix.GetUserDB, Spotflix.GetMediaDB, Spotflix.GetPeopleDB, fileName);
Console.WriteLine("Ready");
Thread.Sleep(1000);
Console.Clear();
}
else if (selectedMenuItem == "Log out")
{
adm = "";
break;
}
else if (selectedMenuItem == "a")
{
}
Save(Spotflix.GetUserDB, Spotflix.GetMediaDB, Spotflix.GetPeopleDB, fileName);
}
}
else
{
Console.Clear();
RegexUtilities.LoadingScreen();
Console.WriteLine("You are not an administrator.");
break;
}
Save(Spotflix.GetUserDB, Spotflix.GetMediaDB, Spotflix.GetPeopleDB, fileName);
}
else if (selectedMenuItem == "Exit")
{
Save(Spotflix.GetUserDB, Spotflix.GetMediaDB, Spotflix.GetPeopleDB, fileName);
Environment.Exit(0);
}
Console.Clear();
}
/*
*
* string ans = Console.ReadLine();
*
* if (ans == "new")
* {
* Spotflix.Register();
* }
*
* else if (ans == "returning")
* {
* Console.WriteLine("Please write your username and password");
* Console.WriteLine("Username: "******"Password: "******"What do you want to do?");
* Console.WriteLine("a) Search for music or videos");
* Console.WriteLine("b) Go to playlists");
* Console.WriteLine("c) Look for other profiles");
* Console.WriteLine("");
* Console.WriteLine("d) Exit");
*
* string Ans = Console.ReadLine();
*
* if (Ans == "a")
* {
* Console.WriteLine("Please write the name of the song or video that you are looking for");
* string search = Console.ReadLine();
*
* Console.WriteLine("Do you wish to apply any filters? y/n");
* string a = Console.ReadLine();
*
* if (a == "y")
* {
* Console.WriteLine("Please choose one or more of the following filters:");
* Console.WriteLine("For songs:");
* Console.WriteLine("1) Name");
* Console.WriteLine("2) Artist");
* Console.WriteLine("3) Album");
* Console.WriteLine("4) Genre");
* Console.WriteLine("");
* Console.WriteLine("For videos:");
* Console.WriteLine("5) Name");
* Console.WriteLine("6) Creator");
* Console.WriteLine("7) Genre");
* Console.WriteLine("8) Category");
* Console.WriteLine("9) Director");
* Console.WriteLine("10) Studio");
*
* Console.WriteLine("Please type the numbers next to the desired filters");
* List<int> FilterList = new List<int>();
*
* string b1 = "y";
*
* while (b1 == "y")
* {
* Console.WriteLine("Filter:");
*
* int f1 = Convert.ToInt32(Console.ReadLine());
* FilterList.Add(f1);
*
* Console.WriteLine("Do you wish to add another filter? y/n");
* b1 = Console.ReadLine();
*
* if (FilterList.Count >= 9) //Security measure, so that nobody can write filters forever.
* {
* b1 = "n";
* }
* }
*
* Filter f2 = new Filter();
*
* foreach(object o in f2.FilteredSearch(FilterList, a))
* {
* Console.WriteLine(o);
* }
* }
*
*
* else if (a == "n")
* {
* Filter f2 = new Filter();
*
* foreach(object o in f2.Search(a))
* {
* Console.WriteLine(o);
* }
* }
*
*
* Console.WriteLine("What do you want to search for?");
* string a1 = Console.ReadLine();
*
* Filter f = new Filter();
* List<object> filtered = f.Search(a1);
*
* foreach (object o in filtered)
* {
* Console.WriteLine(o);
* }
* }
*
*
* else if (Ans == "B" || Ans == "b")
* {
* User u = Spotflix.GetUserDB[userN];
* Console.WriteLine("Do you wish to:");
* Console.WriteLine("A) Access your existing playlists?");
* Console.WriteLine("B) Create a new one?");
* string a1 = Console.ReadLine();
*
* if (a1 == "A" || a1 == "a")
* {
* foreach(Playlist p in u.GetPlaylist())
* {
* Console.WriteLine(p);
* }
*
* }
*
* else if(a1 == "B" || a1 == "b")
* {
* u.NewPlaylist();
* }
*
* else
* {
* Console.WriteLine("Invalid answer");
* }
*
* }
*
* else if (Ans == "C" || Ans == "c")
* {
* Console.WriteLine("Please state the name of the user you are looking for");
* string userSearch = Console.ReadLine();
* User u2 = Spotflix.GetUserDB[userSearch];
*
* try
* {
* u2 = Spotflix.GetUserDB[userSearch];
*
* }
*
* catch(Exception e)
* {
* Console.WriteLine("User not found");
* Console.WriteLine(e.Message);
* }
*
* Console.WriteLine("Here's the public info in the account");
* Console.WriteLine(" ");
*
* Console.WriteLine("Account name: ");
* Console.Write(u2.GetUsername());
* Console.WriteLine(" ");
*
* Console.WriteLine("List of playlists: ");
* Console.Write(u2.GetPlaylist());
* Console.WriteLine(" ");
*
* Console.WriteLine("List of people who follow this account: ");
* Console.Write(u2.GetFollowers());
* Console.WriteLine(" ");
*
* Console.WriteLine("List of people that this account follows: ");
* Console.WriteLine(u2.GetFollowing());
* Console.WriteLine(" ");
* }
*
* else
* {
* Console.WriteLine("Invalid Answer");
* }
*
* }
*
*
* else
* {
* Console.WriteLine("Wrong password");
* }
* }
*
*
* else
* {
* Console.WriteLine("User not found");
* }
*
* }
*
*/
}
public void RegexUtilities_ValidateEmailForTextContainingSpace()
{
Assert.IsFalse(RegexUtilities.IsValidEmail("abc [email protected]"));
}
public void RegexUtilities_IsValidEmail()
{
Assert.IsTrue(RegexUtilities.IsValidEmail("*****@*****.**"));
}
public void RegexUtilities_ValidateEmailForMultipleDots()
{
Assert.IsFalse(RegexUtilities.IsValidEmail(".abcgmail.com@"));
}
//[ValidateAntiForgeryToken]
public async Task<ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
RegexUtilities emailcheck = new RegexUtilities();
string email = model.Email;
var user = new ApplicationUser();
if (emailcheck.IsValidEmail(email)) // Checks whether email is valid in order to fix an error we had
{
user = new ApplicationUser()
{
UserName = model.Email,
Email = model.Email,
FirstName = model.FirstName,
LastName = model.LastName,
Institution = model.Institution,
Type = ApplicationUser.AccountType.Free,
Status = ApplicationUser.AccountStatus.Active
};
}
else
{
user = new ApplicationUser()
{
UserName = "******",//sets up a dummy model so it doesn't crash before showing validation message and error to user
Email = model.Email,
FirstName = model.FirstName,
LastName = model.LastName,
Institution = model.Institution,
Type = ApplicationUser.AccountType.Free,
Status = ApplicationUser.AccountStatus.Active
};
}
IdentityResult result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
UserManager.AddToRole(user.Id, "Learner");
ViewBag.Message = "Check your email and confirm your account, you must be confirmed "
+ "before you can log in.";
return RedirectToAction("Index", "Home");
}
else
{
AddErrors(result);
RedirectToAction("Index", "Profile");
}
}
// If we got this far, something failed, redisplay form
return View(model);
}
private async void Save()
{
if (string.IsNullOrEmpty(this.profileEmail.Name))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.LastNameValidation,
Languages.Accept);
return;
}
if (string.IsNullOrEmpty(this.profileEmail.Email))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.EmailValidation,
Languages.Accept);
return;
}
if (!RegexUtilities.IsValidEmail(this.profileEmail.Email))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.EmailValidation2,
Languages.Accept);
return;
}
this.IsRunning = true;
this.IsEnabled = false;
var checkConnetion = await this.apiService.CheckConnection();
if (!checkConnetion.IsSuccess)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
checkConnetion.Message,
Languages.Accept);
return;
}
var apiSecurity = Application.Current.Resources["APISecurity"].ToString();
var profile = await this.apiService.PutProfile(
apiSecurity,
"/api",
"/ProfileEmails/PutProfileEmail",
profileEmail);
this.IsRunning = false;
this.IsEnabled = true;
//Agregar a la lista
MainViewModel.GetInstance().ProfilesByEmail.updateProfile(profile);
await App.Navigator.PopAsync();
}
private bool CheckExcelSheet(string FileName, DataTable dt)
{
bool isValidExcelSheet = true;
try
{
#region local variables for processing
string StudentName = "";
string LastName = "";
string FatherName = "";
string MotherName = "";
DateTime DateOfBirth;
int Semester;
string Branch = "";
string Section = "";
string RollNo = "";
string ParentsMobileNo = "";
string StudentAddress = "";
string Gender = "";
string ParentsEmail = "";
#endregion
string path = string.Concat(Server.MapPath("~/Documents/" + FileName));
FileStream stream = File.Open(path, FileMode.Open, FileAccess.Read);
IExcelDataReader excelReader;
switch (Path.GetExtension(path).ToLower())
{
case ".xls":
//1. Reading from a binary Excel file ('97-2003 format; *.xls)
excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
break;
//...
case ".xlsx":
//2. Reading from a OpenXml Excel file (2007 format; *.xlsx)
excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
break;
//...
default:
return false;
}
//3. DataSet - Create column names from first row
excelReader.IsFirstRowAsColumnNames = true;
DataSet result = excelReader.AsDataSet();
//5. Data Reader methods
for (int i = 0; i < result.Tables[0].Rows.Count; i++)
{
//excelReader.GetInt32(0);
try
{
StudentName = valid(result.Tables[0].Rows[i], 0);
LastName = valid(result.Tables[0].Rows[i], 1);
FatherName = valid(result.Tables[0].Rows[i], 2);
MotherName = valid(result.Tables[0].Rows[i], 3);
DateOfBirth = DateTime.Parse(valid(result.Tables[0].Rows[i], 4));
if (Session["InstituteType"].ToString() == "S")
{
Semester = 0;
}
else
{
Semester = int.Parse(valid(result.Tables[0].Rows[i], 5));
}
Branch = valid(result.Tables[0].Rows[i], 6);
Section = valid(result.Tables[0].Rows[i], 7);
RollNo = valid(result.Tables[0].Rows[i], 8);
ParentsMobileNo = valid(result.Tables[0].Rows[i], 9);
StudentAddress = valid(result.Tables[0].Rows[i], 10);
Gender = valid(result.Tables[0].Rows[i], 11);
ParentsEmail = valid(result.Tables[0].Rows[i], 12);
if (excelReader[0] == DBNull.Value)
break;
string BranchId = new BOStudentRegistration().GetBranchId(valid(result.Tables[0].Rows[i], 6));
if (BranchId == string.Empty)
{
//string script = @"document.getElementById('" + dvUploadStatus.ClientID + "').innerHTML='Invalid Branch Name found in Branch column!!; it should be number!!';var elem = document.createElement('img');elem.setAttribute('src', 'cross.jpg');document.getElementById('" + dvUploadStatus.ClientID + "').appendChild(elem);document.getElementById('" + dvUploadStatus.ClientID + "').style.color = 'Red';document.getElementById('" + dvUploadStatus.ClientID + "').style.fontSize = '1em' ;document.getElementById('" + dvUploadStatus.ClientID + "').style.fontWeight = 'bold' ;setTimeout(function(){document.getElementById('" + dvUploadStatus.ClientID + "').style.display='none';},4500);";
//ScriptManager.RegisterStartupScript(this, this.GetType(), "script", script, true);
string alertScript = "jAlert('Invalid Branch Name found in Branch column', 'Campus2Caretaker');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript", alertScript, true);
return false;
}
int intvalue;
if (!int.TryParse(Semester.ToString(), out intvalue))
{
//string script = @"document.getElementById('" + dvUploadStatus.ClientID + "').innerHTML='Invalid Semester Id found in Semester column!!; it should be numeric!!';var elem = document.createElement('img');elem.setAttribute('src', 'cross.jpg');document.getElementById('" + dvUploadStatus.ClientID + "').appendChild(elem);document.getElementById('" + dvUploadStatus.ClientID + "').style.color = 'Red';document.getElementById('" + dvUploadStatus.ClientID + "').style.fontSize = '1em' ;document.getElementById('" + dvUploadStatus.ClientID + "').style.fontWeight = 'bold' ;setTimeout(function(){document.getElementById('" + dvUploadStatus.ClientID + "').style.display='none';},4500);";
//ScriptManager.RegisterStartupScript(this, this.GetType(), "script", script, true); isValidExcelSheet = false;
string alertScript = "jAlert('Invalid Semester Id found in Semester column', 'Campus2Caretaker');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript", alertScript, true);
isValidExcelSheet = false;
break;
}
DateTime dateTimeValue;
if (!DateTime.TryParse(DateOfBirth.ToString(), out dateTimeValue))
{
//string script = @"document.getElementById('" + dvUploadStatus.ClientID + "').innerHTML='Invalid DOB found in DOB column!!; it should be numeric!!';var elem = document.createElement('img');elem.setAttribute('src', 'cross.jpg');document.getElementById('" + dvUploadStatus.ClientID + "').appendChild(elem);document.getElementById('" + dvUploadStatus.ClientID + "').style.color = 'Red';document.getElementById('" + dvUploadStatus.ClientID + "').style.fontSize = '1em' ;document.getElementById('" + dvUploadStatus.ClientID + "').style.fontWeight = 'bold' ;setTimeout(function(){document.getElementById('" + dvUploadStatus.ClientID + "').style.display='none';},4500);";
//ScriptManager.RegisterStartupScript(this, this.GetType(), "script", script, true);
string alertScript = "jAlert('Invalid DOB found in DOB column', 'Campus2Caretaker');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript", alertScript, true);
isValidExcelSheet = false;
break;
}
string genderValue = valid(result.Tables[0].Rows[i], 11);
if (genderValue == string.Empty || (genderValue != "Male" && genderValue != "Female"))
{
//string script = @"document.getElementById('" + dvUploadStatus.ClientID + "').innerHTML='Invalid Gender found in Gender column!!; it should be Male or Female!!';var elem = document.createElement('img');elem.setAttribute('src', 'cross.jpg');document.getElementById('" + dvUploadStatus.ClientID + "').appendChild(elem);document.getElementById('" + dvUploadStatus.ClientID + "').style.color = 'Red';document.getElementById('" + dvUploadStatus.ClientID + "').style.fontSize = '1em' ;document.getElementById('" + dvUploadStatus.ClientID + "').style.fontWeight = 'bold' ;setTimeout(function(){document.getElementById('" + dvUploadStatus.ClientID + "').style.display='none';},4500);";
//ScriptManager.RegisterStartupScript(this, this.GetType(), "script", script, true);
string alertScript = "jAlert('Invalid Gender found in Gender column', 'Campus2Caretaker');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript", alertScript, true);
return false;
}
string parentsEmailValue = valid(result.Tables[0].Rows[i], 12);
RegexUtilities util = new RegexUtilities();
if (parentsEmailValue != string.Empty)
{
if (!util.IsValidEmail(parentsEmailValue))
{
//string script = @"document.getElementById('" + dvUploadStatus.ClientID + "').innerHTML='Invalid email found in parents email column!!';var elem = document.createElement('img');elem.setAttribute('src', 'cross.jpg');document.getElementById('" + dvUploadStatus.ClientID + "').appendChild(elem);document.getElementById('" + dvUploadStatus.ClientID + "').style.color = 'Red';document.getElementById('" + dvUploadStatus.ClientID + "').style.fontSize = '1em' ;document.getElementById('" + dvUploadStatus.ClientID + "').style.fontWeight = 'bold' ;setTimeout(function(){document.getElementById('" + dvUploadStatus.ClientID + "').style.display='none';},4500);";
//ScriptManager.RegisterStartupScript(this, this.GetType(), "script", script, true);
string alertScript = "jAlert('Invalid email found in parents email column', 'Campus2Caretaker');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript", alertScript, true);
return false;
}
}
//Here using this method we are inserting the data into a temporary DataTable
dt.Rows.Add(StudentName, LastName, FatherName, MotherName, DateOfBirth, Semester, BranchId, Section, RollNo, ParentsMobileNo, StudentAddress, Gender, ParentsEmail);
}
catch (Exception err)
{
//string script = @"document.getElementById('" + dvUploadStatus.ClientID + "').innerHTML='Invalid data found in uploaded excel!!';var elem = document.createElement('img');elem.setAttribute('src', 'cross.jpg');document.getElementById('" + dvUploadStatus.ClientID + "').appendChild(elem);document.getElementById('" + dvUploadStatus.ClientID + "').style.color = 'Red';document.getElementById('" + dvUploadStatus.ClientID + "').style.fontSize = '1em' ;document.getElementById('" + dvUploadStatus.ClientID + "').style.fontWeight = 'bold' ;setTimeout(function(){document.getElementById('" + dvUploadStatus.ClientID + "').style.display='none';},4500);";
//ScriptManager.RegisterStartupScript(this, this.GetType(), "script", script, true); isValidExcelSheet = false;
string alertScript = "jAlert('Invalid data found in uploaded excel', 'Campus2Caretaker');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript", alertScript, true);
isValidExcelSheet = false;
break;
}
}
//6. Free resources (IExcelDataReader is IDisposable)
excelReader.Close();
}
catch (DataException ee)
{
//string script = @"document.getElementById('" + dvUploadStatus.ClientID + "').innerHTML='" + ee.Message + "';var elem = document.createElement('img');elem.setAttribute('src', 'cross.jpg');document.getElementById('" + dvUploadStatus.ClientID + "').appendChild(elem);document.getElementById('" + dvUploadStatus.ClientID + "').style.color = 'Red';document.getElementById('" + dvUploadStatus.ClientID + "').style.fontSize = '1em' ;document.getElementById('" + dvUploadStatus.ClientID + "').style.fontWeight = 'bold' ;setTimeout(function(){document.getElementById('" + dvUploadStatus.ClientID + "').style.display='none';},4500);";
//ScriptManager.RegisterStartupScript(this, this.GetType(), "script", script, true);
string alertScript = "jAlert('"+ ee.Message +"', 'Campus2Caretaker');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript", alertScript, true);
isValidExcelSheet = false;
}
finally
{
}
return isValidExcelSheet;
}
private async void SaveProfileSpotify()
{
if (string.IsNullOrEmpty(this.Name))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.NameValidation,
Languages.Accept);
return;
}
if (string.IsNullOrEmpty(this.Link))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.LinkValidation,
Languages.Accept);
return;
}
if (!RegexUtilities.IsValidURL(this.Link))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.LinkValidation,
Languages.Accept);
return;
}
this.IsRunning = true;
this.IsEnabled = false;
var checkConnetion = await this.apiService.CheckConnection();
if (!checkConnetion.IsSuccess)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
checkConnetion.Message,
Languages.Accept);
return;
}
var mainViewModel = MainViewModel.GetInstance();
var profileSpotify = new ProfileSM
{
ProfileName = this.Name,
link = this.Link,
UserId = mainViewModel.User.UserId,
Exist = false,
RedSocialId = 8
};
var apiSecurity = Application.Current.Resources["APISecurity"].ToString();
var profileSM = await this.apiService.Post(
apiSecurity,
"/api",
"/ProfileSMs",
profileSpotify);
if (profileSM == default)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.ErrorAddProfile,
Languages.Accept);
return;
}
var ProfileLocal = new Profile
{
UserId = mainViewModel.User.UserId,
ProfileName = profileSM.ProfileName,
value = profileSM.link,
ProfileType = "Spotify",
Logo = "spotify2",
ProfileId = profileSM.ProfileMSId,
};
using (var conn = new SQLite.SQLiteConnection(App.root_db))
{
conn.CreateTable <Profile>();
conn.Insert(ProfileLocal);
}
this.IsRunning = false;
this.IsEnabled = true;
//Agregar a la lista
if (mainViewModel.ProfilesBYPESM != null)
{
mainViewModel.ProfilesBYPESM.addProfileSM(profileSM);
mainViewModel.ListOfNetworks.addProfileSM(profileSM);
}
else
{
mainViewModel.ProfilesBySpotify.addProfile(profileSM);
}
this.Name = string.Empty;
this.Link = string.Empty;
if (mainViewModel.ProfilesBYPESM != null)
{
await PopupNavigation.Instance.PopAsync();
}
else
{
await App.Navigator.PopAsync();
}
}
async void Save()
{
if (string.IsNullOrEmpty(FirstName))
{
await dialogService.ShowMessage(
"Error",
"You must enter a first name.");
return;
}
if (string.IsNullOrEmpty(LastName))
{
await dialogService.ShowMessage(
"Error",
"You must enter a last name.");
return;
}
if (string.IsNullOrEmpty(Email))
{
await dialogService.ShowMessage(
"Error",
"You must enter a email.");
return;
}
if (!RegexUtilities.IsValidEmail(Email))
{
await dialogService.ShowMessage(
"Error",
"You must enter a valid email.");
return;
}
if (string.IsNullOrEmpty(Password))
{
await dialogService.ShowMessage(
"Error",
"You must enter a password.");
return;
}
if (Password.Length < 6)
{
await dialogService.ShowMessage(
"Error",
"The password must have at least 6 characters length.");
return;
}
if (string.IsNullOrEmpty(Confirm))
{
await dialogService.ShowMessage(
"Error",
"You must enter a password confirm.");
return;
}
if (!Password.Equals(Confirm))
{
await dialogService.ShowMessage(
"Error",
"The password and confirm, does not match.");
return;
}
IsRunning = true;
IsEnabled = false;
var connection = await apiService.CheckConnection();
if (!connection.IsSuccess)
{
IsRunning = false;
IsEnabled = true;
await dialogService.ShowMessage("Error", connection.Message);
return;
}
var urlAPI = Application.Current.Resources["URLAPI"].ToString();
var customer = new Customer
{
Address = Address,
CustomerType = 1,
Email = Email,
FirstName = FirstName,
LastName = LastName,
Password = Password,
Phone = Phone,
};
var response = await apiService.Post(
urlAPI,
"/api",
"/Customers",
customer);
if (!response.IsSuccess)
{
IsRunning = false;
IsEnabled = true;
await dialogService.ShowMessage(
"Error",
response.Message);
return;
}
var response2 = await apiService.GetToken(
urlAPI,
Email,
Password);
if (response2 == null)
{
IsRunning = false;
IsEnabled = true;
await dialogService.ShowMessage(
"Error",
"The service is not available, please try latter.");
Password = null;
return;
}
if (string.IsNullOrEmpty(response2.AccessToken))
{
IsRunning = false;
IsEnabled = true;
await dialogService.ShowMessage(
"Error",
response2.ErrorDescription);
Password = null;
return;
}
var mainViewModel = MainViewModel.GetInstance();
mainViewModel.Token = response2;
mainViewModel.RegisterDevice();
mainViewModel.Categories = new CategoriesViewModel();
await navigationService.BackOnLogin();
navigationService.SetMainPage("MasterView");
IsRunning = false;
IsEnabled = true;
}
private async void CambiarPassword()
{
if (string.IsNullOrEmpty(this.ActualPassword))
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
"Error",
"Introduzca su Contraseña.",
"Aceptar");
return;
}
if (this.ActualPassword.Length < 8 ||
this.ActualPassword.Length > 20)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
"Error",
"La Contraseña debe tener entre 8 y 20 caracteres.",
"Aceptar");
return;
}
if (!RegexUtilities.ValidarPassword(this.ActualPassword))
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
"Error",
"Las contraseñas deben tener al menos un carácter que no sea una letra ni un dígito, " +
"al menos una letra en minúscula ('a'-'z') y al menos una letra en mayúscula ('A'-'Z').",
"Aceptar");
return;
}
if (this.ActualPassword != MainViewModel.GetInstance().Componente.Password)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
"Error",
"La contraseña actual es incorrecta.",
"Aceptar");
return;
}
if (string.IsNullOrEmpty(this.NuevoPassword))
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
"Error",
"Introduzca su nueva Contraseña.",
"Aceptar");
return;
}
if (this.NuevoPassword.Length < 8 ||
this.NuevoPassword.Length > 20)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
"Error",
"La nueva Contraseña debe tener entre 8 y 20 caracteres.",
"Aceptar");
return;
}
if (!RegexUtilities.ValidarPassword(this.NuevoPassword))
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
"Error",
"Las contraseñas deben tener al menos un carácter que no sea una letra ni un dígito, " +
"al menos una letra en minúscula ('a'-'z') y al menos una letra en mayúscula ('A'-'Z').",
"Aceptar");
return;
}
if (this.NuevoPassword != this.Confirmacion)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
"Error",
"La nueva Contraseña y la confirmación no coinciden.",
"Aceptar");
return;
}
this.IsRunning = true;
this.IsEnabled = false;
var connection = await this.apiService.CheckConnection();
if (!connection.IsSuccess)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
"Error",
connection.Message,
"Aceptar");
return;
}
var request = new CambiarPasswordRequest
{
ActualPassword = this.ActualPassword,
Email = MainViewModel.GetInstance().Componente.Email,
NuevoPassword = this.NuevoPassword,
};
var apiBase = Application.Current.Resources["APIBase"].ToString();
var response = await this.apiService.CambiarPassword(
apiBase,
"/api",
"/Componentes/CambiarPassword",
MainViewModel.GetInstance().Token.TokenType,
MainViewModel.GetInstance().Token.AccessToken,
request);
if (!response.IsSuccess)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
"Error",
"No se pudo cambiar la contraseña. Intentalo más tarde.",
"Aceptar");
return;
}
MainViewModel.GetInstance().Componente.Password = this.NuevoPassword;
this.dataService.Update(MainViewModel.GetInstance().Componente);
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
"Confirmación",
"Contraseña modificada correctamente.",
"Aceptar");
await App.Navigator.PopAsync();
}
public async void Editar()
{
//Variable para la validacion de campos numericos
int num = 0;
//Obtener las imagenes del XAML
var imageFotoPerfil = this.FotoSource as FileImageSource;
var imageCredencialFrontal = this.CredencialFrontalSource as FileImageSource;
var imageCredencialPosterior = this.CredencialPosteriorSource as FileImageSource;
//Obtencion de las rutas de las imagenes de XAML
string fotoRuta = string.Empty;
string credencialFRuta = string.Empty;
string credencialPRuta = string.Empty;
//Verificaciones de las cadenas de ruta de imagenes de XAML
if (imageFotoPerfil == null)
{
fotoRuta = "0";
}
else
{
fotoRuta = "no_image";
}
if (imageCredencialFrontal == null)
{
credencialFRuta = "0";
}
else
{
credencialFRuta = "no_image";
}
if (imageCredencialPosterior == null)
{
credencialPRuta = "0";
}
else
{
credencialPRuta = "no_image";
}
//Validaciones
//Validacion de Imagen de foto de perfil
if (fotoRuta.Equals("no_image"))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Se necesita una foto de perfil",
"Aceptar");
}
//Validaciones de campos vacios
else if (this.Nombre.Equals(string.Empty))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Nombre Vacío",
"Aceptar");
}
else if (this.ApellidoPat.Equals(string.Empty))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Apellido Paterno Vacío",
"Aceptar");
}
else if (this.ApellidoMat.Equals(string.Empty))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Apellido Materno Vacío",
"Aceptar");
}
else if (this.SexoSelected.Equals(this.Sexos.ElementAt(0)))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Sexo Vacío",
"Aceptar");
}
else if (this.Edad.Equals(string.Empty))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Edad Vacío",
"Aceptar");
}
//Validacion de campo numerico
else if (!Int32.TryParse(this.Edad, out num))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo edad no es númerico",
"Aceptar");
}
else if (this.EstadoCivilSelected.Equals(this.EstadosCiviles.ElementAt(0)))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Estado Civil Vacío",
"Aceptar");
}
else if (this.Municipio.Equals(string.Empty))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Municipio Vacío",
"Aceptar");
}
else if (this.Region.Equals(string.Empty))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Región Vacío",
"Aceptar");
}
else if (!Int32.TryParse(this.Region, out num))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo región no es númerico",
"Aceptar");
}
/*else if (this.Zona.Equals(string.Empty))
* {
* await Application.Current.MainPage.DisplayAlert(
* "ERROR",
* "Campo Zona Vacío",
* "Aceptar");
* }
* else if (!Int32.TryParse(this.Zona, out num))
* {
* await Application.Current.MainPage.DisplayAlert(
* "ERROR",
* "Campo zona no es númerico",
* "Aceptar");
* }
* else if (this.Seccion.Equals(string.Empty))
* {
* await Application.Current.MainPage.DisplayAlert(
* "ERROR",
* "Campo Sección Vacío",
* "Aceptar");
* }
* else if (!Int32.TryParse(this.Seccion, out num))
* {
* await Application.Current.MainPage.DisplayAlert(
* "ERROR",
* "Campo sección no es númerico",
* "Aceptar");
* }*/
else if (this.Casilla.Equals(string.Empty))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Casilla Vacío",
"Aceptar");
}
else if (this.Promotor.Equals(string.Empty))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Promotor Vacío",
"Aceptar");
}
else if (this.Comunidad.Equals(string.Empty))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Comunidad Vacío",
"Aceptar");
}
else if (this.Domicilio.Equals(string.Empty))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Domicilio Vacío",
"Aceptar");
}
else if (this.TelefonoCelular.Equals(string.Empty))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Teléfono Celular Vacío",
"Aceptar");
}
//Validacion de tamaño de la cadena
else if (!this.TelefonoCelular.Length.Equals(14))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Teléfono Celular Vacío",
"Aceptar");
}
else if (this.Ocupacion.Equals(this.Ocupaciones.ElementAt(0)))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Ocupación Vacío",
"Aceptar");
}
else if (this.Escolaridad.Equals(this.Escolaridades.ElementAt(0)))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Escolaridad Vacío",
"Aceptar");
}
else if (this.Email.Equals(string.Empty))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Correo Electrónico Vacío",
"Aceptar");
}
else if (!RegexUtilities.ComprobarFormatoEmail(this.Email))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Formato Correo Electrónico Incorrecto",
"Aceptar");
}
else if (this.NumIne.Equals(string.Empty))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Número INE Vacío",
"Aceptar");
}
else if (!this.NumIne.Length.Equals(13))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
string.Format("Campo Número INE Tiene {0} dígitos y deben ser 13 dígitos", this.NumIne.Length),
"Aceptar");
}
else if (this.ClaveIne.Equals(string.Empty))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo Clave de Elector Vacío",
"Aceptar");
}
else if (!this.ClaveIne.Length.Equals(18))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
string.Format("Campo Clave de Elector Tiene {0} caracteres y deben ser 18 caracteres", this.ClaveIne.Length),
"Aceptar");
}
else if (this.Curp.Equals(string.Empty))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Campo CURP Vacío",
"Aceptar");
}
else if (!this.Curp.Length.Equals(18))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
string.Format("Campo CURP Tiene {0} caracteres y deben ser 18 caracteres", this.Curp.Length),
"Aceptar");
}
else if (credencialFRuta.Equals("no_image"))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Foto frontal de la credencial es obligatoria",
"Aceptar");
}
else if (credencialPRuta.Equals("no_image"))
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"Foto posterior de la credencial es obligatoria",
"Aceptar");
}
else
{
//Creacion de variables por default
string id = Settings.Id;
byte[] imageArray = null;
byte[] credencialFArray = null;
byte[] credencialPArray = null;
//Obtener las imagenes del promovido ya en base de datos
using (SQLiteConnection conn = new SQLiteConnection(App.DatabaseLocation))
{
var afiliado = conn.Table <Afiliado>().Where(a => a.Id.Equals(id)).FirstOrDefault();
imageArray = afiliado.Foto;
credencialFArray = afiliado.CredencialFrontal;
credencialPArray = afiliado.CredencialPosterior;
}
//convertir las imagenes en tipo byte[]
if (this.file != null)
{
imageArray = FilesHelper.ReadFully(this.file.GetStream());
File.Delete("/storage/emulated/0/Android/data/com.companyname.encuestahorizonte/files/Pictures/fotoPerfilEdit.jpg");
if (this.perfilTomado > 1)
{
for (int i = 1; i < this.perfilTomado; i++)
{
File.Delete(string.Format("/storage/emulated/0/Android/data/com.companyname.encuestahorizonte/files/Pictures/fotoPerfilEdit_{0}.jpg", i));
}
}
this.file.Dispose();
this.file = null;
}
if (this.credencialFrontalfile != null)
{
credencialFArray = FilesHelper.ReadFully(this.credencialFrontalfile.GetStream());
File.Delete("/storage/emulated/0/Android/data/com.companyname.encuestahorizonte/files/Pictures/testCredencialFEdit.jpg");
if (this.frontalTomado > 1)
{
for (int i = 1; i < this.frontalTomado; i++)
{
File.Delete(string.Format("/storage/emulated/0/Android/data/com.companyname.encuestahorizonte/files/Pictures/testCredencialFEdit_{0}.jpg", i));
}
}
this.credencialFrontalfile.Dispose();
this.credencialFrontalfile = null;
}
if (this.credencialPosteriorfile != null)
{
credencialPArray = FilesHelper.ReadFully(this.credencialPosteriorfile.GetStream());
File.Delete("/storage/emulated/0/Android/data/com.companyname.encuestahorizonte/files/Pictures/testCredencialPEdit.jpg");
if (this.posteriorTomado > 1)
{
for (int i = 1; i < this.posteriorTomado; i++)
{
File.Delete(string.Format("/storage/emulated/0/Android/data/com.companyname.encuestahorizonte/files/Pictures/testCredencialPEdit_{0}.jpg", i));
}
}
this.credencialPosteriorfile.Dispose();
this.credencialPosteriorfile = null;
}
this.perfilTomado = 0;
this.frontalTomado = 0;
this.posteriorTomado = 0;
int rows = 0;
try
{
//Actualizar el afiliado
using (SQLiteConnection conn = new SQLiteConnection(App.DatabaseLocation))
{
conn.CreateTable <Afiliado>();
this.Afiliado = new Afiliado();
this.Afiliado = this.helperAfiliado.Llenado(id, this.Municipio, this.Region, this.Zona, this.Seccion, this.Casilla, this.Promotor, this.Comunidad,
this.Nombre, this.NombreSegundo, this.ApellidoPat, this.ApellidoMat, this.SexoSelected, this.Edad, this.EstadoCivilSelected, this.Domicilio,
this.TelefonoFijo, this.TelefonoCelular, this.TelefonoAlter, this.Ocupacion, this.Escolaridad, this.Email, this.NumIne, this.ClaveIne, this.Curp,
this.Facebook, this.Observacion, Settings.IdUsuario, imageArray, credencialFArray, credencialPArray);
rows += conn.Update(this.Afiliado);
}
}
catch (Exception e)
{
//Mensaje de error con la base de datos
await Application.Current.MainPage.DisplayAlert(
"ERROR",
e.Message + "\n\nVolver a intentar",
"Aceptar");
}
if (rows > 0)
{
await Application.Current.MainPage.DisplayAlert(
"EXITO",
"Actualización Exitosa",
"Aceptar");
}
else
{
await Application.Current.MainPage.DisplayAlert(
"ERROR",
"La Actualización Falló",
"Aceptar");
}
}
}
private void ejecutar()
{
RegexUtilities util = new RegexUtilities();
if (ValidarCamposVacios())
{
MessageBox.Show("Debe completar todos los campos");
}
else if (ValidarTipoCabinaVacio())
{
}
else if (ValidaPisoNumeroTipo())
{
MessageBox.Show("Piso, numero y tipo de cabina repetido");
}
else
{
if (String.IsNullOrEmpty(this.IDCrucero))
{
//Validar ID
if (!CruceroFunc.EsValidoIdCrucero(this.txt_id.Text.Trim()))
{
MessageBox.Show("La identificación ya existe");
}
else
{
//Crear crucero
Crucero crucero = new Crucero();
Tipo_Servicio tser = new Tipo_Servicio();
Fabricante fab = new Fabricante();
ComboboxItem item = new ComboboxItem();
item = (ComboboxItem)cmb_fabricante.SelectedItem;
fab = (Fabricante)item.Value;
crucero.fab_id = fab.id;
item = (ComboboxItem)cmb_servicio.SelectedItem;
tser = (Tipo_Servicio)item.Value;
crucero.tser_id = tser.id;
crucero.mod = txt_modelo.Text.Trim();
crucero.id = txt_id.Text.Trim();
CruceroFunc.CrearCrucero(crucero);
for (int l = 0; l < this.dgv_cabinas.Rows.Count - 1; l++)
{
Cabinas_Crucero cabinaCrucero = new Cabinas_Crucero();
cabinaCrucero.cru_id = txt_id.Text.Trim();
cabinaCrucero.piso = Convert.ToInt32(dgv_cabinas.Rows[l].Cells["colPiso"].Value);
cabinaCrucero.numero = Convert.ToInt32(dgv_cabinas.Rows[l].Cells["colNumero"].Value);
cabinaCrucero.tcab_id = Cabina_crucerofunc.ObtenerIDTipo(Convert.ToString(dgv_cabinas.Rows[l].Cells["colTipoCabina"].Value));
Cabina_crucerofunc.CrearCabinaCrucero(cabinaCrucero);
}
MessageBox.Show("Crucero creado");
this.Close();
}
}
else
{
//Modificar crucero
Crucero crucero = new Crucero();
Tipo_Servicio tser = new Tipo_Servicio();
Fabricante fab = new Fabricante();
ComboboxItem item = new ComboboxItem();
item = (ComboboxItem)cmb_fabricante.SelectedItem;
fab = (Fabricante)item.Value;
crucero.fab_id = fab.id;
item = (ComboboxItem)cmb_servicio.SelectedItem;
tser = (Tipo_Servicio)item.Value;
crucero.tser_id = tser.id;
crucero.mod = txt_modelo.Text.Trim();
crucero.id = txt_id.Text.Trim();
CruceroFunc.ModificarCrucero(crucero);
//Cabinas del crucero
for (int l = 0; l < this.cantCabinas; l++)
{
Cabinas_Crucero cabinaCrucero = new Cabinas_Crucero();
cabinaCrucero.cru_id = txt_id.Text.Trim();
cabinaCrucero.piso = Convert.ToInt32(dgv_cabinas.Rows[l].Cells["colPiso"].Value);
cabinaCrucero.numero = Convert.ToInt32(dgv_cabinas.Rows[l].Cells["colNumero"].Value);
cabinaCrucero.tcab_id = Cabina_crucerofunc.ObtenerIDTipo(Convert.ToString(dgv_cabinas.Rows[l].Cells["colTipoCabina"].Value));
cabinaCrucero.id = Convert.ToInt32(dgv_cabinas.Rows[l].Cells["ColId"].Value);
Cabina_crucerofunc.ModificarCabinaCrucero(cabinaCrucero);
}
for (int l2 = this.cantCabinas; l2 < this.dgv_cabinas.Rows.Count - 1; l2++)
{
Cabinas_Crucero cabinaCrucero = new Cabinas_Crucero();
cabinaCrucero.cru_id = txt_id.Text.Trim();
cabinaCrucero.piso = Convert.ToInt32(dgv_cabinas.Rows[l2].Cells["colPiso"].Value);
cabinaCrucero.numero = Convert.ToInt32(dgv_cabinas.Rows[l2].Cells["colNumero"].Value);
cabinaCrucero.tcab_id = Cabina_crucerofunc.ObtenerIDTipo(Convert.ToString(dgv_cabinas.Rows[l2].Cells["colTipoCabina"].Value));
Cabina_crucerofunc.ModificarCabinaCrucero(cabinaCrucero);
}
MessageBox.Show("Crucero modificado");
this.Close();
}
}
}
public async Task <IActionResult> ImportProjectsFromExcel(ImportProjectsFromExcelViewModel viewModel)
{
#region Validate ViewModel
ViewBag.SemesterId = new SelectList(await _context.Semesters.OrderByDescending(s => s.StartedDate).ToListAsync(), "Id", "Name", viewModel.SemesterId);
if (!ModelState.IsValid)
{
return(View(viewModel));
}
if (!FormFileValidation.IsValidFileSizeLimit(viewModel.File, 268435456)) // 256 MiB
{
ModelState.AddModelError("File", _localizer["File size not greater than or equals 256 MiB."]);
return(View(viewModel));
}
var fileExtension = FormFileValidation.GetFileExtension(viewModel.File.FileName).ToLower();
if (!FormFileValidation.IsValidExcelFileExtension(fileExtension))
{
ModelState.AddModelError("File", _localizer["Invalid file extension(.xls, .xlsx)."]);
return(View(viewModel));
}
#endregion
//set sheet
ISheet sheet;
using (var stream = new MemoryStream())
{
viewModel.File.CopyTo(stream);
stream.Position = 0;
if (fileExtension == ".xls")
{
HSSFWorkbook workbook = new HSSFWorkbook(stream);
sheet = workbook.GetSheetAt(0);
}
else
{
XSSFWorkbook workbook = new XSSFWorkbook(stream);
sheet = workbook.GetSheetAt(0);
}
}
#region Read Sheet
var projects = new List <Project>();
var newStudents = new List <ApplicationUser>();
var newLecturers = new List <ApplicationUser>();
var regexStudentCode = new Regex(@"^\d{10}$");
var rowIndex = sheet.FirstRowNum + 1;
while (rowIndex <= sheet.LastRowNum)
{
IRow row = sheet.GetRow(rowIndex);
rowIndex = getMegreRowLastRowIndex(sheet, rowIndex) + 1;
if (row == null || row.Cells.All(d => d.CellType == CellType.Blank))
{
continue;
}
//check unique project
var uniqueId = row.GetCell(0).ToString();
if (_context.Projects.Any(p => p.UniqueId == uniqueId))
{
continue;
}
//Init project
var project = new Project
{
UniqueId = uniqueId,
ProjectTypeId = short.Parse(row.GetCell(1).ToString()),
Title = row.GetCell(2)?.ToString(),
Description = row.GetCell(3)?.ToString(),
FacultyId = short.Parse(row.GetCell(4).ToString()),
SemesterId = viewModel.SemesterId
};
//Add members to project
project.ProjectMembers = new List <ProjectMember>();
for (int localRowIndex = row.RowNum; localRowIndex < rowIndex; localRowIndex++)
{
IRow localRow = sheet.GetRow(localRowIndex);
var studentCode = localRow.GetCell(5)?.ToString();
if (!string.IsNullOrWhiteSpace(studentCode) && regexStudentCode.IsMatch(studentCode))
{
var user = newStudents.FirstOrDefault(u => u.UserName == studentCode) ?? await _userManager.FindByNameAsync(studentCode);
if (user == null)
{
user = new ApplicationUser
{
UserName = studentCode,
Student = new Student
{
ClassName = localRow.GetCell(6)?.ToString(),
StudentCode = studentCode,
},
LastName = localRow.GetCell(7)?.ToString(),
FirstName = localRow.GetCell(8)?.ToString(),
Email = localRow.GetCell(9)?.ToString(),
PhoneNumber = localRow.GetCell(10)?.ToString(),
};
if (RegexUtilities.IsValidEmail(user.Email))
{
user.EmailConfirmed = true;
}
else
{
user.Email = $"student{user.UserName}@myweb.com";
}
newStudents.Add(user);
}
project.ProjectMembers.Add(new ProjectMember
{
StudentId = user.Id,
Type = (ProjectMemberType)byte.Parse(localRow.GetCell(11)?.ToString() ?? "0")
});
}
}
//Add lecturers to project
project.ProjectLecturers = new List <ProjectLecturer>();
for (int localRowIndex = row.RowNum; localRowIndex < rowIndex; localRowIndex++)
{
IRow localRow = sheet.GetRow(localRowIndex);
var lecturerCode = localRow.GetCell(12)?.ToString();
if (!string.IsNullOrWhiteSpace(lecturerCode))
{
var user = newLecturers.FirstOrDefault(u => u.UserName == lecturerCode) ?? await _userManager.FindByNameAsync(lecturerCode);
if (user == null)
{
user = new ApplicationUser
{
UserName = lecturerCode,
Lecturer = new Lecturer
{
LecturerCode = lecturerCode,
},
LastName = localRow.GetCell(13)?.ToString(),
FirstName = localRow.GetCell(14)?.ToString(),
Email = localRow.GetCell(15)?.ToString(),
PhoneNumber = localRow.GetCell(16)?.ToString(),
};
if (RegexUtilities.IsValidEmail(user.Email))
{
user.EmailConfirmed = true;
}
else
{
user.Email = $"lecturer{user.UserName}@myweb.com";
}
newLecturers.Add(user);
}
project.ProjectLecturers.Add(new ProjectLecturer
{
LecturerId = user.Id,
Type = (ProjectLecturerType)byte.Parse(localRow.GetCell(17)?.ToString() ?? "0")
});
}
}
//Add weeks schedule
var schedules = new List <ProjectSchedule>();
var startedDate = new DateTime(viewModel.StartedDate.Value.Year, viewModel.StartedDate.Value.Month, viewModel.StartedDate.Value.Day);
if (!int.TryParse(row.GetCell(18)?.ToString(), out int weeks))
{
weeks = 10;
}
for (int i = 1; i <= weeks; i++)
{
var expiredDate = startedDate.AddDays(7);
schedules.Add(new ProjectSchedule
{
Name = $"Tuần {i}",
StartedDate = startedDate,
ExpiredDate = expiredDate
});
startedDate = expiredDate;
}
schedules.Reverse();
project.ProjectSchedules = schedules;
projects.Add(project);
}
#endregion
#region Insert To Database
using (var transaction = _context.Database.BeginTransaction())
{
try
{
foreach (var user in newStudents)
{
var result = await _userManager.CreateAsync(user, user.UserName);
if (result.Succeeded)
{
await _userManager.AddToRoleAsync(user, "Student");
}
}
foreach (var user in newLecturers)
{
var result = await _userManager.CreateAsync(user, user.UserName);
if (result.Succeeded)
{
await _userManager.AddToRoleAsync(user, "Lecturer");
}
}
await _context.Projects.AddRangeAsync(projects);
await _context.SaveChangesAsync();
await transaction.CommitAsync();
}
catch (TransactionException ex)
{
_logger.LogError(ex.Message);
await transaction.RollbackAsync();
ModelState.AddModelError(string.Empty, _localizer["Someone import file as same time with you. Try it later."]);
return(View());
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
await transaction.RollbackAsync();
ModelState.AddModelError(string.Empty, _localizer["Error {0}.", ex.Message]);
return(View());
}
}
#endregion
return(RedirectToAction(nameof(Index)));
}
public async Task <IActionResult> Update(string field, string value)
{
Console.WriteLine(field);
Console.WriteLine(value);
var username = User?.Identity.Name;
var user = await UserMgr.FindByNameAsync(username);
if (field == "firstName")
{
user.FirstName = value;
}
else if (field == "lastName")
{
user.LastName = value;
}
else if (field == "newPassword")
{
await UserMgr.RemovePasswordAsync(user);
await UserMgr.AddPasswordAsync(user, value);
}
else if (field == "newEmail")
{
Console.WriteLine(RegexUtilities.IsValidEmail(value));
if (RegexUtilities.IsValidEmail(value))
{
var checkEmail = await UserMgr.FindByEmailAsync(value);
if (checkEmail == null)
{
await UserMgr.SetEmailAsync(user, value);
var newUser = await UserMgr.FindByEmailAsync(value);
await SignInMgr.SignOutAsync();
await SignInMgr.SignInAsync(newUser, true);
user = newUser;
}
else
{
return(Ok("Email exists"));
}
}
else
{
return(Ok("Email invalid"));
}
}
IdentityResult result = await UserMgr.UpdateAsync(user);
Console.WriteLine(result.Succeeded + "<----");
if (result.Succeeded)
{
var userToSend = new UserModel();
userToSend.FirstName = user.FirstName;
userToSend.LastName = user.LastName;
userToSend.UserName = user.NormalizedEmail;
return(Ok(userToSend));
}
return(Ok("Accout update failed"));
}
async void Login()
{
if (string.IsNullOrEmpty(Email))
{
await dialogService.ShowMessage(
"Error",
"Debe ingresar un correo electrónico");
return;
}
if (!RegexUtilities.IsValidEmail(Email))
{
await dialogService.ShowMessage(
"Error",
"Debe ingresar un Correo válido.");
return;
}
if (string.IsNullOrEmpty(Password))
{
await dialogService.ShowMessage(
"Error",
"Debes ingresar una contraseña");
return;
}
IsRunning = true;
IsEnabled = false;
IsEnabledRegister = false;
var connection = await apiService.CheckConnection();
if (!connection.IsSuccess)
{
IsRunning = false;
IsEnabled = true;
IsEnabledRegister = true;
await dialogService.ShowMessage("Error", connection.Message);
return;
}
var urlAPI = Application.Current.Resources["URLAPI"].ToString();
var response = await apiService.GetBy <Usuario>(
urlAPI,
"/api",
"/Usuarios",
Email);
if (!response.IsSuccess)
{
IsRunning = false;
IsEnabled = true;
IsEnabledRegister = true;
await dialogService.ShowMessage(
"Error",
"Usuario o contraseña incorrecta");
Password = null;
return;
}
var usuario = (Usuario)response.Result;
if (Password != usuario.Password)
{
IsRunning = false;
IsEnabled = true;
IsEnabledRegister = true;
await dialogService.ShowMessage(
"Error",
"Usuario o contraseña incorrecta");
Password = null;
return;
}
Email = null;
Password = null;
IsRunning = false;
IsEnabled = true;
IsEnabledRegister = true;
var mainViewModel = MainViewModel.GetInstance();
mainViewModel.Usuario = usuario;
mainViewModel.Vehiculos = mainViewModel.Usuario.Vehiculos;
mainViewModel.MisReservas = mainViewModel.Usuario.Reservas;
//mainViewModel.Permisos = (List<Permiso>) otherResponse.Result;
mainViewModel.LoadMenu(usuario.Permisos);
mainViewModel.Perfil = new PerfilViewModel(mainViewModel.Usuario);
//mainViewModel.Carros = new VehiculoViewModel(mainViewModel.Vehiculos);
//mainViewModel.Reservas = new ReservaViewModel(mainViewModel.MisReservas);
navigationService.SetMainPage("MasterView");
}
private bool ValidateAll()
{
if (string.IsNullOrEmpty(NewEmployee.FirstName) || NewEmployee.FirstName.Length < 2 || NewEmployee.FirstName.Length > 25)
{
MessageBox.Show("Voornaam moet 2 tot 25 tekens bevatten");
return(false);
}
if (NewEmployee.NameAddition != null && NewEmployee.NameAddition.Length > 10)
{
MessageBox.Show("tussenvoegsel mag maximum 10 tekens bevatten");
return(false);
}
if (string.IsNullOrEmpty(NewEmployee.LastName) || NewEmployee.LastName.Length < 2 || NewEmployee.LastName.Length > 25)
{
MessageBox.Show("Achternaam moet 2 tot 25 tekens bevatten");
return(false);
}
if (!RegexUtilities.IsValidEmail(NewEmployee.Email))
{
MessageBox.Show("Email is geen geldig email");
return(false);
}
if (NewEmployee.MobileNumber != null && NewEmployee.MobileNumber.Length > 20)
{
MessageBox.Show("Gsm mag maximum 20 tekens bevatten");
return(false);
}
if (NewEmployee.PhoneNumber != null && NewEmployee.PhoneNumber.Length > 15)
{
MessageBox.Show("Telefoon mag maximum 15 tekens bevatten");
return(false);
}
if (string.IsNullOrEmpty(NewEmployee.EmpAddress.Street) || NewEmployee.EmpAddress.Street.Length < 2 || NewEmployee.EmpAddress.Street.Length > 30)
{
MessageBox.Show("Straat moet 2 tot 30 tekens bevatten");
return(false);
}
if (NewEmployee.EmpAddress.HouseNumber < 1 || NewEmployee.EmpAddress.HouseNumber > 3000)
{
MessageBox.Show("geen geldig huisnummer");
return(false);
}
if (NewEmployee.EmpAddress.HouseNumberAddition != null && NewEmployee.EmpAddress.HouseNumberAddition.Length > 8)
{
MessageBox.Show("Bus kan maximum 8 tekens bevatten");
return(false);
}
if (string.IsNullOrEmpty(NewEmployee.EmpAddress.Zipcode) || NewEmployee.EmpAddress.Zipcode.Length < 4 || NewEmployee.EmpAddress.Zipcode.Length > 12)
{
MessageBox.Show("postcode moet 4 tot maximum 12 tekens bevatten");
return(false);
}
if (string.IsNullOrEmpty(NewEmployee.EmpAddress.City) || NewEmployee.EmpAddress.City.Length < 4 || NewEmployee.EmpAddress.City.Length > 20)
{
MessageBox.Show("Gemeente moet 4 tot maximum 20 tekens bevatten");
return(false);
}
if (string.IsNullOrEmpty(NewEmployee.EmpAddress.Country) || NewEmployee.EmpAddress.Country.Length < 4 || NewEmployee.EmpAddress.Country.Length > 20)
{
MessageBox.Show("Land moet 4 tot maximum 20 tekens bevatten");
return(false);
}
if (string.IsNullOrEmpty(NewEmployee.PassPortID) || NewEmployee.PassPortID.Length < 4 || NewEmployee.PassPortID.Length > 15)
{
MessageBox.Show("rijksregisternummer moet 5 tot maximum 15 tekens bevatten");
return(false);
}
if (string.IsNullOrEmpty(NewEmployee.IBAN) || NewEmployee.IBAN.Length < 4 || NewEmployee.IBAN.Length > 15)
{
MessageBox.Show("IBAN moet 5 tot maximum 15 tekens bevatten");
return(false);
}
if (NewEmployee.Id_EmpDepartment < 1)
{
MessageBox.Show("Afdeling is niet ingevuld");
return(false);
}
if (NewEmployee.EmpContract.Id_EmpContractType < 1)
{
MessageBox.Show("contracttype is niet ingevuld");
return(false);
}
if (NewEmployee.EmpContract.Id_EmpContractStatuutType < 1)
{
MessageBox.Show("Statuut is niet ingevuld");
return(false);
}
if (NewEmployee.EmpContract.MonthSalary < 1)
{
MessageBox.Show("Ongeldig maandsalaris");
return(false);
}
if (NewEmployee.EmpContract.DateOfStart == null)
{
MessageBox.Show("Startdatum moet ingevuld zijn");
return(false);
}
if (IsNewMode)
{
//cijfers, grote en kleine letters, underscores en range
if (string.IsNullOrEmpty(NewEmployee.EmpAppAccount.UserName) ||
!new Regex("^[0-9A-Za-z_]{5,20}$").IsMatch(NewEmployee.EmpAppAccount.UserName))
{
MessageBox.Show("Geen geldig gebruikersnaam");
return(false);
}
if (string.IsNullOrEmpty(NewEmployee.EmpAppAccount.Password) ||
!new Regex(
"^"
+
"(?=.*[A-Z]+)" // [A-Z] betekend een hoofdletter, het plusje betekend '1 of meer'
+
"(?=.*[a-z]+)" // [a-z] betekend een kleine letter, het plusje betekend '1 of meer'
+
"(?=.*[0-9]+)" // [0-9] betekend een digital, het plusje betekend '1 of meer'
+
$"(?=.*[_]+)" //tekens tss aanhalingstekenz, het plusje betekend '1 of meer'
+
".{8,20}$" //kijken of het geheel 8tot 20 lang is,
).IsMatch(NewEmployee.EmpAppAccount.Password))
{
MessageBox.Show("Geen geldig Passwoord");
return(false);
}
}
return(true);
}
public void RegexUtilities_ValidateBlankEmail()
{
Assert.IsFalse(RegexUtilities.IsValidEmail(" "));
}
public async static void OpenClientEditDialog(Client client)
{
ClientEdit dialog = new ClientEdit(client);
var result = await dialog.ShowAsync();
if (result == ContentDialogResult.Primary)
{
string firstName = dialog.FirstName.Text;
string lastName = dialog.LastName.Text;
string email = dialog.Email.Text;
string phone = dialog.Phone.Text;
string street = dialog.Street.Text;
string number = dialog.HouseNumber.Text;
string box = dialog.Box.Text;
string city = dialog.City.Text;
string zip = dialog.Zip.Text;
string country = "";
string company = dialog.Company.Text;
string vat = dialog.VAT.Text;
if (dialog.Country.SelectedIndex >= 0)
{
country = dialog.Country.SelectedItem.ToString().Split(new string[] { ": " }, StringSplitOptions.None).Last();
}
if (string.IsNullOrWhiteSpace(firstName) || string.IsNullOrWhiteSpace(lastName))
{
MainWindow.DisplayThrowbackDialog("Client Edit Error", "You must fill in a first and list name"); return;
}
if (!RegexUtilities.IsValidEmail(email, false))
{
MainWindow.DisplayThrowbackDialog("Client Edit Error", "The given email address is not valid"); return;
}
if (!RegexUtilities.IsValidPhoneNumber(phone, false))
{
MainWindow.DisplayThrowbackDialog("Client Edit Error", "The given phone number is not valid"); return;
}
if (dialog.Type.SelectedIndex < 0)
{
MainWindow.DisplayThrowbackDialog("Client Edit Error", "You must select an account type"); return;
}
if (!Enum.TryParse(typeof(ClientType), dialog.Type.SelectedItem.ToString().ToUpper().Split(new string[] { ": " }, StringSplitOptions.None).Last(), out object objType))
{
MainWindow.DisplayThrowbackDialog("Client Edit Error", "Something went wrong with the client type, try agian"); return;
}
ClientType type = (ClientType)objType;
if (type == ClientType.PRIVATE || type == ClientType.VIP)
{
company = ""; vat = "";
}
client.Type = type;
client.FirstName = firstName;
client.LastName = lastName;
client.Email = email;
client.Phone = phone;
client.AddressStreet = street;
client.AddressNumber = number;
client.AddressBus = box;
client.AddressCity = city;
client.AddressZip = zip;
client.AddressCounty = country;
client.CompanyName = company;
client.VATNumber = vat;
RentalManager manager = new RentalManager(new UnitOfWork(new RentalContext()));
manager.UpdateClient(client);
MainWindow.DisplayThrowbackDialog("Client Saved", "All changes have been saved"); return;
}
}
public void RegexUtilities_ValidateEmailForTextAndSymbol()
{
Assert.IsFalse(RegexUtilities.IsValidEmail("abc@"));
}
private async void Save()
{
if (string.IsNullOrEmpty(this.User.FirstName))
{
await Application.Current.MainPage.DisplayAlert(
"Error",
"Não pode dejar o Nome vazio",
"Aceitar");
return;
}
if (string.IsNullOrEmpty(this.User.LastName))
{
await Application.Current.MainPage.DisplayAlert(
"Error",
"Não pode dejar o Sobrenome vazio",
"Aceitar");
return;
}
if (string.IsNullOrEmpty(this.User.Email))
{
await Application.Current.MainPage.DisplayAlert(
"Error",
"Não pode dejar o Email vazio",
"Aceitar");
return;
}
if (!RegexUtilities.IsValidEmail(this.User.Email))
{
await Application.Current.MainPage.DisplayAlert(
"Error",
"Não é o Email valido",
"Aceitar");
return;
}
if (string.IsNullOrEmpty(this.User.Telephone))
{
await Application.Current.MainPage.DisplayAlert(
"Error",
"Não pode dejar o Telephone vazio",
"Aceitar");
return;
}
this.IsRunning = true;
this.IsEnabled = false;
var checkConnetion = await this.apiService.CheckConnection();
if (!checkConnetion.IsSucces)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
"Error",
"Problemas de coneçao",
"Aceitar");
return;
}
byte[] imageArray = null;
if (this.file != null)
{
imageArray = FilesHelper.ReadFully(this.file.GetStream());
}
var userDomain = Converter.ToUserDomain(this.User, imageArray);
var apiSecurity = Application.Current.Resources["APISecurity"].ToString();
var response = await this.apiService.Put(
apiSecurity,
"/api",
"/Users",
MainViewModel.GetInstance().TokenType,
MainViewModel.GetInstance().Token,
userDomain);
if (!response.IsSucces)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
"Error",
response.Message,
"Aceitar");
return;
}
this.IsRunning = false;
this.IsEnabled = true;
await App.Navigator.PopAsync();
}
public void RegexUtilities_ValidateEmailForMultipleSymbols()
{
Assert.IsFalse(RegexUtilities.IsValidEmail("[email protected]@"));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string eventName = String.Format("{0}", Request.Form["EventName"]);
string eventCategory = String.Format("{0}", Request.Form["EventCategory"]);
string description = String.Format("{0}", Request.Form["description"]);
string address = String.Format("{0}", Request.Form["address"]);
string date = String.Format("{0}", Request.Form["date"]);
string time = String.Format("{0}", Request.Form["time"]);
string phone = String.Format("{0}", Request.Form["PhoneNumber"]);
string email = String.Format("{0}", Request.Form["email"]);
RegexUtilities util = new RegexUtilities();
//TODO connect to database and create the event
if(eventName.CompareTo("") == 0 || eventCategory.CompareTo("") == 0 ||
description.CompareTo("") == 0 || date.CompareTo("") == 0 ||
time.CompareTo("") == 0 || phone.CompareTo("") == 0 || email.CompareTo("") == 0)
{
Response.Write("Complete all fields");
return;
}
else if(!util.IsValidEmail(email))
{
Response.Write("That is not a valid email.");
return;
}
//opens the object connection
SqlConnection objConnection = new SqlConnection("Data Source=184.168.194.68;Initial Catalog=EventsDB;Integrated Security=False;User ID=kevin95duarte;password=sqlpassword1;Connect Timeout=60;Encrypt=False;Packet Size=4096;MultipleActiveResultSets=True");
try
{
objConnection.Open();
/*
pubprirso values:
0 public university event
1 private university event
2 RSO event
*/
int pubprirso = 0;
//Finds out if the user is a student, admin, or superadmin (denoted by pubprirso)
String strSQL = String.Format("select * from director D where D.directorID={0}", Session["studentID"]);
SqlCommand isDirector = new SqlCommand(strSQL, objConnection);
SqlDataReader isDirectorReader = isDirector.ExecuteReader();
if(isDirectorReader.Read())
{
pubprirso = 1;
}
strSQL = String.Format("select * from admin A where A.adminID={0}", Session["studentID"]);
SqlCommand isAdmin = new SqlCommand(strSQL, objConnection);
SqlDataReader isAdminReader = isAdmin.ExecuteReader();
if (isAdminReader.Read())
{
pubprirso = 2;
}
//checks if there is an event with the same name
strSQL = String.Format("select * from event E where E.name='{0}'", eventName);
SqlCommand eventExists = new SqlCommand(strSQL, objConnection);
SqlDataReader eventExistsReader = eventExists.ExecuteReader();
if(eventExistsReader.Read())
{
Response.Write("An event of that name already exists");
return;
}
//Create the event
strSQL = String.Format("INSERT INTO event(type, name, description, contact_phone, contact_email, date, time, pubprirso) VALUES('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', {7})",
eventCategory, eventName, description, phone, email, date, time, pubprirso);
SqlCommand insertEvent = new SqlCommand(strSQL, objConnection);
insertEvent.ExecuteNonQuery();
//gets the eventID
strSQL = String.Format("SELECT * FROM event E WHERE E.name='{0}'", eventName);
SqlCommand getEventID = new SqlCommand(strSQL, objConnection);
SqlDataReader eventReader = getEventID.ExecuteReader();
int eventID = -1;
if (eventReader.Read())
{
eventID = Convert.ToInt32(eventReader["eventID"]);
}
//gets the universityID
strSQL = String.Format("SELECT * FROM attends A WHERE A.studentID={0}", Session["studentID"]);
SqlCommand getUniversityID = new SqlCommand(strSQL, objConnection);
SqlDataReader universityReader = getUniversityID.ExecuteReader();
int universityID = -1;
if(universityReader.Read())
{
universityID = Convert.ToInt32(universityReader["universityID"]);
}
//creates the hostedBy relation between event and university
strSQL = String.Format("INSERT INTO hostedBy(universityID, eventID) VALUES({0}, {1})", universityID, eventID);
SqlCommand insertHosted = new SqlCommand(strSQL, objConnection);
insertHosted.ExecuteNonQuery();
//creates the organizedBy relation between rso and event
if(pubprirso == 2)
{
//gets the rsoID
strSQL = String.Format("SELECT * FROM manages M WHERE M.adminID={0}", Session["studentID"]);
SqlCommand getRSOID = new SqlCommand(strSQL, objConnection);
SqlDataReader rsoReader = getRSOID.ExecuteReader();
int rsoID = -1;
if (rsoReader.Read())
{
rsoID = Convert.ToInt32(rsoReader["rsoID"]);
}
strSQL = String.Format("INSERT INTO organizedBy(rsoID, eventID) VALUES({0}, {1})", rsoID, eventID);
SqlCommand insertOrganized = new SqlCommand(strSQL, objConnection);
insertOrganized.ExecuteNonQuery();
}
//creates the heldAt relationship for the event
strSQL = String.Format("INSERT INTO heldAt(eventID, address) VALUES({0},'{1}')", eventID, address);
SqlCommand insertHeldAt = new SqlCommand(strSQL, objConnection);
insertHeldAt.ExecuteNonQuery();
Response.Redirect("Events.aspx");
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
if (objConnection.State == ConnectionState.Open)
{
objConnection.Close();
}
}
}
private async void Save()
{
if (string.IsNullOrEmpty(this.User.FirstName))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.FirstNameValidation,
Languages.Accept);
return;
}
if (string.IsNullOrEmpty(this.User.LastName))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.LastNameValidation,
Languages.Accept);
return;
}
if (string.IsNullOrEmpty(this.User.Email))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.EmailValidation,
Languages.Accept);
return;
}
if (!RegexUtilities.IsValidEmail(this.User.Email))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.EmailValidation2,
Languages.Accept);
return;
}
if (string.IsNullOrEmpty(this.User.Telephone))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.PhoneValidation,
Languages.Accept);
return;
}
this.IsRunning = true;
this.IsEnabled = false;
var checkConnetion = await this.apiService.CheckConnection();
if (!checkConnetion.IsSuccess)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
checkConnetion.Message,
Languages.Accept);
return;
}
byte[] imageArray = null;
if (this.file != null)
{
imageArray = FilesHelper.ReadFully(this.file.GetStream());
}
var userDomain = Converter.ToUserDomain(this.User, imageArray);
var apiSecurity = Application.Current.Resources["APISecurity"].ToString();
var response = await this.apiService.Put(
apiSecurity,
"/api",
"/Users",
MainViewModel.GetInstance().Token.TokenType,
MainViewModel.GetInstance().Token.AccessToken,
userDomain);
if (!response.IsSuccess)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
response.Message,
Languages.Accept);
return;
}
var userApi = await this.apiService.GetUserByEmail(
apiSecurity,
"/api",
"/Users/GetUserByEmail",
MainViewModel.GetInstance().Token.TokenType,
MainViewModel.GetInstance().Token.AccessToken,
this.User.Email);
var userLocal = Converter.ToUserLocal(userApi);
MainViewModel.GetInstance().User = userLocal;
this.dataService.Update(userLocal);
this.IsRunning = false;
this.IsEnabled = true;
await App.Navigator.PopAsync();
}
async void Recovery()
{
if (string.IsNullOrEmpty(this.Email))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.EmailValidation,
Languages.Accept);
return;
}
if (!RegexUtilities.IsValidEmail(this.Email))
{
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
Languages.EmailValidation2,
Languages.Accept);
return;
}
IsRunning = true;
IsEnabled = false;
var checkConnetion = await apiService.CheckConnection();
if (!checkConnetion.IsSuccess)
{
this.IsRunning = false;
this.IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
Languages.Error,
checkConnetion.Message,
Languages.Accept);
return;
}
var apiSecurity = Application.Current.Resources["APISecurity"].ToString();
var response = await apiService.PasswordRecovery(
apiSecurity,
"/api",
"/Users/PasswordRecovery",
Email);
if (!response.IsSuccess)
{
IsRunning = false;
IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
"Error",
"We can't send the new password to this email.",
"OK");
return;
}
IsRunning = false;
IsEnabled = true;
await Application.Current.MainPage.DisplayAlert(
Languages.ConfirmLabel,
"Your new password has been sent to your email!",
Languages.Accept);
await Application.Current.MainPage.Navigation.PopAsync();
}
public async Task<int> AddRedactor(string redactorEmail)
{
try
{
RegexUtilities util = new RegexUtilities();
if (util.IsValidEmail(redactorEmail))
{
var user = User.Identity.Name;
var redactor = userRepository.Find(u => u.UserName == redactorEmail);
if (redactor != null)
{
var tRedactor = redactorsRepository.Find(r => r.UserId_Id == redactor.Id && r.Administrator_Id == User.Identity.GetUserId());
if (tRedactor != null)
{
return 3;
}
else
{
redactorsRepository.Add(new Model.TableRedactorModels { Administrator_Id = User.Identity.GetUserId(), IsLocked = false, IsReadOnly = false, TableId = -1, UserId_Id = redactor.Id });
await SendMailHelper.SendNoticeAboutAccess(redactorEmail, user);
return 1;
}
}
else
{
await SendMailHelper.SendInvite(redactorEmail, user);
return 2;
}
}
else
{
return 0;
}
}
catch
{
return 0;
}
}
protected override void OnMenuGUI()
{
Screen.lockCursor = false;
Screen.showCursor = true;
GUIStyle centeredStyle = new GUIStyle(GUI.skin.label);
centeredStyle.alignment = TextAnchor.MiddleCenter;
centeredStyle.normal.textColor = Color.red;
if (loginFailed && Time.time - lastLoginFailed < 5f)
{
GUILayout.Label(failedMessage, centeredStyle, GUILayout.Width(490));
}
else if (Time.time - lastLoginFailed >= 5f)
{
loginFailed = false;
}
if (!internetConnection)
{
failedMessage = "No internet connection";
loginFailed = true;
if (GUILayout.Button("Play offline", GUILayout.Width(490)))
{
SwitchTo <MainMenu>();
}
}
else
{
if (disconnected)
{
disconnected = false;
OnDisconnected();
}
else if (GameStateManager.loggedIn)
{
SwitchTo <MainMenu>();
}
GUILayout.BeginHorizontal(GUILayout.Width(490));
GUILayout.Label("Login: "******"Password: "******"Signup", GUILayout.ExpandWidth(true)))
{
SwitchTo <Signup>();
}
if (GameStateManager.Password != "" && GameStateManager.Login != "")
{
if (GUILayout.Button("Login", GUILayout.Width(245)))
{
confirm = true;
}
if (confirm)
{
RegexUtilities rg = new RegexUtilities();
confirm = false;
using (WebClient wb = new WebClient())
{
string hashString = GameStateManager.Password;
if (hashString != startPassword)
{
isHashNeeded = true;
}
NameValueCollection data = new NameValueCollection();
if (isHashNeeded)
{
hashString = Signup.HashString(GameStateManager.Password);
}
data["id"] = GameStateManager.Login;
data["psw"] = hashString;
data["mode"] = "in";
byte[] response = wb.UploadValues(MainMenu.url, "POST", data);
using (MD5 md5Hash = MD5.Create())
{
if (!Signup.VerifyMd5Hash(md5Hash, "no", System.Text.Encoding.UTF8.GetString(response)))
{
GameStateManager.connectionID = System.Text.Encoding.UTF8.GetString(response);
GameStateManager.loggedIn = true;
GameStateManager.Password = hashString;
GameStateManager.startProcess = true;
GameStateManager.version = checkVersion();
PlayerLogs pl = new PlayerLogs();
pl.Login = GameStateManager.Login;
pl.Password = GameStateManager.Password;
pl.SerializeLogs();
SwitchTo <MainMenu>();
}
else
{
loginFailed = true;
failedMessage = "Login failed";
lastLoginFailed = Time.time;
}
}
}
}
}
GUILayout.EndHorizontal();
}
}
private void txtEmailAdd_Leave(object sender, EventArgs e)
{
RegexUtilities util = new RegexUtilities();
if (txtEmailAdd.Text != string.Empty)
{
if (!util.IsValidEmail(txtEmailAdd.Text))
{
MessageBox.Show("Invalid E-mail Address");
txtEmailAdd.Focus();
return;
}
}
}
async void Save()
{
try
{
if (conexion.AbrirConexion() == true)
{
/*aca validamos que si hallan ingresado*/
if (string.IsNullOrEmpty(FirstName))
{
await dialogService.ShowMessage(
"Error",
"Debes ingresar un nombre.");
return;
}
if (string.IsNullOrEmpty(LastName))
{
await dialogService.ShowMessage(
"Error",
"Debes ingresar un apellido");
return;
}
if (string.IsNullOrEmpty(Email))
{
await dialogService.ShowMessage(
"Error",
"Debes ingresar un correo electrónico.");
return;
}
if (!RegexUtilities.IsValidEmail(Email))
{
await dialogService.ShowMessage(
"Error",
"Debes ingresar un Email válido.");
return;
}
if (string.IsNullOrEmpty(Password))
{
await dialogService.ShowMessage(
"Error",
"Debes ingresar una contraseña");
return;
}
if (Password.Length < 6)
{
await dialogService.ShowMessage(
"Error",
"La contraseña debe tener al menos 6 caracteres.");
return;
}
if (string.IsNullOrEmpty(Confirm))
{
await dialogService.ShowMessage(
"Error",
"Debe ingresar una contraseña de confirmación");
return;
}
if (!Password.Equals(Confirm))
{
await dialogService.ShowMessage(
"Error",
"La contraseña y confirmacion, no coincide.");
return;
}
Usuario pUsuario = new Usuario();
pUsuario.FirstName = FirstName;
pUsuario.LastName = LastName;
pUsuario.Email = Email;
pUsuario.Phone = Phone;
pUsuario.Password = Password;
pUsuario.Confirm = Confirm;
int resultado;
resultado = Usuario.AgregarUsuario(conexion.conexion, pUsuario);
if (resultado > 0)
{
FirstName = "";
LastName = "";
Email = "";
Phone = "";
Password = "";
Confirm = "";
}
IsRunning = true;
IsEnabled = false;
conexion.CerrarConexion();
}
} catch (MySql.Data.MySqlClient.MySqlException ex) {
await dialogService.ShowMessage(ex.Message);
}
/* var customer = new Customer
* {
* Email = Email,
* FirstName = FirstName,
* LastName = LastName,
* Password = Password,
* Phone = Phone,
* };*/
#region Comentado
/*var connection = await apiService.CheckConnection();
* if (!connection.IsSuccess)
* {
* IsRunning = false;
* IsEnabled = true;
* await dialogService.ShowMessage("Error", connection.Message);
* return;
* }
* // aca mandamos todos los datos que el usuario halla digitado
* var customer = new Customer
* {
* Address = Address,
* CustomerType = 1,
* Email = Email,
* FirstName = FirstName,
* LastName = LastName,
* Password = Password,
* Phone = Phone,
* };
*
* var response = await apiService.Post(
* "http://productszuluapi.azurewebsites.net",
* "/api",
* "/Customers",
* customer);
*
* if (!response.IsSuccess)
* {
* IsRunning = false;
* IsEnabled = true;
* await dialogService.ShowMessage(
* "Error",
* response.Message);
* return;
* }
*
* var response2 = await apiService.GetToken(
* "http://productszuluapi.azurewebsites.net",
* Email,
* Password);
*
* if (response2 == null)
* {
* IsRunning = false;
* IsEnabled = true;
* await dialogService.ShowMessage(
* "Error",
* "The service is not available, please try latter.");
* Password = null;
* return;
* }
*
* if (string.IsNullOrEmpty(response2.AccessToken))
* {
* IsRunning = false;
* IsEnabled = true;
* await dialogService.ShowMessage(
* "Error",
* response2.ErrorDescription);
* Password = null;
* return;
* }
*/
#endregion
var mainViewModel = MainViewModel.GetInstance();
mainViewModel.Plans = new PlansViewModel();
/**/ await Application.Current.MainPage.Navigation.PushAsync(new PlansPage());
IsRunning = false;
IsEnabled = true;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
//receive the inputed information
string firstName = String.Format("{0}", Request.Form["firstName"]);
string lastName = String.Format("{0}", Request.Form["lastName"]);
string email = String.Format("{0}", Request.Form["email"]);
string password = String.Format("{0}", Request.Form["password"]);
string university = String.Format("{0}", Request.Form["universityInfo"]);
RegexUtilities util = new RegexUtilities();
//TODO connect to database and add the information
if (firstName.CompareTo("") == 0 || lastName.CompareTo("") == 0 ||
email.CompareTo("") == 0 || password.CompareTo("") == 0 ||
university.CompareTo("") == 0)
{
//all fields are not completed
Response.Write("Complete all fields");
}
else if(!util.IsValidEmail(email))
{
//email is not valid
Response.Write("Not a valid email");
}
else
{
SqlConnection objConnection = new SqlConnection("Data Source=184.168.194.68;Initial Catalog=EventsDB;Integrated Security=False;User ID=kevin95duarte;password=sqlpassword1;Connect Timeout=15;Encrypt=False;Packet Size=4096;MultipleActiveResultSets=True");
try
{
objConnection.Open();
//checks if the email is in the DB
string strSQL = String.Format("select * from student where email='{0}'", email);
SqlCommand objCommand = new SqlCommand(strSQL, objConnection);
SqlDataReader objReader = objCommand.ExecuteReader();
//the email is in the DB
if (objReader.Read())
{
//Email already has an account
Response.Write("this email already has an account.");
}
//email is not in the DB, create the account
else
{
//inserts the student in the DB
strSQL = String.Format("INSERT INTO student (first_name, last_name, password, email) VALUES ('{0}','{1}','{2}','{3}');",
firstName, lastName, password, email);
SqlCommand objCommand2 = new SqlCommand(strSQL, objConnection);
objCommand2.ExecuteNonQuery();
//gets the universityID
strSQL = String.Format("SELECT * FROM university U WHERE U.initials='{0}'", university);
SqlCommand getUniversityID = new SqlCommand(strSQL, objConnection);
SqlDataReader universityReader = getUniversityID.ExecuteReader();
int universityID = -1;
if(universityReader.Read())
{
universityID = Convert.ToInt32(universityReader["universityID"]);
}
else
{
//getting the uniID failed, I dont know how such a thing happened
Response.Write("UniversityID failed");
}
universityReader.Close();
//gets the row of the recently created student account
strSQL = String.Format("select * from student where email='{0}'", email);
SqlCommand objCommand3 = new SqlCommand(strSQL, objConnection);
SqlDataReader objReader2 = objCommand3.ExecuteReader();
if (objReader2.Read())
{
//adds the student to the attends table
int studentID = Convert.ToInt32(objReader2["studentID"]);
strSQL = String.Format("INSERT INTO attends(studentID, universityID) VALUES('{0}', '{1}')", studentID, universityID);
SqlCommand insertAttends = new SqlCommand(strSQL, objConnection);
insertAttends.ExecuteNonQuery();
//saves the student id to the session
Session["studentID"] = studentID;
//redirects to the View Events page
Response.Redirect("Events.aspx");
}
else
{
//login failed, I dont know how such a thing happened
Response.Write("Creation failed");
}
objReader2.Close();
}
objReader.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
if (objConnection.State == ConnectionState.Open)
{
objConnection.Close();
}
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string rsoName = String.Format("{0}", Request.Form["RSOName"]);
String[] emails = new String[6];
emails[0] = String.Format("{0}", Request.Form["email"]);
emails[1] = String.Format("{0}", Request.Form["email1"]);
emails[2] = String.Format("{0}", Request.Form["email2"]);
emails[3] = String.Format("{0}", Request.Form["email3"]);
emails[4] = String.Format("{0}", Request.Form["email4"]);
emails[5] = String.Format("{0}", Request.Form["email5"]);
RegexUtilities util = new RegexUtilities();
//ensures all emails are not null, and are emails
if (rsoName.CompareTo("") == 0 || emails[0].CompareTo("") == 0 ||
emails[1].CompareTo("") == 0 || emails[2].CompareTo("") == 0 ||
emails[3].CompareTo("") == 0 || emails[4].CompareTo("") == 0 ||
emails[5].CompareTo("") == 0)
{
Response.Write("Fill in all fields");
return;
}
else if (!(util.IsValidEmail(emails[0]) && util.IsValidEmail(emails[1]) &&
util.IsValidEmail(emails[2]) && util.IsValidEmail(emails[3]) &&
util.IsValidEmail(emails[4]) && util.IsValidEmail(emails[5])))
{
Response.Write("Not valid emails");
return;
}
//opens the object connection
SqlConnection objConnection = new SqlConnection("Data Source=184.168.194.68;Initial Catalog=EventsDB;Integrated Security=False;User ID=kevin95duarte;password=sqlpassword1;Connect Timeout=60;Encrypt=False;Packet Size=4096;MultipleActiveResultSets=True");
try
{
objConnection.Open();
//checks if RSO name exists
String strSQL = String.Format("select * from rso R where name='{0}'", rsoName);
SqlCommand objCommand = new SqlCommand(strSQL, objConnection);
SqlDataReader objReader = objCommand.ExecuteReader();
//the rso name is in the DB
if (objReader.Read())
{
//Email already has an account
Response.Write("This rso name is taken.");
return;
}
objReader.Close();
//check if all emails are in DB
int[] ids = new int[6];
for(int i = 0; i < 6; i++)
{
strSQL = String.Format("SELECT * FROM student S WHERE UPPER(S.email)=UPPER('{0}')", emails[i]);
SqlCommand objCommand2 = new SqlCommand(strSQL, objConnection);
SqlDataReader objReader2 = objCommand2.ExecuteReader();
//the email is in the DB, save the id
if(objReader2.Read())
{
ids[i] = Convert.ToInt32(objReader2["studentID"]);
}
else
{
//email is not in the DB
Response.Write(String.Format("{0} does not have an account", emails[i]));
return;
}
objReader2.Close();
}
//checks if all students attend the same university
int[] universityIDs = new int[6];
for (int i = 0; i < 6; i++)
{
strSQL = String.Format("select * from attends A where A.studentID='{0}'", ids[i]);
SqlCommand objCommand2 = new SqlCommand(strSQL, objConnection);
SqlDataReader objReader2 = objCommand2.ExecuteReader();
if (objReader2.Read())
{
universityIDs[i] = Convert.ToInt32(objReader2["universityID"]);
}
objReader2.Close();
}
for(int i = 1; i < 6; i++)
{
//all the universities are not the same
if(universityIDs[0] != universityIDs[i])
{
Response.Write("All students do not attend the same university");
return;
}
}
String emailEnd = emails[0].Substring(emails[0].IndexOf('@'));
for(int i = 1; i < 6; i++)
{
//all emails do not end the same
if(emailEnd.CompareTo(emails[i].Substring(emails[i].IndexOf('@'))) != 0)
{
Response.Write("All students do not have the same university email");
return;
}
}
//Creates a new rso INSERTS it into the Database
strSQL = String.Format("INSERT INTO rso(name) VALUES('{0}')", rsoName);
SqlCommand insertRSO = new SqlCommand(strSQL, objConnection);
insertRSO.ExecuteNonQuery();
//gets the rsoID
strSQL = String.Format("SELECT * FROM rso WHERE name='{0}'", rsoName);
SqlCommand getRSOID = new SqlCommand(strSQL, objConnection);
SqlDataReader rsoReader = getRSOID.ExecuteReader();
int rsoID = -1;
if(rsoReader.Read())
{
rsoID = Convert.ToInt32(rsoReader["rsoID"]);
}
//creates a new partOf relationship
strSQL = String.Format("INSERT INTO partOf(universityID, rsoID) VALUES({0}, {1})", universityIDs[0], rsoID);
SqlCommand insertPartOf = new SqlCommand(strSQL, objConnection);
insertPartOf.ExecuteNonQuery();
//adds all the students into the rso
for(int i = 0; i < 6; i++)
{
strSQL = String.Format("INSERT INTO memberOf(studentID, rsoID) VALUES({0}, {1})", ids[i], rsoID);
SqlCommand insertMemberOf = new SqlCommand(strSQL, objConnection);
insertMemberOf.ExecuteNonQuery();
}
//makes the admin, an admin
strSQL = String.Format("INSERT INTO admin(adminID) VALUES({0})", ids[0]);
SqlCommand insertAdmin = new SqlCommand(strSQL, objConnection);
insertAdmin.ExecuteNonQuery();
//makes admin manage the rso
strSQL = String.Format("INSERT INTO manages(adminID, rsoID) VALUES({0}, {1})", ids[0], rsoID);
SqlCommand insertManages = new SqlCommand(strSQL, objConnection);
insertManages.ExecuteNonQuery();
Response.Write("The RSO has been successfully created");
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
if (objConnection.State == ConnectionState.Open)
{
objConnection.Close();
}
}
}
