public IndexModel(ILogger <IndexModel> logger, IHostEnvironment environment) { Connected = true; _logger = logger; _environment = environment; IsUploaded = false; if (!System.IO.File.Exists("config.txt")) { _logger.LogError("Brak pliku konfiguracyjnego."); return; } else { _logger.LogInformation($"Korzystanie z pliku konfiguracyjengo."); } foreach (string item in System.IO.File.ReadAllLines(@"config.txt")) { if (!item.Contains("=")) { continue; } string[] line = item.Split("="); config.Add(line[0], line[1]); } try { string conn_str = "server=" + config.GetValueOrDefault("server") + ";port=" + config.GetValueOrDefault("port") + ";database=" + config.GetValueOrDefault("database") + ";uid=" + config.GetValueOrDefault("login") + ";pwd=" + config.GetValueOrDefault("password"); conn = new MySqlConnection(conn_str); string conn_str_in = "server=" + config.GetValueOrDefault("server") + ";port=" + config.GetValueOrDefault("port") + ";database=" + config.GetValueOrDefault("database_err") + ";uid=" + config.GetValueOrDefault("login") + ";pwd=" + config.GetValueOrDefault("password"); conn_in = new MySqlConnection(conn_str_in); //conn = new MySqlConnection("server=localhost;port=3306;database=plan;uid=root;pwd=pass5431"); //conn_in = new MySqlConnection("server=localhost;port=3306;database=err_tmp;uid=root;pwd=pass5431"); conn.Open(); conn_in.Open(); //foreach (string item in GetSQLElements("przedmioty")) if (item != "") Modules.Add(item); foreach (string item in GetSQLElements("grupy")) { if (item != "") { Groups.Add(item); } } foreach (string item in GetSQLElements("prowadzacy")) { if (item != "") { Lecturer.Add(item); } } //foreach (string item in GetSQLElements("sale")) if (item != "") Rooms.Add(item); conn.Close(); } catch (MySqlException e) { Console.WriteLine(); Console.WriteLine(e); Console.WriteLine(); Connected = false; Redirect("Index"); } }
protected void dgLecturer_ItemCommand(object sender, System.Web.UI.WebControls.DataGridCommandEventArgs e) { Lecturer lecturer = new Lecturer(); if (e.CommandName == "AddLecturer") { TextBox txtTempLecturerID = (TextBox)e.Item.Cells[0].FindControl("txtLecturerIDNew"); TextBox txtTempName = (TextBox)e.Item.Cells[1].FindControl("txtNameNew"); TextBox txtTempPhoneNo = (TextBox)e.Item.Cells[2].FindControl("txtPhoneNew"); Regex lecregex = new Regex(@"^\d{1,5}$"); //only support up to 5 integer Match checklec = lecregex.Match(txtTempLecturerID.Text); Regex nameRegex = new Regex(@"[a-zA-Z ]{1,30}$"); //Only allow a-z,A-Z and space Match checkname = nameRegex.Match(txtTempName.Text); //Validation for name (No digit allowed and only up to 30 characters) Regex phoneRegex = new Regex(@"^(01)[0-9]*[0-9]{8,9}$"); Match checkPhone = phoneRegex.Match(txtTempPhoneNo.Text); if (txtTempName.Text.Trim() == "") { ClientScript.RegisterStartupScript(this.GetType(), "Error", "<script type='text/javascript'>swal('Error!', 'Please fill in the lecturer name!', 'error')</script>'"); } else if (!checklec.Success) { ClientScript.RegisterStartupScript(this.GetType(), "Error", "<script type='text/javascript'>swal('Error!', 'The Lecturer ID is not allowed. Please Lecturer ID is only up to 5 digit number.', 'error')</script>'"); } else if (!checkname.Success) { ClientScript.RegisterStartupScript(this.GetType(), "Error", "<script type='text/javascript'>swal('Error!', 'The Lecturer Name is not allowed. Lecturer name is only support character, space and up to 30 character only.', 'error')</script>'"); } else if (txtTempLecturerID.Text.Trim() == "") { ClientScript.RegisterStartupScript(this.GetType(), "Error", "<script type='text/javascript'>swal('Error!', 'Please fill in the lecturer ID!', 'error')</script>'"); } else if (!checkPhone.Success) { ClientScript.RegisterStartupScript(this.GetType(), "Error", "<script type='text/javascript'>swal('Error!', 'The phone number is not allowed. Phone number must start with 01 and is only support 7 or 8 digits', 'error')</script>'"); } else { if (lecturer.Add(txtTempLecturerID.Text, txtTempName.Text, txtTempPhoneNo.Text) == false) { ClientScript.RegisterStartupScript(this.GetType(), "Error", "<script type='text/javascript'>swal('Error!', 'Cannot have same duplicate lecturer ID!', 'error')</script>'"); } else { ClientScript.RegisterStartupScript(this.GetType(), "Success", "<script type='text/javascript'>swal({title: 'Added!', text: 'This " + txtTempName.Text + " (" + txtTempLecturerID.Text + ") lecturer is added successfully, Your password is (holdDoc1)', type : 'success', confirmButtonText : 'OK'}, function (isConfirm) { if (isConfirm) { window.location.href = 'manageLecturer.aspx'; }});</script>'"); } } } else if (e.CommandName == "DeleteLecturer") { Label rowLecturerID = (Label)e.Item.Cells[0].FindControl("lblLecturerID"); if (lecturer.DeleteLecturer(rowLecturerID.Text) == false) { ClientScript.RegisterStartupScript(this.GetType(), "Error", "<script type='text/javascript'>swal('Error!', 'Delete this lecturer record unsuccessfully', 'error')</script>'"); } else { ClientScript.RegisterStartupScript(this.GetType(), "Success", "<script type='text/javascript'>swal({title: 'Deleted!', text: 'Deleted this lecturer record successfully', type : 'success', confirmButtonText : 'OK'}, function (isConfirm) { if (isConfirm) { window.location.href = 'manageLecturer.aspx'; }});</script>'"); } } else if (e.CommandName == "ResetPassword") { Label rowLecturerID = (Label)e.Item.Cells[0].FindControl("lblLecturerID"); if (lecturer.ResetPassword(rowLecturerID.Text) == false) { ClientScript.RegisterStartupScript(this.GetType(), "Error", "<script type='text/javascript'>swal('Error!', 'Reset Password unsuccessfully', 'error')</script>'"); } else { ClientScript.RegisterStartupScript(this.GetType(), "Success", "<script type='text/javascript'>swal({title: 'Reset!', text: 'Reset Password successfully! Your password is (holdDoc1)', type : 'success', confirmButtonText : 'OK'}, function (isConfirm) { if (isConfirm) { window.location.href = 'manageLecturer.aspx'; }});</script>'"); } } }