//We can add an existing product too public Boolean AddEditor(Editor editor) { var editorBl = new EditorBL(); if (editorBl.IsEditorExist(editor.GetUserName())) { return false; } _editorDal.AddEditor(editor); return true; }
protected void RegisterButton_Click(object sender, EventArgs e) { var textboxes = Controls.FindAll().OfType<TextBox>(); var validator = textboxes.Any(t => t.Text.Trim().Equals("")); var firstName = FirstNameTextBox.Text.Trim(); var lastName = LastNameTextBox.Text.Trim(); var userName = UserNameTextBox.Text.Trim(); var password = PasswordTextBox.Text.Trim(); var email = EmailTextBox.Text.Trim(); if (validator) { if (firstName.Equals("")) { FirstName_Validator.Visible = true; } if (lastName.Equals("")) { LastName_Validator.Visible = true; } if (userName.Equals("")) { UserName_Validator.Text = "you have to enter username"; UserName_Validator.Visible = true; } if (password.Equals("")) { Password_Validator.Visible = true; } if (email.Equals("")) { Email_Validator.Visible = true; } } else { var editor = new Editor(firstName, lastName, userName, password, email, 0); var editorBL = new EditorBL(); if (editorBL.AddEditor(editor)) { SendMail(firstName, lastName, userName, email); RegisterTable.Visible = false; ThankYouLabel.Visible = true; } else { UserName_Validator.Text = "Username already exist"; UserName_Validator.Visible = true; } } }
public LinkedList<Editor> GetAllEditors() { var editorsList = new LinkedList<Editor>(); var conn = new SqlConnection(GetConnectionString()); const string sql = "SELECT * FROM Editors"; try { conn.Open(); var cmd = new SqlCommand(sql, conn); var editorsReader = cmd.ExecuteReader(); if (editorsReader.HasRows) { while (editorsReader.Read()) { var editor = new Editor(Convert.ToString(editorsReader["First Name"]).Trim(), Convert.ToString(editorsReader["Last Name"]).Trim(), Convert.ToString(editorsReader["Username"]).Trim(), Convert.ToString(editorsReader["Password"]).Trim(), Convert.ToString(editorsReader["email"]).Trim(), Convert.ToInt32(editorsReader["Authorized"])); if (editorsList.Count == 0) { editorsList.AddFirst(editor); } else { editorsList.AddAfter(editorsList.Last, editor); } } } } catch (SqlException ex) { var msg = "GetAllEditors Sql Error: "; msg += ex.Message; throw new Exception(msg); } finally { conn.Close(); } return editorsList; }
public void AddEditor(Editor editor) { var conn = new SqlConnection(GetConnectionString()); var sql = "INSERT INTO Editors VALUES('" + editor.GetFirstName().Trim() + "','" + editor.GetLastName().Trim() + "','" + editor.GetUserName().Trim() + "','" + editor.GetPassword().Trim() + "','" + editor.GetEmail().Trim() + "','" + editor.GetAuthorized() + "')"; try { conn.Open(); var cmd = new SqlCommand(sql, conn); cmd.ExecuteNonQuery(); } catch (SqlException ex) { var msg = "AddEditor Sql Error: "; msg += ex.Message; throw new Exception(msg); } finally { conn.Close(); } }
public Editor GetEditor(string userName) { userName = userName.Trim(); Editor editor = null; var conn = new SqlConnection(GetConnectionString()); var sql = "SELECT * FROM Editors WHERE [Username] = '" + userName + "'"; try { conn.Open(); var cmd = new SqlCommand(sql, conn); var editorReader = cmd.ExecuteReader(); if (editorReader.HasRows) { editorReader.Read(); editor = new Editor(Convert.ToString(editorReader["First Name"]).Trim(), Convert.ToString(editorReader["Last Name"]).Trim(), Convert.ToString(editorReader["Username"]).Trim(), Convert.ToString(editorReader["Password"]), Convert.ToString(editorReader["Email"]).Trim(), Convert.ToInt32(editorReader["Authorized"])); } } catch (SqlException ex) { var msg = "GetEditor Sql Error: "; msg += ex.Message; throw new Exception(msg); } finally { conn.Close(); } return editor; }