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