//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;
}
